AnsweredAssumed Answered

Ugly Error When Moving Files

Question asked by Jim Sculley on Feb 17, 2012

I have been moving files from a quaratine area in the vault to their final permanent home after cleaning up custom properties and such.  I have a handful of assembly files that refuse to move.  Any attempt yields the following error:



A check of the log file shows this:



Error running query in SpDbOdbc


Msg=[Microsoft][ODBC SQL Server Driver][SQL Server]The statement terminated. The maximum recursion 100 has been exhausted before statement completion.


========= LAST COMMAND ========

If (object_id(N'tempdb..#MoveInput') Is Not Null) Truncate Table #MoveInput Else Create Table #MoveInput (DocID int, ProjID int, DestProjID int, NewName nvarchar(260) collate database_default)




Insert Into #MoveInput


Select 202953, 10044, 10031, N''


Exec SPRM_MoveItems 46, N'C:\_EPDM', N'{EDE1FEEE-6D4C-4028-B6BA-23D923152DA7}'




The files in question have one thing in common.  They all contain a virtual component with in-context references to the top level assembly.  An example set of references looks like this:



I figured that the circular reference was causing the problem (especially since the SQL error mentions recursion), so I deleted all the in context references and the In-Place mate so that the tree looks like this:



The error remains and the file will not move.  I have also tried saving the virtual component externally, but the error still occurs.


Has anyone seen this problem?  If so, what is the solution?




Jim S.