A Qlik Replicate task fails and stops with the error:
[INFRASTRUCTURE ]E: Json doesn't start with '{' [1003001] (at_cjson.c:1790)
Resuming the task may lead to this error message as the last saved file was improperly saved.
Resolution
Restart the task from a timestamp instead of resuming the task to regenerate the file:
- Stop the task
- Download the latest task log and look for this line of statement:
[SORTER ]I: Final saved task state. Stream position 00000000.041081f1.00000001.0000.00.0000:686.102091.16, Source id 573451, next Target id 17, confirmed Target id 13, last source timestamp 1721397987000000 (sorter.c:782)
- Copy the value of the 'Last source timestamp' and use a time conversion tool to convert the time. Example: https://www.epochconverter.com/
Example: 1721397987000000 converts to Friday, July 19, 2024 10:06:27 AM EST
- Input the value and retrieve the timestamp in the local time of your machine
- Use the task's advanced run options and restart the task at the identified timestamp.
Cause
If the target system uses files, such as ADLS or Databricks), a network disconnect occurring while a file is being pushed to the target can lead to an incomplete file being saved on the Qlik Replicate server. When the file is saved improperly, the task will not be able to use it to resume the task.
Regeneration of the last file will be needed.
Environment