The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

Rams_2022's avatar
Rams_2022
New Contributor II
1 year ago

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...
XFBR
Rams_2022's avatar
Rams_2022
New Contributor II
1 year ago

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

FredLucas's avatar
FredLucas
Icon for OneStream Employee rankOneStream Employee
1 year ago

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