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.
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.