My Oracle Support Banner

Error 'oracle.net.ns.NetException: socket read timed out' and 'A Threadpool thread PrmThread-## was determined to be non responsive' When Attempting to Import an XML File in P6 Web (Doc ID 2293245.1)

Last updated on JANUARY 21, 2019

Applies to:

Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 8.4.0.0 and later
Primavera P6 Enterprise Project Portfolio Management - Version 8.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to import an XML file in P6 web, it fails, and the following error occurs in the P6WebAccess.html P6 Web log file:

ERROR DB Id: 1 com.primavera.jobsvc.common.JobServiceExecutable ?:? Job error running job of type JT_ProjectArbiter on database1
org.springframework.dao.DataAccessResourceFailureException: PreparedStatementCallback; SQL [update joblog set job_log_data = ? where job_id = ? ]; IO Error: Socket read timed out; nested exception is java.sql.SQLRecoverableException: IO Error: Socket read timed out
  at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:251)
  at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
  at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:645)
  at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:658)
  at com.primavera.jobsvc.common.dao.JobServiceJDBCDaoImpl.a(Unknown Source)
  at com.primavera.jobsvc.common.dao.JobServiceJDBCDaoImpl.updateLog(Unknown Source)
  at sun.reflect.GeneratedMethodAccessor54.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:498)
  at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)
  at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
  at com.sun.proxy.$Proxy6.updateLog(Unknown Source)
  at com.primavera.jobsvc.common.JobServiceExecutable.c(Unknown Source)
  at com.primavera.jobsvc.common.JobServiceExecutable.a(Unknown Source)
  at com.primavera.jobsvc.common.JobServiceExecutable.execute(Unknown Source)
  at com.primavera.infr.threadpool.ThreadPoolImpl.run(Unknown Source)
  at java.lang.Thread.run(Thread.java:745)
  Caused by: java.sql.SQLRecoverableException: IO Error: Socket read timed out
  at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1065)
  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
  at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3665)
  at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1352)
  at com.primavera.infr.db.PPreparedStatement.executeUpdate(Unknown Source)
  at org.springframework.jdbc.core.support.AbstractLobCreatingPreparedStatementCallback.doInPreparedStatement(AbstractLobCreatingPreparedStatementCallback.java:76)
  at org.springframework.jdbc.core.support.AbstractLobCreatingPreparedStatementCallback.doInPreparedStatement(AbstractLobCreatingPreparedStatementCallback.java:55)
  at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:629)
  ... 14 more
  Caused by: oracle.net.ns.NetException: Socket read timed out

ERROR com.primavera.infr.threadpool.ThreadPoolImpl ?:? A Threadpool thread PrmThread-26 was determined to be non responsive, a new thread has been created. On a side note, check your Maximum Task Duration and Maximum Long Running Task Duration values under ThreadPool settings.

 

The issue can be reproduced at will with the following steps:

  1. Import an XML file.
  2. Observe that the job takes a very long time and hangs or fails.
  3. Observe the reported error in the log file.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.