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.