Question
Open to work
GB
Last activity: 12 Jan 2023 12:35 EST
com.pega.pegarules.pub.PRRuntimeException: Encountered database exception when committing operation
I am newbie to Pega and i am using the latest PE for learning.. When i hit 'Submit ' button to run a case , the following error is displayed:
"There has been an issue; please consult your system administrator" Checking the error in the tracer viewer log , it ihe "com.pega.pegarules.pub.PRRuntimeException" as per title above
Logs:
I am newbie to Pega and i am using the latest PE for learning.. When i hit 'Submit ' button to run a case , the following error is displayed:
"There has been an issue; please consult your system administrator" Checking the error in the tracer viewer log , it ihe "com.pega.pegarules.pub.PRRuntimeException" as per title above
Logs:
Name Exception [600]
RULE-OBJ-ACTIVITY WORK- COMMITWITHERRORHANDLING #20180713T133047.594 GMT
ActivityName COMMITWITHERRORHANDLING
ActivityNumber 18
Break Breakpoint
CorrelationID HM4KZK3DCRSHGDC1CMF6O4O9SJ04JY36OA
DateTime 20220928T174330.329 GMT
EventKey RULE-OBJ-ACTIVITY WORK- COMMITWITHERRORHANDLING #20180713T133047.594 GMT
EventName Exception
EventType Exception
ExceptionTrace java.lang.RuntimeException: com.pega.pegarules.pub.PRRuntimeException: Encountered database exception when committing operation <insert instance TCB-EMEA-ZIM-TCBAPP-WORK T-2014 not only if new>
FirstInput Activity=FinishAssignment
Interaction 52
JavaStackTrace java.lang.RuntimeException: com.pega.pegarules.pub.PRRuntimeException: Encountered database exception when committing operation <insert instance TCB-EMEA-ZIM-TCBAPP-WORK T-2014 not only if new>
at com.pega.pegarules.data.internal.access.DatabaseImpl.commit(DatabaseImpl.java:2197)
at com.pega.pegarules.data.internal.access.DatabaseImpl.commit(DatabaseImpl.java:2124)
at com.pegarules.generated.activity.ra_action_commitwitherrorhandling_663a578384fcc69efadf2473d5dbfc39.step4_circum0(ra_action_commitwitherrorhandling_663a578384fcc69efadf2473d5dbfc39.java:522)
at com.pegarules.generated.activity.ra_action_commitwitherrorhandling_663a578384fcc69efadf2473d5dbfc39.perform(ra_action_commitwitherrorhandling_663a578384fcc69efadf2473d5dbfc39.java:127)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:2850)
at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:11439)
at com.pegarules.generated.activity.ra_action_workcommit_831f9b05908e4e9b7562054e154dc90d.step3_circum0(ra_action_workcommit_831f9b05908e4e9b7562054e154dc90d.java:426)
at com.pegarules.generated.activity.ra_action_workcommit_831f9b05908e4e9b7562054e154dc90d.perform(ra_action_workcommit_831f9b05908e4e9b7562054e154dc90d.java:110)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:2850)
at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:11439)
at com.pegarules.generated.activity.ra_action_finishassignment_e8fe2003e3b7eb82d467c7515e2139c4.step19_circum0(ra_action_finishassignment_e8fe2003e3b7eb82d467c7515e2139c4.java:2134)
at com.pegarules.generated.activity.ra_action_finishassignment_e8fe2003e3b7eb82d467c7515e2139c4.perform(ra_action_finishassignment_e8fe2003e3b7eb82d467c7515e2139c4.java:391)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:2850)
at com.pega.pegarules.session.internal.mgmt.base.ThreadRunner.runActivitiesAlt(ThreadRunner.java:653)
at com.pega.pegarules.session.internal.mgmt.PRThreadImpl.runActivitiesAlt(PRThreadImpl.java:519)
at com.pega.pegarules.session.internal.engineinterface.service.HttpAPI.runActivities(HttpAPI.java:4303)
at com.pega.pegarules.session.external.engineinterface.service.EngineAPI.processRequestInner(EngineAPI.java:445)
at sun.reflect.GeneratedMethodAccessor103.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1391)
at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1123)
at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:977)
at com.pega.pegarules.session.external.engineinterface.service.EngineAPI.processRequest(EngineAPI.java:368)
at com.pega.pegarules.session.internal.engineinterface.service.HttpAPI.invoke(HttpAPI.java:930)
at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl._invokeEngine_privact(EngineImpl.java:338)
at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl.invokeEngine(EngineImpl.java:282)
at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl.invokeEngine(EngineImpl.java:259)
at com.pega.pegarules.priv.context.JNDIEnvironment.invokeEngineInner(JNDIEnvironment.java:281)
at com.pega.pegarules.priv.context.JNDIEnvironment.invokeEngine(JNDIEnvironment.java:226)
at com.pega.pegarules.web.impl.WebStandardImpl.invokeEngine(WebStandardImpl.java:837)
at com.pega.pegarules.web.impl.WebStandardImpl.makeEtierRequest(WebStandardImpl.java:797)
at com.pega.pegarules.web.impl.WebStandardImpl.doPostInner(WebStandardImpl.java:420)
at sun.reflect.GeneratedMethodAccessor100.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:388)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:430)
at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:225)
at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:274)
at com.pega.pegarules.internal.web.servlet.WebStandardBoot.doPost(WebStandardBoot.java:164)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
at com.pega.pegarules.internal.web.servlet.WebStandardBoot.service(WebStandardBoot.java:191)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:799)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:861)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.pega.pegarules.pub.PRRuntimeException: Encountered database exception when committing operation <insert instance TCB-EMEA-ZIM-TCBAPP-WORK T-2014 not only if new>
at com.pega.pegarules.data.internal.access.UpdateProcessor.performOps(UpdateProcessor.java:1855)
at com.pega.pegarules.data.internal.access.UpdateProcessor.action(UpdateProcessor.java:288)
at com.pega.pegarules.data.internal.access.UpdateProcessor.action(UpdateProcessor.java:101)
at com.pega.pegarules.data.internal.store.DataStoreManager.doInTransaction(DataStoreManager.java:273)
at com.pega.pegarules.data.internal.access.UpdateProcessor.processUpdates(UpdateProcessor.java:218)
at com.pega.pegarules.data.internal.access.DatabaseImpl.commit(DatabaseImpl.java:2162)
... 65 more
Caused by: com.pega.pegarules.pub.clipboard.WrongModeException: property 'ContactNumbers' is defined as a column but is of mode String Group instead of required mode String
at com.pega.pegarules.data.internal.access.PageDatabaseMapperImpl.fillInStatementFromPageWithStream(PageDatabaseMapperImpl.java:1304)
at com.pega.pegarules.data.internal.store.ManagedTransaction.getStatementWithPrepValues(ManagedTransaction.java:1000)
at com.pega.pegarules.data.internal.store.ManagedTransaction.addBatchRdbms(ManagedTransaction.java:906)
at com.pega.pegarules.data.internal.store.ManagedTransaction.performUpdate(ManagedTransaction.java:789)
at com.pega.pegarules.data.internal.access.Saver.saveInstance(Saver.java:934)
at com.pega.pegarules.data.internal.access.Saver.saveInstance(Saver.java:876)
at com.pega.pegarules.data.internal.access.UpdateProcessor.performOps(UpdateProcessor.java:1534)
... 70 more
LastStep WORK- COMMITWITHERRORHANDLING #20180713T133047.594 GMT Step: 4 Circum: 0
NodeID 444183a2baab41bc92604cc073a419db
NodeName DESKTOP-GN1PIP1
ParameterPageContent
ParameterPageName =unnamed=
PrimaryPageClass TCB-EMEA-ZIM-TCBApp-Work-TCB
PrimaryPageContent
PrimaryPageName pyWorkPage
RequestorID HM4KZK3DCRSHGDC1CMF6O4O9SJ04JY36OA
Sequence 599
StepNumber 4
ThreadName PS2__TABTHREAD0
WorkPool TCB-EMEA-ZIM-TCBApp-Work