locked
Cannot delete project from Published database RRS feed

  • Question

  • When an administrator attempts to delete a project, the project is successfully deleted from the Draft database, but fails to delete from the Published database. Here are the details from the Queue:

    Collections:
    rejectedTimesheetLines (System.Guid) :
    Item value = '235884f0-5d02-4e53-84d4-f00105e7849e' :
    Error: id='10000' name='GeneralItemDoesNotExist' uid='aba281e1-e6bc-481c-9524-3fe2847d3012'
    Error: id='10000' name='GeneralItemDoesNotExist' uid='1a8ee3ed-5542-423a-baa3-2437a94954c8'
    Error: id='10000' name='GeneralItemDoesNotExist' uid='e781f31d-2bac-4fd1-8e4d-d7b51429d40b'
    Error: id='10000' name='GeneralItemDoesNotExist' uid='2a9b9a9a-8c4d-417d-a199-f086a7601e6c'
    Error: id='10000' name='GeneralItemDoesNotExist' uid='bd5db5f1-86af-469c-8c01-1d7db668e27c'
    Error: id='10000' name='GeneralItemDoesNotExist' uid='a995d232-935e-4f1c-a650-1aff8b9e763b'

    General
    Error:
    ProjectDeleteFailure (23006). Details: id='23006' name='ProjectDeleteFailure' uid='bcabc1fd-8446-4d1e-a6e8-49b5673e5586' projectuid='ad07d099-bdac-4391-9ae4-25e6d24da3f0' messagetype='Microsoft.Office.Project.Server.BusinessLayer.QueueMsg.AdjustTimeSheetForDeletedProjectMessage' messageID='6' stage='' blocking='Undefined'.
    Queue:
    GeneralQueueJobFailed (26000) - ProjectDelete.AdjustTimeSheetForDeletedProjectMessage. Details: id='26000' name='GeneralQueueJobFailed' uid='29f933e6-7b25-4b98-978e-cc5bda4ea8d4' JobUID='8f557b70-3067-4ade-9539-e20dec2dad91' ComputerName='PMA-POC-APP01' GroupType='ProjectDelete' MessageType='AdjustTimeSheetForDeletedProjectMessage' MessageId='6' Stage=''. For more details, check the ULS logs on machine PMA-POC-APP01 for entries with JobUID 8f557b70-3067-4ade-9539-e20dec2dad91.

    And from the ULS file:

    PSI: [QUEUE] [PSI] ReadProjectJobStatus(...) c51816de-deb1-45c6-a94c-4a489439a4df
    PSI: [QUEUE] ProjectQ: Starting group 2f27f6ac-2c87-489d-ad45-e66fee5293a4 type = ProjectDelete priority = StandardPriority 22505ee5-dbca-4c35-95d7-af9eef3241d4
    PSI: [QUEUE] ProjectDeleteParamsMessage ff3de61b-873a-4932-b329-feafc8872580
    PSI: [QUEUE] CheckProjectExistsMessage ff3de61b-873a-4932-b329-feafc8872580
    PSI: [QUEUE] GetProjectNameMessage ff3de61b-873a-4932-b329-feafc8872580
    PSI: [QUEUE] GetWssSiteInfoMessage ff3de61b-873a-4932-b329-feafc8872580
    PSI: [QUEUE] ProjectPreDeleteEventMessage ff3de61b-873a-4932-b329-feafc8872580
    PSI: [QUEUE] AdjustTimeSheetForDeletedProject ff3de61b-873a-4932-b329-feafc8872580
    PSI: [QUEUE] Retry: 1  ProjectDelete  Microsoft.Office.Project.Server.BusinessLayer.QueueMsg.AdjustTimeSheetForDeletedProjectMessage 6364d96e-480a-4cb8-806b-1ae53b66c454
    PSI: [QUEUE] AdjustTimeSheetForDeletedProject ff3de61b-873a-4932-b329-feafc8872580
    04/05/2010 11:20:34.93  w3wp.exe (0x16BC)                        0x1C28 SharePoint Foundation          Monitoring                     b4ly High     Leaving Monitored Scope (ExecuteWcfOperation:http://schemas.microsoft.com/office/project/server/webservices/QueueSystem/ReadProjectJobStatus). Execution Time=2291.6456 c51816de-deb1-45c6-a94c-4a489439a4df
    04/05/2010 11:20:34.99  w3wp.exe (0x16BC)                        0x1C28 SharePoint Foundation          Monitoring                     b4ly Medium   Leaving Monitored Scope (Request (POST:http://pma-poc-app01:80/pwa/_layouts/pwa/Admin/DBCleanUp.aspx)). Execution Time=3793.9765 c51816de-deb1-45c6-a94c-4a489439a4df
    04/05/2010 11:20:35.04  w3wp.exe (0x17CC)                        0x14B0 Excel Services                 Excel Calculation Services     8jg2 Medium   ResourceManager.PerformCleanup: Disk Manager: CurrentSize=120760. 11c5f189-1382-0bba-0000-000050f7b00c
    PSI: [QUEUE] Retry: 2  ProjectDelete  Microsoft.Office.Project.Server.BusinessLayer.QueueMsg.AdjustTimeSheetForDeletedProjectMessage 6364d96e-480a-4cb8-806b-1ae53b66c454

    I wouldn't expect the existance of Timesheets to stop the deletion of a project. Any ideas as to what is happening here?

    Monday, April 5, 2010 4:03 PM

Answers

  • The project contains tasks that were rejected in timesheets.

    You need to find the timesheets that contained tasks from this project, delete them then delete the project from the published database

    Please advise if this will work or you need additional information.

    Regards,

    Mira

    Monday, April 12, 2010 1:13 PM

All replies

  • The project contains tasks that were rejected in timesheets.

    You need to find the timesheets that contained tasks from this project, delete them then delete the project from the published database

    Please advise if this will work or you need additional information.

    Regards,

    Mira

    Monday, April 12, 2010 1:13 PM
  • Hi.

    To help everyone to solve this problem.
    We have find timesheets to be deleted using theese queries.

    For find project that isn't in draft.

    USE ProjectServer_Published 
    SELECT PubProj.PROJ_UID, PubProj.PROJ_NAME AS Published, DrafProj.PROJ_NAME AS Draft 
     FROM ProjectServer_Published.dbo.MSP_PROJECTS AS PubProj 
     LEFT OUTER JOIN ProjectServer_Draft.dbo.MSP_PROJECTS AS DrafProj ON PubProj.PROJ_UID = DrafProj.PROJ_UID 
     WHERE DrafProj.PROJ_NAME IS NULL
    

    For find timesheets.

    USE ProjectServer_Published 
    SELECT MSP_TIMESHEETS.TS_UID, MSP_TIMESHEETS.CREATED_DATE, MSP_TIMESHEETS.TS_CACHED_RES_NAME, MSP_TIMESHEETS.TS_COMMENTS,
    RepTSP.PeriodName, RepTSP.StartDate, RepTSP.EndDate, 
    MSP_TIMESHEET_LINES.PROJ_UID, MSP_TIMESHEET_LINES.TS_LINE_CACHED_PROJ_NAME 
    FROM MSP_TIMESHEETS 
     INNER JOIN MSP_TIMESHEET_LINES ON MSP_TIMESHEETS.TS_UID = MSP_TIMESHEET_LINES.TS_UID 
     INNER JOIN ProjectServer_Reporting.dbo.MSP_TimesheetPeriod AS RepTSP ON MSP_TIMESHEETS.WPRD_UID = RepTSP.PeriodUID 
    WHERE 
     MSP_TIMESHEET_LINES.PROJ_UID IN 
    (SELECT PubProj.PROJ_UID 
     FROM ProjectServer_Published.dbo.MSP_PROJECTS AS PubProj 
      LEFT OUTER JOIN ProjectServer_Draft.dbo.MSP_PROJECTS AS DrafProj ON PubProj.PROJ_UID = DrafProj.PROJ_UID 
    WHERE DrafProj.PROJ_NAME IS NULL) 
    ORDER BY CREATED_DATE
    

    Then, we deleted the timesheets in list using "manage timesheets" and the problem is solved.

    Samantha

    Tuesday, December 28, 2010 8:34 AM