1. Administrator's Guide
  2. Troubleshooting
  3. Unable to Refresh Application Error

Unable to Refresh Application Error

Scenario:

When using a DB2 database and refreshing an application in Oracle Hyperion Planning, an error displays.

Solution:

DB2 could not refresh or correctly generate its transaction log because insufficient space was allocated for log files. (See the Oracle Enterprise Performance Management System Installation and Configuration Troubleshooting Guide.) To resolve this issue, use these procedures.

Allocate more space for the DB2 transaction log:

  1. In DB2 Command Center, select Tools, then Wizard, and then Configure Database Logging Wizard.
  2. Connect to the database and ensure that Circular Logging is selected.
  3. On the next screen, increase the number of primary (for example, 20) and secondary log files (for example, 10).
  4. Increase the size of each log file (for example, 2000).
  5. Click Next to accept all defaults.
  6. At Summary, enter the user name and password.
  7. Click Finish.
  8. Restart DB2.
  9. Refresh the database.

Perform a database refresh more frequently, after a few changes instead of waiting for all changes to the application.