Cannot Delete Repository

Justin Spindler · Post by **Justin Spindler** » Mon Jun 20, 2005 3:46 pm

I created a new repository to test a VSS import. After I successfully imported a project I then deleted the files and obliterated them. Then decided to delete the repository so that I could start fresh, however when I attempt to delete the repository I get the following error:

Code: Select all

VaultServiceAPILib.VaultSoapException: 1104 : FailDBReader
   at VaultService.VaultAdminService.DeleteRepository(Int32 nRepID)

I am using Vault 3.0.7 on Windows Server 2003 Standard Edition SP1 on a named instance of SQL Server 2000 SP4.

The log contains the following entry:

Code: Select all

----6/20/2005 4:31:42 PM     admin--gssidev1.debtsoftware.com(127.0.0.1)--SSL Enabled	Internal Query Processor Error: The query processor could not produce a query plan.  Contact your primary support provider for more information.

lbauer · Post by **lbauer** » Mon Jun 20, 2005 4:01 pm

This is a known issue with SP 4 for MS SQL Server.

See this forum post for details:

http://support.sourcegear.com/viewtopic.php?t=4039

One user reported he was able to revert back to SP3 and then could delete the repository.

lbauer · Post by **lbauer** » Tue Jun 21, 2005 9:38 am

We've posted a workaround for users with MS SQL Server SP 4:

http://support.sourcegear.com/viewtopic.php?t=3786