We have been experiencing intermittent problems when trying to refresh our cubes using EPMA. Example: we add new members in the Shared library, validate and refresh outline. Sometimes it pushes it down to the Planning application itself, sometimes not. Sometimes it never makes it’s way down to essbase. It seems to keep getting stuck on the EPMA side. Sometimes it works, sometimes it doesn’t.
This is a new problem in the past week. Prior to this issue starting, the servers had been hard rebooted 1x per month for the previous 2 months.
Now we are doing a hard reboot of the servers every night, followed by a batch script for services to start. Sunday evening, essbase refreshed fine. Yesterday it did not.