Error: "Unable To Load Data" When Loading the Timesheet Approval Page and Error "DBEngine.executeStatement for {call ta_gather_multi_timesheets(?, ?, ?, ?, ?, ?, ?)}failed:IO Error: Socket read timed out" In the P6 Managed Server Log File (Doc ID 2279092.1)

Last updated on AUGUST 08, 2017

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 16.2.8.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to load Timesheet Approval within P6, the following error occurs:

ERROR

Unable to load data

The P6 Managed Server log file displays the following exception:

ERROR

Error loading timesheet data.
com.primavera.bo.remoting.RemoteDataException: Error loading timesheet data.
     at com.primavera.lwfsupport.timesheetapproval.TimesheetLWFDataLoader.load(Unknown Source)
     at com.primavera.rest.service.timesheetapproval.TimesheetApprovalDataHandler.loadData(TimesheetApprovalDataHandler.java:115)
     at com.primavera.rest.resources.timesheetapproval.TimesheetApprovalResource.load(TimesheetApprovalResource.java:64)
     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
     at java.lang.reflect.Method.invoke(Method.java:497)
     at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
     at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:185)
     at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
     at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)
     at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
     at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
      ...
Caused By: com.primavera.PhoenixException: SpecialQueryHelper() populateUPKForLwfTSA: Problem populating UPKLIST table
     at com.primavera.bo.remotable.SpecialQueryHelper.populateUPKForLwfTSA(Unknown Source)
     at com.primavera.lwfsupport.timesheetapproval.TimesheetLWFDataLoaderHelper.a(Unknown Source)
     at com.primavera.lwfsupport.timesheetapproval.TimesheetLWFDataLoaderHelper.a(Unknown Source)
     at com.primavera.lwfsupport.timesheetapproval.TimesheetLWFDataLoaderHelper.loadActionRequiredTimesheets(Unknown Source)
     at com.primavera.lwfsupport.timesheetapproval.TimesheetLWFDataLoader.a(Unknown Source)
     at com.primavera.lwfsupport.timesheetapproval.TimesheetLWFDataLoader.load(Unknown Source)
     at com.primavera.rest.service.timesheetapproval.TimesheetApprovalDataHandler.loadData(TimesheetApprovalDataHandler.java:115)
     at com.primavera.rest.resources.timesheetapproval.TimesheetApprovalResource.load(TimesheetApprovalResource.java:64)
     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      ...
Caused By: com.primavera.PhoenixException: DBEngine.executeStatement for {call ta_gather_multi_timesheets(?, ?, ?, ?, ?, ?, ?)}failed:IO Error: Socket read timed out
     at com.primavera.bo.base.DBEngineImpl.executeStatement(Unknown Source)
     at com.primavera.bo.remotable.SpecialQueryHelper.populateUPKForLwfTSA(Unknown Source)
     at com.primavera.lwfsupport.timesheetapproval.TimesheetLWFDataLoaderHelper.a(Unknown Source)
     at com.primavera.lwfsupport.timesheetapproval.TimesheetLWFDataLoaderHelper.a(Unknown Source)
     at com.primavera.lwfsupport.timesheetapproval.TimesheetLWFDataLoaderHelper.loadActionRequiredTimesheets(Unknown Source)
     at com.primavera.lwfsupport.timesheetapproval.TimesheetLWFDataLoader.a(Unknown Source)
      ...
Caused By: java.sql.SQLRecoverableException: IO Error: Socket read timed out
     at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1062)
     at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
      ...
     at weblogic.work.ExecuteThread.run(ExecuteThread.java:263)
Caused By: oracle.net.ns.NetException: Socket read timed out
     at oracle.net.ns.Packet.receive(Packet.java:339)
     at oracle.net.ns.DataPacket.receive(DataPacket.java:106)
     at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:315)
      ...

Note:  When increasing the connection pool values to allow the procedure to execute, it takes a very long time for the page to load.


Steps To Reproduce

  1. Login to P6
  2. Select Dashboard Dropdown, Approve Timesheets
  3. Note the exception which occurs

 

Changes

 

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