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

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.

Published July 30, 2015 - Updated October 8, 2020

Was this useful?

0% found this useful

Have a question? Get answers now.

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

Did you find this content helpful?

Want to help us improve this content?

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