CIM Night Batch Failure

CIM, RTIM
Customer Interaction Manager, Real-Time Interaction Manager, TD Channel Integration Services
Highlighted
Teradata Employee

CIM Night Batch Failure

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

3 REPLIES
Teradata Employee

Re: CIM Night Batch Failure

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.

Teradata Employee

Re: CIM Night Batch Failure

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

 

 

Teradata Employee

Re: CIM Night Batch Failure

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