Summary

Error Messages

Steps to Reproduce

1. Install Pega 7.3.1.
2. Navigate to 115631_Pega7.31/scripts/utils.
3. Configure prpcUtils.properties.
4. Run the ./prpcUtils.sh generateDDL ----archivePath 115341_CRM722.zip/Rules/PegaCRM_722.jar. In the generated DDL, tables created in the rules schema are missing GRANTS to the data schema user.

Root Cause

Resolution

1. Use a fixed prconfig.xml as the generated prconfig.xml only creates one data source. For this, set the following property in the prpcUtils.properties.
   
   pegarules.config=<your_path>/prconfig.xml
    
2. Make the following changes in the prconfig.xml values in the file from the above path.
   
   <?xml version="1.0" encoding="UTF-8"?>
   <pegarules>
       <env name="Identification/SystemName" value="pega" />
       
       <env name="Initialization/PersistRequestor" value="OnTimeout" />
       <env name="Initialization/usenativelibrary" value="false" />
       <env name="initialization/explicittempdir" value="C:\PRPC\PRPCTempDirs\TCTemp731\PegaTemp" />
       <env name="initialization/displayexceptiontraceback" value="true" />
    
                
       <env name="database/drivers" value="oracle.jdbc.OracleDriver" />
   
       <res name="java:comp/env/jdbc/PegaRULES"
            type="javax.sql.DataSource"
            driverClassName="oracle.jdbc.OracleDriver"
            url="jdbc:oracle:thin:@localhost:1521/PRPCDB"
            maxActive="30" maxIdle="10" maxWait="-1"
            username="BaseUser" password="BaseUser"/>
   
       <res name="java:comp/env/jdbc/AdminPegaRULES"
            type="javax.sql.DataSource"
            driverClassName="oracle.jdbc.OracleDriver"
            url="jdbc:oracle:thin:@localhost:1521/PRPCDB" 
            maxActive="30" maxIdle="10" maxWait="-1"
            username="AdminUser" password="AdminUser"/>
   
           
         <env name="database/databases/PegaRULES/dataSource" value="java:comp/env/jdbc/PegaRULES"/>
       <env name="database/databases/PegaRULES/dataSourceAdmin" value="java:comp/env/jdbc/AdminPegaRULES"/>
       <env name="database/databases/PegaRULES/defaultSchema" value="PRPC731RULES"/>
       
       <env name="database/databases/PegaDATA/dataSource" value="java:comp/env/jdbc/PegaRULES"/>
       <env name="database/databases/PegaDATA/dataSourceAdmin" value="java:comp/env/jdbc/AdminPegaRULES"/>
       <env name="database/databases/PegaDATA/defaultSchema" value="PRPC731DATA"/>
       
   </pegarules>
    
3. Run the prpcUtil script to generate GRANTS in the DDL.