failed to load data from SQL server to MYSQL

[suvbin]

Hi, 

while replicating data from SQLServer to MYSQL, am facing the below issue.

Failure in starting (with TXN consistency...) Failure validating initial LSN 'anywhere existance' mssql_lsn_anywhere_validator(...)Failed in looking at Active TLOG lsn_exists(...)Failed in statement execution for looking at Active TLOG RetCode: SQL_ERROR SqlState: HY000 NativeError: 9003 Message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The log scan number (60:376:5) passed to log scan in database 'sample1' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup. Line: 1 Column: -1 Failed (retcode -1) to execute statement: 'select top 1 [Current LSN] from fn_dblog('0x0000003c:00000178:0005','0x0000003c:00000178:0005')'

[john_wang]

Hello @suvbin ,

Thanks for your feedback. We'd like to suggest you open a support ticket and provide below info:

1. this article link

2. set SOURCE_CAPTURE/SOURCE_UNLOAD to Verbose, reproduce the error, and attach the Diagnostics Packages to the case. Support team will help you further.

Regards,

John.