SQL Compare | Errors occurred whilst parsing file

devesharma

Hi Team,

We are facing a weird issue on our systems where SQL Compare would fail on parsing certain SQL Procedures. Although the same proc we can create manually in the database. It would bomb out with message "SQLCompare.exe terminated with the exit
code 126: Failed due to a SQL Server error.

PS : We are using DLM Automation 2 to promote artifacts to other ENVs

failed: Errors occurred whilst parsing file 
DriveLabel:\Directory\dbo.proc_name.sql
'' at line 5, column 7

SQL Compare : 13.3.6.6387

Any leads would be greatly appreciated.

Regards
Devesh Sharma

DanC

Hi @devesharma

Sorry to hear you're experiencing this issue!

I think this might be an old bug, I would recommend upgrading to the use of SQL Change Automation which uses version 14.4.7.16917 of the SQL Compare Engine.

Let me know how that goes!