Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error
Deleting project in SQL
Options
Go to last post Go to first unread
Previous Topic Next Topic
ryan.baxter  
#1 Posted : Thursday, August 26, 2010 12:01:01 PM(UTC)
ryan.baxter
Rank: Newbie

Reputation:

Groups: Registered
Posts: 21
Location: EBA Engineering

I'm having a problem deleting miss-entered or test SQL projects. I try to delete in the site/project association window and I get:

 170[Microsoft][ODBC SQL Server] The DELETE statment conflicted with the REFERENCE constraint "FK_Sample_Delivery_Groups_Projects". The conflict occurred in database "ESdat_HG", table "dbo.Lab_Sample_Delivery_Groups".

 Any ideas? I have DBO privliges.

Back to top

Wanna join the discussion?! Login to your ESdat Forums forum accountor Register a new forum account.
Back to top  
Warwick Wood  
#2 Posted : Thursday, August 26, 2010 8:53:41 PM(UTC)
Warwick Wood
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 498
Man
Location: Byron Bay

Was thanked: 19 time(s) in 19 post(s)

Hello Ryan,

This is the same problem that Alex identified yesterday (see other forum post).  This is due to a bug.  We have a fix I can forward, or otherwise you can just delete the data for that site in "Lab_Sample_Delivery_Groups" table then re-try deleting the site, which should then work fine.

Regards,

Warwick
Back to top
WWW
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF.NET | YAF.NET © 2003-2024, Yet Another Forum.NET