Discussion

Exception during RDB-Save in External database

I am getting a following exception during RDB-Save in external DB2 database.

om.pega.pegarules.pub.services.ResourceUnavailableException: RDB-Save failed
at com.pegarules.generated.activity.ra_action_senduow_e53f7f480dc4075957e2b64b3de684b9.step4_circum0(ra_action_senduow_e53f7f480dc4075957e2b64b3de684b9.java:450)
at com.pegarules.generated.activity.ra_action_senduow_e53f7f480dc4075957e2b64b3de684b9.perform(ra_action_senduow_e53f7f480dc4075957e2b64b3de684b9.java:131)
at com.pega.pegarules.engine.runtime.Executable.doActivity(Executable.java:3049)
at com.pegarules.generated.activity.ra_action_savempswrkpkg_0025006d6ee1857cf6ea9e5db33565a4.step5_circum0_MC_Data_CustReq_DataBlock_SIPs(ra_action_savempswrkpkg_0025006d6ee1857cf6ea9e5db33565a4.java:608)
at com.pegarules.generated.activity.ra_action_savempswrkpkg_0025006d6ee1857cf6ea9e5db33565a4.perform(ra_action_savempswrkpkg_0025006d6ee1857cf6ea9e5db33565a4.java:185)
at com.pega.pegarules.engine.runtime.Executable.doActivity(Executable.java:3049)
at com.pegarules.generated.activity.ra_action_buildwrkpkgforrngblk_ab99879efd7555b425b1c2b35ed2c0f8.step8_circum0(ra_action_buildwrkpkgforrngblk_ab99879efd7555b425b1c2b35ed2c0f8.java:765)
at com.pegarules.generated.activity.ra_action_buildwrkpkgforrngblk_ab99879efd7555b425b1c2b35ed2c0f8.perform(ra_action_buildwrkpkgforrngblk_ab99879efd7555b425b1c2b35ed2c0f8.java:254)
at com.pega.pegarules.engine.runtime.Executable.doActivity(Executable.java:3049)
at com.pegarules.generated.flow.ra_action_pf_wrk_pkgs_18570f3fdb45a9bb6ddefc47e211a7bc.RunTaskActivity(ra_action_pf_wrk_pkgs_18570f3fdb45a9bb6ddefc47e211a7bc.java:3160)
at com.pegarules.generated.flow.ra_action_pf_wrk_pkgs_18570f3fdb45a9bb6ddefc47e211a7bc.Task_UTILITY73_circum0(ra_action_pf_wrk_pkgs_18570f3fdb45a9bb6ddefc47e211a7bc.java:1429)
at com.pegarules.generated.flow.ra_action_pf_wrk_pkgs_18570f3fdb45a9bb6ddefc47e211a7bc.perform(ra_action_pf_wrk_pkgs_18570f3fdb45a9bb6ddefc47e211a7bc.java:540)
at com.pega.pegarules.engine.runtime.Executable.doActivity(Executable.java:3049)
at com.pegarules.generated.flow.ra_action_pf_sipsprocessselectionmain_a199faebadb702e4682b770c7323fdc1.LaunchFlow(ra_action_pf_sipsprocessselectionmain_a199faebadb702e4682b770c7323fdc1.java:5274)
at com.pegarules.generated.flow.ra_action_pf_sipsprocessselectionmain_a199faebadb702e4682b770c7323fdc1.Task_SUBPROCESS136_circum0(ra_action_pf_sipsprocessselectionmain_a199faebadb702e4682b770c7323fdc1.java:3362)
at com.pegarules.generated.flow.ra_action_pf_sipsprocessselectionmain_a199faebadb702e4682b770c7323fdc1.perform(ra_action_pf_sipsprocessselectionmain_a199faebadb702e4682b770c7323fdc1.java:602)
at com.pega.pegarules.engine.runtime.Executable.doActivity(Executable.java:3049)
at com.pegarules.generated.flow.ra_action_pf_internalflows_ebc7197a69512f465f7f65387feed5c3.RestartIssuingFlow(ra_action_pf_internalflows_ebc7197a69512f465f7f65387feed5c3.java:4865)
at com.pegarules.generated.flow.ra_action_pf_internalflows_ebc7197a69512f465f7f65387feed5c3.perform(ra_action_pf_internalflows_ebc7197a69512f465f7f65387feed5c3.java:676)
at com.pega.pegarules.engine.runtime.Executable.doActivity(Executable.java:3049)
at com.pegarules.generated.flow.ra_action_sf_rangeblocking_0c1652a5f1802146b5dde3183d0af401.RestartIssuingFlow(ra_action_sf_rangeblocking_0c1652a5f1802146b5dde3183d0af401.java:3827)
at com.pegarules.generated.flow.ra_action_sf_rangeblocking_0c1652a5f1802146b5dde3183d0af401.perform(ra_action_sf_rangeblocking_0c1652a5f1802146b5dde3183d0af401.java:654)
at com.pega.pegarules.engine.runtime.Executable.doActivity(Executable.java:3049)
at com.pegarules.generated.pega_procom_flow.StartFlow05_05_01(pega_procom_flow.java:6029)
at com.pegarules.generated.pega_procom_flow.StartFlow(pega_procom_flow.java:6112)
at com.pegarules.generated.activity.ra_action_completeassignment_89495ff00dcfa5b88e36995f07c47f3c.step21_circum0(ra_action_completeassignment_89495ff00dcfa5b88e36995f07c47f3c.java:2284)
at com.pegarules.generated.activity.ra_action_completeassignment_89495ff00dcfa5b88e36995f07c47f3c.perform(ra_action_completeassignment_89495ff00dcfa5b88e36995f07c47f3c.java:450)
at com.pega.pegarules.engine.runtime.Executable.doActivity(Executable.java:3049)
at com.pegarules.generated.pega_rules_utilities.callActivity05_05_01(pega_rules_utilities.java:2242)
at com.pegarules.generated.pega_rules_utilities.callActivity(pega_rules_utilities.java:2276)
at com.pegarules.generated.activity.ra_action_performflowaction_3a49aa31d1f7e0db664d02f8cff02ca9.step13_circum0(ra_action_performflowaction_3a49aa31d1f7e0db664d02f8cff02ca9.java:1344)
at com.pegarules.generated.activity.ra_action_performflowaction_3a49aa31d1f7e0db664d02f8cff02ca9.perform(ra_action_performflowaction_3a49aa31d1f7e0db664d02f8cff02ca9.java:281)
at com.pega.pegarules.engine.runtime.Executable.doActivity(Executable.java:3049)
at com.pegarules.generated.activity.ra_action_finishassignment_3638c3ebbe83fe82097fc201e07f6f22.step8_circum0(ra_action_finishassignment_3638c3ebbe83fe82097fc201e07f6f22.java:1272)
at com.pegarules.generated.activity.ra_action_finishassignment_3638c3ebbe83fe82097fc201e07f6f22.perform(ra_action_finishassignment_3638c3ebbe83fe82097fc201e07f6f22.java:195)
at com.pega.pegarules.engine.runtime.Executable.doActivity(Executable.java:3049)
at com.pega.pegarules.engine.context.base.ThreadRunner.runActivitiesAlt(ThreadRunner.java:574)
at com.pega.pegarules.engine.context.PRThreadImpl.runActivitiesAlt(PRThreadImpl.java:588)
at com.pega.pegarules.services.HttpAPI.runActivities(HttpAPI.java:1816)
at com.pega.pegarules.services.EngineAPI.processRequestInner(EngineAPI.java:334)
at sun.reflect.GeneratedMethodAccessor77.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.pega.pegarules.engine.context.PREnvironment.doWithRequestorLocked(PREnvironment.java:932)
at com.pega.pegarules.engine.context.PREnvironment.doWithRequestorLocked(PREnvironment.java:689)
at com.pega.pegarules.services.EngineAPI.processRequest(EngineAPI.java:268)
at com.pega.pegarules.services.HttpAPI.invoke(HttpAPI.java:525)
at com.pega.pegarules.etier.impl.EngineImpl._invokeEngine_privact(EngineImpl.java:283)
at com.pega.pegarules.etier.impl.EngineImpl.invokeEngine(EngineImpl.java:234)
at com.pega.pegarules.etier.impl.EngineImpl.invokeEngine(EngineImpl.java:211)
at com.pega.pegarules.priv.context.JNDIEnvironment.invokeEngineInner(JNDIEnvironment.java:274)
at com.pega.pegarules.priv.context.JNDIEnvironment.invokeEngine(JNDIEnvironment.java:219)
at com.pega.pegarules.web.impl.WebStandardImpl.makeEtierRequest(WebStandardImpl.java:308)
at com.pega.pegarules.web.impl.WebStandardImpl.doPost(WebStandardImpl.java:202)
at sun.reflect.GeneratedMethodAccessor75.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:258)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:299)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:348)
at com.pega.pegarules.internal.web.servlet.WebStandardBoot.doPost(WebStandardBoot.java:93)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:989)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:501)
at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:464)
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3252)
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:264)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:811)
at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1433)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:112)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:454)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:383)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:195)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:743)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:873)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1469)
Caused by: com.pega.pegarules.pub.database.ConnectionException: There was a problem getting a list: code: -4498 SQLState: 08506 Message: [ibm][db2][jcc][t4][2027][11212] A connection failed but has been re-established. The host name or IP address is "mcd2p1" and the service name or port number is 9,209.
Special registers may or may not be re-attempted (Reason code = 1).

Caused by SQL Problems.
Problem #1, SQLState 08506, Error code -4498: com.ibm.websphere.ce.cm.StaleConnectionException: [ibm][db2][jcc][t4][2027][11212] A connection failed but has been re-established. The host name or IP address is "mcd2p1" and the service name or port number is 9,209.
Special registers may or may not be re-attempted (Reason code = 1).
Problem #2, SQLState 08506, Error code -4498: com.ibm.db2.jcc.c.ClientRerouteException: [ibm][db2][jcc][t4][2027][11212] A connection failed but has been re-established. The host name or IP address is "mcd2p1" and the service name or port number is 9,209.
Special registers may or may not be re-attempted (Reason code = 1).
at com.pega.pegarules.engine.database.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:146)
at com.pega.pegarules.engine.database.DatabaseImpl.list(DatabaseImpl.java:4449)
at com.pega.pegarules.engine.database.DatabaseImpl.executeRDB(DatabaseImpl.java:4657)
at com.pega.pegarules.engine.database.DatabaseImpl.saveRDB(DatabaseImpl.java:3949)
at com.pegarules.generated.activity.ra_action_senduow_e53f7f480dc4075957e2b64b3de684b9.step4_circum0(ra_action_senduow_e53f7f480dc4075957e2b64b3de684b9.java:448)
... 81 more
Caused by: com.ibm.websphere.ce.cm.StaleConnectionException: [ibm][db2][jcc][t4][2027][11212] A connection failed but has been re-established. The host name or IP address is "mcd2p1" and the service name or port number is 9,209.
Special registers may or may not be re-attempted (Reason code = 1).
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapExceptionHelper(GenericDataStoreHelper.java:523)
at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapException(GenericDataStoreHelper.java:578)
at com.ibm.ws.rsadapter.jdbc.WSJdbcUtil.mapException(WSJdbcUtil.java:903)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.execute(WSJdbcPreparedStatement.java:513)
at com.pega.pegarules.engine.database.DatabasePreparedStatement.execute(DatabasePreparedStatement.java:833)
at com.pega.pegarules.engine.database.DatabaseImpl.list(DatabaseImpl.java:4409)
... 84 more

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Comments

Keep up to date on this post and subscribe to comments

March 11, 2011 - 4:30pm

Seems your datasource configuration is incorrect. If it was working earlier then do a test connection, may be the db is unavailable. Also ensure that you have included SQLErrorPage in your RDB connect, then check the error message

April 4, 2016 - 8:30pm

Issue got resolved when application rules were revalidated and saved.