Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Hemant Kumar (HemantK9)
HCL Technologies

HCL Technologies
IN
HemantK9 Member since 2018 6 posts
HCL Technologies
Posted: Nov 1, 2019
Last activity: Nov 3, 2019
Posted: 1 Nov 2019 9:15 EDT
Last activity: 3 Nov 2019 21:05 EST
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.

Show More

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


Show Less
To see attachments, please log in.
Pega Platform

Posted: 5 years ago
Posted: 3 Nov 2019 21:05 EST
Shubham Shekhar (Shekhar_Shubham) Senior Solutions Engineer
Pegasystems Inc.
IN

Hi,

I guess there is some problem with the primary key on the table.

Please check below link should help you on the query generated.

https://www.ibm.com/support/pages/diagnosing-and-handling-error-code-4229

https://community.pega.com/knowledgebase/articles/troubleshooting-batchupdateexception-when-importing-rule-admin-product-rap Don't think this is valid for you 

https://community.pega.com/support/support-articles/extract-rule-causing-batchupdateexception-errorcode-4229

Also can you run the tracer while doing the action, you should be able to see the insert values. Based on that you can see which is a wrong value here.

Thank You

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice