none
Project Server 2007 error message, Force check-in enterprise objects RRS feed

  • Question

  • project server 2007 deployed on windows server 2008. When attemping to use the force check-in enterprise objects under server settings, Database administration, I receive the following error message. Any help would be greatly appreciated.

    System.Web.Services.Protocols.SoapException: ProjectServerError(s) LastError=GeneralUnhandledException Instructions: Pass this into PSClientError constructor to access all error information
       at Microsoft.Office.Project.Server.WebService.PWA.AdminReadCheckedOutEnterpriseProjects() 

     

    the following event is logged in the application log

    Log Name:      Application
    Source:        Office SharePoint Server
    Date:          7/13/2010 7:59:16 PM
    Event ID:      7758
    Task Category: Project Server Queue
    Level:         Error
    Keywords:      Classic
    User:          N/A
    Computer:      "Servername"."companydomain".com
    Description:
    Standard Information:PSI Entry Point: PWA.AdminReadCheckedOutEnterpriseProjects
    Project User: "CompanyDomain"\"myusername"
    Correlation Id: dad916b5-6239-4515-ae07-d6b2a237f3e6
    PWA Site URL: http://psiprojectsrv/PWA
    SSP Name: PROJECTSRV - SSP
    PSError: Success (0)
    Queue SQL call failed. Error: System.Data.SqlClient.SqlException: Procedure or function 'MSP_ProjQ_Get_Status_Of_Jobs_List' expects parameter '@wantJobsQLS', which was not supplied.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
       at System.Data.SqlClient.SqlDataReader.get_MetaData()
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
       at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
       at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
       at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
       at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
       at Microsoft.Office.Project.Server.DataAccessLayer.DAL.SubDal.FillTypedDataSet(DataSet typedDataSet, String[] tables, SqlCommand sqlCommand)
       at Microsoft.Office.Project.Server.DataAccessLayer.DAL.SubDal.FillTypedDataSet(DataSet typedDataSet, String[] tables, String storedProcedureName, SqlParameter[] parameters)
       at Microsoft.Office.Project.Server.DataAccessLayer.QueueDal.GetStatusOfJobsList(String prefix, String jobUIDList, String TrackingIDList, String jobInfoUIDList, String resUIDList, String correlationUIDList, String msgTypeList, String groupStateList, Boolean wantErrorInfo, Nullable`1 history, Nullable`1 startDate, Nullable`1 endDate, Nullable`1 rowLimit, Nullable`1 sortColumn, Nullable`1 sortOrder)
       at Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SqlCallRetry.GetStatusOfJobsListSqlCall.Execute()
       at Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SqlCallRetry.RetryableSqlCallBase.ExecuteRetryableSqlCall()
    Event Xml:
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
      <System>
        <Provider Name="Office SharePoint Server" />
        <EventID Qualifiers="0">7758</EventID>
        <Level>2</Level>
        <Task>1148</Task>
        <Keywords>0x80000000000000</Keywords>
        <TimeCreated SystemTime="2010-07-13T23:59:16.000Z" />
        <EventRecordID>5301</EventRecordID>
        <Channel>Application</Channel>
        <Computer>"Servername"."companydomain".com</Computer>
        <Security />
      </System>
      <EventData>
        <Data>PSI Entry Point: PWA.AdminReadCheckedOutEnterpriseProjects
    Project User: "companydomain"\"myusername"
    Correlation Id: dad916b5-6239-4515-ae07-d6b2a237f3e6
    PWA Site URL: http://psiprojectsrv/PWA
    SSP Name: PROJECTSRV - SSP
    PSError: Success (0)</Data>
        <Data>System.Data.SqlClient.SqlException: Procedure or function 'MSP_ProjQ_Get_Status_Of_Jobs_List' expects parameter '@wantJobsQLS', which was not supplied.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
       at System.Data.SqlClient.SqlDataReader.get_MetaData()
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
       at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
       at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
       at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
       at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
       at Microsoft.Office.Project.Server.DataAccessLayer.DAL.SubDal.FillTypedDataSet(DataSet typedDataSet, String[] tables, SqlCommand sqlCommand)
       at Microsoft.Office.Project.Server.DataAccessLayer.DAL.SubDal.FillTypedDataSet(DataSet typedDataSet, String[] tables, String storedProcedureName, SqlParameter[] parameters)
       at Microsoft.Office.Project.Server.DataAccessLayer.QueueDal.GetStatusOfJobsList(String prefix, String jobUIDList, String TrackingIDList, String jobInfoUIDList, String resUIDList, String correlationUIDList, String msgTypeList, String groupStateList, Boolean wantErrorInfo, Nullable`1 history, Nullable`1 startDate, Nullable`1 endDate, Nullable`1 rowLimit, Nullable`1 sortColumn, Nullable`1 sortOrder)
       at Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SqlCallRetry.GetStatusOfJobsListSqlCall.Execute()
       at Microsoft.Office.Project.Server.BusinessLayer.Queue.BaseQueueAccess.SqlCallRetry.RetryableSqlCallBase.ExecuteRetryableSqlCall()</Data>
      </EventData>
    </Event>

    Wednesday, July 14, 2010 12:07 AM

Answers

  • Error : Procedure or function 'MSP_ProjQ_Get_Status_Of_Jobs_List' expects parameter '@wantJobsQLS', which was not supplied.

    -Assumed the issue is happening for all the users

                   -In that case, restart IIS, project services and Sharepoint Timer service. Check the status

                   -Ensure Office server web services application pool is running on Network service.

                   -Check the status of the other PWA pages to check the service status.

                   -In central admin Stop the project application service and start it.

    Do you have any idea how many projects were checkedout approximately? (Sometimes the issue occurs due to the performance)

     (LAST OPTION)

    Install the latest Service pack / Cumulative update for MOSS / Project server.  Make sure sharepoint configuration wizard executed successfully.

     


    Cheers. Happy troubleshooting !!! Sriram E - MSFT Enterprise Project Management
    Wednesday, July 14, 2010 3:11 AM
    Moderator