Rule Dimension sync issues between Front-End and Essbase in EPCM
Summary:
Getting error while running rules in EPCM related to Rule dimension member sync up
Content (please ensure you mask any confidential information):
We are getting errors very frequently now when we create New rule, delete a rule, migrate rules, migrate models which is very common as per client requirement or monthly activity.
These issues are related to metadata sync between essbase and EPCM.
Error example
- Cannot execute maxl statement: Essbase Error (1260046): Unknown Member PCM_Calculation Rules_25 used in query
We don't have any member with this name.
Earlier we used get this error in lower instances and now in Production as well. FYI, even after Database Refresh (with Validate Metadata) option, it doesn't get resolved. We always need to restore it from old BackUp