
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
direct path does not support triggers
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
BTW, all Oracle versions target endpoint has the option "Use direct path full load":
would you please share your Replicate full version number ?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
