Support Article
Call to sppr_aggregate_usage throwing sqlcode=-206
SA-5553
Summary
System was upgraded to Pega 7.1.6 split schema on db2. An error occurred in the log file on starting when the stored procedure sppr_aggregate_usage tries to insert into PR_USAGE_SUMMARY for column PYPERIODSTARTS.
Error Messages
2015-01-01 20:00:59,566 [aRULES LicenseDaemon] [ STANDARD] [ ] [ ] (rnal.license.LicenseDaemonImpl) ERROR - problem while running the procedure in License Daemon:com.pega.pegarules.pub.database.DatabaseException: Database-General Problem encountered executing a stored procedure -206 42703 DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=PR_USAGE_SUMMARY.PYPERIODSTARTS, DRIVER=3.62.56
Steps to Reproduce
Start Pega 7.1.6 system on db2udb split schema database.
Root Cause
A defect in Pegasystems’ code or rules:
The table names within the stored procedure are not schema qualified correctly.
Resolution
Perform the following local-change:
In PegaRULES Data source, add connection property to set currentSchema=<Data Schema Name>
Published November 10, 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.