Error: 3124 Error: 26000

[DJ Madison]

We use EPM for submission of timesheets. I receive email notifications when
staff submits their time. However this morning some of the updates went
through "normally" or a few didn't. Can someone tell me what the following
error means, and how to fix it?

******************************************

The errors returned from the queue are as follows:
Error ID: 3124
Error ID: 26000

Detailed error below - send it to the administrator for more detailed
troubleshooting.

<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="ExecuteNonQuery requires an open and available Connection.
The connection_s current state is closed.">
<error id="3124" name="StatusingApplyUpdatesFailure"
uid="a3521eb3-ee75-4561-9287-cd45a05fbf32"
ProjectUID="39f118d3-e584-4704-a7c6-18c3f972e470"
JobUID="5fda3fed-5375-48f2-9c33-7b3ff5c6cf3f" MessageID="3"
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.ExecuteStoredProcedureNoResult(String storedProcedureName, SqlParameter[] parameters)
at
Microsoft.Office.Project.Server.DataAccessLayer.Generated.StatusingDalBase.StatusApprovalSetAppliedNoResult(String
uid_list, Int32 assn_trans_error_enum, Int32 assn_trans_state_enum)
at
Microsoft.Office.Project.Server.BusinessLayer.StatusApprovalMessageHandler.ProcessingComplete(StatusApprovalApplyResult result)
at
Microsoft.Office.Project.Server.BusinessLayer.StatusApprovalMessageHandler.Process(StatusApprovalMessage
message, StatusTransactionState expectedState, Boolean keepSchedulingResults,
StatusApprovalApplyResult& result)
at
Microsoft.Office.Project.Server.BusinessLayer.StatusApprovalMessageHandler.Process(StatusApprovalMessage message)
at
Microsoft.Office.Project.Server.BusinessLayer.Queue.ProcessStatusApprovalMessage.ApplyStatusUpdates(Message
msg, Group messageGroup, JobTicket jobTicket, MessageContext mContext)
at
Microsoft.Office.Project.Server.BusinessLayer.Queue.ProcessStatusApprovalMessage.ProcessMessageCallback(Message
msg, Group messageGroup, JobTicket jobTicket, MessageContext mContext)" />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="c7fcdc62-dbaa-4e51-a2b9-1ef0b33ea13b"
JobUID="5fda3fed-5375-48f2-9c33-7b3ff5c6cf3f" ComputerName="RWDEPM1"
GroupType="StatusApproval" MessageType="StatusApprovalMessage" MessageId="3"
Stage="" />
</class>
</general>
</errinfo>

 

[Mike Glen]

Hi ,

Try posting on the microsoft.public.project.server newsgroup (forum).
Please see FAQ Item: 24. Project Newsgroups. FAQs, companion products and
other useful Project information can be seen at this web address:
http://project.mvps.org/faqs.htm

Mike Glen
Project MVP

We use EPM for submission of timesheets. I receive email
notifications when
staff submits their time. However this morning some of the updates
went
through "normally" or a few didn't. Can someone tell me what the
following
error means, and how to fix it?

******************************************

The errors returned from the queue are as follows:
Error ID: 3124
Error ID: 26000

Detailed error below - send it to the administrator for more detailed
troubleshooting.

<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="ExecuteNonQuery requires an open and available
Connection.
The connection_s current state is closed.">
<error id="3124" name="StatusingApplyUpdatesFailure"
uid="a3521eb3-ee75-4561-9287-cd45a05fbf32"
ProjectUID="39f118d3-e584-4704-a7c6-18c3f972e470"
JobUID="5fda3fed-5375-48f2-9c33-7b3ff5c6cf3f" MessageID="3"
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.ExecuteStoredProcedureNoResult(String
storedProcedureName, SqlParameter[] parameters) at
Microsoft.Office.Project.Server.DataAccessLayer.Generated.StatusingDalBase.StatusApprovalSetAppliedNoResult(String
uid_list, Int32 assn_trans_error_enum, Int32 assn_trans_state_enum)
at
Microsoft.Office.Project.Server.BusinessLayer.StatusApprovalMessageHandler.ProcessingComplete(StatusApprovalApplyResult
result) at
Microsoft.Office.Project.Server.BusinessLayer.StatusApprovalMessageHandler.Process(StatusApprovalMessage
message, StatusTransactionState expectedState, Boolean
keepSchedulingResults,
StatusApprovalApplyResult& result)
at
Microsoft.Office.Project.Server.BusinessLayer.StatusApprovalMessageHandler.Process(StatusApprovalMessage
message) at
Microsoft.Office.Project.Server.BusinessLayer.Queue.ProcessStatusApprovalMessage.ApplyStatusUpdates(Message
msg, Group messageGroup, JobTicket jobTicket, MessageContext mContext)
at
Microsoft.Office.Project.Server.BusinessLayer.Queue.ProcessStatusApprovalMessage.ProcessMessageCallback(Message
msg, Group messageGroup, JobTicket jobTicket, MessageContext
mContext)" /> </class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="c7fcdc62-dbaa-4e51-a2b9-1ef0b33ea13b"
JobUID="5fda3fed-5375-48f2-9c33-7b3ff5c6cf3f" ComputerName="RWDEPM1"
GroupType="StatusApproval" MessageType="StatusApprovalMessage"
MessageId="3"
Stage="" />
</class>
</general>
</errinfo>