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 AUGUST 14, 2017

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 in the P6WebAccess.html file is observed:

ERROR
-----------------------
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

STEPS TO DUPLICATE:
-----------------------
The issue can be reproduced at will with the following steps:

  1. Import XML
  2. See job take a very long time and/or fail
  3. Find error in the log

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