extra character ; in LEFT_CleanUp_execute.sql is failing to clean up transfer tables

[hpasumarthi]

Hello Team,
We have found that LEFT_CleanUp_execute.sql is being generate with special character in the following line

-- To be run AFTER final RIGHT SQL statements.;

Which is causing the clean post script to fail with following message

2023-04-17 15:15:08,191 [pool-1-thread-3] INFO Cluster.runTableSql(484):LEFT:SQL:Post Migration Cleanup:-- To be run AFTER final RIGHT SQL statements.
2023-04-17 15:15:08,201 [pool-1-thread-3] ERROR Cluster.runTableSql(491):java.sql.SQLException: Error while compiling statement: FAILED: ParseException line 1:46 cannot recognize input near '' '' ''

Can you please check the code and fix the left sql script.

Hemanth

[hpasumarthi]

Hi @dstreev we did managed to test this fix, looks like the issues still persist.

2023-04-24 11:11:08,440 [pool-1-thread-1] INFO Cluster.runTableSql(484):LEFT:SQL:Post Migration Cleanup:-- To be run AFTER final RIGHT SQL statements.
2023-04-24 11:11:08,452 [pool-1-thread-1] ERROR Cluster.runTableSql(491):java.sql.SQLException: Error while compiling statement: FAILED: ParseException line 1:46 cannot recognize input near '<EOF>' '<EOF>' '<EOF>'

can we test get this retested.

[dstreev]

Fixed issue where we didn't have a CR/LF in clean up script causing the script to miss the "USE ;" statement.