Question

12
Replies
7501
Views
Jayami Dayarathna (JayamiD3)
EvonSys (Pvt) Ltd
Senior Consultant - Technology
EvonSys (Pvt) Ltd
LK
JayamiD3 Member since 2012 19 posts
EvonSys (Pvt) Ltd
Posted: May 10, 2017
Last activity: October 16, 2018
Posted: 10 May 2017 3:22 EDT
Last activity: 16 Oct 2018 12:03 EDT
Closed
Solved

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.

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.

Data Integration System Administration Support Case Created
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.