locked
Error to see detailed projects in Project Server 2010 RRS feed

  • Question

  • Hello everyone:

    I have an error about delete projects.

    In Project Center I want to see an specific project but i get the next error: Error, An Unexpected Error has ocurred.

    I tried to delete this project from Delete Enterprise Objects -> Delete Projects from Draft and Published Databases but this project doesn´t show in this list

    I tried to delete this project from Delete projects from Published Database and i get this error Failed but no blocking correlation

    In logs from Manage Queue i get the next message

     

    • rejectedTimesheetLines (System.Guid) :
      • Item value = 'a7ca415b-f0f3-4f58-ba2c-0ef70d1ec25e' :
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='2d9f5220-d3d4-47ca-a6cd-6492c8941f13'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='3973b606-03e6-463e-9e6b-7efa26b4755a'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='e6f093e4-20a7-4935-8477-01deb748871f'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='9aa33b5d-0048-4761-a6bd-8ebbdacf9a66'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='76542039-b51b-45cb-b5aa-6305fef2f93a'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='6b5dd717-99d5-4840-adf0-4c0ea56f84fe'
      • Item value = '4616a405-5eec-496d-962b-2cd41c30e2df' :
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='9ebbfb6d-245c-437b-b731-3a326919f8eb'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='676ee18f-8cc0-4ccb-bb0c-b2615efd4b18'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='c06bd386-6b6f-4f7b-bb5f-0abdf8e45279'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='1fcdbede-02d7-4972-a51c-6ad24afe3278'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='c39292a3-d5ac-43fa-8d00-3ae8e31bbc5f'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='857abc22-0f07-45b2-bfd5-3b05fb4bee73'
      • Item value = 'e20b69ff-0540-4278-a22f-7b3dd48e6c9b' :
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='9c4af1c9-6ddf-497a-a8f3-1389ee915e5a'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='b2bc612e-fd91-4372-af62-a41cca32dcd5'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='e26defce-683f-46a2-a209-c284bf5d71e8'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='9082fcd9-04a0-4e45-890a-232c1548beec'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='0a006640-cbc8-461b-812b-0bea574146ae'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='491e492d-aa43-4130-a049-79f71b4b1245'
      • Item value = '05ce8d6c-b840-41eb-bdeb-99bd955b7c2c' :
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='a160c87a-3813-4e00-99c4-85f87a51e0d7'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='edf00493-0146-4428-880c-e5c6e80c7c67'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='b75659af-4bab-4273-a6fe-b0758651c00a'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='dccdba1e-a374-455d-a987-eaa3fe3520e7'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='cb66b2cb-b872-4d84-b90e-17edcd1c1ee5'
        • Error: id='10000' name='GeneralItemDoesNotExist' uid='566b4c45-9c92-40bb-89a9-4f93a46f0959'


    General

    • Error:
      • ProjectDeleteFailure (23006). Details: id='23006' name='ProjectDeleteFailure' uid='ea9e6deb-1772-4b8a-98c2-4861b6059489' projectuid='002af47a-f85e-455c-a315-3d9d28980195' messagetype='Microsoft.Office.Project.Server.BusinessLayer.QueueMsg.AdjustTimeSheetForDeletedProjectMessage' messageID='6' stage='' blocking='Undefined'.
    • Queue:
      • GeneralQueueJobFailed (26000) - ProjectDelete.AdjustTimeSheetForDeletedProjectMessage. Details: id='26000' name='GeneralQueueJobFailed' uid='4d1fbf39-370e-493e-82f5-4ad8d264d7b4' JobUID='3a0f35cf-0c60-481d-bfd2-3802f3807e17' ComputerName='SRV09PRJ01' GroupType='ProjectDelete' MessageType='AdjustTimeSheetForDeletedProjectMessage' MessageId='6' Stage=''. For more details, check the ULS logs on machine SRV09PRJ01 for entries with JobUID 3a0f35cf-0c60-481d-bfd2-3802f3807e17.

     

    Have anyone help me , please

     

    Greetings

    Gina


    Gina Ocaña
    Tuesday, December 7, 2010 5:16 PM

Answers

  • I've seen a similar message while trying to delete a project while a timesheet was in a rejected state.

    After the timesheet was opened it resynched and allowed the project delete. See if you can identify the timesheet, and go fix it. Then try to delete again.

     


    Jack Dahlgren blogs at:
    Project and Retrovention
    and rarely Twitter
    Tuesday, December 7, 2010 6:35 PM

All replies

  • Seems to be a case of orphan record, anybody wanna chime in please suggest / reccomend
    if you could share the ULS Log it would help in identifying the exact problem 

    OR

    if you just want to delete it, you might try the below mentioned script,
    but have a backup of all the DB's before trying

    Execute the below mentioned SP in RDB supplying the ProjectUID of error causing project 

    EXEC MSP_Epm_DeleteResourcePlan <ProjectUID >
    EXEC MSP_Epm_DeleteProject <ProjectUID>

    If you are not able to find the UID, run the query given below

    ---- Identifies Orphan Records---------
    SELECT PROJECTNAME, PROJECTUID FROM MSP_EPMPROJECT
    WHERE  PROJECTUID NOT IN
    (SELECT PROJ_UID
    FROM <ProjectServer_Published>.DBO.MSP_PROJECTS)

    Hope this helps


    Thanks | Sunil Kr Singh | http://epmxperts.wordpress.com
    Tuesday, December 7, 2010 5:47 PM
  • I've seen a similar message while trying to delete a project while a timesheet was in a rejected state.

    After the timesheet was opened it resynched and allowed the project delete. See if you can identify the timesheet, and go fix it. Then try to delete again.

     


    Jack Dahlgren blogs at:
    Project and Retrovention
    and rarely Twitter
    Tuesday, December 7, 2010 6:35 PM
  • Hello

    Thanks Jack and Sunil

    I delete timesheet rejecteds and i can delete the project from Published Database.

    Is there any way to query to database for identify timesheet rejecteds asociated with projects?


    Gina Ocaña
    Tuesday, December 7, 2010 8:58 PM
  • But how to delete only rejected timesheets? I can only delete timesheets between entered start and end date. 
    Friday, June 3, 2011 7:24 AM