Timesheet Review Error- Failed And Blocking Correlation__

Question

Dear All,

Most of Timesheet manager from my organization are getting "Timesheet Review-Failed And Blocking Correlation"

for the same queue error I have pasted below in bold.

So kindly help me out to get the cause and resolution for the error.

----------------------------------------------------------------------------------------------------------------

Error summary/areas:
There has been an error processing a timesheet for which you are/were responsible. Check your approvals list to locate the offending timesheet if one exists. The error condidtion may be related to the fact that Timesheets are a state driven feature; therefore, the allowable values for processing are dependent upon the existing value which for this transaction was 3. Refer to the documentation to determine which status transitions are allowable and submit the transaction.
TimesheetIncorrectMode
Queue
GeneralQueueJobFailed
Error details:

<?xml version="1.0" encoding="utf-16"?>
<errinfo>
  <general>
    <class name="There has been an error processing a timesheet for which you are/were responsible.  Check your approvals list to locate the offending timesheet if one exists. The error condidtion may be related to the fact that Timesheets are a state driven feature; therefore, the allowable values for processing are dependent upon the existing value which for this transaction was 3.  Refer to the documentation to determine which status transitions are allowable and submit the transaction.">
      <error id="3204" name="TimesheetIncorrectMode" uid="d1d270b0-703c-4e06-a531-f984bb4faab0" mode="3" />
    </class>
    <class name="Queue">
      <error id="26000" name="GeneralQueueJobFailed" uid="2c5f37dc-4dfb-4a7d-ab4c-65ee92cb6bd5" JobUID="9a3f277b-7188-4bd6-b2d6-2dfd907eaf7f" ComputerName="VALVCSAPP010VM" GroupType="TimesheetReview" MessageType="ReviewTimesheetMessage" MessageId="1" Stage="" />
    </class>
  </general>
</errinfo>

---

Sachin Vashishth MCTS

Answer 1

Hi,

can a resource recall his timesheet (one of the failed ones)? What happens when resubmitting? Is timesheet manager apply to approve this one?

I can remember that I read something like that can happen if a timesheet manager wants to approve too may timesheets at once. Could that be the case?
Are you allowed too restart one of the jobs in Manage Queue by selecting and hitting "Retry Jobs"?

Regards
Barbara

Answer 2

Thanks Barbara,

By this time I can update you only for one query that you have asked to me.

I have retry the job but again it is going to same state as mentioned in the thread.

For rest of your queries let me collect those information from my users then I'll update you for the same.

---------------------------------ULS Log Details------------------------------------

11/17/2010 07:58:05.73     w3wp.exe (0x0598)                           0x156C    Project Server                    Project Server Queue              8thf    Medium      PWA:http://projectserver/PWA, SSP:SharedServices1, User:VAL\Bdberchu, PSI: TimeSheet.QueueReviewTimesheet  [QUEUE] [SENDER] TimesheetQ: Send( Microsoft.Office.Project.Server.BusinessLayer.QueueMsg.RdsReviewTimesheetSpawnerMessage ): ID: 2 GroupUID: 7cddf9fa-b25d-4328-a7cb-03efd57d04d9    8924234e-bbb4-4610-8c93-b0db9c753a84

11/17/2010 07:58:06.29     Microsoft.Office.Project.Server (0x0A14)    0x1190    Project Server                    Project Server Timesheet          4z9u    Critical         8924234e-bbb4-4610-8c93-b0db9c753a84

11/17/2010 07:58:06.31     Microsoft.Office.Project.Server (0x0A14)    0x0F4C    Project Server                    Project Server Queue              954l    Medium      PWA:http://valvcsapp010vm/PWA, SSP:SharedServices1, User:VAL\PSAdmin, PSI:   [QUEUE]  Message not processed: Group: 7cddf9fa-b25d-4328-a7cb-03efd57d04d9MsgId: 1 Type: ReviewTimesheetMessage    2cb14504-f4ee-4c97-86dc-f35f9ade5bd0

11/17/2010 07:58:06.31     Microsoft.Office.Project.Server (0x0A14)    0x0BCC    Project Server                    Project Server Queue              7h53    Medium      PWA:http://valvcsapp010vm/PWA, SSP:SharedServices1, User:VAL\PSAdmin, PSI:   [QUEUE] TimesheetQ: Group is sleepting: c5d871b2-1cb5-4629-afe7-e3ddd0640f34 type = TimesheetReview    239b5333-cf84-4534-bddd-0b64f36d679e

11/17/2010 07:58:06.31     Microsoft.Office.Project.Server (0x0A14)    0x0C28    Project Server                    Project Server Timesheet          4z9u    Critical         8924234e-bbb4-4610-8c93-b0db9c753a84

11/17/2010 07:58:06.71     Microsoft.Office.Project.Server (0x0A14)    0x0CD8    Project Server                    Project Server Queue              954l    Medium      PWA:http://valvcsapp010vm/PWA, SSP:SharedServices1, User:VAL\PSAdmin, PSI:   [QUEUE]  Message not processed: Group: 3d0e5915-7ef7-402d-b701-2790750a7aafMsgId: 1 Type: ReviewTimesheetMessage    a4d4499d-854a-49fd-811b-b0898765296e

11/17/2010 07:58:06.74     Microsoft.Office.Project.Server (0x0A14)    0x0BCC    Project Server                    Project Server Queue              7h51    Medium      PWA:http://valvcsapp010vm/PWA, SSP:SharedServices1, User:VAL\PSAdmin, PSI:   [QUEUE] TimesheetQ No available group    239b5333-cf84-4534-bddd-0b64f36d679e

11/17/2010 07:58:06.74     Microsoft.Office.Project.Server (0x0A14)    0x0BCC    Project Server                    Project Server Queue              7h60    Critical    Standard Information:PSI Entry Point:   Project User: VAL\Bdberchu  Correlation Id: 8924234e-bbb4-4610-8c93-b0db9c753a84  PWA Site URL: http://projectserver/PWA  SSP Name: SharedServices1  PSError: GeneralQueueJobFailed (26000) A queue job has failed. This is a general error logged by the Project Server Queue everytime a job fails - for effective troubleshooting use this error message with other more specific error messages (if any), the Operations guide (which documents more details about queued jobs) and the trace log (which could provide more detailed context). More information about the failed job follows. GUID of the failed job: 436a8b3f-1e8e-42e3-9cbd-89b9670df5c9. Name of the computer that processed this job: VALVCSAPP010VM (to debug further, you need to look at the trace log from t...    239b5333-cf84-4534-bddd-0b64f36d679e

11/17/2010 07:58:06.74*    Microsoft.Office.Project.Server (0x0A14)    0x0BCC    Project Server                    Project Server Queue              7h60    Critical    ...his computer). Failed job type: TimesheetReview. Failed sub-job type: ReviewTimesheetMessage. Failed sub-job ID: 1. Stage where sub-job failed:  (this is useful when one sub-job has more than one logical processing stages).    239b5333-cf84-4534-bddd-0b64f36d679e

11/17/2010 07:58:06.74     Microsoft.Office.Project.Server (0x0A14)    0x0944    Project Server                    Project Server Timesheet          4z9u    Critical         8924234e-bbb4-4610-8c93-b0db9c753a84
11/17/2010 07:58:06.74     Microsoft.Office.Project.Server (0x0A14)    0x0BCC    Project Server                    Project Server Queue              7h5x    Medium      PWA:http://valvcsapp010vm/PWA, SSP:SharedServices1, User:VAL\PSAdmin, PSI:   [QUEUE] TimesheetQ: Group  3d0e5915-7ef7-402d-b701-2790750a7aaf type = TimesheetReview aborted at Message 1    239b5333-cf84-4534-bddd-0b64f36d679e

11/17/2010 07:58:06.74     Microsoft.Office.Project.Server (0x0A14)    0x0BCC    Project Server                    Project Server Queue              7h5z    Medium      PWA:http://valvcsapp010vm/PWA, SSP:SharedServices1, User:VAL\PSAdmin, PSI:   [QUEUE] TimesheetQ: Group  3d0e5915-7ef7-402d-b701-2790750a7aaf correlation 60281c9e-2195-40c3-bf8c-5696244dc0f4 type = TimesheetReview failed at Message 1 and is blocking the correlation Errors: TimesheetIncorrectMode, GeneralQueueJobFailed    239b5333-cf84-4534-bddd-0b64f36d679e

 

---

Sachin Vashishth MCTS

Answer 3

Hi,

the chance that this one would work was very small - but nevertheless worth trying...
Let's see if recall and submitting once more will help.

Regards
Barbara

Answer 4

Thanks Barbara,

Your suggestion to "recall" timesheet and then "approve" again  has worked for me for almost all the cases.

Only one more thing is still under doubt that waht was the actual reason for this "Timesheet Review Error".

1) Recalling a submitted "Timesheet"  by a resource before "Approving" by his Timesheet Manager.

2) Too many timesheets pending for approval from Timesheet Manager.

3) Are there any corrupted timesheets which are causing these errors.

4) Any other reasons that you aware of(Like Recent Patch Update or Known Issue of any CU).

---

Sachin Vashishth MCTS

Answer 5

Hi Sachin,

We have the same issue.

 I am not sure, but think that 1 and 4 reason does not approach in my case. Because i cannot reproduce this error by simply sending timesheet from one of our test user and then recalling him before he was approved. And currently we do not have any CU installed on our environment, only out of box Project Server 2010.

  Statistically I see this errors on my queue in the days when we have mass activity of submitting and approving timesheets. But not for all users. So i guess that 2 and 3 reasons would be more probably but also more difficultly for diagnostics.

---

Alexey

Answer 6

Hi Alexey,

CU Feb 2011 does resolve some issues regarding timesheets, especially when lots of users are creating their timesheets at the same time: http://support.microsoft.com/kb/2479792

So worth thinking about patching?
Barbara

Answer 7

Hi Barbara,

Thank you for this recommendation,

This may be helps for me, but i not sure until the end:
  1. That this update will solve exactly my question. I read the description and did not find nothing regarding the resolving this error (Timesheet Review errors)
  2. I have no information about how stable this update and whether it will not cause additional errors.

Additionaly my temporary test environment  does not work now.  

---

Alexey

Answer 8

Hi Alexey,

Above resolution given by Barbara has worked for me for most of the case, but still I am getting same error for few time sheets dont know why ? As till date, I dont have any concrete reason for this error.

One most important thing which I forget to mention in entire post that I have a setup of PS 2007 SP2 CU Dec09.

And you have PS 2010 in place, So in that case, it would be worth going with above Barbara's suggestion to have latest patches update on your servers.

---

Sachin Vashishth MCTS

Answer 9

Hi Alexey,

in KB articles, not all details are described. However, timesheets had been touched, with some focus on the situation when a lot of timesheets are created at the same time. So there is at least a good chance, that your issue was resolved by a "side-effect".

So far I have also no experience with this CU, not sure when I will be able to test. Sorry!

Barbara

 

Answer 10

Sachin, Barbara,

Thanks to you i got a action plan. I will trying find information about somebody else who install and test Feb 2011 CU for PS 2010 and then after my test environment would be work again - test them.

---

Alexey

Answer 11

Good day Barbara

We are also using PS 2007 in the process of migrating to 2010.  Just want to know if the tests you did with the Feb 2011 CU for PS 2010 helped.

In our case when the timesheets failed when the Timesheet Approver approves them they received a mail but the status in their approval list shows a error.  I just requested them to recall the timesheet and approve it again as the resources are not always in the office to recall and resend to the T/A.

When Timesheet Approver approve and it failes in the error it says "Timesheets are a state dri ven feature ....".  The people said it could be that while the Timesheet Approver approves the timesheet the resource recall it.  One of our T/A had a error yesterday, i had a look in the queue and the resource did not recall or do anything to his timesheet at that time, so i cannot see that, that can be the issues\.

Adri