Skip to main content
Announcements
UPGRADE ADVISORY for Qlik Replicate 2024.5: Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
chandraprakash_j_volvo
Contributor III
Contributor III

Facing anywhere existence error

Source: On-Prem SQL server

Target: Azure SQL server

We are copying 196 tables from source to target. For whole night it was running fine. Full load and Change processing was perfect over a night.

Suddenly we encountered this error.

chandraprakash_j_volvo_0-1713849276045.png

 

3 Replies
DesmondWOO
Support
Support

Hi @chandraprakash_j_volvo ,

According to the error message, Replicate cannot find the LSN from the transaction log. Please check this article: "Failure validating initial LSN 'xx:xx:xx' 'anywhere existance'. Found nowherefor details.

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!
SushilKumar
Support
Support

Hello @chandraprakash_j_volvo 

Such error occurred when QR is not able to find the Transaction logs to apply the changes being cached since the Full load initiated.  To resolve such issue, you need to pick the best option as per your business requirement from where Qlik Replicate read the changes. Such as Transaction logs/Online logs / backup logs. And you must have sufficient space to hold till they are read or process by Qlik replicate.  

You may need to observe the volume of data to anticipate the Space requirement. 

Regards,

Sushil Kumar

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

 

narendersarva
Support
Support

@chandraprakash_j_volvo 

Additionally, please check the sql server logs around the same time to find out the SQL native errors.

 

Thanks
Naren