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.




Time out with batch updates

web-app

Hi,

As I want to change the assigned resource for a number of issues, I tried using the batch update which looked perfect for the job. However, when selecting more than 1 issue the batch update always result in a time out (as I can see in de error report)

I followed the advice from this thread, no success though.

I'm running 2.0.4.

Any thoughts?
erikl
· 1 		erikl
Thursday, June 8, 2006, 12:20:34 PM
Replies (2)
helpful
0
not helpful

Try amending the gemini_getissue stored procedure to use the no lock option.

This usually is an SQL Server 2005 issue.

..

..

from issuesview(nolock)....
Mark Wing
· 9108 		Mark Wing
Thursday, June 8, 2006, 12:35:14 PM
helpful
0
not helpful

The batch update works flawless now

Thnx a lot

 
erikl
· 1 		erikl
Thursday, June 8, 2006, 1:46:07 PM