com.pega.pegarules.pub.PRRuntimeException: Encountered database exception when preprocessing deferred operations
Hi All,
We have a Produciton incident where few cases are failing with PRRuntime Exception. User not able to Save the Case.
Appreciate if anyone can help on this.
Hi All,
We have a Produciton incident where few cases are failing with PRRuntime Exception. User not able to Save the Case.
Appreciate if anyone can help on this.
2017-05-09 13:14:42,734 [ WebContainer : 11] [OpenPortal] [ ] [ NGTWF:04.01.01] ( internal.access.DatabaseImpl) ERROR wam.systems.uk.hsbc|XX.XX.XX.XX GBM_NGTWF_REL - Encountered problem when performing a Commit
com.pega.pegarules.pub.PRRuntimeException: Encountered database exception when preprocessing deferred operations <update instance HSBC-GBM-GBL-NGTWF-WORK SCR-8977 not only if new>. PRRuntimeException
at com.pega.pegarules.data.internal.access.DatabaseImpl.preprocessInstancesBeforeCriticalCommitSection(DatabaseImpl.java:3300)
at com.pega.pegarules.data.internal.access.DatabaseImpl.attemptToProcessUpdates(DatabaseImpl.java:2746)
at com.pega.pegarules.data.internal.access.DatabaseImpl.processUpdates(DatabaseImpl.java:2415)
at com.pega.pegarules.data.internal.access.DatabaseImpl.commit(DatabaseImpl.java:2142)
at com.pegarules.generated.activity.ra_action_commitwitherrorhandling_6c6c3f21ead5ea2a97cdc30349237e37.step4_circum0(ra_action_commitwitherrorhandling_6c6c3f21ead5ea2a97cdc30349237e37.java:492)
at com.pegarules.generated.activity.ra_action_commitwitherrorhandling_6c6c3f21ead5ea2a97cdc30349237e37.perform(ra_action_commitwitherrorhandling_6c6c3f21ead5ea2a97cdc30349237e37.java:120)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3527)
at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10674)
at com.pegarules.generated.activity.ra_action_save_1fc1ffbef7621bddc5f37067649267e8.step2_circum0(ra_action_save_1fc1ffbef7621bddc5f37067649267e8.java:452)
at com.pegarules.generated.activity.ra_action_save_1fc1ffbef7621bddc5f37067649267e8.perform(ra_action_save_1fc1ffbef7621bddc5f37067649267e8.java:86)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3527)
at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10674)
at com.pegarules.generated.activity.ra_action_savecovered_fd5cf335ad610b28a95908a86abca67a.step6_circum0(ra_action_savecovered_fd5cf335ad610b28a95908a86abca67a.java:539)
at com.pegarules.generated.activity.ra_action_savecovered_fd5cf335ad610b28a95908a86abca67a.perform(ra_action_savecovered_fd5cf335ad610b28a95908a86abca67a.java:162)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3527)
at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10674)
at com.pegarules.generated.activity.ra_action_dosave_7b0f91076758a5409d7006d2d568db69.step7_circum0(ra_action_dosave_7b0f91076758a5409d7006d2d568db69.java:694)
at com.pegarules.generated.activity.ra_action_dosave_7b0f91076758a5409d7006d2d568db69.perform(ra_action_dosave_7b0f91076758a5409d7006d2d568db69.java:174)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3527)
at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10674)
at com.pegarules.generated.activity.ra_action_saveandcontinue_b518efa9d8cfb091ecefeedf64722f77.step2_circum0(ra_action_saveandcontinue_b518efa9d8cfb091ecefeedf64722f77.java:305)
at com.pegarules.generated.activity.ra_action_saveandcontinue_b518efa9d8cfb091ecefeedf64722f77.perform(ra_action_saveandcontinue_b518efa9d8cfb091ecefeedf64722f77.java:86)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3527)
at com.pegarules.generated.activity.ra_action_reloadharness_64918f09a9eb95090c16ac804a4738fb.step5_circum0(ra_action_reloadharness_64918f09a9eb95090c16ac804a4738fb.java:663)
at com.pegarules.generated.activity.ra_action_reloadharness_64918f09a9eb95090c16ac804a4738fb.perform(ra_action_reloadharness_64918f09a9eb95090c16ac804a4738fb.java:137)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3527)
at com.pega.pegarules.session.internal.mgmt.base.ThreadRunner.runActivitiesAlt(ThreadRunner.java:646)
at com.pega.pegarules.session.internal.mgmt.PRThreadImpl.runActivitiesAlt(PRThreadImpl.java:467)
at com.pega.pegarules.session.internal.engineinterface.service.HttpAPI.runActivities(HttpAPI.java:3166)
at com.pega.pegarules.session.external.engineinterface.service.EngineAPI.processRequestInner(EngineAPI.java:390)
at sun.reflect.GeneratedMethodAccessor106.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56)
at java.lang.reflect.Method.invoke(Method.java:620)
at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1301)
at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1038)
at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:893)
at com.pega.pegarules.session.external.engineinterface.service.EngineAPI.processRequest(EngineAPI.java:331)
at com.pega.pegarules.session.internal.engineinterface.service.HttpAPI.invoke(HttpAPI.java:825)
at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl._invokeEngine_privact(EngineImpl.java:327)
at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl.invokeEngine(EngineImpl.java:270)
at com.pega.pegarules.session.internal.engineinterface.etier.ejb.EngineBean.invokeEngine(EngineBean.java:225)
at sun.reflect.GeneratedMethodAccessor69.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56)
at java.lang.reflect.Method.invoke(Method.java:620)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:370)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:411)
at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:224)
at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingException(AppServerBridgeToPega.java:246)
at com.pega.pegarules.internal.etier.ejb.EngineBeanBoot.invokeEngine(EngineBeanBoot.java:168)
at com.pega.pegarules.internal.etier.interfaces.EJSLocalStatelessEngineBMT_f2439d86.invokeEngine(Unknown Source)
at com.pega.pegarules.priv.context.JNDIEnvironment.invokeEngineInner(JNDIEnvironment.java:278)
at com.pega.pegarules.priv.context.JNDIEnvironment.invokeEngine(JNDIEnvironment.java:223)
at com.pega.pegarules.web.impl.WebStandardImpl.makeEtierRequest(WebStandardImpl.java:594)
at com.pega.pegarules.web.impl.WebStandardImpl.doPost(WebStandardImpl.java:390)
at sun.reflect.GeneratedMethodAccessor105.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56)
at java.lang.reflect.Method.invoke(Method.java:620)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:370)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:411)
at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:224)
at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:273)
at com.pega.pegarules.internal.web.servlet.WebStandardBoot.doPost(WebStandardBoot.java:121)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1232)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:781)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:480)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1114)
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3926)
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:304)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1007)
at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1817)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:200)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:463)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:530)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:316)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:88)
at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1818)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175)
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:138)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1881)
Caused by:
com.pega.pegarules.pub.PRRuntimeException: PRRuntimeException
at com.pega.pegarules.data.internal.clipboard.DirectStreamEncoderV7$PageSection$PageEntry.writeSection(DirectStreamEncoderV7.java:2760)
at com.pega.pegarules.data.internal.clipboard.DirectStreamEncoderV7$PageSection.writeSection(DirectStreamEncoderV7.java:2558)
at com.pega.pegarules.data.internal.clipboard.DirectStreamEncoderV7.encode(DirectStreamEncoderV7.java:456)
at com.pega.pegarules.data.internal.clipboard.StorageStreamCommonImpl.encode(StorageStreamCommonImpl.java:853)
at com.pega.pegarules.data.internal.clipboard.ClipboardPageImpl.getStreamForm(ClipboardPageImpl.java:3873)
at com.pega.pegarules.data.internal.access.PageDatabaseMapperImpl.getStreamFormOfPage(PageDatabaseMapperImpl.java:1458)
at com.pega.pegarules.data.internal.access.DatabaseImpl.preprocessInstancesBeforeCriticalCommitSection(DatabaseImpl.java:3235)
... 86 more
Caused by:
com.pega.pegarules.data.internal.clipboard.directstream.BadStreamDataException: Irregular or Corrupted Stream. Unable to read string property. Array length: 32768, start index: 5180, num bytes: 7536754
at com.pega.pegarules.data.internal.clipboard.directstream.ByteArrayUtil.getStringUTF16(ByteArrayUtil.java:293)
at com.pega.pegarules.data.internal.clipboard.directstream.ByteArrayUtil.getStringUTF16(ByteArrayUtil.java:245)
at com.pega.pegarules.data.internal.clipboard.DirectStreamEncoderV7$StringSection.getStringUsingOffset(DirectStreamEncoderV7.java:3638)
at com.pega.pegarules.data.internal.clipboard.DirectStreamEncoderV7$StringSection.access$200(DirectStreamEncoderV7.java:3600)
at com.pega.pegarules.data.internal.clipboard.DirectStreamEncoderV7$PageSection$PageEntry.writeSection(DirectStreamEncoderV7.java:2753)
Thank You!
Jayami Dayarathna
***Updated by moderator: Lochan to add Categories***
***Updated by Moderator: Marissa to remove proprietary information; update SR Details***
**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.