Red Gate forums :: View topic - Script folder contains circular object references.
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 3
SQL Source Control 3 forum

Script folder contains circular object references.

Search in SQL Source Control 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
PravinDPatil



Joined: 26 Oct 2012
Posts: 4

PostPosted: Fri Oct 26, 2012 2:10 pm    Post subject: Script folder contains circular object references. Reply with quote

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]
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 936
Location: Red Gate Software

PostPosted: Mon Oct 29, 2012 3:47 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
PravinDPatil



Joined: 26 Oct 2012
Posts: 4

PostPosted: Tue Nov 20, 2012 7:21 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Thu Nov 22, 2012 12:09 pm    Post subject: Reply with quote

Thanks for the scripts.

I'll try to reproduce the issue and let you know what I find.
_________________
Chris
Back to top
View user's profile Send private message Send e-mail
PravinDPatil



Joined: 26 Oct 2012
Posts: 4

PostPosted: Thu Nov 29, 2012 7:12 am    Post subject: Reply with quote

I have replied to your email.

waiting for your valuable reply.
Back to top
View user's profile Send private message
PravinDPatil



Joined: 26 Oct 2012
Posts: 4

PostPosted: Tue Jan 22, 2013 10:20 am    Post subject: Reply with quote

Hi Chris/Eddie,

Any updates on this?

Thanks in advance.
Pravin
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Tue Jan 22, 2013 10:26 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group