Project and Portfolio Management Practitioners Forum
cancel

Failed to rollup task actuals for some workplan

Highlighted
TurboMan
Honored Contributor.

Failed to rollup task actuals for some workplan

Hi all,

Have you guys met such a console message before?

:Task Actual Rollup Service:com.kintana.services:2011/04/01-02:01:40.899 EEST: Failed to rollup task actuals for some workplan, rolling back transaction
java.lang.NullPointerException

Any help is appreciated
Regards
TM
4 REPLIES
Celil
Acclaimed Contributor.

Re: Failed to rollup task actuals for some workplan

Hi TurboMan

Did you delete any project or request type that used in any time sheet ?

Celil
Celil

IT Governance Professional
& PPM Solution Architect
TurboMan
Honored Contributor.

Re: Failed to rollup task actuals for some workplan

I don't remember such a thing.
Any suggestion?

Regards
TM
Celil
Acclaimed Contributor.

Re: Failed to rollup task actuals for some workplan

Hi,

You could run SQL to check it. You can make this sql for requests too:

SELECT ts.time_sheet_id, decode(work_item_id,wpt.task_id,'OK','NOT')
FROM tm_time_sheets ts, tm_time_sheet_lines tsl, WP_TASKS wpt
WHERE
ts.time_sheet_id = tsl.time_sheet_id AND
tsl.work_item_type='TASK' AND
tsl.work_item_id(+)=wpt.task_id

Celil
Celil

IT Governance Professional
& PPM Solution Architect
TurboMan
Honored Contributor.

Re: Failed to rollup task actuals for some workplan

Thanks Celil,

Not any "NOT" from the result set.
All I've got "OK".

Regards
TM