Welcome E-mail to Team Member Fails with ORA-01795: MAXIMUM NUMBER OF EXPRESSIONS (Doc ID 2085986.1)

Last updated on DECEMBER 14, 2015

Applies to:

Primavera P6 Team Member - Version 8.3.2.0 to 8.3.10.0 [Release 8.3]
Information in this document applies to any platform.

Symptoms

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


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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms