Options
Problem with Redgate SQL Source Control
PietroPerugino
Posts: 2
I am suddenly getting the following error message when i try to do anything on Redgate source control, whether it be get the latest or commit changes:
Invalid token type for reading string (expected ASCIIStringLiteral or UnicodeStringLiteral but got 714) on column 0 (1)
It has been happening since i applied some changes to a database after running a SQL compare on another database to find the structural differences.
I am struggling to debug this. This is literally all of the information I have and i'm finding very little searching the web.
Any help is greatly appreciated. It is not only affecting me but the entire development team
Invalid token type for reading string (expected ASCIIStringLiteral or UnicodeStringLiteral but got 714) on column 0 (1)
It has been happening since i applied some changes to a database after running a SQL compare on another database to find the structural differences.
I am struggling to debug this. This is literally all of the information I have and i'm finding very little searching the web.
Any help is greatly appreciated. It is not only affecting me but the entire development team
Tagged:
Comments
It turns out SQL Source Control is reading your static data and looking for a string to insert into the first field (column 0) of your table, but it's finding a number (1). (Token types are different in each engine version, but 714 has been "Integer" in some recent versions).
It sounds like your static data contains something like:
I hope this helps you track down the issue, but it would probably be worth contacting support@red-gate.com for further help.
Redgate Software
Thanks for posting a solution. Glad that worked you.