none
Project Server 2007 - Adding "My tasks" webpart RRS feed

  • Question

  • By accident, "My tasks" webpart was deleted from "My tasks" web page. Now we need to add "My tasks" webpart back to "my tasks" page. When we try to add "My tasks" webpart, we are getting the following error message

    -----------------------------------------------------------------------------------------------------------------------------

    Error 
     
    An unexpected error has occurred.

    Web Parts Maintenance Page: If you have permission, you can use this page to temporarily close Web Parts or remove personal settings. For more information, contact your site administrator.
    Troubleshoot issues with Windows SharePoint Services.

    -----------------------------------------------------------------------------------------------------------------------------

    Following are the entries from the server's event log

    A runtime exception was detected. Details follow.
    Message: Procedure or function MSP_WEB_SP_QRY_Statusing_ReadStatus has too many arguments specified.

    Techinal Details:
    System.Data.SqlClient.SqlException: Procedure or function MSP_WEB_SP_QRY_Statusing_ReadStatus has too many arguments specified.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.SqlInternalConnection.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.StatusingDal.ReadStatusTyped(Guid residForSecurity, String residsForStatus, Guid assnid, Int32 filter, Int32 filterCompleted, DateTime mindate, DateTime maxdate, Int32 lcid, Boolean getAllCustomFields, String entTaskCustomFields, String entResCustomFields, String entAssnCustomFields, String localTaskCustomFields, String localResCustomFields, String localAssnCustomFields, Boolean useProjectResources)
       at Microsoft.Office.Project.Server.BusinessLayer.Statusing.ReadStatusForStatusingViews(Guid assnid, DateTime mindate, DateTime maxdate)
       at Microsoft.Office.Project.Server.WebService.PWA.StatusingReadStatusForStatusingViews(Guid assnid, DateTime mindate, DateTime maxdate)

    For more information, see Help and Support Center at

    --------------------------------------------------------------------------------------------------------------------------------------------

    Any help on this issue?

     
     
     


    Sanjeev
    • Edited by Sanjeev S K Friday, December 9, 2011 12:20 AM correction
    Friday, December 9, 2011 12:03 AM

All replies

  • Please verify the permission for this web part, if once again you need to synchronize with it.

    After that you can try to add the mentioned web part with Administrative permission.

    Steps :

    1. Click Site Setting

    2. Click on Web Part Gallery

    3. Click on TaskPart

    4. Verify the permission.

    Please verify, Hope it help to resolve the issue.

     

    Friday, December 9, 2011 9:34 AM