Script folder contains circular object references.

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace, andy.campbell.smith

Script folder contains circular object references.

Postby PravinDPatil » Fri Oct 26, 2012 2:10 pm

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]
PravinDPatil
 
Posts: 4
Joined: Fri Oct 26, 2012 12:48 pm

Postby eddie davis » Mon Oct 29, 2012 3:47 pm

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
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 942
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

Postby PravinDPatil » Tue Nov 20, 2012 7:21 am

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.
PravinDPatil
 
Posts: 4
Joined: Fri Oct 26, 2012 12:48 pm

Postby Chris Auckland » Thu Nov 22, 2012 12:09 pm

Thanks for the scripts.

I'll try to reproduce the issue and let you know what I find.
Chris
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.

Postby PravinDPatil » Thu Nov 29, 2012 7:12 am

I have replied to your email.

waiting for your valuable reply.
PravinDPatil
 
Posts: 4
Joined: Fri Oct 26, 2012 12:48 pm

Postby PravinDPatil » Tue Jan 22, 2013 10:20 am

Hi Chris/Eddie,

Any updates on this?

Thanks in advance.
Pravin
PravinDPatil
 
Posts: 4
Joined: Fri Oct 26, 2012 12:48 pm

Postby Chris Auckland » Tue Jan 22, 2013 10:26 am

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.
Chris
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.


Return to SQL Source Control 3

Who is online

Users browsing this forum: No registered users and 1 guest