Last updated on DECEMBER 14, 2015
Applies to:Primavera P6 Team Member - Version 22.214.171.124 to 126.96.36.199 [Release 8.3]
Information in this document applies to any platform.
When attempting to send a "Welcome" email to a P6 Team member using the Team Member Email Statusing Service, the email fails to send and the following error is generated in the Team Member Email Statusing Service Log File (Messaging.log):
ERROR com.oracle.pgbu.teammember.messaging.PullMessageProcessor - Error while loading ResourceAssignments:
Caused by: java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000
The issue can be reproduced at will with the following steps:
1. Send a welcome email to the P6 Team Member (with a Team Member's Email address in the body of the welcome email, and "Welcome" In The Subject line)
2. The Email Is Recieved By The Team Member Email Statusing Service But Moves To A Failed Folder
3. Noted Error Is Generated In The Log File.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms