Solution ID: prim84670
When logging into Primavera Web Access and accessing Time Approval, the ‘Time Approval’ screen does not load.
Status: Reviewed
Version(s): 6.2.1

Problem: When logging into Primavera Web Access and accessing Time Approval, the ‘Time Approval’ screen does not load.
Problem: When clicking on Approve Timesheets it throws a java null pointer exception.

basic: Referencing classloader: sun.plugin.ClassLoaderInfo@1372a1a, refcount=1
basic: Loading applet …
basic: Initializing applet …
basic: Starting applet …
basic: completed perf rollup
liveconnect: Invoking JS method: resizeApplet
network: Connecting http://localhost:8080/primaveraweb/BO with proxy=DIRECT
network: Connecting http://localhost:8080/primaveraweb/BO with cookie “LANGUAGE=en; IA_HD_CODE=127.0.0.1-1254758250890; SELECTED_DBID=1; CLIENTLOCALE=en-us; COMPOSITE_COOKIE=INIT_LOGIN_JRE%3Dtrue%01webpm_cached%3Dtrue%01timesheet_approval_cached%3Dtrue%01cnwy-TabNo%3D1%01nljzo-TabNo%3D1%01nlevk-TabNo%3D1%01gbmjad-TabNo%3D1%01gbgdog-TabNo%3D1; JSESSIONID=B173A94C4D9D94A156D91514CA9CC0C3″
java.lang.NullPointerException
 at com.primavera.pvapplets.timesheetapproval.TimesheetListPanel.updateSelectedGrouping(Unknown Source)
 at com.primavera.pvapplets.timesheetapproval.TimesheetApprovalContainer.reloadDataAndInitUI(Unknown Source)
 at com.primavera.pvapplets.timesheetapproval.TimesheetApprovalContainer.<init>(Unknown Source)
 at com.primavera.pvapplets.timesheetapproval.TimesheetApprovalApplet.start(Unknown Source)
 at sun.applet.AppletPanel.run(Unknown Source)
 at java.lang.Thread.run(Unknown Source)
Cause: User settings are in an ‘invalid state’.
Fix: This known problem in Project Management 6.2.1 and is currently under review and may be corrected in a future release.
Fix: Workaround:

Run the following script against your database:


update admuser.userset set setting_value=’approvedTimesheets|timesheetGroupNone|rejectedTimesheets|timesheetGroupNone|allTimesheets|timesheetGroupNone|resubmittedTimesheets|timesheetPeriod|notSubmittedTimesheets|timesheetStatus|actionRequiredTimesheets|timesheetStatus|submittedTimesheets|timesheetStatus|’ whereuser_id = <user_id> and setting_name = ‘TimesheetApprovalTimesheetFilterGroups’


Note:  Where <user_id>  is the affected user’s id from the USERS table.