Problem with Redgate SQL Source Control

PietroPerugino

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

sam.blackburn

This is perhaps not the clearest error message ever!

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:

INSERT INTO Foo (stringColumn, ...) VALUES (1, ...)

I hope this helps you track down the issue, but it would probably be worth contacting support@red-gate.com for further help.

JamesHaydock

I had this problem and the solution for me was to unlink from source control and then connect back up again.

Sam J

Hi @JamesHaydock

Thanks for posting a solution. Glad that worked you.

SemperFi89

@JamesHaydock I also will add my Thanks.  I had the same basic problem and this fixed worked for me.

dsbert

I just ran into this issue and the description provided by @sam.blackburn made it more clear. This  problem occurred after I changed a table with linked static data. I altered a column from int to varchar.

Paddy

I had the same reproduction as dsbert.  Column in a statically linked table was changed from integer to string.

gioa

I've got the same problem and just unlinking the static data for the changed table helped