An unexpected null value has been found while running postprocessing

XClass

I'm trying to Get Latest via source control and I'm getting this error.  I recently did a cleanup and removed a bunch of tables an d stored procedures and a fulltext catalogue and indexes.  After that, the commit worked but now, it's not working.  Not sure how to resolve this and from what I've read, it's a software issue that RedGate hasn't resolved yet.  Any help is appreciated.

DanC

Hi @XClass

Have you tried unlinking and relinking the database?

XClass

@DanC Yes I have, multiple times.

DanC

Hi @XClass

Sorry that didn't help!

Unfortunately, without a support and upgrades package, I'm unable to help further 

XClass

Even the send report on the app doesn't work.  Here is the report I got:

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 Redgate support.

   at RedGate.SQLCompare.Engine.ReadFromFolder.DatabaseFromScriptFilesPopulator.Freeze()

   at RedGate.SQLCompare.Engine.Model.DatabaseObjects.DatabaseFromFolderPopulator.DatabaseFromFolderPopulator.PopulateFromFolder(Database database, DirectoryInfo path, ScriptDatabaseInformation dbinfo, Options options, IEnumerable`1 filesToUse, IReadFromFolderCache cache, CancellationToken cancellationToken)

   at RedGate.SQLCompare.Engine.Model.DatabaseObjects.DatabaseFromFolderPopulator.DatabaseFromFolderPopulator.Populate(String path, CancellationToken cancellationToken)

   at RedGate.SQLSourceControl.Engine.CompareEngineImpl.Registration.Incremental.ScriptsFolder.DatabaseFromSnapshotCachePopulator.Populate(String path, CancellationToken cancellationToken)

   at RedGate.SQLCompare.Engine.Database.<>c__DisplayClass126_0.<Register>b__0()

   at RedGate.SQLCompare.Engine.Utils.GetTimeToRun[T](Func`1 action)

   at RedGate.SQLCompare.Engine.Database.Register(String path, ScriptDatabaseInformation dbinfo, Nullable`1 optionsParam, IEnumerable`1 filesToUse, IReadFromFolderCache cache, IDatabaseFromFolderPopulator databasePopulator)

   at RedGate.SQLSourceControl.Engine.CompareEngineImpl.Compare.CompareDatabase.RegisterScriptsFolder(DirectoryInfo path, ICompareScriptDatabaseInformation scriptFolderOptions, ICompareOptions options)

   at RedGate.SQLSourceControl.Engine.Diff.DiffBuildSessions.CompareDatabaseRegistrar.<>c__DisplayClass4_0.<Register>b__0()

   at RedGate.SQLSourceControl.Engine.Utils.Task.SharedUtilsUtils.DoActionWithCancel(ICancellableOperationStatus status, ICancellable cancellable, Action action)

   at RedGate.SQLSourceControl.Engine.Diff.DiffBuildSessions.CompareDatabaseRegistrar.Register(ScriptsFolderDatabaseSource source, ICancellableOperationStatus status)

   at RedGate.SQLSourceControl.Engine.Diff.DiffBuildSessions.SocDatabaseRegistrar.Register(ScriptsFolderDatabaseSource databaseSource, ICancellableOperationStatus status)

   at RedGate.SQLSourceControl.Engine.Diff.DiffBuildSessions.ThreeWorkspaceRegistrar.GetTwoWayDiffBuildSessionTransient(ScriptsFolderDatabaseSource scriptsFolderDatabaseSource)

   at RedGate.SQLSourceControl.Engine.Diff.DiffBuildSessions.ThreeWorkspaceRegistrar.<>c__DisplayClass7_0.<GetRegisterWorkspacesActions>b__0(ICancellableOperationStatus s)

   at RedGate.SQLSourceControl.Engine.Utils.Task.NamedOperation.Operation(ICancellableOperationStatus cancellableOperation)

   at RedGate.SQLSourceControl.Engine.Utils.Task.CancellableUtils.<>c__DisplayClass3_0.<StartTask>b__0()

   at RedGate.SQLSourceControl.Engine.Utils.Task.CancellableUtils.ExceptionHandler.ThrowIfErrored()

   at RedGate.SQLSourceControl.Engine.Utils.Task.CancellableUtils.DoInParallel(ICancellableOperationStatus status, INamedOperation[] namedActions)

   at RedGate.SQLSourceControl.Engine.Diff.DiffBuildSessions.TwoWorkspaceRegistrar.RegisterWorkspaces(IWorkspaces workspaces, ICompareScriptDatabaseInformation scriptDatabaseInformation)

   at RedGate.SQLSourceControl.Engine.Diff.DiffBuildSessions.ThreeWayDiffSession.RegisterWorkspaces(IWorkspaces workspaces, SourceControlRevision transientRevision)

   at RedGate.SQLSourceControl.Engine.Diff.DiffBuildSessions.ThreeWayDiffSession.BuildCommon()

   at RedGate.SQLSourceControl.Engine.Diff.DiffBuildSessions.DiffBuilder.GetChangeSetResolvingNoOps[T](String source, IBoundDatabase boundDatabase, IChangeSetFactory`1 changeSetFactory, ICancellableOperationStatus status, SourceControlOperation sourceControlOperation)

   at RedGate.SQLSourceControl.Engine.Diff.DiffBuildSessions.DiffBuilder.BuildToRetrieveChangeSet(IBoundDatabase boundDatabase, ICancellableOperationStatus status)

   at RedGate.SQLSourceControl.Engine.Diff.BoundDatabase.GetNewRetrievableChanges(ICancellableOperationStatus status)

   at RedGate.SQLSourceControl.Engine.Utils.Task.MutexedCancellableOperation`1.<>c__DisplayClass7_0.<Invoke>b__0()

   at RedGate.SQLSourceControl.Engine.Utils.Task.CancellableOperationBase.PerformAction(Action action)

   at RedGate.SQLSourceControl.Engine.Utils.Task.CancellableOperationBase.InvokeWithTracker(Action action)

   at RedGate.SQLSourceControl.Engine.Utils.Task.MutexedCancellableOperation`1.Invoke()

   at RedGate.SQLSourceControl.Engine.Utils.Task.CancellableOperationTypeConverter`2.Invoke()

   at RedGate.SQLSourceControl.CommonUI.Controls.CancellableControl`2.<>c__DisplayClass30_0.<InvokeOperation>b__1()

   at RedGate.SQLSourceControl.Engine.Utils.ErrorReporting.ErrorReporterBase.Do(Action toDo, Predicate`1 isFatalPredicate, Boolean rethrow)