SA-21267

Summary

After upgrade from 6.3 to 7.19 (split schema), PRPC Schema Report shows a lot of tables, columns and indexes missing but the objects exist in the database.

What are the grants required for schema users across data and rules schema?

Error Messages

PRPC Schema Report shows a lot of tables missing

Steps to Reproduce

After upgrade, run PRPC Schema report. 

Root Cause

A defect or configuration issue in the operating environment.  The application server datasource configuration was not setup per the Installation Guide. The PegaRULES datasource was connecting using the RULES schema name instead of the DATA schema name.  Also the second run on the migrate script to create the rules schema objects was run with the target data schema property not set and as a result the grants needed between the rules and data schemas were not setup correctly.

Resolution

Make the following change to the operating environment: 

1.  Rerun the migrate script with the correct settings to setup the grants needed between the data and rules schema users.

2. Update the datasource to use the DATA schema name as outlined in the Oracle Tomcat install guide and remove any references to PegaDATA, as they are not needed.

3.. Add entries to conf/context.xml file to define the default rules and data schema names
< Environment name="prconfig/database/databases/PegaRULES/defaultSchema" value="v71rules" type="java.lang.String"/>
< Environment name="prconfig/database/databases/PegaDATA/defaultSchema" value="v71data" type="java.lang.String"/>

4. Update prconfig.xml file to the version that comes with the 7.1 media to make sure environment variables are set like the following:

<env name="database/databases/PegaRULES/dataSource" value="java:comp/env/jdbc/PegaRULES"/>
<env name="database/databases/PegaDATA/dataSource" value="java:comp/env/jdbc/PegaRULES"/>