I spend lot of time searching on the internet to find a solution for this issue but could not find anywhere finally I had to contact Microsoft and thanks to Roop Kumar who help me to find this solution.

I had this issue on our project server 2010 when user try to delete some project it is deleted from but still shows up in list of projects. On the job queue page it also shows me that job was 7% or sometimes 20% complete with error below. After looking more I find out that project still reside in the published data base, it was deleted only from the draft data base.

rejectedTimesheetLines (System.Guid) :
Item value = ’55df1eea-5d6c-0ff0-0a26-979bed281388′ :
Error: id=’10000′ name=’GeneralItemDoesNotExist’ uid=’452d0181-26c5-42c1-9588-b3bd2b9ca4b7′
Error: id=’10000′ name=’GeneralItemDoesNotExist’ uid=’6fc2cb49-4072-4e55-8c6d-87faeb07c56e’
Error: id=’10000′ name=’GeneralItemDoesNotExist’ uid=’9d9ccd87-09c6-461b-b784-52330bba6e13′
Error: id=’10000′ name=’GeneralItemDoesNotExist’ uid=’60b5c3d9-8c0b-421b-a7c4-f1dcd6f94ea5′
Error: id=’10000′ name=’GeneralItemDoesNotExist’ uid=’043160c3-cc42-4bdf-9bf6-25ce1a0b6b31′
Error: id=’10000′ name=’GeneralItemDoesNotExist’ uid=’956964e8-ae10-4353-a0a6-6c7ae4e501bf’
Item value = ‘8c9b1235-b444-0eb5-2306-9c0cb357bc34′ :
Error: id=’10000′ name=’GeneralItemDoesNotExist’ uid=’4cb03352-517b-4b3d-be23-5d312a3e628b’
Error: id=’10000′ name=’GeneralItemDoesNotExist’ uid=’8c2dec26-e1f0-4f54-b4fa-7e99c3c24af3′
Error: id=’10000′ name=’GeneralItemDoesNotExist’ uid=’08555499-4e94-4d45-913d-cbdc5924bda7′
Error: id=’10000′ name=’GeneralItemDoesNotExist’ uid=’2770e31b-6c44-4607-aeb5-9689adf85534′
Error: id=’10000′ name=’GeneralItemDoesNotExist’ uid=’bedd69f6-8a84-4e6b-b990-6e2cc83f8da1′
Error: id=’10000′ name=’GeneralItemDoesNotExist’ uid=’b5401565-5a62-4e5b-a571-da25919335cb’

General Error:
ProjectDeleteFailure (23006). Details: id=’23006′ name=’ProjectDeleteFailure’ uid=’1fb2ee32-538b-47d3-854b-d56f30b6e5b0′ projectuid=’93c03f72-1736-4961-ad3f-5062067f82b0′ messagetype=’Microsoft.Office.Project.Server.BusinessLayer.QueueMsg.AdjustTimeSheetForDeletedProjectMessage’ messageID=’6′ stage=” blocking=’Undefined’.
Queue:
GeneralQueueJobFailed (26000) – ProjectDelete.AdjustTimeSheetForDeletedProjectMessage. Details: id=’26000′ name=’GeneralQueueJobFailed’ uid=’9c824957-4e4b-4fd5-be58-af24b4e2d467′ JobUID=’cb13ed49-b781-45b9-b65a-15336803b5e8′ ComputerName=’SGPROJECT’ GroupType=’ProjectDelete’ MessageType=’AdjustTimeSheetForDeletedProjectMessage’ MessageId=’6′ Stage=”. For more details, check the ULS logs on machine SGPROJECT for entries with JobUID cb13ed49-b781-45b9-b65a-15336803b5e8.

This is due to the bad time sheet lines. It can also be some task that was not completed or rejected or corrupted.

Solution:

First you need to find out the Proj_UID  for the project that is causing this issue by running this query against your Published data base (ProjectServer_Published)

select * from MSP_PROJECTS where PROJ_NAME like’Name of your Project’

Copy Proj_UID from the column here

Run this query to delete the time sheet lines that are causing issue you need to paste proj_uid in the red text .

delete MSP_TIMESHEET_ACTUALs where ts_line_UID IN (SELECT DISTINCT A.TS_LINE_UID FROM MSP_TIMESHEET_ACTIONS A

INNER JOIN MSP_TIMESHEET_LINES L ON A.TS_LINE_UID = L.TS_LINE_UID WHERE A.TS_ACTION_ENUM = 1 AND L.PROJ_UID = ‘paste Guid here copied in the step above’)

delete MSP_TIMESHEET_LINES where ts_line_UID IN (SELECT DISTINCT A.TS_LINE_UID FROM MSP_TIMESHEET_ACTIONS A

INNER JOIN MSP_TIMESHEET_LINES L ON A.TS_LINE_UID = L.TS_LINE_UID WHERE A.TS_ACTION_ENUM = 1 AND L.PROJ_UID = ‘paste Guid here copied in the step above’

Try to delete the project now.