Queue SQL call failed. The connection's current state is closed.

[Sinisa Jovancic]

Hi,

I'm using Project Server 2007 integrated with MOSS 2007.

In one moment I have this error:

Event Type: Error
Event Source: Office SharePoint Server
Event Category: Project Server Queue
Event ID: 7758
Date: 4/22/2009
Time: 11:08:52 AM
User: N/A
Computer: PS07
Description:
Standard InformationSI Entry Point: WinProj.QueuePublish
Project User: PEXIMBG\aleksandar.djordjevi
Correlation Id: 02d1d431-cd65-44dc-affa-7b24d8471f8a
PWA Site URL: http://ps07/projectserver
SSP Name: ProjectServerSSP
PSError: Success (0)
Queue SQL call failed. Error: System.InvalidOperationException:
ExecuteNonQuery requires an open and available Connection. The connection's
current state is closed.
at System.Data.SqlClient.SqlConnection.GetOpenConnection(String method)
at
System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String
method, SqlCommand command)
at System.Data.SqlClient.SqlCommand.ValidateCommand(String method,
Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at
Microsoft.Office.Project.Server.DataAccessLayer.DAL.SubDal.ExecuteStoredProcedureReturnVal(String storedProcedureName, SqlParameter[] parameters)
at
Microsoft.Office.Project.Server.DataAccessLayer.QueueDal.PurgeGroup(String
prefix, Guid GroupUID)
at
Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SqlCallRetry.PurgeGroupSqlCall.Execute()
at
Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SqlCallRetry.RetryableSqlCallBase.ExecuteRetryableSqlCall()

After this error I have problem with save and publish project jobs. I found
solutions for this problem (Job's Queue was stuck) but I want know cause of
this error.