Solution for projectserver to report error generalreadonlycolumn (20005)-column ts_act_finish_date when calling PSI

Timesheetdataset

Table actuals

Row: ts_line_uid = 'f4b970f8-fb03-44d1-9997-cd31da42cb09 'ts_act_start_date = '2017/07/29 00:00:00'

Error generalreadonlycolumn (20005)-column ts_act_finish_date

 

General

Queue:

Generalqueuejobfailed (26000)-timesheetupdate. updatetimesheetmessage. details: id = '000000' name = 'hangzhou' uid = '47fe2fdc-hangzhou' jobuid = 'b97052fe-hangzhou' computername = 'win-fk1jwhebtd3 'grouptype = 'timesheetupdat' messagetype = 'messageid = '1' stage = ''. for more information, see the entries with the jobuid WIN-FK1G0HEBTD3 In the ULS log on the machine b97052fe-4ddb-4ebd-a0ef-c49cbd833a31.

 

The reason is as follows:

If (actualsrow = NULL)

{

// Writelog. recordlog ("in? Input? Between? Table? What are the three sides of the page? 4 ");

Timesheetdataset. actualsrow newrow = timesheetdataset. actuals. newactualsrow ();

If (newrow! = NULL)

{

Newrow. ts_line_uid = tslineid;

Newrow. ts_act_start_date = startdate;

Newrow. ts_act_finish_date = startdate. adddays (1). addmilliseconds (-1 );

Newrow. ts_act_value = convert. todecimal (workday. actualwork * 60000 );

// Newrow. ts_act_comment = item. comment;

Timesheetdataset. actuals. addactualsrow (newrow );

 

// Timesheetdataset. actualsrow actualsrow1 = timesheetdataset. actuals. findbyts_line_uidts_act_start_date (tslineid, startdate );

// Actualsrow1.ts _ act_value = convert. todecimal (workday. actualwork * 60000 );

 

}

 

}

This is because newrow. ts_act_finish_date = startdate. adddays (1). addmilliseconds (-1 );

In principle, if the employees do not have special settings, the planned completion time of the management plan task is 18Point, and you change to 23: 59: 59This will involve modifying the actual completion time, and the actual completion time of management tasks cannot be modified, resulting in blocking of the queue and an error.

 

After finding the cause, we can solve the problem:

Newrow. ts_act_start_date = startdate. addhours (8 );

Newrow. ts_act_finish_date = startdate. addhours (17 );

It is best to take the scheduled start time and scheduled completion time of management tasks.

 

References:

Http://www.msprojectnow.com/Blog/tabid/142/entryid/254/Default.aspx

Http://social.technet.microsoft.com/Forums/projectserver/en-US/ac9c2f0a-633d-48bd-ba33-12e0ee515fa5/pwa-2010-timesheet-update-or-submit-error? Forum = projectserver2010general

Http://social.technet.microsoft.com/Forums/projectserver/en-US/d81c0661-88fe-4a74-a1f4-359e4243e5d9/pwa-2010-timesheet-error? Forum = projectserver2010general

Http://social.microsoft.com/Forums/ru-RU/f77ebc8b-6567-4ce2-ac6f-5848a584ca31/ps-2010-timesheet-error-on-save-error-generalreadonlycolumn-20005-column-tsactfinishdate? Forum = projserv2010setup