My Oracle Support Banner

Error: 'ORA-01795: maximum number of expressions in a list is 1000' When Attempting to Open a BP Record (Doc ID 2679286.1)

Last updated on JUNE 16, 2021

Applies to:

Primavera Unifier - Version 19.12 to 19.12.4.0 [Release 19.12]
Primavera Unifier Cloud Service - Version 19.12 to 19.12.4.0 [Release 19.12]
Information in this document applies to any platform.

Symptoms

When attempting to open a BP Record, the following error occurs.

ERROR
-----------------------
The system could not process your request. Logging in again may help in some cases. Contact your System Administrator if you are still having problems.

In the logs, the following error message will appear:

java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into the application
2. Access a project/shell and select a BP
3. Click on a record to open it


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

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.