Question
TCS
GB
Last activity: 6 Apr 2018 19:26 EDT
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.
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.