After Adding Resource Hours in Timesheets Using P6 Web Services a NullPointerException Occurs When Opening Progress Reporter (Doc ID 2104020.1)

Last updated on JUNE 05, 2016

Applies to:

Primavera Web Services - Version 8.3.2.0 and later
Information in this document applies to any platform.

Symptoms

When opening Progress Reporter after adding resource hours using P6 Web Services the following error occurs,

ERROR
------------------------------------------------------------------------------------------------------------------------------------------
java.lang.NullPointerException
at com.primavera.jpeg2k.support.P.a(Unknown Source)
at com.primavera.jpeg2k.controls.table.W.b(Unknown Source)
at com.primavera.jpeg2k.controls.table.W.a(Unknown Source)
at com.primavera.jpeg2k.gui.TimesheetPanel.loadTimesheet(Unknown Source)
at com.primavera.jpeg2k.gui.TimesheetPanel.loadTimesheet(Unknown Source)
at com.primavera.jpeg2k.gui.TimesheetPanel.i(Unknown Source)
at com.primavera.jpeg2k.gui.TimesheetPanel.(Unknown Source)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at com.primavera.jpeg2k.controls.h.a(Unknown Source)
at com.primavera.jpeg2k.controls.h.viewChanged(Unknown Source)
at com.primavera.jpeg2k.JPegMain.fireViewChanged(Unknown Source)
at com.primavera.jpeg2k.JPegMain.gotoInitialView(Unknown Source)
at com.primavera.jpeg2k.gui.aZ.run(Unknown Source)
at com.primavera.jpeg2k.gui.aL.run(Unknown Source)

 

STEPS TO REPRODUCE:


1. Use the ResourceHour service to add Approved hours. Using required fields documented in the P6 Web Services Reference Manual and Approved Hours

<v1:ApprovedHours>9</v1:ApprovedHours>
<v1:ResourceAssignmentObjectId>135468</v1:ResourceAssignmentObjectId>
<v1:ResourceObjectId>1189</v1:ResourceObjectId>
<v1:TimesheetPeriodObjectId>1131</v1:TimesheetPeriodObjectId>

2. Try to login to Progress Reporter and notice exception after login
3. Delete invalid new rows from the RSRHOUR table
4. Try the adding hours again but specify Date and Status in the service call

<v1:ApprovedHours>9</v1:ApprovedHours>
<v1:ResourceAssignmentObjectId>135468</v1:ResourceAssignmentObjectId>
<v1:ResourceObjectId>1189</v1:ResourceObjectId>
<v1:TimesheetPeriodObjectId>1131</v1:TimesheetPeriodObjectId>
<v1:Date>2015-10-27T00:00:00</v1:Date>
<v1:Status>Approved</v1:Status>

5. Open Progress Reporter and notice exception no longer occurs but hours do not show in the Timesheet. This seems to be caused by pend_hr_cnt not being populated in the rsrshour table. If pend_hr_cnt is manually updated in the database then the hours appear in Progress Reporter.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms