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

Exception while importing RAP file through prpcUtils.sh

SA-8997

Summary



You import a RAP file through command line into a Pega 7.1.7 instance by using prpcUtils.sh. The build is successful and all the rules are imported, but there is one SQL exception which is related to the execution of stored procedure (PRPCDATA.sppr_aggregate_usage ()). 

Error Messages



[java] 2015-04-08 22:02:56,428 [ <Host>] [ STANDARD] [ ] (l.access.ConnectionManagerImpl) ERROR - Not returning connection 3 for database "pegarules" to the pool as it previously encountered the following error
[java] User ID:
[java] Last SQL: {call DATA.sppr_aggregate_usage ()}
[java] com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=PR_USAGE_SUMMARY.PYPERIODSTARTS, DRIVER=3.62.56
[java] at com.ibm.db2.jcc.am.fd.a(fd.java:676)
[java] at com.ibm.db2.jcc.am.fd.a(fd.java:60)
[java] at com.ibm.db2.jcc.am.fd.a(fd.java:127)
[java] at com.ibm.db2.jcc.am.jn.b(jn.java:2299)
[java] at com.ibm.db2.jcc.am.jn.c(jn.java:2282)
[java] at com.ibm.db2.jcc.t4.cb.k(cb.java:370)
[java] at com.ibm.db2.jcc.t4.cb.e(cb.java:98)
[java] at com.ibm.db2.jcc.t4.q.e(q.java:81)
[java] at com.ibm.db2.jcc.t4.rb.k(rb.java:160)
[java] at com.ibm.db2.jcc.am.jn.jb(jn.java:2248)
[java] at com.ibm.db2.jcc.am.kn.b(kn.java:4078)
[java] at com.ibm.db2.jcc.am.ln.fc(ln.java:113)
[java] at com.ibm.db2.jcc.am.ln.execute(ln.java:96)
[java] at com.pega.pegarules.data.internal.access.DatabasePreparedStatementImpl.execute(DatabasePreparedStatementImpl.java:576)
[java] at com.pega.pegarules.data.internal.access.SQLGenerator.callStoredProc(SQLGenerator.java:3244)
[java] at com.pega.pegarules.data.internal.access.DatabaseImpl.callStoredProc(DatabaseImpl.java:10134)
[java] at com.pega.pegarules.data.internal.access.DatabaseImpl.callAggregateUsageSP(DatabaseImpl.java:10199)
[java] at com.pega.pegarules.monitor.internal.license.LicenseDaemonImpl.callUsageAggregationStoredProcedure(LicenseDaemonImpl.java:351)
[java] at com.pega.pegarules.monitor.internal.license.InvocationTrackerImpl.initializeAtStartup(InvocationTrackerImpl.java:416)
[java] at com.pega.pegarules.session.internal.mgmt.PREnvironment.getThreadAndInitialize(PREnvironment.java:381)
[java] at com.pega.pegarules.session.internal.PRSessionProviderImpl.getThreadAndInitialize(PRSessionProviderImpl.java:1905)
[java] at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineStartup.initEngine(EngineStartup.java:657)
[java] at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl._initEngine_privact(EngineImpl.java:165)
[java] at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl.doStartup(EngineImpl.java:138)
[java] at com.pega.pegarules.session.internal.mgmt.EngineImpl.startEngineImpl(EngineImpl.java:240)
[java] at com.pega.pegarules.session.internal.mgmt.EngineImpl.startEngine(EngineImpl.java:119)
[java] at com.pega.pegarules.session.internal.mgmt.EngineImpl.startEngine(EngineImpl.java:112)
[java] at com.pega.pegarules.deploy.external.util.ImportUtility.main(ImportUtility.java:174)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[java] at java.lang.reflect.Method.invoke(Method.java:597)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:338)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:379)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:216)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:265)
[java] at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:85)
[java] 2015-04-08 22:02:56,430 [ dd976c2n12.ms.com] [ 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
[java] From: (B99C5736C1832B16F87CFE919F593A64F:(License Daemon))
[java] SQL: {call DATA.sppr_aggregate_usage ()}
[java] SQL Inserts:
[java]
[java] Caused by SQL Problems.
[java] Problem #1, SQLState 42703, Error code -206: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=PR_USAGE_SUMMARY.PYPERIODSTARTS, DRIVER=3.62.56


Steps to Reproduce



Import a RAP file using prpcUtils.sh to a PRPC 7.1.7 instance.

Root Cause



When starting the PRPC engine from command line, there are agents that should be disabled as they are not needed. The prconfig.xml file that is generated by prpcUtils.sh in Pega 7.1.7 does not include the settings to disable these agents.

Resolution



This error can be safely ignored.

Published June 12, 2015 - 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