Support Article
Call to sppr_aggregate_usage throwing sqlcode=-206 on 7.1.7 db2
SA-8045
Summary
System running Pega 7.1.7 split schema on DB2. Upon startup there is an error in the log file when the stored procedure sppr_aggregate_usage tries to insert into PR_USAGE_SUMMARY for column PYPERIODSTARTS
Error Messages
Last SQL: {call DATA.sppr_aggregate_usage ()}
com.ibm.db2.jcc.am.SqlSyntaxErrorException: "PR_USAGE_SUMMARY.PYPERIODSTARTS" is not valid in the context where it is used.. SQLCODE=-206, SQLSTATE=42703, DRIVER=3.62.56
Caused by SQL Problems.
Problem #1, SQLState 42703, Error code -206: com.ibm.db2.jcc.am.SqlSyntaxErrorException: "PR_USAGE_SUMMARY.PYPERIODSTARTS" is not valid in the context where it is used.. SQLCODE=-206, SQLSTATE=42703, DRIVER=3.62.56
Steps to Reproduce
Clean install of PRPC 7.1.7 with AES Framework imported.
Root Cause
The root cause of this problem is a defect in Pegasystems’ code or rules. The stored procedure content is not schema qualified correctly.
Resolution
This issue is resolved through the following local-change:
In PegaRULES Data source, add data schema to the currentFunctionPath in datasource to work around the issue with the call to the stored procedure not being schema qualified.
currentFunctionPath=SYSISM,SYSFUN,[Data schema name];
Published March 11, 2016 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.