Object reference not set to an instance of an object

jasonsmink

I am able to link my DB to Source Control but it immediately throws an error when doing a compare: Object reference not set to an instance of an object

15:41:20.662|Error |n=7f465a1c156d4d57]]|10 |An exception occurred whilst performing an operation
RedGate.SQLSourceControl.Engine.Model.Comparison.TwoDatabase.SqlCompareException: Object reference not set to an instance of an object. ---> RedGate.SQLSourceControl.Engine.Model.Comparison.TwoDatabase.SqlCompareException: Object reference not set to an instance of an object. ---> System.NullReferenceException: Object reference not set to an instance of an object.
at RedGate.SQLCompare.Engine.ReadFromFolder.Cache.CacheMetadata.Deserialize(Int32 versionId, ISerializeFormatter formatter)
at RedGate.Shared.Utils.IO.Serialization.XMLSerializeFormatter.DeserializeRootObject(XmlReader #2FWb, String #hvPb, String #h8Pb)
at RedGate.Shared.Utils.IO.Serialization.XMLSerializeFormatter.DeserializeRootObject(String fileName, String name, String typeName)
at RedGate.SQLCompare.Engine.ReadFromFolder.Cache.PersistentReadFromFolderCache.#FOxc()
at RedGate.SQLCompare.Engine.ReadFromFolder.Cache.PersistentReadFromFolderCache.#PBxc(String #RBxc)
at RedGate.SQLCompare.Engine.ReadFromFolder.Cache.PersistentReadFromFolderCache.#EOxc(String #RBxc)
at RedGate.SQLCompare.Engine.ReadFromFolder.Cache.PersistentReadFromFolderCache..ctor(String astCacheFile, String cachedParsesFile, Int32 maxFileSizeInMB)
at #NsZc.#rusc.#nHD()
at #NsZc.#y0Lc.#PsZc(DirectoryInfo #yIc, ICompareScriptDatabaseInformation #P53c, ICompareOptions #5OPb)
at RedGate.SQLSourceControl.Engine.Diff.CompareEngineUtils.WrapRegisterWithCache(ICompareDatabase db, String path, ICompareScriptDatabaseInformation scriptFolderOptions, ICompareOptions options)
at #R9Jd.#Z4Jd.#hSJd(String #nIc, ICompareDatabase #Z3c, ICompareScriptDatabaseInformation #Y4Jd)
at #R9Jd.#Z4Jd.#v3.#MRJd()
at #NsZc.#MsZc.#gKf(Action #sxPb)
--- End of inner exception stack trace ---

Server stack trace:
at #NsZc.#MsZc.#gKf(Action #sxPb)
at #R9Jd.#Z4Jd.#Jfb.#Rz1d()
at RedGate.SQLSourceControl.Engine.SharedUtilsUtils.DoActionWithCancel(ICancellableOperationStatus status, ICancellable cancellable, Action action)
at #R9Jd.#Z4Jd.#f6c(String #nIc, ICompareScriptDatabaseInformation #Y4Jd)
at #R9Jd.#Z4Jd.#eSJd(IWorkspaces #RZJd, ICompareScriptDatabaseInformation #Y4Jd)
at #R9Jd.#Z4Jd.#A2.#6K5b()
at RedGate.SQLSourceControl.Engine.Cancellables.CancellableUtils.<>c__DisplayClass3.<DoInParallel>b__0()
at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)

Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.EndInvokeHelper(Message reqMsg, Boolean bProxyCase)
at System.Runtime.Remoting.Proxies.RemotingProxy.Invoke(Object NotUsed, MessageData& msgData)
at System.Action.EndInvoke(IAsyncResult result)
at RedGate.SQLSourceControl.Engine.Cancellables.CancellableUtils.DoInParallel(ICancellableOperationStatus status, Pair`2[] labelledActions)
at #R9Jd.#Z4Jd.#rYM(IWorkspaces #RZJd, ICompareScriptDatabaseInformation #Y4Jd)
at #R9Jd.#XXM.#rYM(IWorkspaces #RZJd, SourceControlRevision #V37d)
at #R9Jd.#XXM.#qYM()
at #R9Jd.#XXM.#iS()
at #qlhb.#0heb.#l36(String #yIc, #1heb #ead, ICancellableOperationStatus #KHc)
at #qlhb.#K3c.#83c(String #yIc, #O9U #jkUb, ICancellableOperationStatus #KHc)
at RedGate.SQLSourceControl.Engine.Diff.Memoization.ReattachableMemoizer.#A3.#eL5b(ICancellableOperationStatus #yTb)
at RedGate.SQLSourceControl.Engine.Diff.Memoization.ReattachableMemoizer.#YZBc.#jzb.#Qnw()
--- End of inner exception stack trace ---
at RedGate.SQLSourceControl.Engine.Diff.Memoization.ReattachableMemoizer.#YZBc.#VAb.#xSXc()
at RedGate.SQLSourceControl.Engine.Diff.Memoization.ReattachableMemoizer.#uz2b(String #yIc, IDatabaseConnection #SHc, #1heb #jkUb, ICancellableOperationStatus #KHc, Action #RqAc)
at #qlhb.#0heb.#wieb(IBoundDatabase #PPPb, ICompareOptions #5OPb, ICancellableOperationStatus #KHc, IVcsCallbacks #LOPb, Action #RqAc)
at #R9Jd.#VXM.#RjKd[#NrPb](IBoundDatabase #PPPb, #BJ4c #C75d, ICancellableOperationStatus #KHc, IVcsCallbacks #LOPb, IDifferenceSelector #xrWb, Action #RqAc)
at #R9Jd.#VXM.#jYM(IBoundDatabase #PPPb, ICancellableOperationStatus #KHc, ISourceControlUserCallBacks #LOPb, IDifferenceSelector #xrWb)
at #GWeb.#4Ec.#7Jc(ICancellableOperationStatus #KHc, ISourceControlUserCallBacks #iIc, IDifferenceSelector #xrWb)
at #GWeb.#4Ec.#y2.#QB7b(ICancellableOperationStatus #KHc)
at RedGate.SQLSourceControl.Engine.Cancellables.MutexedCancellableOperation`1.<>c__DisplayClass1.<Invoke>b__0()
at RedGate.SQLSourceControl.Engine.Cancellables.CancellableOperationBase.InvokeWithTracker(Action action)
at RedGate.SQLSourceControl.Engine.Cancellables.MutexedCancellableOperation`1.Invoke()
at RedGate.SQLSourceControl.Engine.Cancellables.CancellableOperationPostProcesser`2.Invoke()
at RedGate.SQLSourceControl.CommonUI.Controls.CancellableControl`2.<>c__DisplayClassa.<InvokeOperation>b__8()
at RedGate.SQLSourceControl.Engine.Logging.ErrorReporting.ErrorReporterBase.Do(Action toDo, Predicate`1 isErrorSourceUnknownPredicate, Boolean rethrow)
at RedGate.SQLSourceControl.CommonUI.ErrorHandling.SaErrorReporter.DoWithObviousExceptionsRethrowAll(Action action)
at RedGate.SQLSourceControl.CommonUI.Controls.CancellableControl`2.InvokeOperation(ICancellableOperation`1 operation, Object token)

RickyR

Hi Jason,

Thanks for posting your inquiry.

I have created a ticket for this situation, and would like to take this offline to troubleshoot further.

I will contact you through the ticket, and would like to thank you for your time!

All the best,

Rick