MUX Project Timeline error: ORA-01795

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

The MUX Project Timeline view errors with API-1019 : Could not process the request due to internal error

The grid view loads fine and when changing the filtering criteria on the timeline view, the view loads.

Looking at the app-ca.log file we see the following exception:

SELECT c.prid AS sub_obj_id,  NVL(p.odf_blueprint_id, (SELECT id FROM odf_blueprints b WHERE b.type = NLS_UPPER(p.odf_object_code) AND b.is_default = 1 ) ) AS blueprint_id  FROM prtask c JOIN inv_investments p ON p.id = c.prProjectID AND c.prid IN (5846035, 5978019, 5892153, 5187545, 5881103….

                at com.ca.ppm.rule.RuleHelper.findBlueprintIdsBySubObject(RuleHelper.java:226)
                at com.ca.platform.osf.object.rule.ODFRuleExecutor.loadSubObjIdBlueprintIds(ODFRuleExecutor.java:392)
                at com.ca.platform.osf.object.rule.ODFRuleExecutor.executeBlueprintRules(ODFRuleExecutor.java:252)
                at com.ca.platform.osf.object.rule.ODFRuleExecutor.executeBlueprintRules(ODFRuleExecutor.java:358)
                at com.ca.platform.osf.object.rule.ODFRuleExecutor.executeBulkRequestRules(ODFRuleExecutor.java:143)
                ... 91 more
Caused by: com.niku.union.persistence.PersistenceException: 
SQL error code: 1795
Error message: ORA-01795: maximum number of expressions in a list is 1000

 

Environment

This only happens in Oracle Datasets

Cause

This is caused by DE70381

Resolution

The ODFRuleExecutor has been refactored and can not be reproduced in 16.1.2