SA-12988

Summary

During a fresh installation of Pega 7.1.8, the portion of the installation that builds the rules in the Oracle database has completed without error. However, while deploying the prweb.war on Tomcat, the deployment fails with an error.
 

Error Messages

INFO: Server startup in 34290 ms
/home/myuser/tomcat/pega718/webapps/prweb/WEB-INF/lib/boot/prbootphase2.jar (No such file or directory)
Perhaps executing with a non-standard classpath (e.g. JUnit tests)?
Unable to load phase 2 bootstrap class: com.pega.pegarules.internal.bootstrap.phase2.PRBootstrapImpl
/home/myuser/tomcat/pega718/webapps/prweb/WEB-INF/lib/boot/prbootphase2.jar (No such file or directory)
Perhaps executing with a non-standard classpath (e.g. JUnit tests)?
Unable to load phase 2 bootstrap class: com.pega.pegarules.internal.bootstrap.phase2.PRBootstrapImpl
 

Steps to Reproduce

Install Pega 7.1.8. Startup Tomcat.

Root Cause

The cause of the issue lies in the database permissions given to the Data user.
 

Resolution

When configuring the Pega installation, it is recommended that you follow the latest published installation guide for your application server/database combination.

https://pdn.pega.com/resources/deployment-guides

This includes guidance on the permissions to grant to the database users.

You can verify your current database permissions by running the following SQL commands:

select * from dba_sys_privs
where grantee='<your rules user>'
 
select * from dba_sys_privs where grantee in
(select granted_role from dba_role_privs where grantee = 'your rules user')
 
select * from dba_sys_privs
where grantee='<your data user>'
 
select * from dba_sys_privs where grantee in
(select granted_role from dba_role_privs where grantee = 'your data user')