APCC Archive Measures profiles not working on VCP 12.2.4
We are facing performance issues with "Archive Plan Summary" request. It is taking around 2 hours to complete. Though we have set both the profile options MSC: APCC - Enable Cumulative Measures in Archive and MSC: APCC Archive SCRM Measures to "No", the program is still collecting measure counts for the two. We also ran the program after setting the profile to "Yes" and it took the same time.
As we suspected that the profile option is not working, we looked in the code and found that program looks in the value for feild MEASURE_BLOCKS in MSC_APCC_CONFIG table. The value was set as "1,2,3,5' by concurrent program "Maintain APCC Data Model" when it was run the first time after applying VCP12.2.4 patch. As at the time of running the program the profile option value for both the profiles was "Yes" the field has vale "1,2,3,5". But this field value does not get updated if we rerun the program after setting both the profiles to "No". This looks like