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
This only happens in Oracle Datasets
This is caused by DE70381
The ODFRuleExecutor has been refactored and can not be reproduced in 16.1.2