Skip to main content

Support Article

Report definition error after migrating database to a new server

SA-12501

Summary



Database is migrated to a new server. While testing the application, error is observed while running Report Definitions.


Error Messages



There was a problem getting a list: code: -4304 SQLState: 42724 Message: DB2 SQL Error: SQLCODE=-4304, SQLSTATE=42724, SQLERRMC=SCHEMA.PR_READ_FROM_;SQL130726133530800;com/pega/pegarules/data/udf/, DRIVER=3.65.92

There was a problem getting a list: code: -4304 SQLState: 42724 Message: DB2 SQL Error: SQLCODE=-4304, SQLSTATE=42724, SQLERRMC=SCHEMA.PR_READ_FROM_;SQL130726133530800;/directory/home/schema/sqllib/, DRIVER=3.65.92


Steps to Reproduce

1. Migrate database to new server.
2. Attempt to run report definitions.

Root Cause



The root cause of this problem is defect/misconfiguration in the operating environment. User Defined Functions must be reinstalled when migrating to a new server.

Resolution



This issue is resolved by making the following change to the operating environment:

1. Create a configuration file "user-deployudf.properties". In this example it is saved to a directory in the distribution media. Have it contain the following information, but specify the connection information.


udb.jdbc.class=com.ibm.db2.jcc.DB2Driver

dev.udb.url=

dev.udb.username=

dev.udb.password=

dev.udb.schema=


2. Update the below command to reference the locations of the specified files. 

java -cp "C:\Media\PRPC6_2SP2withHotfixes\scripts\prdeploy.jar:C:\Media\PRPC6_2SP2withHotfixes\scripts\db2jcc.jar" com.pega.pegarules.install.DatabaseLibraryLoader --config="C:\Media\PRPC6_2SP2withHotfixes\archives\udf\user-deployudf.properties" --profile=dev.udb"C:\Media\PRPC6_2SP2withHotfixes\archives\udf\prreadstream.jar"

prdeploy.jar – Located in the scripts directory of the distribution media.
db2jcc.jar – Not included in the media.
user-deployudf.properties – Created in step 1.
Prreadstream.jar – Located in the \archives\udf directory of the distribution media.


3. After updating the command, run it. This places the classes in the database.

4. Edit the scripts in \schema\udb\install\udfstatements directory of the distribution media. These contain the text #DBOWNR, each occurrence must be manually replaced with the name of the schema into which the UDF is to be installed.

5. Run the scripts.
Suggest Edit

Published July 30, 2015 - Updated October 8, 2020

Did you find this content helpful?

Have a question? Get answers now.

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

Ready to crush complexity?

Experience the benefits of Pega Community when you log in.

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