3.0.0 Only Upgrade to 3.x and Update the Legacy Backing Store Schema

New TIBCO BusinessEvents metadata tables were added to the backing store schema in version 3.0.1. If you are upgrading from version 3.0.0, you first must upgrade to the latest 3.x version before you migrate data to a JDBC backing store.

Procedure

  1. Upgrade from 3.0.0 to the latest 3.x version.
  2. If the deployed application is running, gracefully shut down all agents and cache servers before you proceed.
  3. Login to the Oracle server as be_user, password be_user (or whatever username and password you are using, as set in the initialize_database.sql script).
  4. Navigate to the location of the scripts (by default in BE_HOME/bin) and open an SQLPlus prompt. Identify yourself as the user you logged in as.
  5. At the SQL prompt, type the following to run the script:

    @create_tables.sql

Result

Running this script does not affect any existing tables (therefore there is no need to run be-oradeploy.exe). Your database tables are now configured.

3.x Only: Import Projects into TIBCO BusinessEvents Studio

Import the project into TIBCO BusinessEvents Studio and ensure that the migrated project is configured correctly. See Migration of 3.x Projects for full details.