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 220.127.116.11 to 18.104.22.168 [Release 15.2]
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 22.214.171.124 to 126.96.36.199 [Release 15.2]
Information in this document applies to any platform.
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.
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