Skip to main content
Announcements
UPGRADE ADVISORY for Qlik Replicate 2024.5: Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Gaurav2
Contributor III
Contributor III

Bulk apply operation failed. Trying to execute bulk statements in 'one-by-one' mode

Hi, 

My 8 tasks was running fine before. I stopped the task for DB upgrade and post DB upgrade, I started the task. 7 tasks are running fine. Just 1 task is having latency. 

When I am looking into logs, I can see below things:

 

00011642: 2021-11-11T12:41:13 [TARGET_APPLY ]I: Bulk apply operation failed. Trying to execute bulk statements in 'one-by-one' mode (bulk_apply.c:2374)
00011642: 2021-11-11T12:41:14 [TARGET_APPLY ]I: Applying INSERTS one-by-one for table 'XXXX'.'XXXX' (2001596) (bulk_apply.c:5481)
00011642: 2021-11-11T12:41:19 [TARGET_APPLY ]I: Switch back to bulk apply mode (bulk_apply.c:5575)
00011642: 2021-11-11T12:41:19 [TARGET_APPLY ]E: ORA-00001: unique constraint (XXXX.XXXXX) violated [1020408] (oracle_endpoint_load.c:1180)

Source DB: Oracle 19C

Target DB: Oracle 19C

CDC-1-many-Log Stream

Labels (1)
1 Reply
lyka
Support
Support

Hello,

this means that the bulk apply failed due to a duplicate error. You need to verify if the source and target table have the same unique constraints defined.

 

To avoid the task to go one-by-one by one you can set the apply error handling to use MERGE for the duplicate errors

 

The option to change is:

 

Got to task settings > error handling > apply conflicts.

Duplicate key when applying an INSERT: > Update the existing target record:

 

Thanks

Lyka