Upgrading From an Earlier 8.2.x Release to Release 8.2 Version 03

Topics:

Due to changes in the WebFOCUS Release 8.2 repository database structure, a database update is required to enable you to use an existing Release 8.2.x database with Release 8.2 Version 03.

Upgrade Installation Steps

How to:

Reference:

The database update is performed during the upgrade installation. The installation checks the database version used for the WebFOCUS repository to determine if a database update is required. Database updates are performed when upgrading from Release 8.2.00 or Release 8.2.01.

  • If a database update is required, the db_inplace_update.bat utility runs, using the credentials configured with the installation.
    If the database update was successful, the following information is entered in the installation log:
    Update process SUCCEEDED

    Note: Credentials used for the database update utility need privileges to allow table changes.

    • If the database update fails, the WebFOCUS web application does not start and you are not able to connect to WebFOCUS. This can occur if the connection to the database is not available. In this case, you need to review the installation log and the WebFOCUS event log for more information, and manually run the db_inplace_update utility post-installation.
      The following are examples of failures captured in the installation log file:
      Version checker process FAILED to connect to database 
      ERROR:connecting to DB, DBCHECK:connect_error-not going to execute:
      C:\ibi\WebFOCUS82\utilities\dbupdate\db_inplace_update.bat
      The following is an example of a failure captured in the WebFOCUS event.log file:
      ERROR_DB_NOT_UP_TO_DATE Database is not up to date. Please run the update utility first.

      For more information on how to manually run the db_inplace_update utility post-installation, see How to Manually Run the Database Utility Post-Installation.

  • The update_repos utility runs automatically. This utility imports the following Change Management packages:
    • managers_group_and_rules.zip
    • bip_page_templates_Vnn.zip, where nn is the version of the package.
    • roles.zip
    • pgx_page_templates_Vnn.zip, where nn is the version of the package.
    • themes_Vnn.zip, where nn is the version of the package.

    You are prompted for WebFOCUS Administrator credentials during the installation. If communication to the database is not available, or the provided credentials do not have permissions to import Change Management packages, you must manually run the update_repos utility post-installation. See step 6 in How to Manually Run the Database Utility Post-Installation.

    Note: This step is required for all Release 8.2.x upgrades to Release 8.2 Version 03.

  • Use the Role Update Utility available in the WebFOCUS Administration Console to update repository roles and privileges. The utility enables you to identify differences between roles and privileges available in your existing repository and the new roles and privileges provided with the new installation.

    It is recommended that you replace your repository with new roles and privileges to use new functionality and features.

    The following is an example using a WebFOCUS Release 8.2 Version 01M repository and upgrading to Release 8.2 Version 03. The Run Procedures with Insight and Designer privileges are required to use new functionality, run Insight content, and access WebFOCUS Designer.

    1. Sign in to WebFOCUS as an administrator.
    2. Click the User menu, point to Administration, and then click Administration Console.
    3. In the Configuration panel, click Role Update Utility.

      At the top of the table, you will see a message that identifies new roles and high-level differences between your existing roles.

    4. Examine the differences between the Repository and Packaged roles and privileges and apply the new roles and privileges to enable new functionality and features.

Procedure: How to Manually Run the Database Utility Post-Installation

  1. Ensure that the database is running.
  2. Run the db_inplace_update.bat utility. The db_inplace_update database utility is stored in the drive:\ibi\WebFOCUS82\utilities\dbupdate folder.

    Note: The application server should not be running when running the database update utility.

    A Command window opens and is used to run the database update utility.

  3. Type the database repository user name and password, when prompted.

    Note: Credentials used for the database update utility need privileges to allow table changes.

  4. After a successful database update, clear the application server cache and then start the application server.
  5. Confirm that the connection to WebFOCUS is functional and that the content is correct.
  6. Run the following utility to load new roles and BI Portal page templates into the WebFOCUS repository:

    drive:\ibi\WebFOCUS82\utilities\WFReposUtil\update_repos.bat

    You will get prompted to provide WebFOCUS administrator credentials.

    This utility imports the following Change Management packages:

    • drive:\ibi\WebFOCUS82\features\bip\managers_group_and_rules.zip
    • drive:\ibi\WebFOCUS82\features\bip\bip_page_templates_Vnn.zip, where nn is the version of the package.
    • drive:\ibi\WebFOCUS82\features\bip\pgx_page_templates_Vnn.zip, where nn is the version of the package.
    • drive:\ibi\WebFOCUS82\features\bip\themes_Vnn.zip, where nn is the version of the package.
    • drive:\ibi\WebFOCUS82\features\roles\roles.zip.

    Logs are created in the drive:\ibi\WebFOCUS82\logs folder under the following names:

    • cm_import_bip_page_templates_<date_time>.log
    • cm_import_managers_group_and_rules_<date_time>.log
    • cm_import_themes_Vnn_<date_time>.log
    • cm_import_pgx_page_templates_Vnn_<date_time>.log
    • cm_import_roles_<date_time>.log
    • cm_import_managers_group_and_rules_<date_time>.log
  7. Use the Role Update Utility available in the WebFOCUS Administration Console to update repository roles and privileges. The utility enables you to identify differences between roles and privileges available in your existing repository and the new roles and privileges provided with the new installation.

    It is recommended that you replace your repository with new roles and privileges to use new functionality and features.

    The following is an example using a WebFOCUS Release 8.2 Version 01M repository and upgrading to Release 8.2 Version 03. The Run Procedures with Insight and Designer privileges are required to use new functionality, run Insight content, and access WebFOCUS Designer.

    1. Sign in to WebFOCUS as an administrator.
    2. Click the User menu, point to Administration, and then click Administration Console.
    3. In the Configuration panel, click Role Update Utility.

      At the top of the table, you will see a message that identifies new roles and high-level differences between your existing roles.

    4. Examine the differences between the Repository and Packaged roles and privileges and apply the new roles and privileges to enable new functionality and features.

Reference: Troubleshooting the Upgrade Installation

  • If the database update fails, you must ensure that the database is running and that the db owner is allowed to make changes to the database tables.
  • Run the drive:\ibi\WebFOCUS82\utilities\dbupdate\db_check_version.bat utility to verify if the database was updated.
  • In case the application server cannot load the WebFOCUS web application, review the application server logs and WebFOCUS logs, such as the event.log for errors.
    • WebFOCUS logs are created in the drive:\ibi\WebFOCUS82\logs folder.
    • Log names for the dbupdate and dbcheck utilities are named db_inplace_update_<timestamp>.log and db_check_version__<timestamp>.log.
  • If the database update was successful, and the application server fails to start and db_check_version indicates that the database is not up to date, ensure that the application server cache is cleared and attempt to restart the application server and connect to WebFOCUS.

WebFOCUS

Feedback