Upgrading From an Earlier 8.2.x Release to Release 8.2 Version 01M

Upgrade Installation Steps

How to:

Manually Run the Database Utility Post-Installation

Reference:

Troubleshooting the Upgrade Installation

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.

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.

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

Ensure that the database is running.
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.
Type the database repository user name and password, when prompted.

Note: Credentials used for the database update utility need privileges to allow table changes.
After a successful database update, clear the application server cache and then start the application server.
Confirm that the connection to WebFOCUS is functional and that the content is correct.
Add the new Manager roles, using the Role Update Utility in the WebFOCUS Administration Console.
1. Sign in to WebFOCUS as an administrator.
2. From the Menu bar, click 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. Under the following Roles, click Add, to add them to your environment:
  - WebFOCUSManager
  - WebFOCUSManagerDomainRestrictions
  - WebFOCUSManagerFolderRestrictions
  - WebFOCUSManagerRestrictions
  - WebFOCUSManagerServerAccess
Run the following utility to update roles and user groups, and include new templates that are available for portal development:
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.
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
Close the Administration Console.

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.