Support Article
UDF missing invalid identifier while querying optimized property
SA-8949
Summary
“Invalid Identifier” messages are generated in the log file when Pega is trying to query on optimized properties.
Several stream reader User-Defined Functions (UDFs) are missing including PR_READ_FROM_STREAM.
Error Messages
SQLSyntaxErrorException: ORA-00904: "MYSCHEMA"."PR_READ_FROM_STREAM": invalid identifier
Steps to Reproduce
Run a report definition that needs to read a stream.
Root Cause
The root cause of this problem is missing required User-Defined Functions.
Resolution
This issue is resolved by regenerating the necessary UDFs using the following steps:
- On your database, drop the existing version of the UDF functions: pr_read_decimal_from_stream, pr_read_from_stream, pr_read_int_from_stream (since you appear to be missing these, you can probably forgoe this, but it's best to confirm that they're all dropped)
- Update setupDatabase.properties to point to the database in question
- 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.