Hi all We are using Spirateam V 3.2 hosted on a Windows Server 2003 with IIS 6.0 Some users have sometimes problems to work with spirateam. When they try to connect to the webpage or to work in spirateam they get timeouts... (Firefox and IE) On the webserver in the Application Event Log we have several errors: ------ Source: SpiraTeam / Category: None / EventID:0 APPLICATION.Business.Release::Update: The version number specified is not unique For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. ------ Source: SpiraTeam / Category: None / EventID:0 APPLICATION.Business.User::UpdateLastOpenedProject: Database foreign key violation occurred [APPLICATION.Business.DataAccessForeignKeyException] The UPDATE statement conflicted with the FOREIGN KEY constraint "FK_PROJECT_USER". The conflict occurred in database "SpiraTeam", table "dbo.TST_PROJECT", column 'PROJECT_ID'. The statement has been terminated. [System.Data.SqlClient.SqlException] Stack Trace: at APPLICATION.Business.DataAccess.ExecuteNonQuery(String sqlCommand, Boolean useParam) at APPLICATION.Business.UserManager.UpdateLastOpenedProject(Int32 userId, Int32 lastOpenedProjectId) I have no idea if the errors have something to do with the timeouts or not... Thx for help en-US(C) Copyright 2006-2026 Inflectra Corporation.support@inflectra.com/Computers/Software/Project_Management//Computers/Software/Quality_Assurance/KronoDesksupport@inflectra.comhttp://www.inflectra.com/kronodesk/forums/threads120/Support/Forum/spirateam/issues-questions/249.aspxthreadId=249Sandro Bischof (sandro.bischof@frama.com) Hi all We are using Spirateam V 3.2 hosted on a Windows Server 2003 with IIS 6.0 Some users have sometimes problems to work with spirateam. When they try to connect to the webpage or to work in spirateam they get timeouts... (Firefox and IE) On the webserver in the Application Event Log we have several errors: ------ Source: SpiraTeam / Category: None / EventID:0 APPLICATION.Business.Release::Update: The version number specified is not unique For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. ------ Source: SpiraTeam / Category: None / EventID:0 APPLICATION.Business.User::UpdateLastOpenedProject: Database foreign key violation occurred [APPLICATION.Business.DataAccessForeignKeyException] The UPDATE statement conflicted with the FOREIGN KEY constraint "FK_PROJECT_USER". The conflict occurred in database "SpiraTeam", table "dbo.TST_PROJECT", column 'PROJECT_ID'. The statement has been terminated. [System.Data.SqlClient.SqlException] Stack Trace: at APPLICATION.Business.DataAccess.ExecuteNonQuery(String sqlCommand, Boolean useParam) at APPLICATION.Business.UserManager.UpdateLastOpenedProject(Int32 userId, Int32 lastOpenedProjectId) I have no idea if the errors have something to do with the timeouts or not... Thx for help Wed, 29 Feb 2012 14:13:43 -05002012-02-29T14:47:37-05:00/Support/Forum/spirateam/issues-questions/249.aspxmessageId=482David J (adam.sandman+support@inflectra.com) Please could you make sure that you're on the latest patch for v3.2 (currently patch 009) that should fix the error messages you're seeing. If not, please send a ticket to support@inflectra.com so that we can investigate further for you. Regarding the timeouts, please refresh the database indexes and that should address the issue (see https://www.inflectra.com/Support/FAQs.aspx?productId=3#technical07 ). Wed, 29 Feb 2012 14:47:37 -05002012-02-29T14:47:37-05:00/Support/Forum/spirateam/issues-questions/249.aspx#reply482