Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

total actual effort for task or request work item can not be negative - error

Highlighted
eata
Regular Collector

total actual effort for task or request work item can not be negative - error

We are facing with -total actual effort for task or request work item can not be negative- error on

search timesheets > etid time sheet screen.

Could any one help us how to solve this problem.

12 REPLIES
dirkf
Honored Contributor

Re: total actual effort for task or request work item can not be negative - error

Hi Eata,

 

there's several reasons for this issue possibly occuring. Is the timesheet for the same resource that you're having the decompress mismatch for?

Check if you can find a previous or later timesheet in which the same task / request is referenced and check if the sum of time logged is positive.

Should you not be able to locate it this way, please log a new case also.

Which version is this? There are a couple of known issues for 7.5, but I'm not currently aware if this also happens in later versions.

 

Best regards,

Dirk 

Utkarsh_Mishra
Honored Contributor

Re: total actual effort for task or request work item can not be negative - error

Hi,

 

This is a Know Bug# QCCR1L26470 (Error when saving timesheet - "Total actual effort for task or request work item can not be negative") in HP PPM 7.5.

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
eata
Regular Collector

Re: total actual effort for task or request work item can not be negative - error

Hello;

Is the timesheet for the same resource that you're having the decompress mismatch for?

Answer: No. Two completly different case.

 

Vesion 7.5

 

Check if you can find a previous or later timesheet in which the same task / request is referenced and check if the sum of time logged is positive.

OK. I will reply when I contact with user.

 

Should you not be able to locate it this way, please log a new case also.

I cound not understand what you mean.

log a new case = ?. Shall I open a new topic in forum? shall I open an offical ticket for HP support asistant? Our purchasing department is now considering the purchase. In mean time I am following the forum. There is noting else to do for me.

dirkf
Honored Contributor

Re: total actual effort for task or request work item can not be negative - error

Hi all,

 

there IS a know issue that should prevent negative actual effort. However, it is solved in SP 6. For whatever reason, it may still happen though that for some rows, there is either NEGATIVE actual effort and on the other side, actual effort in certain rows may be NULL.

 

Check with the following query if you have negative actual effort:

select * from tm_work_units where act_effort < 0;

 

Check with the following query if you have NULL actual effort:

 

SELECT t.work_item_id, t.RESOURCE_ID,t.LAST_UPDATE_DATE, t.WORK_ITEM_TYPE, t.act_effort, s.tm_actual
FROM tm_work_units t,
(SELECT b.resource_id, c.work_item_id, SUM (e.actual_effort) tm_actual
FROM tm_time_sheets b,
tm_time_sheet_lines c,
tm_actuals d,
tm_actuals_effort e
WHERE 1=1
AND c.effort_on_work_item_entity = 'Y'
--AND c.work_item_type IN ('TASK', 'PROJECT') --c.STATE <> 5
AND b.time_sheet_id = c.time_sheet_id
AND d.time_sheet_line_id = c.time_sheet_line_id
AND d.totals_flag = 'Y'
AND e.actuals_id = d.actuals_id
GROUP BY b.resource_id, c.work_item_id) s
WHERE
1=1
AND t.ACT_EFFORT is null
AND t.resource_id = s.resource_id (+)
AND t.work_item_id = s.work_item_id (+)
AND ( s.tm_actual = 0 or s.tm_actual is null)

 

Attach both resulting files if you have entries.

Best regards,

Dirk

eata
Regular Collector

Re: total actual effort for task or request work item can not be negative - error

Both two queries returned no record.

I am still waiting for guidance.

kintanadan
Regular Collector

Re: total actual effort for task or request work item can not be negative - error

Hello eata,

 

This is a known issue, and HP Support has a Hot Fix for this.

You can go here--> http://support.openview.hp.com/support.jsp and create a account for support.

I have attached the documentation outlining the issue, defect number, and Hot Fix file name.

 

I hope this help.

 

Best Regards

eata
Regular Collector

Re: total actual effort for task or request work item can not be negative - error

Hello Kintanadan;

I can not find the hotfix.

Here are my searches.

 

How can I find the solution?

eata
Regular Collector

Re: total actual effort for task or request work item can not be negative - error

I could not find a  hotfix or a solution.

could any one one guide me?

dirkf
Honored Contributor

Re: total actual effort for task or request work item can not be negative - error

Hi Eata,

 

hotfixes are not deployed to Self Solve Online.

If you need a hotfix for a case, you need to log a support ticket. The negative error-message can have several issues and deployal of a hotfix whithout having first insured that the issue is what it seems to be, no hotfix will be handed out.

You need to log a case to have this analysed. If you still don't have an issue with obtaining a support contract, I suggest you get in touch with your HP Sales Rep to have at least temporary allowance to open cases on a trust basis.

 

Regards,

Dirk

roxor
Member

Re: total actual effort for task or request work item can not be negative - error


dirkf wrote:

Hi all,

 

there IS a know issue that should prevent negative actual effort. However, it is solved in SP 6. For whatever reason, it may still happen though that for some rows, there is either NEGATIVE actual effort and on the other side, actual effort in certain rows may be NULL.

 

Check with the following query if you have negative actual effort:

select * from tm_work_units where act_effort < 0;

 

Check with the following query if you have NULL actual effort:

 

SELECT t.work_item_id, t.RESOURCE_ID,t.LAST_UPDATE_DATE, t.WORK_ITEM_TYPE, t.act_effort, s.tm_actual
FROM tm_work_units t,
(SELECT b.resource_id, c.work_item_id, SUM (e.actual_effort) tm_actual
FROM tm_time_sheets b,
tm_time_sheet_lines c,
tm_actuals d,
tm_actuals_effort e
WHERE 1=1
AND c.effort_on_work_item_entity = 'Y'
--AND c.work_item_type IN ('TASK', 'PROJECT') --c.STATE <> 5
AND b.time_sheet_id = c.time_sheet_id
AND d.time_sheet_line_id = c.time_sheet_line_id
AND d.totals_flag = 'Y'
AND e.actuals_id = d.actuals_id
GROUP BY b.resource_id, c.work_item_id) s
WHERE
1=1
AND t.ACT_EFFORT is null
AND t.resource_id = s.resource_id (+)
AND t.work_item_id = s.work_item_id (+)
AND ( s.tm_actual = 0 or s.tm_actual is null)

 

Attach both resulting files if you have entries.

Best regards,

Dirk


Hello there:)

I have issue right now related probably to this what dirk wrote. I have run both queries and the first is throwing this:

 

 

 

 

My problem is that in server log I have this message from yesterday till now:

 

 

 

I suppose that I have to run PMTMSync script, but I can't figure out on which project id should I use. I only know that I have this error, Then I have run dirk's query and I found that there are really som rubish values. But How can I figure out the project id to which it belongs?

 

Thanks a lot.

 

roxor

 

 

 

 

 

Celil
Esteemed Contributor

Re: total actual effort for task or request work item can not be negative - error

Hi roxor,

 

depend on dirkf's code, here is the related projects or request and demand IDs.

 

SELECT t.work_item_type,
decode(t.work_item_type, 'TASK', wp.project_id, 0) Project_ID,
decode(t.work_item_type, 'REQUEST', t.work_item_id, 0) Demand_Request_ID,
t.work_item_id, t.RESOURCE_ID,t.LAST_UPDATE_DATE, t.WORK_ITEM_TYPE, t.act_effort, s.tm_actual
FROM tm_work_units t,
wp_tasks wt,
pm_work_plans wp,
(SELECT b.resource_id, c.work_item_id, SUM (e.actual_effort) tm_actual
FROM tm_time_sheets b,
tm_time_sheet_lines c,
tm_actuals d,
tm_actuals_effort e
WHERE 1=1
AND c.effort_on_work_item_entity = 'Y'
AND b.time_sheet_id = c.time_sheet_id
AND d.time_sheet_line_id = c.time_sheet_line_id
AND d.totals_flag = 'Y'
AND e.actuals_id = d.actuals_id
GROUP BY b.resource_id, c.work_item_id) s
WHERE
1=1
AND t.ACT_EFFORT is null
AND t.resource_id = s.resource_id (+)
AND t.work_item_id = s.work_item_id (+)
AND ( s.tm_actual = 0 or s.tm_actual is null)
AND ((t.work_item_type = 'TASK' and wt.task_id=t.work_item_id and wp.work_plan_id=wt.work_plan_id)
OR (t.work_item_type = 'REQUEST'))

 

Above query is just for if actual effort is NULL. You can populate  a query for if actual effort is Negative from above query.

 

PS: If the post resolves your issue, please click KUDOS star icon and mark it as Accepted Solution.

 

Celil

IT Governance Professional
& PPM Solution Architect
roxor
Member

Re: total actual effort for task or request work item can not be negative - error

oh, exactly. I was blind:) Thanks a lot.
//Add this to "OnDomLoad" event