An unexpected null value has been found

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

An unexpected null value has been found

Postby IoneRedGate2013 » Mon Feb 04, 2013 8: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
IoneRedGate2013
 
Posts: 1
Joined: Mon Feb 04, 2013 8:21 pm

Postby james.billings » Wed Feb 06, 2013 9: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.
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests