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:

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
FirstInput Activity=FinishAssignment
Interaction 52
JavaStackTrace java.lang.RuntimeException: com.pega.pegarules.pub.PRRuntimeException: Encountered database exception when committing operation
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
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

@EdwardA6 this sounds like a mis-configuration or mis-use of a function call.

Usually these sorts of WrongModeException errors occur when in custom application code or rules where improper data is written to the database. See archived SA-48668 for more information. There may be a discrepancy in the application-based validation (ABV) list and the runtime list. During design time, the ABV occurs across rulesets or branches. During runtime (using VTable), additional filtering is performed on branches. Hence, the exception occurs at runtime when the rule is checked-in (that is, in the branch).

Regarding the following:

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”

Please can you validate your process flow, declare pages et and the data you are trying to generate?

Try to simplify your flow to catch where the error is happening.

Please check other forum posts containing that error. I found this post..