An unexpected null value has been found

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

Comments

  • 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.
    Systems Software Engineer

    Redgate Software

Sign In or Register to comment.