locked
Completed projects are displaying in the resource availability view RRS feed

  • Question

  • Hi,

    I have an issue concerning completed projects in Project Server 2010. First, I follow the standard procedure for completing project described here http://office.microsoft.com/en-us/project-server-help/archive-a-completed-project-HA102420489.aspx

    It works OK except for one thing; the projects are still displayed in the resource availability views!

    The thing is, that I can not archive projects or deactivate tasks, which contains actual work, and the only way then is to set resources proposed, which is fine as a work around, but if I want to use the proposed option on projects, which are not completed, I can't tell which projects are completed, and which are not.

    Can anyone tell me best practice regarding completing projects and not having them displayed in the resource views?

    In the article link above, they describe a way to archive a project by removing it from the published database - this is not possible if the project contains actual work... Is there a way to do this?

    Tuesday, March 22, 2011 7:34 AM

Answers

  • In your specifc case, I am not sure the first query is relevant, however the second one is.

    The rows returned will highlight the specific timesheets that have the error causing your delete to fail, specifically it will show you which timesheet for a specific user and period has the rejected tasks.

    In order to archive the project, you will need to delete those identified timesheets, considering of course whether you need that information for reporting purposes, or make note of the final timesheet contents, delete the timesheet and recreate / renter the data, this time not rejecting any lines. This should keep your timesheet data intact and allow you to archive the project.

    Hope this helps,


    Alex Burton
    www.epmsource.com | Twitter
    Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page
    Wednesday, March 23, 2011 10:04 AM

All replies

  • Hi,

    Can I ask why you cannot archive projects with actuals? As far as I am aware, PS will allow you to archive schedules that have actuals within.

    If you wish to remove the projects from the resource availability views, and the project is completed, then I would personally follow the alternate method outlined in that link about backing up the projects via an administrative backup and then removing the schedules from the Draft, Published and Reporting databases. This would stop your resource availability issues. Should you need to report on the information in those schedules later, simply perform an administrative restore of the project.

    Hope this helps,


    Alex Burton
    www.epmsource.com | Twitter
    Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page
    Tuesday, March 22, 2011 7:59 AM
  • If I try to remove a project from the draft, published and reporting databases, which contains actuals, I get the message that the job "Failed But Not Blocking Correlation", because it contains actuals. After doing this, the project is still listed in the project center view, but not accesible, and it is still listed in the resource availability view...  

    I've already set up the administrative back-up and it works fine for projects, which doesn't contain actuals.

    There must be a way to do this - otherwise I would say that the software lacks an essential feature.

    Tuesday, March 22, 2011 8:52 AM
  • Can you click on the 'Failed But Not Blocking Correlation' and post the contents here please?
    Alex Burton
    www.epmsource.com | Twitter
    Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page
    Tuesday, March 22, 2011 8:55 AM
  • This is what I get.
    I have once tried to make all my resources on a deleted project recall and open up their timesheets to update and send them again - then I am able to delete the project - but then I loose history on my completed projects.
    Collections:
    • rejectedTimesheetLines (System.Guid) :
      • Item value = '0a2b2e9e-9a9e-4a02-80ce-1f7d50b73fbd' :
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='5efd4827-fbaf-44f6-9517-90ee90b6407a'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='8cc4ec1e-2e09-4457-b404-b5aafd24d838'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='7c61ec57-1c65-4f40-a175-1a2296addf5c'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='bcf338be-2558-49bb-8cb6-957584dbd0ef'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='9f550dee-976e-46fc-b0e6-3c702a1c3f5e'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='e6140b81-6533-458f-930b-e39503240e34'
      • Item value = '79679791-8643-0e3e-0a7c-2afcf205953e' :
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='40a5fa24-8800-4145-929b-39fa424396bf'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='68e1e2cf-fa37-4e94-b1f9-21ab5b3b6389'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='bdc96e2a-b772-4394-a83b-b4f8affa5ad3'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='faedb346-0221-4315-b0cb-3d9dc3bc9d3f'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='55b20468-56ed-49e1-85cd-cac7e71ac35b'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='b46c6dfe-7b14-434d-b1e7-ac80976f9cab'
      • Item value = 'bb572734-c49d-064c-3b69-3a15b9281c10' :
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='272ef065-2b83-4a24-b220-d00646362ec7'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='b3caf94f-1ba3-4a1d-9f43-150bca15e32b'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='e46eaccf-5900-41ab-b7db-6d5e1b3590f0'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='373b6540-4384-41fb-bfae-5883721f0754'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='0de6477c-a9d4-400e-a609-cbbc246c06bf'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='40168493-7c75-4f98-bded-97a62b91dadd'
      • Item value = '400a9578-892a-4b30-87cd-3d0821ed0cbd' :
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='a54ff492-52b8-49bc-b637-8bef5c98bb92'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='26e8c612-629c-4356-9cc7-020a8eb8eb82'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='761fff8d-9b82-4278-9b0b-c888b8f821f7'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='05ad8894-8102-4633-8907-269332078f3d'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='e05097a9-2b0a-4529-98bf-5be04eb45a73'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='6e1d0da0-9907-4253-9507-2b832214c1e0'
      • Item value = 'e1bcd357-414d-08c9-07a1-4beb296da5c7' :
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='27ba214e-dc28-4fac-81ce-746e415793d1'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='dfe4e395-4e22-472e-bccd-d68dab6a64e6'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='f2196191-e9c8-4985-8c7e-b521457fe463'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='31fc0443-6d70-413c-902b-798a65cf6d25'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='fbd9b3da-f80b-4340-b39c-cda2316ca4b3'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='4f5114f5-8990-4b33-8429-d4ab025fb0b8'
      • Item value = 'c04b0df0-5c8d-026f-0745-65116e0dcb8a' :
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='3de5612e-079f-46cc-b898-0e399f851418'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='ab8c99a8-c669-4dae-baa7-8fb7f4f8bd32'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='1b61c299-2df5-485e-aa65-bf476e7d5531'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='601b828f-f88b-4f7b-8ec1-5e4b8fcf8d28'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='895d085f-62aa-4695-a809-bf5379e09d2d'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='d6efa89e-d856-4a05-9e0f-38ac72572835'
      • Item value = '47bd5595-cd88-07fe-24ef-734baa18c094' :
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='40d037cb-259c-41bc-aa55-7315326f0bfa'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='ed8ff85b-ef10-458d-a166-7916f231aad7'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='f31b7f2a-89a2-469b-a1d7-e35f77804f84'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='5adc6a71-a44c-4385-8d38-44c8448d733f'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='8cc895c9-4edb-43a1-9bb8-60905ad4bf3e'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='737531bc-fa09-4ab1-a527-5985a2d03cf2'
      • Item value = '2b9a6e17-c23c-0e6b-1fb9-73d9b8b581a6' :
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='1ddfda7e-9b68-4b7c-a201-d2302f45e470'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='8c67245b-d9c8-4385-8ecc-4e4addc302b4'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='b713fccf-b746-48f4-a710-558581de54af'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='c70962de-0b44-4301-95d2-1ec41ab10c3a'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='0ad3de9e-e331-456f-8d18-83e8501f08bf'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='4257d8a2-dda7-4a4b-8a6f-c61362a3a798'
      • Item value = 'a612a259-bb11-4bcc-9feb-74be3de26850' :
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='bc90d54c-103b-487f-9a91-b951a64d7520'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='f1030192-7194-4c9e-b2e1-f7eddd5c21aa'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='f80bfa99-e1ec-4483-9221-e9081f1f5d99'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='30c20309-8296-4368-82af-a5fb1dfe82d1'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='f25ddf86-5b35-4f2a-a728-6f77e11d08de'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='336bee81-ffc3-4642-b146-94b4f94a41c8'
      • Item value = '857230d0-d4f3-07e3-0694-7944bc40a871' :
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='8cf19de7-56a1-4893-9509-0f2a08b5a9ad'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='9c8261bf-c3bf-4ed5-8a39-a726797a0863'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='7231989b-2849-4987-9335-e8eb6dddcf17'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='2646da5b-b5cd-4e48-84c2-628c9abb05fb'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='51cb9a66-ead6-425b-858f-cdde5e5caa8a'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='3661a88e-b67c-407e-a5b8-a909e4c1fcf5'
      • Item value = '5adacc8b-e389-440c-a6dc-857f9f40b0d1' :
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='a83ab705-c91f-4e08-aa0a-06c7d6f7003d'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='1c79a47f-6f79-487a-a328-804255943618'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='85d8378c-b0bb-43bc-a273-917bacf66c34'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='4344d1c4-e421-488e-9716-ed3b8706f05f'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='9b9c486c-21bf-47db-83ef-9caa0395481a'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='cad23815-3fe3-4f4f-b218-f73619b06a9c'
      • Item value = '3afe2121-616f-4098-978f-8b5d7930087f' :
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='147a1384-9eb7-4bdb-b168-1f146ff947ca'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='c8b6c845-5bb8-4b2a-bc75-6cce84364bd0'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='bb9c4553-8e4b-47c8-85b1-b71d3ced219d'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='22e2bf40-2083-48f2-abd4-f34bd9d6e43d'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='46f8023d-d510-4055-9637-bd68255b3c7b'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='5e61e66a-dcd2-4a13-974b-84d2416fb0fe'
      • Item value = '4b1f44d6-d08a-0496-3e5d-9329fe81b96a' :
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='9c8418e4-8c4d-4943-ad16-1759d4405e75'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='6f2656f7-c372-43e0-9911-06e823e7332c'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='7d3f3338-bbd9-48f2-8b7d-dad6fc9513db'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='aaae7e50-c6c4-46a6-9b57-d0a7b9902815'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='53f222ac-2e24-4688-9a71-d2be6f7ada5e'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='35dfd8ee-0026-48a7-8864-099084fa25b7'
      • Item value = 'eb6e667f-e137-08d2-0a8c-97f6488016c1' :
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='a69d0669-628f-414e-b407-3c68967c16ca'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='cfedf03a-8dff-4162-a2ee-a5b0bbcfeacf'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='dcf7b21c-2a29-437a-8502-21adcdc6f5ab'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='03f0e0d9-4b4f-4efd-a600-8e3693da146a'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='83090990-208b-4b8c-92bf-40a9df5eabb5'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='b9bcb7a7-8210-4fc2-869b-ab27b20c9c91'
      • Item value = 'e5f71a11-c645-0d1e-2770-99b4fa7490bd' :
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='ad600196-9c15-4abe-9f89-4d62275301fa'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='aa00b0e0-edcf-4b9c-9e8c-73df4b0314fe'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='635f0615-fc42-4e56-8a00-1a5c572314b0'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='867aa4aa-b34a-42cd-8e52-0c3ac672e063'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='0ef270dc-70ab-4255-98e9-e89ee25a510b'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='8071fb3b-cb35-4dfe-9585-620d281081c5'
      • Item value = '2fd1a751-4534-0bbc-3f68-a1866bacb4dc' :
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='25d4414c-54a1-4d53-94e4-8ed3403d041f'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='38a071ce-8d8c-42e4-8eba-e37336f50a5b'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='9f9f66e8-2a9d-4b9c-93c2-b0a4d8c22f9f'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='fab52cfe-ecf7-41b5-b017-ac4a77fb0ed3'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='2fabbfe7-650a-44e2-8d76-d691dc8a917d'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='7cb89874-48d3-4e0f-889d-f53612ec032a'
      • Item value = '3388163c-ee22-05bb-325c-c759a48ecb41' :
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='cf9ed378-32c8-4337-af2c-6a27d0866593'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='d46f1a6e-a30c-49a7-9c83-8d16bf9ed518'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='4b876dfe-9094-4668-a615-65518bfe2881'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='8d82ed7f-159e-40be-9bb4-9e60c6ccaee9'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='61620ac7-58d3-4164-8e65-2131e3338871'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='703e2548-ab79-421c-a30d-764deb74088c'
      • Item value = 'ef8c3b87-1dac-4cf9-a74a-e30986c52a3e' :
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='1859e9c8-64f5-41fc-b866-07b094bfbe45'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='f67b9eaf-bb05-40c5-b27b-599a8290adc2'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='8a3d72c1-ee13-4af3-b0bb-81ab34e57ac2'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='e7b5a927-1b26-4048-8364-e8525adf31d7'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='d4af72ca-a9d1-4679-8eb6-5523d26c4b7f'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='1ea79e5a-bae3-42d6-8034-887f501ad444'
      • Item value = '66629938-3a00-40bf-8a87-ee7548336acb' :
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='0c9506d2-deca-484d-acc9-445c123a2f78'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='6e909937-b166-4655-ac3f-d87a6172a066'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='b2adaa0e-a79c-4cde-9b6f-69e0c05e1d81'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='b6678346-d723-43f5-a5ee-1250453679ec'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='9f18a433-62fc-4363-936e-546c6758f482'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='2ba77209-56d4-4c38-9c81-d77ac4591021'

    General
    • Error:
      • ProjectDeleteFailure (23006). Details: id='23006' name='ProjectDeleteFailure' uid='3ecb25ad-644d-42dd-bfc1-9301093e67bf' projectuid='fe9125bf-2385-4492-a511-1b942147b4d3' messagetype='Microsoft.Office.Project.Server.BusinessLayer.QueueMsg.AdjustTimeSheetForDeletedProjectMessage' messageID='6' stage='' blocking='Undefined'.
    • Queue:
      • GeneralQueueJobFailed (26000) - ProjectDelete.AdjustTimeSheetForDeletedProjectMessage. Details: id='26000' name='GeneralQueueJobFailed' uid='1c6c5655-27eb-444a-9a19-02d30deaee11' JobUID='7fdcf7cb-6cbe-495a-ad6d-eaf3f205e344' ComputerName='AARSPSNT03' GroupType='ProjectDelete' MessageType='AdjustTimeSheetForDeletedProjectMessage' MessageId='6' Stage=''. For more details, check the ULS logs on machine AARSPSNT03 for entries with JobUID 7fdcf7cb-6cbe-495a-ad6d-eaf3f205e344.

     
     
     
      <input id="ctl00_ctl00_OkButton" class="ms-ButtonHeightWidth" name="ctl00$ctl00$OkButton" type="button" value="Copy to Clipboard" accesskey="o" /> <input id="CancelButton" class="ms-ButtonHeightWidth" onclick="doCancel();" type="button" value="Close" accesskey="c" />  
    Tuesday, March 22, 2011 9:48 AM
  • Hi,

    That error is caused by timesheets existing with rejected tasks, check out http://social.technet.microsoft.com/Forums/en-US/projectserver2010general/thread/0fc90c31-3994-4e86-96c7-870f78d11bcb

    Once addressed, you should be able to delete the project and archive.

    Hope this helps,


    Alex Burton
    www.epmsource.com | Twitter
    Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page
    Tuesday, March 22, 2011 10:42 AM
  • Thanks, but I have checked, and there are no rejected tasks on the project.

    As I understand, a rejected task is a task created by the resource from the timesheet, which is not approved by the owner of the project, but this can't be the case, since none of the projects I have tried to archive refers to rejected timesheet lines.

    I'm really beginning to loose it on this one, and I hope to end up with a solution.

    Tuesday, March 22, 2011 11:44 AM
  • Hi,

    So the queries in the linked post returned no rows when executed?


    Alex Burton
    www.epmsource.com | Twitter
    Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page
    Tuesday, March 22, 2011 6:25 PM
  • Yes they returned rows, but I'm not sure that I understand what they mean.

    I need to understand what defines a rejected timesheet line, so I can identify the problem with my resource's timesheets, since it is a problem for all of my projects, which contains actuals. Can you help with that?

    Wednesday, March 23, 2011 8:35 AM
  • In your specifc case, I am not sure the first query is relevant, however the second one is.

    The rows returned will highlight the specific timesheets that have the error causing your delete to fail, specifically it will show you which timesheet for a specific user and period has the rejected tasks.

    In order to archive the project, you will need to delete those identified timesheets, considering of course whether you need that information for reporting purposes, or make note of the final timesheet contents, delete the timesheet and recreate / renter the data, this time not rejecting any lines. This should keep your timesheet data intact and allow you to archive the project.

    Hope this helps,


    Alex Burton
    www.epmsource.com | Twitter
    Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page
    Wednesday, March 23, 2011 10:04 AM