Question

1
Replies
44
Views
Vigneshwaran Aravindhan (VigneshAravind)
Cognizant
Senior Technology Architect
Cognizant
IN
VigneshAravind Member since 2007 28 posts
Cognizant
Posted: June 2, 2017
Last activity: April 6, 2018
Posted: 2 Jun 2017 9:51 EDT
Last activity: 6 Apr 2018 19:26 EDT
Closed

Error while performing the third upgrade step (Generate and Apply Rules Schema Objects)

We received a similar error while performing the third upgrade step (Generate and Apply Rules Schema Objects)

[java] Exception in thread "main" com.pega.pegarules.install.SQLLoaderException: Error executing SQL statements
[java] at com.pega.pegarules.install.SQLLoader.load(SQLLoader.java:80)
[java] at com.pega.pegarules.install.SQLLoader.main(SQLLoader.java:65)
[java] Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
[java]
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)

Later we realized that our "Deployment User" did not have enough privileges to read/modify the New Pega7 Rules Schema. Necessary privileges were grated and the issue was resolved.

Occasionally you may also encounter the following error when the deployment user does not have the necessary privileges.

[java] java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges

System Administration Upgrades
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.