topic Re: direct path does not support triggers in Qlik Replicate

direct path does not support triggers

Noelavx — Tue, 10 Sep 2024 14:28:35 GMT

how do I resolve ORA-26086: direct path does not support triggers [1022307] (oracle_endpoint_load.c:1588

there is no direct path under advance tab on the target end point

Re: direct path does not support triggers

john_wang — Tue, 10 Sep 2024 14:35:18 GMT

Hello @Noelavx ,

Welcome to Qlik Community forum and thanks for reaching out here!

Please check out: Error: ORA-26086: direct path does not support triggers

Hope it helps.

John.

Re: direct path does not support triggers

kng — Tue, 10 Sep 2024 14:36:09 GMT

Hello Team,
Good Day

Hope the target is oracle!!

Here Either you have to disable the triggers on the table or disable Direct Path in the target endpoint. You can disable this in the Advanced tab of the target endpoint.

See Limitation for more information using oracle as a target!!

https://help.qlik.com/en-US/replicate/May2024/Content/Replicate/Main/Oracle/OracleDB_limitations.htm

Regards,
shivananda

Re: direct path does not support triggers

john_wang — Tue, 10 Sep 2024 14:38:25 GMT

BTW, all Oracle versions target endpoint has the option "Use direct path full load":

would you please share your Replicate full version number ?

Re: direct path does not support triggers

Noelavx — Tue, 10 Sep 2024 14:48:33 GMT

Hi
The version is May 2023(2023.5.0.322)
When I go to target end point, advanced tab , there is no direct load on the screen

Re: direct path does not support triggers

Noelavx — Tue, 10 Sep 2024 14:55:28 GMT

I do not want to disable the triggers, and there is no direct path under the advance tab setting to be disabled

Re: direct path does not support triggers

john_wang — Tue, 10 Sep 2024 14:58:02 GMT

Hello @Noelavx ,

Thanks for the update.

Would you please clean your browser cache and histories then try again?

BTW, did you ever upgrade Replicate recently? if yes, please remove the version number from the URL and let Replicate to detect the number again, for example your current URL is:

https://<hostName>/attunityreplicate/2024.5.0.435/#!/taskMonitoring/DB400-to-GBQ

please change it to:

https://<hostName>/attunityreplicate/ ,then press Enter.

Regards,

John.