Upgrading the warehouse database

Rational ProjectConsole Dashboard Designer Help

Checking in the ProjectConsole schema only updates the master database. The next required step required is to upgrade the warehouse database.

Before upgrading a warehouse database, make sure that there are no scheduled tasks currently running that are associated with the database. ProjectConsole prevents new scheduled tasks from connecting to a database while you are upgrading it, but it does not disconnect scheduled tasks that are currently connected.

Whenever you successfully check in a schema you are given the opportunity to upgrade the warehouse database at that time. The following procedure pertains to upgrading the data warehouse at some other time than schema check-in. Perform these steps only if you did not upgrade your warehouse when you checked in your schema.

To upgrade the warehouse database:

  1. In Rational ProjectConsole Dashboard Designer, click "" or click Schema > Upgrade Warehouse.
  2. Confirm your action and acknowledge completion in the messages and window that are displayed.
To continue the Rational RequisitePro example, go to Creating a source-to-target mapping .