Qlik Replicate: No records sent from Oracle to Snowflake log stream

Dineshan — Thu, 28 Dec 2023 13:58:06 GMT

After a reload, no records are sent to the target. No errors are logged, but the following entries are shown:

[TASK_MANAGER ]I: Start loading table 'table.name' (Id = 1) by subtask 1. Start load timestamp 000606229C590B80
[SORTER ]I: Start collecting changes for table id = 2
[TASK_MANAGER ]I: Start loading table 'table.name2' (Id = 2) by subtask 2. Start load timestamp 000606229C590B80
[SOURCE_UNLOAD ]I: Unload finished for table 'table.name' (Id = 1). 0 rows sent.
[SOURCE_UNLOAD ]I: Unload finished for table 'table.name2' (Id = 2). 0 rows sent.
[TARGET_LOAD ]I: Load finished for table 'table.name' (Id = 1). 0 rows received. 0 rows skipped. Volume transferred 0.
[TASK_MANAGER ]I: Loading finished for table 'table.name' (Id = 1) by subtask 1. 0 records transferred.
[TARGET_LOAD ]I: Load finished for table 'table.name2' (Id = 2). 0 rows received. 0 rows skipped. Volume transferred 0.
[TASK_MANAGER ]I: Subtask #1 ended
[TASK_MANAGER ]I: Loading finished for table 'table.name2' (Id = 2) by subtask 2. 0 records transferred.

Resolution

To resolve the issue, increase the Max file size.

Open the Snowflake Endpoint
Open the Advanced tab
Set the Max file size (MB) from 1 to 1000 or a similar increased value

article Qlik Replicate: No records sent from Oracle to Snowflake log stream in Official Support Articles

Qlik Replicate: No records sent from Oracle to Snowflake log stream

Resolution

Environment