An unexpected null value has been found

Forum for users of SQL Compare schema synchronization utility

An unexpected null value has been found

Postby IoneRedGate2013 » Mon Feb 04, 2013 7:26 pm

I getting the following error while running SQLCompare between the repository and database

An unexpected null value has been found while running postprocessing
operations on the script database. Please ensure the script database is
consistent. If the problem persists, please contact our support.

Can some one please assist me to debug the issue as its causing deployment issues currently
Posts: 1
Joined: Mon Feb 04, 2013 7:21 pm

Postby james.billings » Wed Feb 06, 2013 8:53 pm

Thanks for your post.

Generally this error occurs when there's something invalid in the scripts folder; so the first thing I'd suggest is seeing if you can recall what may have changed since the last time it ran successfully? I've found an error report submitted by you in our system from the 3rd, and we can see the last files it was working on before it errored:
- ImpressionLogSuspect.sql
- LUTimeZoneDisplay_Data.sql

- there are more listed, but i'd begin by checking these are looking correct regarding the information within them and any dependencies they may have.
Posts: 1121
Joined: Wed Jun 16, 2010 10:10 am
Location: Red Gate

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: Yahoo [Bot] and 0 guests