If you see this message, your browser either has disabled or does not support JavaScript. To use the full features of this help system, such as searching and the table of contents, your browser must have JavaScript support enabled. If your browser supports JavaScript, it provides settings that enable or disable JavaScript. When JavaScript is disabled, you can view only the content of the help topic, which follows this message.

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 Planning server, not on a remote server.

Optional: If an encrypted password file is set up, you can specify [-f:passwordFile] as the first parameter in the command line, where passwordFile is the full file path and name for the password file. See Suppressing Password Prompts in Planning Utilities.

application_name: The name of the Planning application on which to run the create or refresh.

user_name: The administrative user who has rights to create or refresh the application.

/C or /R: The function to perform on the application:

/C: Create the database outline.

/R: Refresh the database outline.

/D: Specify the database during create or refresh.

/F: Use security filters for all users of the application. Optionally, use with S, V, or SV:

/FS: Generate shared member security filters.

/FV: Validate security filters, but do not save the filters.

/FSV: Validate the shared member security filters.

/RMIPORT: Specify an RMI port number different from the preset value of 11333.

/-L: Default option, to create or refresh by connecting to an application server on a local or remote machine. (You can use /L to create or refresh without connecting to an application server, for example, if the application server is not running.)

/DEBUG: Specify detailed error messages.

If prompted, enter your password.

View the result of the application refresh, including errors. Completion status is shown on the console.

This example shows a command line used to refresh a database for all users logged on to the specified application. It uses the default RMI port and includes shared member security filters: