Question

1
Replies
40
Views
VigneshAravind Member since 2007 28 posts
Cognizant
Posted: June 2, 2017
Last activity: April 6, 2018
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

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