topic Re: Task is in recoverable state in Qlik Replicate

Task is in recoverable state

suvbin — Sun, 26 May 2024 03:22:52 GMT

Hi Team,

We are getting below error

02234508688: 2024-05-25T22:07:06 [SORTER_STORAGE ]E: The Transaction sorter. Cannot get buffer for self committed transaction. [1022101] (transaction_storage.c:1065)

Source SAP

target: Azure sql

full load + cdc task

Request your help on this.

Thanks.

Re: Task is in recoverable state

sureshkumar — Sun, 26 May 2024 16:30:28 GMT

Hello @suvbin

The Error "Cannot get buffer for self committed transaction" it could be that it could running out of memory/cache. Could you please check if there is sufficient disk space available on the Qlik Replicate server.

Regards,

Suresh

Re: Task is in recoverable state

DesmondWOO — Mon, 27 May 2024 05:19:09 GMT

Hi @suvbin ,

In addition to Suresh's comment, if your disk space is full, I am afraid your sorter file is corrupt. Please do a full load or restart the task from earlier timestamp for the affected tasks.

Regards,
Desmond

Re: Task is in recoverable state

suvbin — Tue, 28 May 2024 08:56:37 GMT

Issue got resolved.

There was a source connection issue due to which the issue occurred. So we have resumed the task back in time (the first time when the connection failure happened) . Then the issue got resolved. Task is running fine now .

Thank you all for your responses

Re: Task is in recoverable state

john_wang — Tue, 28 May 2024 10:06:23 GMT

Thank you so much for the brilliant support! I'm marking the comment as solution.