Business rules showing in Planning Job Console as running though Completed in Essbase

Applies to:

Hyperion Planning – Version: 11.1.2.0.00 and later [Release: 11.1 and later ]
Information in this document applies to any platform.

Goal

When running business rules through planning or workspace if the user switches to the job console to track the progress of the business rule, it never completes and always show as ‘processing’. Some other rules however do complete.

Solution

This is a known issue in 11.1.2 but has been resolved in 11.1.2.1.

An alternative that could work would be to do the following:

– Stop the planning service
– Take a relational database repository backup of the planning application
– Go the Hyperion Planning Application repository database and clear the HSP_JOB_STATUS table
– Start the planning service
– Login to the planning application to make sure that the job status are cleared
– go to administration -> Application -> Properties
Add the following parameters in the application properties section:
Enter HBR_MAX_WAIT_FOR_RULE and the interval in milliseconds to wait before running (ie. 290000))
business rules in the background. If this property is not set, the feature does not work, and
business rules do not run in the background.
Enter HBR_MONITOR_DELAY and the interval in milliseconds for checking business rule status (ie. 180000))
– Save and log off
– Restart Hyperion Planning service.

Advertisements
This entry was posted in Hyperion Business Rules, Oracle EPM, Oracle Hyperion Planning and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s