Question
TCS
IN
Last activity: 24 Jan 2018 14:45 EST
Error while connecting to Pega database with PRPC tool
We are currently using Pega 7.1.9 and are implementing DevOps. There is a java utility that we have which uses the PRPC utility from Pega to connect directly to the Pega database and export the rule set. This is later used for importing into the higher environments.
This used to work for an earlier version of Pega. Now, since the upgrade, we are unable to get this to work.
Any ideas/suggestions on how to get the utility working?
Pegasystems Inc.
US
The error which i can see in this attachment is most generic error message and it doesn't help us to find the real root cause behind the failure. Could you able to see any other error messages apart from this in the console log or in the PegaRULES log during the execution of your utility?
Pegasystems Inc.
US
Please post the actual log from this attempt. It looks like an issue connecting to the database but cannot tell what the issue is from the screenshot.
Updated: 23 Jan 2018 4:21 EST
Virtusa
IN
Hi ,
Thanks for your reply,I am from karthick's team and replying on behalf of him, i have attached the log that we got.
Pegasystems Inc.
US
@HariharanR2775 actually i had requested for the PegaRULES log file on the environment where you are performing export, if the process is failing at export functionality.
Pegasystems Inc.
IN
Have you filled the schema names in the prpcutils.properties file?
It seems database user configured in this file is not able to access pr_engineclasses table.
Concentrate on this error:
19830421: PRMiniLoader - unable to load classes from the database: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=PEGAUSR.PR_ENGINECLASSES, DRIVER=4.16.53
Check if the user has sufficient privileges and make sure you filled schema names in below properties:
rules.schema.name=<rules_name>
data.schema.name=<data_name>
Please attach prpcutils.properties file.
Make sure you are using prpcutils from scripts folder which is taken from 7.1.9 distribution media only.