Force consolidation error
Hi OS Experts:
While I am running the ForceConsolidation in cube view, I am getting the below error message. Are there any possibilities of this error:
Error calculating member 'EndBal_Calc' in d...
Forum Discussion
MarcusH thanks for recommendation. Just to let you know, user/I started getting this error since yesterday afternoon. we never experienced this issue as of Yesterday noon. we never changed any code or metadata updates that I verified. So, I synced the prod model in Development environment and ran the ForceConsolidation and it is running without any issues. I am stuck here to find out ghost. any leads suggestion please
Have you used the Grid view in the dimension library to check the Text 2 property for all entities? As Marcus suggests, this being missing for an entity seems the most likely cause. It could also be that the text property has been added as time dependant and is not valid for the scenario/time you're consolidating in your cube view.
I also agree that the issue is likely to be on the Text 2 property so would start by doing what KarlT has suggested.
If you still cannot figure out what is causing it I would suggest to do some simple debugging.
Adding the following code to under you Catch Exception part of the rule should enable you to identify what target entity, source entity (given by the Text2 property) and Time is causing it to fail by checking the error log:
Catch ex As Exception 'debug entity, and time causing the exception api.LogMessage($"Target POV Entity: {api.Pov.Entity.Name}; SourceEntity: {api.Entity.Text(2)}; Time: {api.Pov.Time.Name}") Throw ErrorHandler.LogWrite(si, New XFException(si, ex)) End Try
