My Oracle Support Banner

Error: "ORA-01795: maximum number of expressions in a list is 1000" When Copy/Pasting Projects With Baselines (Doc ID 2819677.1)

Last updated on OCTOBER 06, 2022

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 19.12.13.0 to 19.12.16.0 [Release 19.12]
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 19.12.13.0 to 19.12.16.0 [Release 19.12]
Primavera P6 Professional Project Management - Version 19.12.13.0 to 19.12.16.0 [Release 19.12]
Information in this document applies to any platform.

Symptoms

When attempting to copy/paste multiple projects with baselines the following error occurs.

ERROR

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 P6 Pro or P6 Web.
  2. Copy/paste projects with baselines.
  3. Service will fail.
Note: The 'ORA-01795' error has also been seen in the Web Access log when attempting to log into P6 Web and seeing the error: "Unexpected login error."

 

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
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.