This content has been marked as final. Show 3 replies
Have you checked the planning logs and the essbase application log to look for more information at the tim4e of the error.1 person found this helpful
This error usually occurs when there are few resources to execute business, to check this go to:1 person found this helpful
Tools --> Job Console
and check the status of business rule that runs on form load if the business rule failed to execute then check the reason if it states something about block size then the error is due to lack of resources and in such case you have to make performance tunning of your application.
Hi team members,
thanks for your support, issue is solved after reviewing the below logs and consulting some manuals & yes application needs some performance tuning at Essbase level.
please find below the logs and workout.
Note:_ workout is for a basic level application, please change the setting as per your application needs.
FATAL calcmgr.launch - Date/Time Ended: 2012/03/08:11:05:24.561 AFT Server/Application/Database: localhost/Rev/Plan1 Business Rule Name: 5.1_XXX_Rev_Mig By Planning user: admin.Exception: com.hyperion.planning.InvalidCalcException: An error occurred while running the specified calc script. Check the log for details.
Essbase Log for Respective Application:_
[Tue Mar 13 15:14:09 2012]Local/Revenue/Plan1/admin@Native Directory/489/Error(1012700)
Dynamic calc processor cannot allocate more than  blocks from the heap. Please increase CalcLockBlock setting and then retry
[Tue Mar 13 15:14:09 2012]Local/Revenue/Plan1/admin@Native Directory/489/Error(1200467)
Error executing formula for [Subscriber]: status code  in function [@_VAL]
[Tue Mar 13 15:14:09 2012]Local/Revenue/Plan1/admin@Native Directory/489/Warning(1080014)
Transaction [ 0x3c30001( 0x4f5f24f9.0x6d081 ) ] aborted due to status .
[Tue Mar 13 15:14:09 2012]Local/Revenue/Plan1/admin@Native Directory/489/Info(1012550)
Total Calc Elapsed Time : [0.03] seconds
Essbase Error Message:_
Reason: Dynamic calc processor cannot allocate more than number blocks from the heap. Please increase CalcLockBlock setting and then retry
Increase the number of blocks that Essbase can allocate for a calculation:
1.Set the maximum number of blocks that Essbase can allocate to at least 500:
a.If ESSBASEPATH/bin/ essbase.cfg does not exist on the server computer, create one using a text editor.
b.In the essbase.cfg file on the server computer, set CALCLOCKBLOCKHIGH to 500.
c.Stop and restart Essbase Server.
2.Add the SET LOCKBLOCK HIGH command to the beginning of the calculation script.
3.Set the data cache large enough to hold all blocks specified in the CALCLOCKBLOCKHIGH setting.
•Determine the block size.
•Set the data cache size.