Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Deleting a Project

web-app

We have been trying to delete a project that is no longer used.  We have removed all the issues, all the assigned resources, etc.  But the project just will not delete, no matter what we do.

Is there a secret to deleting a project in Gemini?

BTW, we just updated to 3.7 yesterday.  We were running 3.6 previously.  The problem existed in both versions.

COMC
· 1
COMC
Replies (4)
helpful
0
not helpful

Can you please check Gemini's system log for errors?


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Hi,

Thanks for the quick response.  Here is the error just generated when I tried to delete the project again:

Delete Project Failed The DELETE statement conflicted with the REFERENCE constraint "geminiissueattachmentsprojectidfk". The conflict occurred in database "comcgemini", table "dbo.gemini_issueattachments", column 'projectid'. The statement has been terminated. .Net SqlClient Data Provider

However, there are no issues in this project -- they were moved to other projects some time ago.


COMC
· 1
COMC
helpful
0
not helpful

Seems like an old bug that didn't move the project id when moving issues (attachments).
Run the following SQL and then you'll be able to delete it:

update a
    set a.projectid = i.projectid
from geminiissueattachments a join geminiissues i on a.issueid = i.issueid and a.projectid != i.projectid


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

Outstanding.  That worked perfectly. Thanks for your help.


COMC
· 1
COMC