Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

prpcUtils.sh does not generate GRANT

SA-55438

Summary



Pega Customer Service 7.22 is installed using prpcUtils.sh and a data description language (DDL) is generated. The generated file does not have GRANTS to the data schema user for tables created in the rules schema. 


Error Messages



Not Applicable


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



The issue occurs when a dual user or schema setup is set; while in Developer Studio two data sources are set. Hence, the product adds GRANTS to the generated file. The script is unaware of the dual setup.


Resolution



Perform the following local-change for the prpcUtils script to generate GRANTS in the DDL:
  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.

 
Suggest Edit

Published October 12, 2018 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us