Question

2
Replies
65
Views
HemantK9 Member since 2018 6 posts
Cognizant Technology Solutions India PVT Ltd
Posted: November 1, 2019
Last activity: November 3, 2019
Closed

Merge Query issue

Hi team,

Can you please help me in analyzing below merge query issue which I am seeing in logs?

As per logs, I am seeing thread dumps as well as requestor lock exception when system is trying to run Merge query at the time of work object creation. Below you can find log sample. Also, in alert logs I am seeing in pzInskey is only having class name and there is no pyid.

? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?)) AS inputs ("pzInsKey" , "AccountNumber" , "AcctBusinessLine" , "ApprovedBy" , "AssignTo" , "Branch" , "BulkAccounts" , "CaseType" , "Category" , "ClientCard" , "ClientName" , "ClientSegmentation" , "CreateReqID" , "HasAttachments" , "IACode" , "InitiatorLOB" , "InterDeptCase" , "IsDSR" , "PCDID" , "ProActive" , "ProactiveSLA" , "pxApplication" , "pxApplicationVersion" , "pxCoveredCount" , "pxCoveredCountOpen" , "pxCoveredCountUnsatisfied" , "pxCoverInsKey" , "pxCreateDateTime" , "pxCreateOperator" , "pxCreateOpName" , "pxCreateSystemID" , "pxCurrentStage" , "pxCurrentStageLabel" , "pxExternalSystemUpdateCount" , "pxFlowCount" , "pxInsName" , "pxObjClass" , "pxSaveDateTime" , "pxUpdateDateTime" , "pxUpdateOperator" , "pxUpdateOpName" , "pxUpdateSystemID" , "pxUrgencyWork" , "pyAckTimestamp" , "pyAgeFromDate" , "pyChargeAmount" , "pyChargeTo" , "pyContactChannel" , "pyContactType" , "pyCusLevel" , "pyCustomer" , "pyCustomerEnterprise" , "pyCustomerName" , "pyCustomerOrg" , "pyCustomerSatisfiedTimestamp" , "pyDescription" , "pyEffortActual" , "pyEffortEstimate" , "pyEffortEstimateTimestamp" , "pyElapsedCustomerAck" , "pyElapsedCustomerUnsatisfied" , "pyElapsedPastDeadline" , "pyElapsedPastGoal" , "pyElapsedStatusNew" , "pyElapsedStatusOpen" , "pyElapsedStatusPending" , "pyEventID" , "pyFolderType" , "pyID" , "pyLabel" , "pyOrigDivision" , "pyOrigOrg" , "pyOrigOrgUnit" , "pyOrigUserDivision" , "pyOrigUserID" , "pyOrigUserWorkgroup" , "pyOwnerDivision" , "pyOwnerOrg" , "pyOwnerOrgUnit" , "pyPrimaryContact" , "pyProblemReason" , "pyProblemSource" , "pyProblemType" , "pyReopenCount" , "pyReopenTimestamp" , "pyResolutionComplexity" , "pyResolutionCost" , "pyResolvedDivision" , "pyResolvedOrg" , "pyResolvedOrgUnit" , "pyResolvedTime" , "pyResolvedTimestamp" , "pyResolvedUserID" , "pyResolvedUserWorkgroup" , "pyRootCause" , "pySLADeadline" , "pySLAGoal" , "pySLAName" , "pyStatusCustomerSat" , "pyStatusWork" , "pyWorkListDate1" , "pyWorkListDateTime1" , "pyWorkListDateTime2" , "pyWorkListDecimal1" , "pyWorkListDecimal2" , "pyWorkListInteger1" , "pyWorkListText1" , "pyWorkListText2" , "pyWorkListText3" , "QueueID" , "ReOpenReason" , "RequestType" , "SecurityCode" , "SIN" , "SourceOfRequest" , "SubCategory" , "Subject" , "SubmittedDateTime" , "Tracking" , "TransactionDate" , "WasReClassified" , "WasRejected" , "WasReOpen" , "WasRFI" , "ASSIGNNAME" , "EXTRACTDATETIME" , "PYURGENCYADJUSTMENT" , "SECURITYATTRIBUTE" , "pzPVStream") ON (t.pzInsKey = inputs."pzInsKey") WHEN MATCHED THEN UPDATE SET "ACCOUNTNUMBER" = inputs."AccountNumber" , "ACCTBUSINESSLINE" = inputs."AcctBusinessLine" , "APPROVEDBY" = inputs."ApprovedBy" , "ASSIGNTO" = inputs."AssignTo" , "BRANCH" = inputs."Branch" , "BULKACCOUNTS" = inputs."BulkAccounts" , "CASETYPE" = inputs."CaseType" , "CATEGORY" = inputs."Category" , "CLIENTCARD" = inputs."ClientCard" , "CLIENTNAME" = inputs."ClientName" , "CLIENTSEGMENTATION" = inputs."ClientSegmentation" , "CREATEREQID" = inputs."CreateReqID" , "HASATTACHMENTS" = inputs."HasAttachments" , "IACODE" = inputs."IACode" , "INITIATORLOB" = inputs."InitiatorLOB" , "INTERDEPTCASE" = inputs."InterDeptCase" , "ISDSR" = inputs."IsDSR" , "PCDID" = inputs."PCDID" , "PROACTIVE" = inputs."ProActive" , "PROACTIVESLA" = inputs."ProactiveSLA" , "PXAPPLICATION" = inputs."pxApplication" , "PXAPPLICATIONVERSION" = inputs."pxApplicationVersion" , "PXCOVEREDCOUNT" = inputs."pxCoveredCount" , "PXCOVEREDCOUNTOPEN" = inputs."pxCoveredCountOpen" , "PXCOVEREDCOUNTUNSATISFIED" = inputs."pxCoveredCountUnsatisfied" , "PXCOVERINSKEY" = inputs."pxCoverInsKey" , "PXCREATEDATETIME" = inputs."pxCreateDateTime" , "PXCREATEOPERATOR" = inputs."pxCreateOperator" , "PXCREATEOPNAME" = inputs."pxCreateOpName" , "PXCREATESYSTEMID" = inputs."pxCreateSystemID" , "PXCURRENTSTAGE" = inputs."pxCurrentStage" , "PXCURRENTSTAGELABEL" = inputs."pxCurrentStageLabel" , "PXEXTERNALSYSTEMUPDATECOUNT" = inputs."pxExternalSystemUpdateCount" , "PXFLOWCOUNT" = inputs."pxFlowCount" , "PXINSNAME" = inputs."pxInsName" , "PXOBJCLASS" = inputs."pxObjClass" , "PXSAVEDATETIME" = inputs."pxSaveDateTime" , "PXUPDATEDATETIME" = inputs."pxUpdateDateTime" , "PXUPDATEOPERATOR" = inputs."pxUpdateOperator" , "PXUPDATEOPNAME" = inputs."pxUpdateOpName" , "PXUPDATESYSTEMID" = inputs."pxUpdateSystemID" , "PXURGENCYWORK" = inputs."pxUrgencyWork" , "PYACKTIMESTAMP" = inputs."pyAckTimestamp" , "PYAGEFROMDATE" = inputs."pyAgeFromDate" , "PYCHARGEAMOUNT" = inputs."pyChargeAmount" , "PYCHARGETO" = inputs."pyChargeTo" , "PYCONTACTCHANNEL" = inputs."pyContactChannel" , "PYCONTACTTYPE" = inputs."pyContactType" , "PYCUSLEVEL" = inputs."pyCusLevel" , "PYCUSTOMER" = inputs."pyCustomer" , "PYCUSTOMERENTERPRISE" = inputs."pyCustomerEnterprise" , "PYCUSTOMERNAME" = inputs."pyCustomerName" , "PYCUSTOMERORG" = inputs."pyCustomerOrg" , "PYCUSTOMERSATISFIEDTIMESTAMP" = inputs."pyCustomerSatisfiedTimestamp" , "PYDESCRIPTION" = inputs."pyDescription" , "PYEFFORTACTUAL" = inputs."pyEffortActual" , "PYEFFORTESTIMATE" = inputs."pyEffortEstimate" , "PYEFFORTESTIMATETIMESTAMP" = inputs."pyEffortEstimateTimestamp" , "PYELAPSEDCUSTOMERACK" = inputs."pyElapsedCustomerAck" , "PYELAPSEDCUSTOMERUNSATISFIED" = inputs."pyElapsedCustomerUnsatisfied" , "PYELAPSEDPASTDEADLINE" = inputs."pyElapsedPastDeadline" , "PYELAPSEDPASTGOAL" = inputs."pyElapsedPastGoal" , "PYELAPSEDSTATUSNEW" = inputs."pyElapsedStatusNew" , "PYELAPSEDSTATUSOPEN" = inputs."pyElapsedStatusOpen" , "PYELAPSEDSTATUSPENDING" = inputs."pyElapsedStatusPending" , "PYEVENTID" = inputs."pyEventID" , "PYFOLDERTYPE" = inputs."pyFolderType" , "PYID" = inputs."pyID" , "PYLABEL" = inputs."pyLabel" , "PYORIGDIVISION" = inputs."pyOrigDivision" , "PYORIGORG" = inputs."pyOrigOrg" , "PYORIGORGUNIT" = inputs."pyOrigOrgUnit" , "PYORIGUSERDIVISION" = inputs."pyOrigUserDivision" , "PYORIGUSERID" = inputs."pyOrigUserID" , "PYORIGUSERWORKGROUP" = inputs."pyOrigUserWorkgroup" , "PYOWNERDIVISION" = inputs."pyOwnerDivision" , "PYOWNERORG" = inputs."pyOwnerOrg" , "PYOWNERORGUNIT" = inputs."pyOwnerOrgUnit" , "PYPRIMARYCONTACT" = inputs."pyPrimaryContact" , "PYPROBLEMREASON" = inputs."pyProblemReason" , "PYPROBLEMSOURCE" = inputs."pyProblemSource" , "PYPROBLEMTYPE" = inputs."pyProblemType" , "PYREOPENCOUNT" = inputs."pyReopenCount" , "PYREOPENTIMESTAMP" = inputs."pyReopenTimestamp" , "PYRESOLUTIONCOMPLEXITY" = inputs."pyResolutionComplexity" , "PYRESOLUTIONCOST" = inputs."pyResolutionCost" , "PYRESOLVEDDIVISION" = inputs."pyResolvedDivision" , "PYRESOLVEDORG" = inputs."pyResolvedOrg" , "PYRESOLVEDORGUNIT" = inputs."pyResolvedOrgUnit" , "PYRESOLVEDTIME" = inputs."pyResolvedTime" , "PYRESOLVEDTIMESTAMP" = inputs."pyResolvedTimestamp" , "PYRESOLVEDUSERID" = inputs."pyResolvedUserID" , "PYRESOLVEDUSERWORKGROUP" = inputs."pyResolvedUserWorkgroup" , "PYROOTCAUSE" = inputs."pyRootCause" , "PYSLADEADLINE" = inputs."pySLADeadline" , "PYSLAGOAL" = inputs."pySLAGoal" , "PYSLANAME" = inputs."pySLAName" , "PYSTATUSCUSTOMERSAT" = inputs."pyStatusCustomerSat" , "PYSTATUSWORK" = inputs."pyStatusWork" , "PYWORKLISTDATE1" = inputs."pyWorkListDate1" , "PYWORKLISTDATETIME1" = inputs."pyWorkListDateTime1" , "PYWORKLISTDATETIME2" = inputs."pyWorkListDateTime2" , "PYWORKLISTDECIMAL1" = inputs."pyWorkListDecimal1" , "PYWORKLISTDECIMAL2" = inputs."pyWorkListDecimal2" , "PYWORKLISTINTEGER1" = inputs."pyWorkListInteger1" , "PYWORKLISTTEXT1" = inputs."pyWorkListText1" , "PYWORKLISTTEXT2" = inputs."pyWorkListText2" , "PYWORKLISTTEXT3" = inputs."pyWorkListText3" , "QUEUEID" = inputs."QueueID" , "REOPENREASON" = inputs."ReOpenReason" , "REQUESTTYPE" = inputs."RequestType" , "SECURITYCODE" = inputs."SecurityCode" , "SIN" = inputs."SIN" , "SOURCEOFREQUEST" = inputs."SourceOfRequest" , "SUBCATEGORY" = inputs."SubCategory" , "SUBJECT" = inputs."Subject" , "SUBMITTEDDATETIME" = inputs."SubmittedDateTime" , "TRACKING" = inputs."Tracking" , "TRANSACTIONDATE" = inputs."TransactionDate" , "WASRECLASSIFIED" = inputs."WasReClassified" , "WASREJECTED" = inputs."WasRejected" , "WASREOPEN" = inputs."WasReOpen" , "WASRFI" = inputs."WasRFI" , "ASSIGNNAME" = inputs."ASSIGNNAME" , "EXTRACTDATETIME" = inputs."EXTRACTDATETIME" , "PYURGENCYADJUSTMENT" = inputs."PYURGENCYADJUSTMENT" , "SECURITYATTRIBUTE" = inputs."SECURITYATTRIBUTE" , pzPVStream = inputs."pzPVStream" , pxCommitDateTime = CURRENT_TIMESTAMP WHEN NOT MATCHED THEN INSERT (pzInsKey , pxCommitDateTime , "ACCOUNTNUMBER" , "ACCTBUSINESSLINE" , "APPROVEDBY" , "ASSIGNTO" , "BRANCH" , "BULKACCOUNTS" , "CASETYPE" , "CATEGORY" , "CLIENTCARD" , "CLIENTNAME" , "CLIENTSEGMENTATION" , "CREATEREQID" , "HASATTACHMENTS" , "IACODE" , "INITIATORLOB" , "INTERDEPTCASE" , "ISDSR" , "PCDID" , "PROACTIVE" , "PROACTIVESLA" , "PXAPPLICATION" , "PXAPPLICATIONVERSION" , "PXCOVEREDCOUNT" , "PXCOVEREDCOUNTOPEN" , "PXCOVEREDCOUNTUNSATISFIED" , "PXCOVERINSKEY" , "PXCREATEDATETIME" , "PXCREATEOPERATOR" , "PXCREATEOPNAME" , "PXCREATESYSTEMID" , "PXCURRENTSTAGE" , "PXCURRENTSTAGELABEL" , "PXEXTERNALSYSTEMUPDATECOUNT" , "PXFLOWCOUNT" , "PXINSNAME" , "PXOBJCLASS" , "PXSAVEDATETIME" , "PXUPDATEDATETIME" , "PXUPDATEOPERATOR" , "PXUPDATEOPNAME" , "PXUPDATESYSTEMID" , "PXURGENCYWORK" , "PYACKTIMESTAMP" , "PYAGEFROMDATE" , "PYCHARGEAMOUNT" , "PYCHARGETO" , "PYCONTACTCHANNEL" , "PYCONTACTTYPE" , "PYCUSLEVEL" , "PYCUSTOMER" , "PYCUSTOMERENTERPRISE" , "PYCUSTOMERNAME" , "PYCUSTOMERORG" , "PYCUSTOMERSATISFIEDTIMESTAMP" , "PYDESCRIPTION" , "PYEFFORTACTUAL" , "PYEFFORTESTIMATE" , "PYEFFORTESTIMATETIMESTAMP" , "PYELAPSEDCUSTOMERACK" , "PYELAPSEDCUSTOMERUNSATISFIED" , "PYELAPSEDPASTDEADLINE" , "PYELAPSEDPASTGOAL" , "PYELAPSEDSTATUSNEW" , "PYELAPSEDSTATUSOPEN" , "PYELAPSEDSTATUSPENDING" , "PYEVENTID" , "PYFOLDERTYPE" , "PYID" , "PYLABEL" , "PYORIGDIVISION" , "PYORIGORG" , "PYORIGORGUNIT" , "PYORIGUSERDIVISION" , "PYORIGUSERID" , "PYORIGUSERWORKGROUP" , "PYOWNERDIVISION" , "PYOWNERORG" , "PYOWNERORGUNIT" , "PYPRIMARYCONTACT" , "PYPROBLEMREASON" , "PYPROBLEMSOURCE" , "PYPROBLEMTYPE" , "PYREOPENCOUNT" , "PYREOPENTIMESTAMP" , "PYRESOLUTIONCOMPLEXITY" , "PYRESOLUTIONCOST" , "PYRESOLVEDDIVISION" , "PYRESOLVEDORG" , "PYRESOLVEDORGUNIT" , "PYRESOLVEDTIME" , "PYRESOLVEDTIMESTAMP" , "PYRESOLVEDUSERID" , "PYRESOLVEDUSERWORKGROUP" , "PYROOTCAUSE" , "PYSLADEADLINE" , "PYSLAGOAL" , "PYSLANAME" , "PYSTATUSCUSTOMERSAT" , "PYSTATUSWORK" , "PYWORKLISTDATE1" , "PYWORKLISTDATETIME1" , "PYWORKLISTDATETIME2" , "PYWORKLISTDECIMAL1" , "PYWORKLISTDECIMAL2" , "PYWORKLISTINTEGER1" , "PYWORKLISTTEXT1" , "PYWORKLISTTEXT2" , "PYWORKLISTTEXT3" , "QUEUEID" , "REOPENREASON" , "REQUESTTYPE" , "SECURITYCODE" , "SIN" , "SOURCEOFREQUEST" , "SUBCATEGORY" , "SUBJECT" , "SUBMITTEDDATETIME" , "TRACKING" , "TRANSACTIONDATE" , "WASRECLASSIFIED" , "WASREJECTED" , "WASREOPEN" , "WASRFI" , "ASSIGNNAME" , "EXTRACTDATETIME" , "PYURGENCYADJUSTMENT" , "SECURITYATTRIBUTE" , pzPVStream) VALUES (inputs."pzInsKey" , CURRENT_TIMESTAMP , inputs."AccountNumber" , inputs."AcctBusinessLine" , inputs."ApprovedBy" , inputs."AssignTo" , inputs."Branch" , inputs."BulkAccounts" , inputs."CaseType" , inputs."Category" , inputs."ClientCard" , inputs."ClientName" , inputs."ClientSegmentation" , inputs."CreateReqID" , inputs."HasAttachments" , inputs."IACode" , inputs."InitiatorLOB" , inputs."InterDeptCase" , inputs."IsDSR" , inputs."PCDID" , inputs."ProActive" , inputs."ProactiveSLA" , inputs."pxApplication" , inputs."pxApplicationVersion" , inputs."pxCoveredCount" , inputs."pxCoveredCountOpen" , inputs."pxCoveredCountUnsatisfied" , inputs."pxCoverInsKey" , inputs."pxCreateDateTime" , inputs."pxCreateOperator" , inputs."pxCreateOpName" , inputs."pxCreateSystemID" , inputs."pxCurrentStage" , inputs."pxCurrentStageLabel" , inputs."pxExternalSystemUpdateCount" , inputs."pxFlowCount" , inputs."pxInsName" , inputs."pxObjClass" , inputs."pxSaveDateTime" , inputs."pxUpdateDateTime" , inputs."pxUpdateOperator" , inputs."pxUpdateOpName" , inputs."pxUpdateSystemID" , inputs."pxUrgencyWork" , inputs."pyAckTimestamp" , inputs."pyAgeFromDate" , inputs."pyChargeAmount" , inputs."pyChargeTo" , inputs."pyContactChannel" , inputs."pyContactType" , inputs."pyCusLevel" , inputs."pyCustomer" , inputs."pyCustomerEnterprise" , inputs."pyCustomerName" , inputs."pyCustomerOrg" , inputs."pyCustomerSatisfiedTimestamp" , inputs."pyDescription" , inputs."pyEffortActual" , inputs."pyEffortEstimate" , inputs."pyEffortEstimateTimestamp" , inputs."pyElapsedCustomerAck" , inputs."pyElapsedCustomerUnsatisfied" , inputs."pyElapsedPastDeadline" , inputs."pyElapsedPastGoal" , inputs."pyElapsedStatusNew" , inputs."pyElapsedStatusOpen" , inputs."pyElapsedStatusPending" , inputs."pyEventID" , inputs."pyFolderType" , inputs."pyID" , inputs."pyLabel" , inputs."pyOrigDivision" , inputs."pyOrigOrg" , inputs."pyOrigOrgUnit" , inputs."pyOrigUserDivision" , inputs."pyOrigUserID" , inputs."pyOrigUserWorkgroup" , inputs."pyOwnerDivision" , inputs."pyOwnerOrg" , inputs."pyOwnerOrgUnit" , inputs."pyPrimaryContact" , inputs."pyProblemReason" , inputs."pyProblemSource" , inputs."pyProblemType" , inputs."pyReopenCount" , inputs."pyReopenTimestamp" , inputs."pyResolutionComplexity" , inputs."pyResolutionCost" , inputs."pyResolvedDivision" , inputs."pyResolvedOrg" , inputs."pyResolvedOrgUnit" , inputs."pyResolvedTime" , inputs."pyResolvedTimestamp" , inputs."pyResolvedUserID" , inputs."pyResolvedUserWorkgroup" , inputs."pyRootCause" , inputs."pySLADeadline" , inputs."pySLAGoal" , inputs."pySLAName" , inputs."pyStatusCustomerSat" , inputs."pyStatusWork" , inputs."pyWorkListDate1" , inputs."pyWorkListDateTime1" , inputs."pyWorkListDateTime2" , inputs."pyWorkListDecimal1" , inputs."pyWorkListDecimal2" , inputs."pyWorkListInteger1" , inputs."pyWorkListText1" , inputs."pyWorkListText2" , inputs."pyWorkListText3" , inputs."QueueID" , inputs."ReOpenReason" , inputs."RequestType" , inputs."SecurityCode" , inputs."SIN" , inputs."SourceOfRequest" , inputs."SubCategory" , inputs."Subject" , inputs."SubmittedDateTime" , inputs."Tracking" , inputs."TransactionDate" , inputs."WasReClassified" , inputs."WasRejected" , inputs."WasReOpen" , inputs."WasRFI" , inputs."ASSIGNNAME" , inputs."EXTRACTDATETIME" , inputs."PYURGENCYADJUSTMENT" , inputs."SECURITYATTRIBUTE" , inputs."pzPVStream")

Caused by SQL Problems.

Problem #1, SQLState null, Error code -4229: com.ibm.db2.jcc.am.BatchUpdateException: [jcc][t4][102][10040][4.19.77] Batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch.

Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4229, SQLSTATE=null

Problem #2, SQLState 40506, Error code -1476: com.ibm.db2.jcc.am.SqlTransactionRollbackException: Error for batch element #1: DB2 SQL Error: SQLCODE=-1476, SQLSTATE=40506, SQLERRMC=-911, DRIVER=4.19.77

Problem #3, SQLState null, Error code -4225: com.ibm.db2.jcc.am.SqlException: [jcc][103][10843][4.19.77] Non-recoverable chain-breaking exception occurred during batch processing. The batch is terminated non-atomically. ERRORCODE=-4225, SQLSTATE=null

DatabaseException caused by prior exception: com.ibm.db2.jcc.am.BatchUpdateException: [jcc][t4][102][10040][4.19.77] Batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch.

Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4229, SQLSTATE=null

| SQL Code: -4229 | SQL State: null

DatabaseException caused by prior exception: com.ibm.db2.jcc.am.SqlTransactionRollbackException: Error for batch element #1: DB2 SQL Error: SQLCODE=-1476, SQLSTATE=40506, SQLERRMC=-911, DRIVER=4.19.77

| SQL Code: -1476 | SQL State: 40506

DatabaseException caused by prior exception: com.ibm.db2.jcc.am.SqlException: [jcc][103][10843][4.19.77] Non-recoverable chain-breaking exception occurred during batch processing. The batch is terminated non-atomically. ERRORCODE=-4225, SQLSTATE=null

| SQL Code: -4225 | SQL State: null

at com.pega.pegarules.data.internal.store.RetryPolicy.tryAgainOrFail(RetryPolicy.java:147) ~[prprivate.jar:?]

at com.pega.pegarules.data.internal.store.DataStoreManager.doInTransaction(DataStoreManager.java:300) ~[prprivate.jar:?]

at com.pega.pegarules.data.internal.access.UpdateProcessor.processUpdates(UpdateProcessor.java:215) ~[prprivate.jar:?]

at com.pega.pegarules.data.internal.access.DatabaseImpl.commit(DatabaseImpl.java:2120) ~[prprivate.jar:?]

at com.pega.pegarules.data.internal.access.DatabaseImpl.commit(DatabaseImpl.java:2082) ~[prprivate.jar:?]

at com.pegarules.generated.activity.ra_action_commitwitherrorhandling_663a578384fcc69efadf2473d5dbfc39.step4_circum0(ra_action_commitwitherrorhandling_663a578384fcc69efadf2473d5dbfc39.java:512) ~[?:?]

at com.pegarules.generated.activity.ra_action_commitwitherrorhandling_663a578384fcc69efadf2473d5dbfc39.perform(ra_action_commitwitherrorhandling_663a578384fcc69efadf2473d5dbfc39.java:123) ~[?:?]

at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:2695) ~[prprivate.jar:?]

at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10961) ~[prprivate.jar:?]

at com.pegarules.generated.activity.ra_action_workcommit_831f9b05908e4e9b7562054e154dc90d.step3_circum0(ra_action_workcommit_831f9b05908e4e9b7562054e154dc90d.java:418) ~[?:?]

at com.pegarules.generated.activity.ra_action_workcommit_831f9b05908e4e9b7562054e154dc90d.perform(ra_action_workcommit_831f9b05908e4e9b7562054e154dc90d.java:106) ~[?:?]

at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:2695) ~[prprivate.jar:?]

at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10961) ~[prprivate.jar:?]

at com.pegarules.generated.activity.ra_action_add_fbed7f5716dd358202c205432b9d9652.step8_circum0(ra_action_add_fbed7f5716dd358202c205432b9d9652.java:965) ~[?:?]

at com.pegarules.generated.activity.ra_action_add_fbed7f5716dd358202c205432b9d9652.perform(ra_action_add_fbed7f5716dd358202c205432b9d9652.java:195) ~[?:?]

at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:2695) ~[prprivate.jar:?]

at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10961) ~[prprivate.jar:?]

at com.pegarules.generated.activity.ra_action_new_28401dff1847bd831fb8b6f0d75e22b5.step18_circum0(ra_action_new_28401dff1847bd831fb8b6f0d75e22b5.java:1307) ~[?:?]

at com.pegarules.generated.activity.ra_action_new_28401dff1847bd831fb8b6f0d75e22b5.perform(ra_action_new_28401dff1847bd831fb8b6f0d75e22b5.java:399) ~[?:?]

at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:2695) ~[prprivate.jar:?]

at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10961) ~[prprivate.jar:?]

at com.pegarules.generated.activity.ra_action_createwo_529b0f8c8d623f66335758e2ae5436d3.step6_circum0(ra_action_createwo_529b0f8c8d623f66335758e2ae5436d3.java:637) ~[?:?]

at com.pegarules.generated.activity.ra_action_createwo_529b0f8c8d623f66335758e2ae5436d3.perform(ra_action_createwo_529b0f8c8d623f66335758e2ae5436d3.java:163) ~[?:?]

at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:2695) ~[prprivate.jar:?]

at com.pegarules.generated.flow.ra_action_findaclient_28c25964cba9af43a0fa88702a7e53fe.RunTaskActivity(ra_action_findaclient_28c25964cba9af43a0fa88702a7e53fe.java:5590) ~[?:?]

at com.pegarules.generated.flow.ra_action_findaclient_28c25964cba9af43a0fa88702a7e53fe.Task_Utility1_circum0(ra_action_findaclient_28c25964cba9af43a0fa88702a7e53fe.java:1557) ~[?:?]

at com.pegarules.generated.flow.ra_action_findaclient_28c25964cba9af43a0fa88702a7e53fe.perform(ra_action_findaclient_28c25964cba9af43a0fa88702a7e53fe.java:651) ~[?:?]

at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:2695) ~[prprivate.jar:?]

at com.pegarules.generated.StartFlow_080101__6814452274195860222.StartFlow08_01_01(StartFlow_080101__6814452274195860222.java:165) ~[?:?]

at com.pegarules.generated.StartFlow_080101__6814452274195860222.invoke(StartFlow_080101__6814452274195860222.java:74) ~[?:?]

at com.pega.pegarules.generation.internal.library.LibraryRuntime.resolveAndinvokeFunctionViaReflection(LibraryRuntime.java:222) ~[prprivate.jar:?]

at com.pega.pegarules.generation.internal.library.LibraryRuntime.invokeLibraryRuntime(LibraryRuntime.java:119) ~[prprivate.jar:?]

at com.pega.pegarules.session.internal.mgmt.Executable.invokeLibraryRuntime(Executable.java:9329) ~[prprivate.jar:?]

at com.pega.pegarules.priv.generator.LibrarySupport.resolveAndInvokeFunctionViaReflectionWithException(LibrarySupport.java:275) ~[prpublic.jar:?]

at java.lang.invoke.DirectHandle.invokeExact_thunkArchetype_L(DirectHandle.java:300) ~[?:2.9 (11-02-2017)]

at java.lang.invoke.BruteArgumentMoverHandle.invokeExact_thunkArchetype_X(ArgumentMoverHandle.java:406) ~[?:2.9 (11-02-2017)]

at java.lang.invoke.CollectHandle.invokeExact_thunkArchetype_X(CollectHandle.java:122) ~[?:2.9 (11-02-2017)]

at java.lang.invoke.FilterReturnHandle.invokeExact_thunkArchetype_X(FilterReturnHandle.java:59) ~[?:2.9 (11-02-2017)]

at java.lang.invoke.AsTypeHandle.invokeExact_thunkArchetype_X(AsTypeHandle.java:49) ~[?:2.9 (11-02-2017)]

at com.pegarules.generated.activity.ra_action_completeassignment_8647d0c6b1a3f49c61c420f1a0455af6.step28_circum0(ra_action_completeassignment_8647d0c6b1a3f49c61c420f1a0455af6.java:2737) ~[?:?]

at com.pegarules.generated.activity.ra_action_completeassignment_8647d0c6b1a3f49c61c420f1a0455af6.perform(ra_action_completeassignment_8647d0c6b1a3f49c61c420f1a0455af6.java:588) ~[?:?]

at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:2695) ~[prprivate.jar:?]

at com.pegarules.generated.callActivity_080101_7217029187124185656.callActivity08_01_01(callActivity_080101_7217029187124185656.java:133) ~[?:?]

at com.pegarules.generated.callActivity_080101_7217029187124185656.invoke(callActivity_080101_7217029187124185656.java:80) ~[?:?]

at com.pega.pegarules.generation.internal.library.LibraryRuntime.resolveAndinvokeFunctionViaReflection(LibraryRuntime.java:222) ~[prprivate.jar:?]

at com.pega.pegarules.generation.internal.library.LibraryRuntime.invokeLibraryRuntime(LibraryRuntime.java:119) ~[prprivate.jar:?]

at com.pega.pegarules.session.internal.mgmt.Executable.invokeLibraryRuntime(Executable.java:9329) ~[prprivate.jar:?]

at com.pega.pegarules.priv.generator.LibrarySupport.resolveAndInvokeFunctionViaReflectionWithException(LibrarySupport.java:275) ~[prpublic.jar:?]

at java.lang.invoke.DirectHandle.invokeExact_thunkArchetype_L(DirectHandle.java:300) ~[?:2.9 (11-02-2017)]

at java.lang.invoke.BruteArgumentMoverHandle.invokeExact_thunkArchetype_X(ArgumentMoverHandle.java:406) ~[?:2.9 (11-02-2017)]

at java.lang.invoke.CollectHandle.invokeExact_thunkArchetype_X(CollectHandle.java:122) ~[?:2.9 (11-02-2017)]

at java.lang.invoke.FilterReturnHandle.invokeExact_thunkArchetype_X(FilterReturnHandle.java:59) ~[?:2.9 (11-02-2017)]

at java.lang.invoke.AsTypeHandle.invokeExact_thunkArchetype_X(AsTypeHandle.java:49) ~[?:2.9 (11-02-2017)]

at com.pegarules.generated.activity.ra_action_performflowaction_9aa60608a589cdaa7517b78b5475f34f.step18_circum0(ra_action_performflowaction_9aa60608a589cdaa7517b78b5475f34f.java:1691) ~[?:?]

at com.pegarules.generated.activity.ra_action_performflowaction_9aa60608a589cdaa7517b78b5475f34f.perform(ra_action_performflowaction_9aa60608a589cdaa7517b78b5475f34f.java:368) ~[?:?]

at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:2695) ~[prprivate.jar:?]

at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10961) ~[prprivate.jar:?]

at com.pegarules.generated.activity.ra_action_finishassignment_e9fc6e321f0f3e75279b61b986cee8c2.step12_circum0(ra_action_finishassignment_e9fc6e321f0f3e75279b61b986cee8c2.java:1552) ~[?:?]

at com.pegarules.generated.activity.ra_action_finishassignment_e9fc6e321f0f3e75279b61b986cee8c2.perform(ra_action_finishassignment_e9fc6e321f0f3e75279b61b986cee8c2.java:267) ~[?:?]

at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:2695) ~[prprivate.jar:?]

at com.pega.pegarules.session.internal.mgmt.base.ThreadRunner.runActivitiesAlt(ThreadRunner.java:646) ~[prprivate.jar:?]

at com.pega.pegarules.session.internal.mgmt.PRThreadImpl.runActivitiesAlt(PRThreadImpl.java:490) ~[prprivate.jar:?]

at com.pega.pegarules.session.internal.engineinterface.service.HttpAPI.runActivities(HttpAPI.java:3838) ~[prprivate.jar:?]

at com.pega.pegarules.session.external.engineinterface.service.EngineAPI.processRequestInner(EngineAPI.java:438) ~[prenginext.jar:?]

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0]

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:90) ~[?:1.8.0]

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55) ~[?:1.8.0]

at java.lang.reflect.Method.invoke(Method.java:508) ~[?:1.8.0]

at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1382) ~[prprivate.jar:?]

at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1114) ~[prprivate.jar:?]

at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:968) ~[prprivate.jar:?]

at com.pega.pegarules.session.external.engineinterface.service.EngineAPI.processRequest(EngineAPI.java:361) ~[prenginext.jar:?]

at com.pega.pegarules.session.internal.engineinterface.service.HttpAPI.invoke(HttpAPI.java:892) ~[prprivate.jar:?]

at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl._invokeEngine_privact(EngineImpl.java:331) ~[prprivate.jar:?]

at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl.invokeEngine(EngineImpl.java:274) ~[prprivate.jar:?]

at com.pega.pegarules.session.internal.engineinterface.etier.ejb.EngineBean.invokeEngine(EngineBean.java:225) ~[prprivate.jar:?]

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0]

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:90) ~[?:1.8.0]

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55) ~[?:1.8.0]

at java.lang.reflect.Method.invoke(Method.java:508) ~[?:1.8.0]

at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:381) ~[prbootstrap.jar:8.2.2-354]

at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:422) ~[prbootstrap.jar:8.2.2-354]

at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:224) ~[prbootstrap-api.jar:8.2.2-354]

at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingException(AppServerBridgeToPega.java:246) ~[prbootstrap-api.jar:8.2.2-354]

at com.pega.pegarules.internal.etier.ejb.EngineBeanBoot.invokeEngine(EngineBeanBoot.java:168) ~[prbeans.jar:8.2.2-354]

at com.pega.pegarules.internal.etier.interfaces.EJSLocalStatelessEngineBMT_f2439d86.invokeEngine(Unknown Source) ~[prbeans.jar:8.2.2-354]

at com.pega.pegarules.priv.context.JNDIEnvironment.invokeEngineInner(JNDIEnvironment.java:275) ~[prpublic.jar:?]

at com.pega.pegarules.priv.context.JNDIEnvironment.invokeEngine(JNDIEnvironment.java:220) ~[prpublic.jar:?]

at com.pega.pegarules.web.impl.WebStandardImpl.makeEtierRequest(WebStandardImpl.java:728) ~[prwebj2ee.jar:?]

at com.pega.pegarules.web.impl.WebStandardImpl.doPost(WebStandardImpl.java:412) ~[prwebj2ee.jar:?]

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0]

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:90) ~[?:1.8.0]

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55) ~[?:1.8.0]

at java.lang.reflect.Method.invoke(Method.java:508) ~[?:1.8.0]

at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:381) ~[prbootstrap.jar:8.2.2-354]

at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:422) ~[prbootstrap.jar:8.2.2-354]

at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:224) ~[prbootstrap-api.jar:8.2.2-354]

at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:273) ~[prbootstrap-api.jar:8.2.2-354]

at com.pega.pegarules.internal.web.servlet.WebStandardBoot.doPost(WebStandardBoot.java:141) ~[prbootstrap-api.jar:8.2.2-354]

at javax.servlet.http.HttpServlet.service(HttpServlet.java:595) ~[javax.j2ee.servlet.jar:?]

at com.pega.pegarules.internal.web.servlet.WebStandardBoot.service(WebStandardBoot.java:167) ~[prbootstrap-api.jar:8.2.2-354]

at javax.servlet.http.HttpServlet.service(HttpServlet.java:668) ~[javax.j2ee.servlet.jar:?]

at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1233) ~[com.ibm.ws.webcontainer.jar:?]

at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:782) ~[com.ibm.ws.webcontainer.jar:?]

at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:481) ~[com.ibm.ws.webcontainer.jar:?]

at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178) ~[com.ibm.ws.webcontainer.jar:?]

at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1114) ~[com.ibm.ws.webcontainer.jar:?]

at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:87) ~[com.ibm.ws.webcontainer.jar:?]

at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:949) ~[com.ibm.ws.webcontainer.jar:?]

at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1817) ~[com.ibm.ws.webcontainer.jar:?]

at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:200) ~[com.ibm.ws.webcontainer.jar:?]

at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:463) ~[com.ibm.ws.runtime.jar:?]

at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:530) ~[com.ibm.ws.runtime.jar:?]

at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:316) ~[com.ibm.ws.runtime.jar:?]

at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:88) ~[com.ibm.ws.runtime.jar:?]

at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1820) ~[com.ibm.ws.runtime.jar:?]

at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175) ~[com.ibm.ws.runtime.jar:?]

at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217) ~[com.ibm.ws.runtime.jar:?]

at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161) ~[com.ibm.ws.runtime.jar:?]

at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138) ~[com.ibm.ws.runtime.jar:?]

at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204) ~[com.ibm.ws.runtime.jar:?]

at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775) ~[com.ibm.ws.runtime.jar:?]

at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905) ~[com.ibm.ws.runtime.jar:?]

at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1892) ~[com.ibm.ws.runtime.jar:?]

Caused by: com.pega.pegarules.pub.database.ConnectionException: [jcc][t4][102][10040][4.19.77] Batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch.

Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4229, SQLSTATE=null

DatabaseException caused by prior exception: com.ibm.db2.jcc.am.BatchUpdateException: [jcc][t4][102][10040][4.19.77] Batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch.

Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4229, SQLSTATE=null

| SQL Code: -4229 | SQL State: null

DatabaseException caused by prior exception: com.ibm.db2.jcc.am.SqlTransactionRollbackException: Error for batch element #1: DB2 SQL Error: SQLCODE=-1476, SQLSTATE=40506, SQLERRMC=-911, DRIVER=4.19.77

| SQL Code: -1476 | SQL State: 40506

DatabaseException caused by prior exception: com.ibm.db2.jcc.am.SqlException: [jcc][103][10843][4.19.77] Non-recoverable chain-breaking exception occurred during batch processing. The batch is terminated non-atomically. ERRORCODE=-4225, SQLSTATE=null

| SQL Code: -4225 | SQL State: null

at com.pega.pegarules.data.internal.access.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:435) ~[prprivate.jar:?]

at com.pega.pegarules.data.internal.store.ConnectionStatementStore.executeBatchForAllStatements(ConnectionStatementStore.java:233) ~[prprivate.jar:?]

at com.pega.pegarules.data.internal.store.ManagedTransaction.executeOutstandingBatches(ManagedTransaction.java:266) ~[prprivate.jar:?]

at com.pega.pegarules.data.internal.access.UpdateProcessor.action(UpdateProcessor.java:292) ~[prprivate.jar:?]

at com.pega.pegarules.data.internal.access.UpdateProcessor.action(UpdateProcessor.java:90) ~[prprivate.jar:?]

at com.pega.pegarules.data.internal.store.DataStoreManager.doInTransaction(DataStoreManager.java:272) ~[prprivate.jar:?]

thanks,

Hemant

Pega Platform
Moderation Team has archived post
Share this page LinkedIn