A created object instance will not be displayed if more than 1000 values are selected in a Multiple Valued Lookup field

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

If we select more than 1000 values in a Multiple Valued Lookup field and save it, the following error message appears and the created instance will no longer be displayed due to the error message.

ERROR: System error. Contact system administrator.

The app-ca.log shows the following error message.
Caused by: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01795: maximum number of expressions in a list is 1000

STEPS TO REPRODUCE: 

1. Create a Dynamic Lookup that retrieves 1001 or more records.
2. Create a new attribute with the Data Type "Multiple Valued Lookup" to an Object and specify the Lookup created on the step 1
3. Add the created attribute to the Object View. Ensure that the field’s Display Type is set to "Browse".
4. Create a new Object Instance and select more than 1000 values in the added Multiple Valued Lookup field.
5. Click on 'Save' button.

Expected Results: 
The Object Instance is saved and opened without a problem.

Actual Results:
The following error message is displayed when the Object Instance is saved and opened. (The Instance cannot be displayed due to the error message, though it is stored in the database.)

ERROR: System error. Contact system administrator.

Environment

Release : 15.8.1

Component : CA PPM STUDIO

Cause

Oracle Database limitation

Resolution

Adjust the number of values selected in the Multiple Valued Lookup field so that the number of the selected values are less than 1001.