Call to sppr_aggregate_usage throwing sqlcode=-206
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.
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.
A defect in Pegasystems’ code or rules:
The table names within the stored procedure are not schema qualified correctly.
Perform the following local-change:
In PegaRULES Data source, add connection property to set currentSchema=<Data Schema Name>
0% found this useful