direct path does not support triggers

[Noelavx]

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

NB

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

[john_wang]

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.

[kng]

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

[john_wang]

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

would you please share your Replicate full version number ?

[Noelavx]

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

[Noelavx]

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

[john_wang]

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.