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] 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.
Just adding a point here: -Sometimes in production clients will not provide DDL access to deployment user. In such cases we need to run the DDL manually and execute that scritps in prod with different user who has DDL access. Inside the scripts we have option for this DDL generation. Thanks !