Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
suvbin
Creator III
Creator III

Task is in recoverable state

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.

 

 

Labels (1)
1 Solution

Accepted Solutions
suvbin
Creator III
Creator III
Author

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

View solution in original post

4 Replies
sureshkumar
Support
Support

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

DesmondWOO
Support
Support

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

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
suvbin
Creator III
Creator III
Author

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

john_wang
Support
Support

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

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!