Support Article

SQL error when server is started



An error occurred when the server was started.

Error Messages

**Date and time**,078 [ servername] [ STANDARD] [ ] [ ] (l.access.ConnectionManagerImpl) ERROR - Not returning connection 9650 for database "pegadata" to the pool as it previously encountered the following error
User ID:
Last SQL: {call [schema name].sppr_aggregate_usage ()}
Caused by SQL Problems.
Problem #1, SQLState 42703, Error code -206: DB2 SQL error: SQLCODE: -206, SQLSTATE: 42703, SQLERRMC: PR_USAGE_SUMMARY.PYPERIODSTARTS

Steps to Reproduce

Start the server.

Root Cause

The error is due to the incorrect PegaRULES datasource configuration, specifically custom properties: currentSchema and currentFunctionPath.


Set currentSchema and currentFunctionPath to  the data schema name and SYSIBM, SYSFUN, [data schema name], respectively, in split schema installation.
Suggest Edit

Published April 1, 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.