Support Article
SQL error when server is started
SA-326
Summary
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: com.ibm.db2.jcc.b.SqlException: 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.
Resolution
Set currentSchema and currentFunctionPath to the data schema name and SYSIBM, SYSFUN, [data schema name], respectively, in split schema installation.
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.