Error: "Application exception overridden by rollback exception org.springframework.dao.DataAccessResourceFailureException: PreparedStatementCallback; SQL [SQL Query] IO Error: Write failed: Broken pipe" Running Scheduled Service (Doc ID 1609730.1)

Last updated on JUNE 29, 2016

Applies to:

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

Symptoms

After running a scheduled service (like summarization), the process fails and the following error is logged to the P6WebAccess.html log file:

ERROR
-----------------------
[org.springframework.transaction.interceptor.TransactionInterceptor] ERROR TIMESTAMP: Application exception overridden by rollback exception
org.springframework.dao.DataAccessResourceFailureException: PreparedStatementCallback; SQL [select job_id, job_name, job_type, user_id, job_type_key, last_run_date, update_date, recur_data, recur_type, status_code, seq_num, parent_job_id, last_error_descr, worker_host, (select jobset.setting_value from jobset where jobset.setting_name='JobDataDateUpdateType' and jobset.job_id=jobsvc.job_id) as JobDataDateUpdateType, (select jobset.setting_value from jobset where jobset.setting_name='DataDateUpdateValue' and jobset.job_id=jobsvc.job_id) as DataDateUpdateValue from jobsvc where job_id = ? and ((status_code = ?) or (status_code in (?, ?, ?) and recur_type = ?)) for update]; IO Error: Write failed: Broken pipe; nested exception is java.sql.SQLRecoverableException: IO Error: Write failed: Broken pipe
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:236)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:607)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:641)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:666)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:698)
at org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:112)
at org.springframework.jdbc.object.SqlQuery.findObject(SqlQuery.java:252)
at org.springframework.jdbc.object.SqlQuery.findObject(SqlQuery.java:260)
at com.primavera.jobsvc.common.dao.JobServiceJDBCDaoImpl.updateJobRunning(Unknown Source)
at sun.reflect.GeneratedMethodAccessor97.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy67.updateJobRunning(Unknown Source)
at com.primavera.jobsvc.common.JobServiceExecutable.a(Unknown Source)
at com.primavera.jobsvc.common.JobServiceExecutable.a(Unknown Source)
at com.primavera.jobsvc.common.JobServiceExecutable$1.locateJob(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:662)
Caused by: java.sql.SQLRecoverableException: IO Error: Write failed: Broken pipe


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot summarize.

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