Error: "ORA-00920: Invalid Relational Operator" When Running P6 Job Services

(Doc ID 2250348.1)

Last updated on APRIL 11, 2017

Applies to:

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

Symptoms

The following SQL error continuously appears in the P6 log file:

ERROR

WARNING: DBEngine.executeSelect: {SELECT jobsvc.job_id JobId,jobsvc.job_type JobType,jobsvc.status_code JobStatus,jobsvc.recur_data RecurringData FROM jobsvc WHERE jobsvc.recur_type=RT_WebEnabled AND JS_Failed AND JT_EnterpriseData}
null
com.primavera.bo.base.DBEngineException: DBEngine.executeSelect: {SELECT jobsvc.job_id JobId,jobsvc.job_type JobType,jobsvc.status_code JobStatus,jobsvc.recur_data RecurringData FROM jobsvc WHERE jobsvc.recur_type=RT_WebEnabled AND JS_Failed AND JT_EnterpriseData}
null
  at com.primavera.bo.base.DBEngineImpl.executeSelect(Unknown Source)
  at com.primavera.bo.base.DBEngineImpl.executeSelect(Unknown Source)
  at com.primavera.bo.base.LDBEngineImpl.selectObjects(Unknown Source)
  at com.primavera.bo.base.CalculateEngineImpl.getObjects(Unknown Source)
  at com.primavera.bo.base.CalculateEngineImpl.getObjects(Unknown Source)
  at com.primavera.bo.base.CalculateEngineImpl.getObjects(Unknown Source)
  at com.primavera.bo.base.server.ServerDAOImpl.load(Unknown Source)
  at com.primavera.px.common.PxServiceJobRescheduler.g(Unknown Source)
  at com.primavera.px.common.PxServiceJobRescheduler.resheduleRecurringJob(Unknown Source)
  at com.primavera.px.common.PxService.a(Unknown Source)
  at com.primavera.px.common.PxService.runJob(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.SQLSyntaxErrorException: ORA-00920: invalid relational operator

  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
  at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
  at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:873)
  at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1281)
  at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1909)
  at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1871)
  at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:318)
  at com.primavera.infr.db.PStatement.execute(Unknown Source)
  ... 16 more
Original Exception:
java.sql.SQLSyntaxErrorException: ORA-00920: invalid relational operator

  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
  at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
  at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:873)
  at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1281)
  at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1909)
  at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1871)
  at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:318)
  at com.primavera.infr.db.PStatement.execute(Unknown Source)
  at com.primavera.bo.base.DBEngineImpl.executeSelect(Unknown Source)
  at com.primavera.bo.base.DBEngineImpl.executeSelect(Unknown Source)
  at com.primavera.bo.base.LDBEngineImpl.selectObjects(Unknown Source)
  at com.primavera.bo.base.CalculateEngineImpl.getObjects(Unknown Source)
  at com.primavera.bo.base.CalculateEngineImpl.getObjects(Unknown Source)
  at com.primavera.bo.base.CalculateEngineImpl.getObjects(Unknown Source)
  at com.primavera.bo.base.server.ServerDAOImpl.load(Unknown Source)
  at com.primavera.px.common.PxServiceJobRescheduler.g(Unknown Source)
  at com.primavera.px.common.PxServiceJobRescheduler.resheduleRecurringJob(Unknown Source)
  at com.primavera.px.common.PxService.a(Unknown Source)
  at com.primavera.px.common.PxService.runJob(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)

STEPS TO DUPLICATE:

The issue can be reproduced at will with the following steps:
1. Observe the repetitive error reported in the P6WebAccess.html file.

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