Calc Manager error “An error occurred while running the specified calc script.Check the log for details”


If you are using Calc Manager with Planning you may have came across this error.

Once we (me and Lingaraj – a colleague/friend of mine) were doing a project and had to migrate all the Business Rules into Calc Manager and then we were testing some rules and came across this error.

We tried to check almost all possible scenarios to see why the error came up. I kind of (personally)hate the 11.1.2 error logging system because when you open up the logs files for  a possible explanation of the error it’ll say “Please check the log for details”. He he…isn’t it cool.

So coming back to business, we found that the rule is running correctly, i.e. we are getting the correct results – numbers(logic is running fine). Somewhere in Calc Manger it is saying that the rule didn’t run correctly. S0 back to the back-end tables. (It always starts and ends with back-end tables for me and Linga ;))

If you look at the relational tables for Planning, you can see that some tables are especially for Calc Manger.

  • HSP_CALC_MGR_RULES
  • HSP_CALC_MGR_RULESETS
  • HSP_CALC_MGR_USER_VAR_PPT
  • HSP_CALC_MGR_VARIABLES

We checked all theses backend tables and found that there are some constraints involved.

The culprit was a constraint called UK_CALC_MGR_USER_VAR_PPT which is a unique constraint.


So we disabled this constraint and the issue got resolved. Now we have to check with Oracle and see whether there is any implication if we disable this constraint.

Also I’ve seen that if you import any Hyperion Business Rules to Calc Manager, the validation fails with the following error message
A substitution variable required for this calculation is undefined. Variable: Variable Name 

There is nothing wrong with your variable, you’ll have to assign a default value to the variable!!!!!(didn’t like this one too)

Hope these will get resolved in the new release 🙂
Advertisements

About Celvin Kattookaran

I’m an EPM Consultant, my primary focus is on Hyperion Planning and Essbase. Some of you from Hyperion Support team might recognize me or have seen my support articles, I was with the WebAnalysis Support Team. I'm an Independent Consultant with “Intekgrate Corporation” based out of Aurora office. I’m from God’s Own Country (Kerala, India), lived in all southern states of India, Istanbul and Johannesburg (and of course United States). I’m core gamer :) and an avid reader. I was awarded Oracle ACE Director for my contributions towards EPM community.

Leave a Reply