Hi,
Any idea about this failure
2018-01-10 04:42:33,404 :[pool-4-thread-42] INSERT
INTO "XC_ISTD01_CIM_META".CR_WORKFLOW_LOCK
(
Workflow_Lock_Key,
Job_History_Id
)
VALUES
(
'ed25ecb52379de47a70f60d8d671ae8a27d24e85243e63630ef23e94114b9ec078bd306166e5e9750ee3b712fd72996fea8374b60cc684c52b8e2647bc298f20',
'1000jgk5kl77'
)
2018-01-10 04:42:33,418 :[pool-4-thread-42] Applying retry rules to exception [Teradata Database] [TeraJDBC 14.10.00.26] [Error 2801] [SQLState 23000] Duplicate unique prime key error in XC_ISTD01_CIM_META.CR_WORKFLOW_LOCK.
Regards,
Ali Nasir
After all communications removed. Night batch executed successfully. After that communications were added back and Night batch executed successfully. Later the issue again happened. What is the exact reason for this issue.
Hi Ali,
Have you checked the knowledge base? There are a few different issues which may result in this error:
http://knowledge.teradata.com/KCS/id/KCS008018
http://knowledge.teradata.com/KCS/id/KCS007622