Question

3
Replies
375
Views
Close popover
Jaffer Sathick Mohideen Abdul Kather (jafferSathick)
TCS
Engineering Lead
TCS
GB
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.

System Administration Upgrades
Moderation Team has archived post