idea Qlik Replicate should wait in FullLoad mode only when replicated tables involving in open transaction in Suggest an Idea https://community.qlik.com/t5/Suggest-an-Idea/Qlik-Replicate-should-wait-in-FullLoad-mode-only-when-replicated/idi-p/2003811 <P>Qlik Replicate currently waits in FULL LOAD mode if there is any open transaction exists in Oracle source. Time for waiting set by parameter - Transaction consistency timeout (seconds).<BR />But Qlik Replicate does not check whether tables marked for replication are used in open transactions or not. It waits in any case, even when only some other tables which are not involving in replication are changing in such open transactions</P> <P>So it make sense to check if there are any replicated tables changing in open transaction. If QR recognize there are not any replicated table involving in open transaction it does not should to wait.</P> <P>For Oracle endpoint - following query can be used to determinate which tables are changing in open transactions.</P> <P>select l.SESSION_ID, o.OWNER, o.OBJECT_NAME <BR />from gv$locked_object l<BR />join dba_objects o<BR />on l.object_id = o.object_id</P> Sun, 13 Nov 2022 08:51:02 GMT yuriypopov 2022-11-13T08:51:02Z From now on, please track this idea from the Ideation por... https://community.qlik.com/t5/Suggest-an-Idea/Qlik-Replicate-should-wait-in-FullLoad-mode-only-when-replicated/idc-p/2100998#M14244 <P>From now on, please track this idea from the Ideation portal.&nbsp;</P><P><STRONG><A title="Link to new idea" href="https://ideation.qlik.com/app/#/case/281459" target="_blank" rel="noopener">Link to new idea</A></STRONG></P><P>Meghann</P><P data-unlink="true"><EM>NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you <STRONG>only</STRONG> see 1 tab with the login page, please try clicking this link first: <STRONG><A title="Authenticate me!" href="#" target="_blank" rel="noopener">Authenticate me!</A></STRONG>&nbsp;t</EM><EM>hen try the link above again. Ensure pop-up blocker is off.</EM></P> Wed, 02 Aug 2023 16:04:40 GMT https://community.qlik.com/t5/Suggest-an-Idea/Qlik-Replicate-should-wait-in-FullLoad-mode-only-when-replicated/idc-p/2100998#M14244 Meghann_MacDonald 2023-08-02T16:04:40Z Re: Qlik Replicate should wait in FullLoad mode only when replicated tables involving in open transaction - Status changed to: Closed - Archived https://community.qlik.com/t5/Suggest-an-Idea/Qlik-Replicate-should-wait-in-FullLoad-mode-only-when-replicated/idc-p/2100999#M14245 Wed, 02 Aug 2023 16:04:42 GMT https://community.qlik.com/t5/Suggest-an-Idea/Qlik-Replicate-should-wait-in-FullLoad-mode-only-when-replicated/idc-p/2100999#M14245 Ideation 2023-08-02T16:04:42Z