topic Task not starting when started from particular time in Qlik Replicate

Task not starting when started from particular time

SaranyaK — Mon, 31 Jan 2022 21:38:50 GMT

Hi all - I am trying to resume a task (SQL server source and target is Snowfake) from a specific date/time using Advanced options. As I start the task I see the "Starting Task" bar but it get stuck and not able to start the task. Any idea what is causing this (attached picture). Any idea what is causing this?

Also I see the below in logs

[SOURCE_UNLOAD ]I: Calculated batch used for UNLOAD size is 1000 rows per fetch. (sqlserver_endpoint_unload.c:215)
[SOURCE_UNLOAD ]I: Unload finished for table 'dbo'.'Application' (Id = 1). 0 rows sent. (streamcomponent.c:3616)

Re: Task not starting when started from particular time

Heinvandenheuvel — Tue, 01 Feb 2022 06:15:52 GMT

The message shown are normal. The "0 rows sent" is expect for the 'fake load' for each table after start by timestamp. There is certainly more in the log. Download and look from the end backwards for something useful.

Are all Tlog backups available for the requested start time? That's a hard requirement. Is it not complaining it is waiting for the Tlog on UI or in the log?

You may want to verify you have a backup with a start date before the requested time.

Used SQL similar to the following:

select bs.backup_start_date, bs.first_lsn, [dbo].[fn_NumericLsnToHexa](bs.first_lsn) "first_lsn - hex", [dbo].[fn_NumericLsnToHexa](bs.last_lsn) "last_lsn - hex", bs.backup_size/(1024*1024) "MB", bmf.physical_device_name from msdb.dbo.backupmediafamily bmf, msdb.dbo.backupset bs where bmf.media_set_id = bs.media_set_id and bs.database_name=db_name() and bs.type='L' and bs.backup_start_date > getdate() - 5

You may also need to check the task settings for Tlog management.

Good luck,

Hein

Re: Task not starting when started from particular time

SaranyaK — Tue, 01 Feb 2022 06:24:41 GMT

Thank you, this helps!!