Here is the SQL to run for retry:
UPDATE CONFIGELEMENT SET VALUE = ' SQLCODE=-911,SQLCODE=-913,ORA-00370,ORA-02049,ORA-00060,SQLCODE=-968,SQLCODE=-803, SQLCODE=-723'
, LAST_UPDATE_DT = CURRENT_TIMESTAMP WHERE NAME = '/IBM/DWLCommonServices/ErrorHandling/retryErrorStringList';
UPDATE CONFIGELEMENT SET VALUE = '12,2037,4930, 109,10506,49359',
LAST_UPDATE_DT = CURRENT_TIMESTAMP WHERE NAME = '/IBM/DWLCommonServices/ErrorHandling/retryErrorCodeList';
Summary of error response for defects which have been configured for retry:
1:
<DWLError>
<ComponentType>1012</ComponentType>
<ErrorMessage>The following is required: PersonName</ErrorMessage>
<ErrorType>FVERR</ErrorType>
<LanguageCode>100</LanguageCode>
<ReasonCode>2037</ReasonCode>
<Severity>0</Severity>
<Throwable>com.dwl.tcrm.exception.TCRMDataInvalidException: com.dwl.base.exception.DWLDataInvalidException: [1012 FVERR 2037 The following is required: PersonName]</Throwable>
</DWLError>
2:
<DWLError>
<ComponentType>111</ComponentType>
<ErrorMessage>Duplicate primary key already exists.</ErrorMessage>
<ErrorType>DKERR</ErrorType>
<LanguageCode>100</LanguageCode>
<ReasonCode>12</ReasonCode>
<Severity>0</Severity>
<Throwable>com.dwl.tcrm.exception.TCRMDuplicateKeyException: [Exception_Common_DuplicateKey:] CDKCS0001E:The object cannot be created due to duplicate primary key. Primary key = null; object = com.dwl.tcrm.coreParty.component.TCRMSuspectBObj; exception = DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=3;RYY4.SUSPECT, DRIVER=3.72.52</Throwable>
</DWLError>
3:
<DWLError>
<ComponentType>108</ComponentType>
<ErrorMessage>BTM ITxRxException occurred in Request and Response Framework.</ErrorMessage>
<ErrorType>READERR</ErrorType>
<LanguageCode>100</LanguageCode>
<ReasonCode>4930</ReasonCode>
<Severity>0</Severity>
<Throwable>com.dwl.base.exception.DWLBaseException</Throwable>
</DWLError>
4:
<DWLError>
<ComponentType>904</ComponentType>
<ErrorMessage>The following transaction failed: updateLobRelationship</ErrorMessage>
<ErrorType>UPDERR</ErrorType>
<LanguageCode>100</LanguageCode>
<ReasonCode>10506</ReasonCode>
<Severity>0</Severity>
<Throwable>com.ibm.pdq.runtime.exception.DataRuntimeException: [pdq][10103][3.200.75] An error prevented the update operation from completing successfully.; Caused by: com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-723, SQLSTATE=09000, SQLERRMC=RYY4.U_LEBREL;-803;23505;1|RYY4.H_LOBREL, DRIVER=3.72.52</Throwable>
</DWLError>
5:
<DWLError>
<ComponentType>99</ComponentType>
<ErrorMessage>[Exception_Shared_LastUpdateDtNotMatched:] CDKCH2001E:Another transaction has updated the database record you are trying to update. Cannot update record at this time, please try again.</ErrorMessage>
<ErrorType>UPDERR</ErrorType>
<LanguageCode>100</LanguageCode>
<ReasonCode>109</ReasonCode>
<Severity>0</Severity>
<Throwable>java.lang.RuntimeException: com.dwl.base.exception.LastUpdateDateException: class com.dwl.tcrm.businessServices.entityObject.EObjLobRelationship | 879956570600676001</Throwable>
</DWLError>
6:
<DWLError>
<ComponentType>4405</ComponentType>
<ErrorMessage>Suspect search adapter execution failed.</ErrorMessage>
<ErrorType>DIERR</ErrorType>
<LanguageCode>100</LanguageCode>
<ReasonCode>49359</ReasonCode>
<Severity>0</Severity>
<Throwable>java.lang.NullPointerException</Throwable>
</DWLError>
No comments:
Post a Comment