My Oracle Support Banner

Error 'Error while trying to load assignments' or 'ORA-01795: maximum number of expressions in a list is 1000' When Accessing Team Member (Doc ID 2266267.1)

Last updated on MARCH 22, 2022

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 15.2.0.0 to 15.2.13.0 [Release 15.2]
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 15.2.0.0 to 15.2.13.0 [Release 15.2]
Information in this document applies to any platform.

Symptoms

When attempting to log into Team Member and access My Tasks, the following error occurs:

Alert- Error while trying to load assignments: Error while trying to load resources: DBEngine.executeSelect: <followed by a complex 'select' statement>

In addition, the Team Member log shows the following error entry:

ORA-01795: maximum number of expressions in a list is 1000

 

The issue can be reproduced at will with the following steps:
1. Log into Team Member.
2. Note reported error.

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.