SA-19531

Summary

When the application runs the query given below, a database error occurs that refers to the DirectStreamReader Java class.
SELECT "PC0".ID AS "ID" , "PC0".MDM_DATA AS "MDM_DATA" , BASE.pr_read_int_from_stream('.ORDER', "PC0".pzInsKey, "PC0".pzPVStream) AS "ORDER" , BASE.pr_read_from_stream('.VALUES', "PC0".pzInsKey, "PC0".pzPVStream) AS "VALUES" ,
"PC0".PZINSKEY AS "pzInsKey" FROM BASE.pr_VM_NBAVM_Data_BBRGU "PC0" WHERE "PC0".pxObjClass ='VM-NBAVM-Data-BBRGU' ORDER BY 1 ASC;

Error Messages

ORA-**Number**: class com/pega/pegarules/data/udf/directstreamreader/DirectStreamReader does not exist
29540. 00000 - "class %s does not exist"
*Cause: Java method execution failed to find a class with the indicated name.
*Action: Correct the name or add the missing Java class.

Steps to Reproduce

Rebuild the database using database administrator (DBA).

Root Cause

When the database was rebuilt, the DBAs overlooked rebuilding the Java class for the User Defined Functions (UDFs).

Resolution

Follow the Resolution in Support Article SA-6433 using the link given below.
https://pdn.pega.com/support-articles/directstreamreader-does-not-exist-errors-after-upgrade

Note: The Support Article refers an issue from a different version of Pega 7, but the steps to resolve are still valid.