Bookshelf Home | Contents | Index | PDF     

Siebel Database Upgrade Guide > Reviewing the Siebel Upgrade Log Files >

Reviewing Siebel Upgrade Log Files for Errors

Upgrades from: All Siebel releases.

Environments: Development, production test, production.

Platforms: Windows and UNIX only. Does not apply to IBM z/OS.

This topic is part of an upgrade process. See How to Perform a Siebel Database Upgrade.

Using the Logparse utility to review the log files created when you run Upgrade Wizard is the recommended way to verify that the upgrade process completed correctly and to identify errors that must be resolved.

The Logparse utility writes its findings to a summary file:

Windows: SIEBEL_ROOT\log\process\summary.html

UNIX: $SIEBEL_ROOT/log/process/summary.html

where

process is the upgrade process you want to review, for example upgrep_dev_77

Logparse also writes a summary.txt file that contains the same information as summary.html. Use the summary.txt file if you do not have a browser.

The procedures in this topic describe how to review the summary.html file.

Verifying the Upgrade Environment

Before reviewing the upgrade steps for errors, verify that the upgrade environment is set up correctly.

To verify the upgrade environment

  1. If summary.html is not already open in your browser, navigate to siebsrvr\log, and locate the subdirectory for the upgrade process you want to review.
  2. In the desired upgrade process directory, click summary.html to open the file in a browser.
  3. On the summary.html home page, Upgrade/Install Log File Navigation Page, locate the Parameter column in the table, and click the Parameters link.

    The Parameters page displays.

  4. Review the parameters, and verify that they are correct.

    License key values are encrypted. If you find errors in the parameters, correct them, and run the upgrade process again as needed.

Determining If the Upgrade Process Completed Successfully

The upgrade processes consist of a series of steps. Each step must complete successfully.

If the Upgrade Wizard cannot complete a step, it marks the step incomplete in the state log (siebsrvr\log\Process\state\state.log) and exits. You must correct the error, and run the Upgrade Wizard again. When you rerun the Upgrade Wizard, it refers to the state log and resumes at the incomplete step that contained the error.

Use the following process to identify errors:

  1. Resolve errors for steps with a Status of Incomplete.
  2. Review all the steps with a Status of Complete. If any contain unacceptable errors, resolve these errors.
  3. Restart the Upgrade Wizard, or if necessary, restore the database and rerun the upgrade process.

If you have any questions regarding how to resolve errors, contact Oracle's Siebel Technical Support.

To determine if the upgrade process completed successfully

  1. If summary.html is not already open in your browser, navigate to siebsrvr\log, and locate the subdirectory for the upgrade process you want to review.
  2. In the desired upgrade process directory, click summary.html to open the file in a browser.
  3. On the summary.html home page, Upgrade/Install Log File Navigation Page, locate the Step/Error column in the table and click the Steps/Errors link.

    The Steps/Errors Summary page displays.

  4. Locate the Status column, and verify that all the steps have a status of Complete.

    If the Status of all the steps is Complete, the upgrade process completed successfully.

    If the Status of any step is Incomplete, the upgrade process did not complete successfully. The Upgrade Wizard has exited before completing all the steps in the upgrade process. You must identify the error, and correct it.

    CAUTION:  In some cases, the Upgrade Wizard can complete a step even though the step contains unacceptable errors. You must verify that all steps do not contain unacceptable errors.

Determining if Steps Contain Unacceptable Errors

There are two types of unacceptable errors:

  • The Upgrade Wizard could not complete a step due to an error and exited. You can locate these errors by checking the Status field on the Steps/Errors Summary page. If the Status of a step is Incomplete, the step contains an unacceptable error.
  • The Upgrade Wizard encountered an unacceptable error but was able to complete the step. You can locate these errors by examining the detailed information for each step.

To determine if steps contain unacceptable errors

  1. If summary.html is not already open in your browser, navigate to siebsrvr\log, and locate the subdirectory for the upgrade process you want to review.
  2. In the desired upgrade process directory, click summary.html to open the file in a browser.
  3. On the summary.html home page, Upgrade/Install Log File Navigation Page, locate the Step/Error column in the table, and click the Steps/Errors link

    The Steps/Errors Summary page displays.

  4. In the Name column, click the name link.

    The detailed information for the step displays. An alternate method is to use the slide bar to browse down through the detailed information listing for all the steps.

  5. In the detailed information for each step, check the Errors item.

    If the value for Errors is None, the step has no errors.

  6. If there is a table or a link to a table listing errors, open the errors file:

    Windows: DBSRVR_ROOT\DATABASE_PLATFORM\errors.rtf or errors.htm

    UNIX: DBSRVR_ROOT/DATABASE_PLATFORM/errors.txt

    The errors file lists benign errors that do not need to be corrected.

  7. Compare the errors listed in the Logparse summary.html file to the list of acceptable errors documented in the errors file.

    If you find the error in the errors file, the error is acceptable and no action is required.

    If you find an error that is not listed in the errors file, the error is unacceptable. You must correct the condition that caused the error

    The log files generated by the Upgrade Wizard appear in the errors file as upgwiz1.log, upgwiz2.log, incrementing for additional log files.

  8. To help resolve unacceptable errors, navigate to Siebel SupportWeb > Troubleshooting Steps > Product Areas > Upgrade, and choose Troubleshooting Steps 21. Common errors and how to resolve them are listed in this document. If the error is not listed or you cannot resolve it, contact Siebel Technical Support. Do not proceed with the upgrade.

Determining if Other Log Files Contain Unacceptable Errors

Logparse summarizes the Upgrade Wizard logs. It does not analyze or summarize the logs of upgrade utilities called by Upgrade Wizard. For example, Logparse does not summarize the logs written by the ddlimp and dataimp utilities. You must review these logs for unacceptable errors.

To determine if other log files contain unacceptable errors

  1. Open the errors file:

    Windows: DBSRVR_ROOT\DATABASE_PLATFORM\errors.rtf or errors.htm

    UNIX: DBSRVR_ROOT/DATABASE_PLATFORM/errors.txt

    The errors file lists benign errors that do not need to be corrected.

  2. Navigate to the output directory.

    Windows: SIEBEL_ROOT\log\process\output

    UNIX: $SIEBEL_ROOT/log/process/output

    where

    process is the upgrade process you want to review, for example upgrep_dev_77

  3. Using a text editor identify the logs that need to be reviewed.

    The following logs can be ignored:

      • Logs with names beginning upgwiz or srvrupgwiz. They have either already been analyzed by Logparse, or they contain no useful data.
      • Logs with names beginning sw_cfg_xxx.
      • Logs with the name siebel.log.
  1. Using a text editor open the logs and review them for errors.
  2. Compare any errors to the list of acceptable errors documented in the errors file.

    If you find the error in the errors file, the error is acceptable and no action is required.

    If you find an error that is not listed in the errors file, the error is unacceptable. You must correct the condition that caused the error

  3. To help resolve unacceptable errors, navigate to Oracle's Siebel SupportWeb > Troubleshooting Steps > Product Areas > Upgrade, and choose Troubleshooting Steps 21. Common errors and how to resolve them are listed in this document. If the error is not listed or you cannot resolve it, contact Oracle's Siebel Technical Support. Do not proceed with the upgrade.

Reviewing Upgrade Performance

The Logparse summary file provides the input that Upgrade Tuner uses to analyze the performance of the upgrade scripts. For example, the summary file provides Upgrade Tuner with information about SQL commands that returned 0 rows.

If you plan to use the Upgrade Tuner to tune your production upgrade, familiarize yourself with the performance information in the summary file.

To review upgrade performance in the summary file

  1. If summary.html is not already open in your browser, navigate to siebsrvr\log, and locate the subdirectory for the upgrade process you want to review.
  2. In the desired upgrade process directory, click summary.html to open the file in a browser.
  3. On the summary.html home page, Upgrade/Install Log File Navigation Page, locate the following columns:
    • Performance Information for SQL
    • Performance Information for DDL
  4. Click the links in these columns to display performance information about the upgrade process.

    The Performance Information for SQL page displays the longest running queries and queries that returned 0 rows for SQL scripts.

    The Performance Information for DDL page displays the tables created, altered, and deleted by the ddlimp utility and by SQL scripts.

    In both pages, the Net Cost column lists the time required to perform each operation.

Related Topics

About the Siebel Database Upgrade Log Files

Summarizing Siebel Log Files Using the Logparse Utility

Manually Archiving Siebel Upgrade Log Files

    
Siebel Database Upgrade Guide