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.




v3.7: cannot delete projects

web-app

I logged in the gemini system and go to Administration -> Projects
After deleting 2 projects on the Projects page, i tried to delete the 3rd one using the same method (clicking the X on actions column), it only has the pop up to let me hit Delete Project button, no matter how many time I hit the button, it did not do anything that I expected to see (from deleting the first 2 projects).  The pop up window just stays there for about 2-3 mins then disappear if I don't do anything.  I thought I just wait a minute or 2 to click the "Delete Project" button again, but no matter how long I waited, it just did not take it.

Happened on IE 8 and Firefox 3.6.8

Any idea why?

I am also seeing the problem that:
1) the pop up window, with 2 buttons grayed out, can't hit the buttons
2) after hitting the Delete Project button, the pop up window disappeared, thought that the project got deleted ok, but the project is still there

kha
· 1
kha
Replies (16)
helpful
0
not helpful

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


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

I am seeing several errors in the system log:

9/9/2010 1:57:04 PM
Delete Project Failed The DELETE statement conflicted with the REFERENCE constraint "geminiissueattachmentsprojectidfk". The conflict occurred in database "Gemini", table "dbo.geminiissueattachments", column 'projectid'. The statement has been terminated. .Net SqlClient Data Provider
-----------------

9/9/2010 1:58:46 PM
Delete Project Failed Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. .Net SqlClient Data Provider


kha
· 1
kha
helpful
0
not helpful

Seems like mistmatch in the data, please run the following SQL:

update geminiissueattachments set geminiissueattachments.projectid = geminiissues.projectid
from gemini
issueattachments join geminiissues on geminiissueattachments.issueid = geminiissues.issueid
where gemini
issueattachments.projectid != gemini_issues.projectid

and try deleting again


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

I can delete some project that I couldn't before, after running your script.

However, I still see problem with hitting the Delete Project button and it did not do anything, pop up window still stays there, system log shows:

Delete Project Failed Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. .Net SqlClient Data Provider


kha
· 1
kha
helpful
0
not helpful

I am still seeing the pop up window grayed out, when it does that, i can't click x to close it, or anything else, just have to refresh the page to be able to click on something else


kha
· 1
kha
helpful
0
not helpful

I just tried to delete a project that I couldn't before, I still can now and it still shows the similiar error on system log:

9/9/2010 3:21:22 PM
Delete Project Failed The DELETE statement conflicted with the REFERENCE constraint "geminiwatchissuesissueidfk". The conflict occurred in database "Gemini", table "dbo.geminiwatchissues", column 'issueid'. The statement has been terminated. .Net SqlClient Data Provider


kha
· 1
kha
helpful
0
not helpful

Ok, seems like another data mismatch, run the following SQL:

update geminiwatchissues set geminiwatchissues.projectid = geminiissues.projectid
from gemini
watchissues join geminiissues on geminiwatchissues.issueid = geminiissues.issueid
where gemini
watchissues.projectid != gemini_issues.projectid


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Thanks, I can delete that project now after running your script.
But I still cannot delete the other project that it did not do anything when clicking on "Delete Project" button.  Still see this error:

"Delete Project Failed Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. .Net SqlClient Data Provider"


kha
· 1
kha
helpful
0
not helpful

hehehe i am seeing another mismatch error here:

"Delete Project Failed The DELETE statement conflicted with the REFERENCE constraint "geminiissueattachmentscommentidfk". The conflict occurred in database "Gemini", table "dbo.geminiissueattachments", column 'commentid'. The statement has been terminated. .Net SqlClient Data Provider"


kha
· 1
kha
helpful
0
not helpful

Run this SQL:

update geminiissuecomments set geminiissuecomments.projectid = geminiissues.projectid
from gemini
issuecomments join geminiissues on geminiissuecomments.issueid = geminiissues.issueid
where gemini
issuecomments.projectid != gemini_issues.projectid


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Can you please look into why I keep getting the "Delete project failed timeout expired..." error and clicking on the Delete Project button thought that it's got deleted, but the projects are still there.

I have several projects that I need to delete and running into this "timeout expired" error, not sure what I should try next to solve this problem.


kha
· 1
kha
helpful
0
not helpful

If the project data is big (eg. a lot of issues and attachments) then you might want to set the SQL command timeout in the web.config file:

<!--property name="commandtimeout">60</property-->
to
<property name="command
timeout">0</property>



Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

i changed the command_timeout to 0, but still have the same timeout expired problem


kha
· 1
kha
helpful
0
not helpful

Did you remove the remarks from the timeout (<!-- .... -->)?
Can you post the full error?


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

never mind, i spoke too soon.  It works now. :)


kha
· 1
kha
helpful
0
not helpful

yeah, i did not remove those, that is why it did not work.  My bad.
It's working now :) thanks!


kha
· 1
kha