Support Article

DirectStreamReader does not exist errors after upgrade

SA-6433

Summary



After upgrading to Pega 7.1.7, for some Data Tables when a Report Definition is run, an Oracle exception is seen.

The same exception is not seen for all Data Tables.


Error Messages



Error:
** An error occured on executing the query for the report definition - There was a problem getting a list: code: 29540 SQLState: 99999 Message: ORA-29540: class com/pega/pegarules/data/udf/directstreamreader/DirectStreamReader does not exist


Steps to Reproduce



Run certain report definitions after upgrading to Pega 7.1.7.

Root Cause



The root cause of this problem is defect/misconfiguration in the PRPC operating environment. UDFs were not present in the database.


Resolution



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


1) On the database, drop any existing versions of the UDF functions on both the Data and Rules schemas:
pr_read_decimal_from_stream, pr_read_from_stream, pr_read_int_from_stream

2) Update setupDatabase.properties from the distribution media to point to the database in question, being sure to specifiy both schemas.

3) Run the generateudf.bat or generateudf.sh script in the scripts directory, with the following parameters:
generateudf --action install --dbType [db2zos|mssql|postgres|oracledate|udb]

Published January 31, 2016 - 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.