When Attempting To View The 'View Service Status' Window, The Following Error Occurs: "com.microsoft.sqlserver.jdbc.SQLServerException: The query has timed out"

(Doc ID 1522796.1)

Last updated on APRIL 19, 2015

Applies to:

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

Symptoms

When attempting to view the service status window,
the following error occurs.

ERROR
-----------------------
org.springframework.jdbc.UncategorizedSQLException:
PreparedStatementCallback; uncategorized SQLException for 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 WITH
(ROWLOCK,UPDLOCK) where job_id = ? for update]; SQL state [HY008]; error
 code [0]; The query has timed out.; nested exception is
com.microsoft.sqlserver.jdbc.SQLServerException: The query has timed
out.
        at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
        at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
        at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
        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.a(Unknown Source)
        at com.primavera.jobsvc.common.dao.JobServiceJDBCDaoImpl.updateJobFailed(Unknown Source)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        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.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198)
        at $Proxy64.updateJobFailed(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.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: com.microsoft.sqlserver.jdbc.SQLServerException: The query has timed out.



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