Exception when using PWA Services: MSP_SSP_UPDATE_ENTERPRISE_ENTIT

[Makkan]

For one or two weeks Project 2007 Server acts strangely. In Project Pro I can
see resources but I cannot assign them, a message tells me then there are
zero resources. Also I cannot use the PWA Webservices, I get a strange
exception that lies deep inside MS Code. It says the procedure or function
'MSP_SSP_UPDATE_ENTERPRISE_ENTITIES' excepts the parameter @REV_COUNTER that
was not passed. This is a SQL exception. It occurs when the
GetJobCompletionState from QueueSystem is called.

At first I thought it could be the x64 Windows 2003 Server Englisch Version
that cannot interact properly with the German Project Server. But the machine
was killed and re-installed with German x32 Windows 2003 Server and it occurs
again.

Anybody any ideas?


Complete exception:

Queue request Failed for Job ID 55e00e03-23b2-43e8-bf42-cd93c76d0d1b.
<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="GeneralQueueException">
<error id="9131" name="GeneralQueueException"
uid="cf8a8f0a-041e-4075-9435-df50f513457a" messageID="2"
exception="System.Data.SqlClient.SqlException: Die Prozedur oder Funktion
'MSP_SSP_UPDATE_ENTERPRISE_ENTITIES' erwartet den '@REV_COUNTER'-Parameter,
der nicht bereitgestellt wurde.
bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection)
bei System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
bei
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
bei System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
bei System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader
ds, RunBehavior runBehavior, String resetOptionsString)
bei System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
bei System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
DbAsyncResult result)
bei
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
result, String methodName, Boolean sendToPipe)
bei System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
bei
Microsoft.Office.Project.Server.DataAccessLayer.DAL.SubDal.ExecuteStoredProcedureNoResult(String storedProcedureName, SqlParameter[] parameters)
bei
Microsoft.Office.Project.Server.DataAccessLayer.ProjectDal.UpdateEnterpriseEntities(Guid projectUid)
bei
Microsoft.Office.Project.Server.BusinessLayer.ProjectMain.LoadSchedulingData(Boolean isDelete)
bei
Microsoft.Office.Project.Server.BusinessLayer.ProjectMain.HandleProject(ProjectDataSet
dataset, Guid projectUid, Guid userUid, String userName, Boolean isNew,
Boolean addColumns, ProjectLocks projectLock, Boolean fCheckReadOnly, Boolean
fCheckProtectedActuals, Boolean fAllowAddEntRes)
bei
Microsoft.Office.Project.Server.BusinessLayer.ProjectMain.HandleProject(ProjectDataSet
dataset, Guid projectUid, Guid userUid, String userName, Boolean isNew,
Boolean addColumns, ProjectLocks projectLock)
bei
Microsoft.Office.Project.Server.BusinessLayer.ProjectQueueDispatch.HandleProject(MessageContext
mContext, ProjectMain project, ServerEventManager sem, ProjectDataSet
dataset, Guid projectUid, Guid userUid, String userName, Boolean isNew,
Boolean addColumns, ProjectLocks projectLock)
bei
Microsoft.Office.Project.Server.BusinessLayer.ProjectQueueDispatch.InternalDispatchMessage(PlatformContext
context, Message msg, Group messageGroup, JobTicket jobTicket, MessageContext
mContext)" />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="8e36c57b-4e1a-4855-8787-81cacba7dc1d"
JobUID="55e00e03-23b2-43e8-bf42-cd93c76d0d1b" ComputerName="PROJECTSERVER"
GroupType="ProjectUpdate" MessageType="" MessageId="" Stage="" />
</class>
</general>
</errinfo>.