The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Failed to rollup task actuals for some workplan

Highlighted
TurboMan
Member

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
Esteemed 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
Member

Re: Failed to rollup task actuals for some workplan

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

Regards
TM
Celil
Esteemed 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
Member

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
//Add this to "OnDomLoad" event