Question

3
Replies
366
Views
jafferSathick Member since 2010 23 posts
TCS
Posted: July 25, 2016
Last activity: April 6, 2018
Closed

Data upgrade failed - Encountered database error attempting to load jar into Oracle: ORA-01950: no privileges on tablespace

The Data Upgrade I executed failed at 'Install UDF Jar' step as follows.

[java] INFO: Adding com/pega/pegarules/data/internal/clipboard/directstream/ReferenceString.class to the list for addition to the table.
[java] Jul 24, 2016 1:48:12 PM com.pega.pegarules.install.DatabaseLibraryLoader writeMessage
[java] INFO: Created temporary table pz_blobtable
[java] Jul 24, 2016 1:48:12 PM com.pega.pegarules.install.DatabaseLibraryLoader writeMessage
[java] INFO: Temporary table pz_blobtable dropped.
[java] Jul 24, 2016 1:48:12 PM com.pega.pegarules.install.DatabaseLibraryLoader writeMessage
[java] WARNING: Encountered database error attempting to load jar into Oracle: ORA-01950: no privileges on tablespace 'SWPEGARULES'
[java]
[java] Throwable occurred: java.sql.SQLSyntaxErrorException: ORA-01950: no privileges on tablespace 'SWPEGARULES'
[java]
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
[java] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
[java] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
[java] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
[java] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
[java] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208)
[java] at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1046)
[java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1336)
[java] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613)
[java] at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3714)
[java] at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1378)
[java] at com.pega.pegarules.install.DatabaseLibraryLoader.installJarOnOracle(DatabaseLibraryLoader.java:584)
[java] at com.pega.pegarules.install.DatabaseLibraryLoader.runMainProgramWithoutExiting(DatabaseLibraryLoader.java:217)
[java] at com.pega.pegarules.install.DatabaseLibraryLoader.main(DatabaseLibraryLoader.java:144)
[java] Jul 24, 2016 1:48:12 PM com.pega.pegarules.install.DatabaseLibraryLoader writeMessage
[java] INFO:
[java] *****************************************************************************************************
[java]
[java] Encountered database error attempting to load UDF library onto Oracle, clean schema before running again.
[java]
[java] *****************************************************************************************************

On Investigation, I determined that the Deployment User I used to execute the Data upgrade did not have 'UNLIMITED TABLESPACE' privilege.

I provided the Unlimited Quota & Tablespace for the deployment user and re-ran. It executed smoothly.

I see that Deployment guide mentions about providing 'UNLIMITED TABLESPACE' privilege to Rule & Data Schema User IDs - Oracle Base users. But, it does not list 'UNLIMITED TABLESPACE' privilege as one of the requriements for Deployment User.

Please let me know your thoughts.

Low-Code App Development Upgrades
Moderation Team has archived post
Share this page LinkedIn