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
- Install Pega 7.3.1.
- Navigate to 115631_Pega7.31/scripts/utils.
- Configure prpcUtils.properties.
- 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:
- 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
- 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>
- Run the prpcUtil script to generate GRANTS in the DDL.
Published October 12, 2018 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.