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

Gaurav2 — Thu, 11 Nov 2021 13:27:15 GMT

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

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

lyka — Fri, 19 Nov 2021 23:50:48 GMT

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

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

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

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