If you are failing to load due to table locks being applied, you can add the following FILTER under the Table Settings -> Filter -> Record Selection Condition. The Table Locks can when there is allot of activity on the Table such as Updates/Inserts/Deletes during the Load process.
You may encounter a message like:
UNSUCCESSFUL EXECUTION CAUSED BY DEADLOCK OR TIMEOUT error encountered while FETCH-ing data from table
Filter to add:
--FILTER: 1=1 ) FOR READ ONLY WITH UR USE CURRENTLY COMMITTED --
Environment
Qlik Replicate > 6.5
The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.
