Refreshing Application Databases Using a Utility
The CubeRefresh utility creates or refreshes the database. Before it runs, it ensures that the application is not locked. While it runs, the application is locked when metadata is updated in the database. For example, if users are assigning access, this message displays: "Cannot process your request because the application is being refreshed." This utility must be run on the same machine as the Oracle Hyperion Planning server, not on a remote server.
Caution:
Oracle recommends that you back up the application before creating or refreshing. See Backing Up Applications and Application Databases. Following these steps affects data in the database. When you use the create or refresh options, data might be replaced or erased, and Planning plan types rebuilt. For important information, see Considerations for Working with Essbase.
To refresh the application database using a utility: