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
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:
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?
Thanks.
Jim S.
SolidworksSolidworks Pdm enterprise Pdm