Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

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

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us