Project Server 2007 Bug : Update Timesheet Actual Work with TASK_U

M

Mehmet Kurt

Hi,

When we want to update timesheet actual work as a programmatically, then
Project Server Web Access Timesheet Detail Page shows an error :
"While communicating with the Project Server an error occured. Check
connectivity with your administrator to determine if further action is
necessary" and Job state is ERROR and also failing and blocking correlation.

My Source Code is
--------------------------------------------------------------------------------
actualsRow = timesheetDs.Actuals.NewActualsRow();
actualsRow.TS_ACT_FINISH_DATE = DateTime.Parse(row["EndDate"].ToString());
actualsRow.TS_ACT_PLAN_VALUE = 10000;
actualsRow.TS_ACT_START_DATE = DateTime.Parse(row["StartDate"].ToString());
actualsRow.TS_ACT_VALUE = Convert.ToDecimal(row["ActualWork"].ToString());
actualsRow.TS_ACT_COMMENT = "Incident";
actualsRow.TS_LINE_UID = timesheetDs.Lines.TS_LINE_UID;
timesheetDs.Actuals.AddActualsRow(actualsRow);

jobUid = Guid.NewGuid();
timeSheetSvc.QueueUpdateTimesheet(jobUid, timeSheetUid, timesheetDs);
Utilities.WaitForQueue(q, jobUid)
--------------------------------------------------------------------------------
Source Code thrown an exception QueueUpdateTimesheet method. [<error
id="26000" name="GeneralQueueJobFailed" GroupType="TimesheetUpdate"]

After an exception, We manual set the actual any value on the timesheet task
line with any value, system set value and fix the timesheet error.

I guess, Project Server has a bug. We need your help ? Thanks
 
M

Mehmet Kurt

Application Logs is here
--------------------------------------
10/06/2009 00:53:51.57 Microsoft.Office.Project.Server
(0x10D0) 0x07D4 Project Server Project Server Queue
954l Medium PWA:http://project.sampas.com.tr, SSP:SharedServices1,
User:SAMPAS\shrpnt2007, PSI: [QUEUE] Message not processed: Group:
07ea19cf-9e8e-4764-a9ec-f84f1ff64de5MsgId: 1 Type:
UpdateTimesheetMessage 63db7c40-16d6-4e1b-90f7-256971661ac3
10/06/2009 00:53:51.57 Microsoft.Office.Project.Server
(0x10D0) 0x12AC Project Server Project Server Queue
7h60 Critical Standard Information:pSI Entry Point: Project User:
SAMPAS\MKURT Correlation Id: 44d1e4b6-9870-4dbf-94c3-55606404d6f4 PWA Site
URL: http://project.sampas.com.tr 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:
eabcb868-cf95-45bc-8518-6afd0a16dc0e. Name of the computer that processed
this job: PORTAL2007 (to debug further, you need to look at the trace log
from t... 96990cbe-1898-4b2d-8519-345d52ba9189
10/06/2009 00:53:51.57* Microsoft.Office.Project.Server
(0x10D0) 0x12AC Project Server Project Server Queue
7h60 Critical ...his computer). Failed job type: TimesheetUpdate. Failed
sub-job type: UpdateTimesheetMessage. Failed sub-job ID: 1. Stage where
sub-job failed: (this is useful when one sub-job has more than one logical
processing stages). 96990cbe-1898-4b2d-8519-345d52ba9189
10/06/2009 00:53:51.59 Microsoft.Office.Project.Server
(0x10D0) 0x12AC Project Server Project Server Queue
7h5x Medium PWA:http://project.sampas.com.tr, SSP:SharedServices1,
User:SAMPAS\shrpnt2007, PSI: [QUEUE] TimesheetQ: Group
07ea19cf-9e8e-4764-a9ec-f84f1ff64de5 type = TimesheetUpdate aborted at
Message 1 96990cbe-1898-4b2d-8519-345d52ba9189
10/06/2009 00:53:51.59 Microsoft.Office.Project.Server
(0x10D0) 0x12AC Project Server Project Server Queue
7h5z Medium PWA:http://project.sampas.com.tr, SSP:SharedServices1,
User:SAMPAS\shrpnt2007, PSI: [QUEUE] TimesheetQ: Group
07ea19cf-9e8e-4764-a9ec-f84f1ff64de5 correlation
08c1ac50-9070-4ab7-8360-3fc8d26ce6bc type = TimesheetUpdate failed at Message
1 and is blocking the correlation Errors:
GeneralQueueJobFailed 96990cbe-1898-4b2d-8519-345d52ba9189
10/06/2009 00:53:55.57 w3wp.exe (0x0F44)
0x13A0 Project Server Project Server Queue
8tfj Medium PWA:http://project.sampas.com.tr, SSP:SharedServices1,
User:SAMPAS\MKURT, PSI: QueueSystem.GetJobCompletionState [QUEUE] [PSI]
GetJobCompletionState(eabcb868-cf95-45bc-8518-6afd0a16dc0e, out
errorString) f288757f-ee96-4cc6-95c9-647c71f9bdf4
10/06/2009 00:54:05.56 OWSTIMER.EXE (0x07DC)
0x15A4 SharePoint Portal Server SSO
8inc Medium In SSOService::Synch(), sso database conn string:
----------------------------------------------------
Thank You

Stephen Sanderlin said:
Can you post the error information from the ULS and Application logs?

--
Stephen Sanderlin, Project MVP
VP of Technology
MSProjectExperts

For Project Server Consulting: http://www.msprojectexperts.com
For Project Server Training: http://www.projectservertraining.com

Read our blog at: http://www.projectserverhelp.com



Hi,

When we want to update timesheet actual work as a programmatically, then
Project Server Web Access Timesheet Detail Page shows an error :
"While communicating with the Project Server an error occured. Check
connectivity with your administrator to determine if further action is
necessary" and Job state is ERROR and also failing and blocking correlation.

My Source Code is ;
--------------------------------------------------------------------------------
actualsRow = timesheetDs.Actuals.NewActualsRow();
actualsRow.TS_ACT_FINISH_DATE = DateTime.Parse(row["EndDate"].ToString());
actualsRow.TS_ACT_PLAN_VALUE = 10000;
actualsRow.TS_ACT_START_DATE = DateTime.Parse(row["StartDate"].ToString());
actualsRow.TS_ACT_VALUE = Convert.ToDecimal(row["ActualWork"].ToString());
actualsRow.TS_ACT_COMMENT = "Incident";
actualsRow.TS_LINE_UID = timesheetDs.Lines.TS_LINE_UID;
timesheetDs.Actuals.AddActualsRow(actualsRow);

jobUid = Guid.NewGuid();
timeSheetSvc.QueueUpdateTimesheet(jobUid, timeSheetUid, timesheetDs);
Utilities.WaitForQueue(q, jobUid);
--------------------------------------------------------------------------------
Source Code thrown an exception QueueUpdateTimesheet method. [<error
id="26000" name="GeneralQueueJobFailed" GroupType="TimesheetUpdate"]

After an exception, We manual set the actual any value on the timesheet task
line with any value, system set value and fix the timesheet error.

I guess, Project Server has a bug. We need your help ? Thanks
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Column 'TS_LINE_UID, TS_ACT_START_DATE' is constrained to be uniqu 1
Can not use PSI for timesheet 0
Timesheet actual work not syncing with Project 2007 8
Project Server 2007 Timesheet & actual work not updated 2
Project Server 2007: Actual Work Protected field gone? 4

Top