Copy Cost Plan action slow in Clarity 16.4.2
Article ID: 451011
Updated On:
Products
Issue/Introduction
Copying a Cost plan in MUX is slower in Clarity 16.4.2 compared to previous releases. Has anything changed?
STEPS TO REPRODUCE:
- In Clarity 16.4.1, go to MUX and open a project that contains financial plans
- On the Cost Plan grid view, right click over any cost plan
- Click Cope Cost Plan.
- Copy of the cost plan is created in 2-3 seconds
- Upgrade to Clarity 16.4.2 and perform the same steps
Expected Results: The Copy of the Cost Plan is created in 2-3 seconds
Actual results: The Copy of the Cost Plan takes about 1 minute
Environment
Clarity 16.4.2 and Oracle DB
Cause
In Clarity 16.4.2 due to some code changes the FIN_COST_PLAN_DETAILS_U1 index was dropped.
This was replaced by the uniqueness enforcement mechanism with a HASH-based approach (FIN_COST_PLAN_DETAILS_U20 on HASH + ID), and dropped U1.
No new non-unique index on PLAN_ID was created.
Resolution
The code changes that caused the index to be dropped has been reviewed by Engineering as part of DE206977. This has now been fixed in Clarity 16.5.0.
If you are experiencing this issue and you are in Clarity 16.4.2 or 16.4.3, please contact Support for a potential fix.
Additional Information
Please also see some other case scenarios caused by the missing index
Performance issues on SQL queries involving Cost Plan Details table
Feedback
