Script folder contains circular object references.

PravinDPatil

When tried to link database to SQL Source Control (V 3.1.0.4829), it throws following error:

Script folder contains circular object references. Such databases cannot be created. Please ensure the source scripts define a consistent database schema.

Detailed error message:

RedGate.SQLSourceControl.Engine.SqlCompareException: Script folder contains circular object references. Such databases cannot be created. Please ensure the source scripts define a consistent database schema. ---> RedGate.SQLCompare.Engine.SqlCompareException: Script folder contains circular object references. Such databases cannot be created. Please ensure the source scripts define a consistent database schema.
at RedGate.SQLCompare.Engine.DatabaseFromScriptObjectResolver.#YGh(Object #Zsf, RecursionEventArgs #ead)
at RedGate.SQLCompare.ASTParser.Resolvers.ContextResolver.#GgU(IResolver #Hfs, ISqlObject #qdk)
at RedGate.SQLCompare.ASTParser.Resolvers.ContextResolver.GetColumnsExportedBySelect(Select expr)
at RedGate.SQLCompare.Engine.DatabaseFromScriptObjectResolver.ColumnsInObject(ISqlObject obj)
at RedGate.SQLCompare.Engine.DatabaseFromScriptObjectResolver.#XGh(SchemaObject #61Qb)
at #Eyg.#Gyg.#vl(IEnumerable`1 #rXrc)
at RedGate.SQLCompare.Engine.Database.Register(String path, ScriptDatabaseInformation dbinfo, Options options, IEnumerable`1 filesToUse, IReadFromFolderCache cache)
at #GWeb.#7Jf.#susc(Database , String , ScriptDatabaseInformation , Options )
at #qlhb.#L3c.#y2.#nKcb()
at #GWeb.#7Jf.#gKf(Action )
--- End of inner exception stack trace ---

Server stack trace:
at #GWeb.#7Jf.#gKf(Action )
at #GWeb.#7Jf.#z2.#rkW()
at RedGate.SQLSourceControl.Engine.SharedUtilsUtils.DoActionWithCancel(ICancellableOperationStatus status, ICancellable cancellable, Action action)
at #GWeb.#7Jf.#jKf(ICancellableOperationStatus , ICancellable , Action )
at #qlhb.#L3c.#l36(String , #x36 , ICancellableOperationStatus )
at #qlhb.#K3c.#83c(String , #O9U , ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks )
at #qlhb.#L3c.#f6c(String , ScriptDatabaseInformation , Options , ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks )
at #GWeb.#WXM.#f6c(String )
at #GWeb.#WXM.#I0db()
at #GWeb.#Wheb.#tieb(Func`1 )
at #GWeb.#WXM.#YtV()
at RedGate.SQLSourceControl.Engine.Cancellables.CancellableUtils.#y2.#RKc()
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 RedGate.SQLSourceControl.Engine.Diff.Memoization.ReattachableMemoizer.#YZBc.#TEb.#j0Bc()
at RedGate.SQLSourceControl.Engine.Diff.Memoization.ReattachableMemoizer.#uz2b(String , IDatabaseConnection , #1heb , ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , Action )
at #qlhb.#0heb.#wieb(#L3c , #ZZ7 , #A57 , IDatabasePollingManager , IObjectExplorerStateService , #82Vc , #32Vc , #4Ec , #j3l , Options , #quBb , ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , Action )
at #GWeb.#VXM.#mYM[#NrPb](Func`2 , ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , IDifferenceSelector , Action )
at #GWeb.#VXM.#kYM(ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , IDifferenceSelector )
at #GWeb.#4Ec.#8Jc(ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , IDifferenceSelector )
at #GWeb.#4Ec.#izb.#SB7b(ICancellableOperationStatus )
at RedGate.SQLSourceControl.Engine.Cancellables.MutexedCancellableOperation`1.#u3.#k5f()
at RedGate.SQLSourceControl.Engine.Cancellables.CancellableOperationBase.InvokeWithTracker(String featureUsageKey, Action action)
at RedGate.SQLSourceControl.Engine.Cancellables.MutexedCancellableOperation`1.Invoke()
at #eEc.#Qlg.Invoke()
at #JLc.#PLc.#Jfb.#EJf()
at RedGate.SQLSourceControl.Engine.SmartAssembly.ExceptionReporting.ErrorReporterBase.Do(Action , Predicate`1 , Boolean )
at RedGate.SQLSourceControl.Engine.SmartAssembly.ExceptionReporting.ErrorReporterBase.DoWithObviousExceptionsRethrowAll(Action action)
at RedGate.SQLSourceControl.CommonUI.Forms.ErrorDialog.DoWithObviousExceptionsRethrowAll(Action action)
at #JLc.#PLc.#CTc(ICancellableOperation`1 , Object )[/b]

Eddie D

Thank you for post into the forum and sorry that you have encountered a problem.

A support call has been created for you, the call reference is F0066162.

Can you please perform an export or whatever you call it and get the latest version out of the repository and into a working folder, then zip the folder and email it?

Send the e-mail to support@red-gate.com with the above call reference number in the subject field of the e-mail.

Also did you send the error report in Red Gate?

Many Thanks
Eddie

PravinDPatil

Hi Eddie,

I have sent the error report to Red Gate.

Now i have sent detailed email with database script.

waiting for your valuable reply.

Thanks
Pravin.

Chris Auckland

Thanks for the scripts.

I'll try to reproduce the issue and let you know what I find.

PravinDPatil

I have replied to your email.

waiting for your valuable reply.

PravinDPatil

Hi Chris/Eddie,

Any updates on this?

Thanks in advance.
Pravin

Chris Auckland

Sorry for the delay. The support ticket that we had open didn't get reactivated after you last replied in November! I'm really sorry about that. It's open now.