Support Article
Error while executing report definition on non-exposed columns
SA-85557
Summary
Post upgrade to Pega Platform 7.3.1, error occurs while executing a report definition on non-exposed columns.
Error Messages
** ** An error occured on executing the query for the report definition - There was a problem getting a list: code: -440 SQLState: 42884 Message: DB2 SQL Error: SQLCODE=-440, SQLSTATE=42884, SQLERRMC=FUNCTION;PEGADEVO.PR_READ_FROM_STREAM, DRIVER=4.23.42 DatabaseException caused by prior exception: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-440, SQLSTATE=42884, SQLERRMC=FUNCTION;PEGADEVO.PR_READ_FROM_STREAM, DRIVER=4.23.42 | SQL Code: -440 | SQL State: 42884 DatabaseException caused by prior exception: com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-516, SQLSTATE=26501, SQLERRMC=null, DRIVER=4.23.42 | SQL Code: -516 | SQL State: 26501 DatabaseException caused by prior exception: com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-514, SQLSTATE=26501, SQLERRMC=SQL_CURLH200C1, DRIVER=4.23.42 | SQL Code: -514 | SQL State: 26501
Steps to Reproduce
- Create a report definition rule with non-exposed columns.
- Execute the rule.
Root Cause
The User Defined Functions (UDF) were not installed.
Resolution
Perform the following local-change:
Install the below UDF functions:
DROP FUNCTION YOURSCHEMA.pr_read_from_stream;
DROP FUNCTION YOURSCHEMA.pr_read_decimal_from_stream;
DROP FUNCTION YOURSCHEMA.pr_read_int_from_stream;
(If a split schema system is present, execute the functions for both the Data schema and Rules schema. If the functions are not present, move to Step 1.)
- Ensure that the setupDatabase.properties are set correctly (such as, database connection URL, username, password, and schema name(s)). This Property file is present in the /scripts directory.
- Execute the generateudf.bat (or .sh, as appropriate) with the '--action install --dbType YourDatabaseType' flags.
For example, when executing the script on a Windows machine for an Oracle database, the path is as below:
For Windows: C:\PegaInstallationMedia\scripts> generateudf.bat --action install --dbType oracledate
Published October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.