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:

 

error.png

A check of the log file shows this:

 

===================================

Error running query in SpDbOdbc

State=23000

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)

 

SET NOCOUNT ON

 

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:

 

refs.png

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:

 

cleanrefs.png

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?

 

Thanks.

 

Jim S.

Outcomes