My Oracle Support Banner

P6 Pro CloudConnect Reports ORA-01795 Maximum Number of Expressions in a List is 1000 (Doc ID 2489932.1)

Last updated on JULY 25, 2019

Applies to:

Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 17.1 to 17.12.9.0 [Release 17.1 to 17.12]
Information in this document applies to any platform.

Symptoms

P6 Professional connected through cloud connect generates the following errors:

ERROR
-----------------------
Front End Error: Database is not configured to run background jobs

Backend Error from P6ProCloudConnect.html : java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000
 
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)
  at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
  at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:30)
  at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:931)
  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1150)
  at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java: 1707)
  at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1670)
  at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:310)
  at com.primavera.cloud.worker.Response.execSqlWithoutParams(Response.java:836)
  at com.primavera.cloud.worker.Response.execSql(Response.java:856)
  at com.primavera.cloud.worker.Request.handleSqlRequest(Request.java:203)
  at com.primavera.cloud.worker.Request.dispatchRequest(Request.java:437)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login on P6 Pro client with Client Side Cache enabled
2. Open a project with more than 1000 activities --> Select 1001 activities
3. Press Delete button --> Ok
4. Error is displayed

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
References


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