Skip to content

Project Server 2010 Time sheet lines issue

March 11, 2011

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. Happy Ending….

Advertisements
Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: