CIM Night Batch Failure

[alinasir]

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

[alinasir]

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.

[SchnikaPender]

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

[alinasir]

Thanks the enviroment is 10.0.0.2 so this is a known issue for it.