9 Using Reports

This chapter describes how to use the reports available to you through Migration Workbench. It contains the following sections:

Overview
Generating Reports
Viewing and Using Reports
Accessing the Log Window and Log File

Overview

Using Migration Workbench, you can generate a variety of reports. These reports contain information about the source and the destination databases. They summarize the actions that have occurred during the phases of migration and record any warnings and errors that occurred.

These reports allow you to:

Make calculated decisions about the migration project
Identify the size and scope of the destination database that Migration Workbench has created
Determine the amount of the migration that succeeded
Determine how much of the migration process you must perform manually
Evaluate the errors that occurred and determine how long it would take to rectify them

Generating Reports

You can generate reports that provide useful information about the migration process. The types of reports that you can generate from Migration Workbench are Database Detailed, Database Summary, and Database Errors and Warnings reports. After using the Capture wizard, the reports provide a preliminary view of the source database and the destination database. After using the Migration wizard, the reports provide a more complete picture of the migration. You can only generate and view information about the errors and warnings that occur during migration after you have captured the source database using the Capture wizard.

To generate the reports within Migration Workbench:

From the Reports menu, select Generate Database Migration Reports.
Click OK.

Viewing and Using Reports

The following sections describe how to view the different reports that Migration Workbench can produce and how to interpret the information contained in the reports.

The Database Summary report contains a list of schema object types and indicates the total number of schema objects that you migrated using Migration Workbench. It also displays the number of schema objects that failed to migrate. If you migrated several source databases, the Database Summary report provides the schema object information for each source databases.

The Database Detailed report shows all of the schema objects that you have migrated and whether they have passed or failed the migration. It also provides information about each source database that you captured.

The Database Errors and Warnings report lists error or warning messages that occurred during the migration of each source database. It shows the phase of the migration during which the error or warning incurred and provides a detailed message for each type of schema object.

Note:

Rename the HTML reports before generating new reports because each time you generate the reports, the previous reports are overwritten.

Viewing the Database Summary Report

To view the Database Summary report:

From the Reports menu, select View Report.

The Open dialog box appears displaying the contents of the Log directory.
- On Windows:
```
OMWB_install_dir\Omwb\log
```
- On UNIX:
```
OMWB_install_dir/Omwb/log
```
Select the Database directory.
Select the Summary_report.htm file, then click Open.

The Database Summary report is displayed in your default browser.

Table 9-1 describes the information that appears in the Database Summary report:

Table 9-1 Database Summary Report

Item	Description
Migration Date	The date and time the migration occurred.
Migration Workbench Release	The release and plug-in information.
Source Database	The name of the migrated third-party database.
Object Type	The type of schema objects are listed. Click the object type to obtain more detailed information.
Total number of objects to migrate	The total number of schema objects from the Source Model that you can migrate to the destination database.
Number of Objects Failed	The number of schema objects that failed to migrate. The failure may have occurred: When using the Capture wizard to create the Oracle Model When using the Migration wizard

The Database Summary report contains links to the other reports. To view more detailed information about the schema object, click on a schema object name. To view more information about the objects that failed to migrate, click the number link in the failed column.

Using the Database Summary Report

To use the Database Summary report:

Review the number of objects failed.
Evaluate the number of errors that you can fix.
If you made changes, migrate the source database again.
Calculate the manual effort required after migration.

Viewing the Database Detailed Report

To view the Database Detailed report:

From the Reports menu, select View Report.

The Open dialog box appears displaying the contents of the Log directory.
- On Windows:
```
OMWB_install_dir\Omwb\log
```
- On UNIX:
```
OMWB_install_dir/Omwb/log
```
Select the Database directory.
Select the Detailed_report.htm file, then click Open.

The Database Detailed report is displayed in your default browser.

Table 9-2 describes the information that appears in the Database Detailed report:

Table 9-2 Database Detailed Report

Item	Description
Migration Date	The date and time of the migration.
Migration Workbench Release	The release and plug-in information.
Source Database	The name of the database that you migrated.
Database Objects	Detailed information about each migrated schema object. Warning and error information for specific schema objects are also listed.
New Oracle Objects	The schema objects created for Oracle, such as tablespaces.
Automatic Name Changes	The name changes that Migration Workbench automatically made when generating the Oracle Model.

Using the Database Detailed Report

To use the Database Detailed report:

Check that the New Oracle Objects and the Automatic Name changes.
Change each application to reflect the new schema object names.
Use the new schema object names when connecting to the destination database.
Test the application with the destination database to verify the schema object name changes were successful.

Viewing the Database Errors and Warnings Report

To view the Database Errors and Warnings report:

From the Reports menu, select View Report.

The Open dialog box appears displaying the contents of the Log directory.
- On Windows:
```
OMWB_install_dir\Omwb\log
```
- On UNIX:
```
OMWB_install_dir/Omwb/log
```
Select the Database directory.
Select the Errors_and_Warnings_Report.htm file, then click Open.

The Database Errors and Warnings report is displayed in your default browser.

Table 9-3 describes the information that appears in the Database Errors and Warnings Report:

Table 9-3 Database Errors and Warnings Report

Item	Description
Migration Date	The date and time of the migration.
Migration Workbench Release	The release and plug-in information.
Source Database	The name of the migrated third-party database.
Type	The type of message is either an error or a warning. An error is indicated by a red octagon with an X. A warning appears as a yellow triangle with an exclamation mark (!) through it.
Phase	The phase in the migration process in which the error or warning occurred.
Object Name	The name of the schema object that generated the error or warning.
Errors and Warnings	The error message and the suggested action.

Using the Database Errors and Warnings Report

The Database Errors and Warnings report categorizes messages into errors and warnings. It provides the reason each error and warning occurred on a schema object as follows:

Symbol	Description	Message Type	Reason for Message
Description of the illustration ch8a.gif	Red X	Error	The transaction failed.
Description of the illustration ch82.gif	Yellow triangle	Warning	The transaction did not fail, but may need manual modifications

To use the Database Errors and Warnings report:

Identify the objects that failed to migrate.
Fix the migrated database objects.
Run the application against the destination database to verify the modifications have been implemented.

Accessing the Log Window and Log File

Migration Workbench displays messages during each phase of the migration process in the Log window. You can also save the information in the Log window to a text file. The default file directory is as follows:

On Windows:
```
OMWB_install_dir\Omwb\log
```
On UNIX:
```
OMWB_install_dir/Omwb/log
```

To view the Log window after migration, from the Tools menu, select Log Window.

To save the Log window to a file:

From the File menu, select Save.

The Save as dialog box appears.
If necessary, modify the default file name, logs.txt, and directory location, then click Save to save the file.