Suggest an Idea

[yuriypopov]

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).
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

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.

For Oracle endpoint - following query can be used to determinate which tables are changing in open transactions.

select l.SESSION_ID, o.OWNER, o.OBJECT_NAME
from gv$locked_object l
join dba_objects o
on l.object_id = o.object_id

[Meghann_MacDonald]

From now on, please track this idea from the Ideation portal. 

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.