Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. READ MORE

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

100% helpful (1/1)
cancel
Showing results for 
Search instead for 
Did you mean: 
Dineshan
Support
Support

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

Last Update:

Dec 28, 2023 8:58:06 AM

Updated By:

Sonja_Bauernfeind

Created date:

Dec 28, 2023 8:58:06 AM

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.

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

    Max file size MB.png

 

Environment

Qlik Replicate 

Labels (1)
Version history
Last update:
‎2023-12-28 08:58 AM
Updated by: