Siebel Database Upgrade Guide > Reviewing the Siebel Upgrade Log Files >
Reviewing Siebel Upgrade Log Files for Errors
Environments: Development, production test, production. Platforms: Windows and UNIX only. Does not apply to IBM z/OS. 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_8x
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
- If
summary.html is not already open in your browser, then navigate to siebsrvr\log, and locate the subdirectory for the upgrade process you want to review.
- In the desired upgrade process directory, click
summary.html to open the file in a browser.
- 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.
- Review the parameters, and verify that they are correct.
License key values are encrypted. If you find errors in the parameters, then correct them, and run the upgrade process again as needed.
Determining Whether 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, then 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:
- Resolve errors for steps with a Status of Incomplete.
- Review all the steps with a Status of Complete. If any contain unacceptable errors, then resolve these errors.
- 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, then contact your Oracle sales representative for Oracle Advanced Customer Services to request assistance from Oracle's Application Expert Services. To determine whether the upgrade process completed successfully
- If
summary.html is not already open in your browser, then navigate to siebsrvr\log, and locate the subdirectory for the upgrade process you want to review.
- In the desired upgrade process directory, click
summary.html to open the file in a browser.
- 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.
- Locate the Status column, and verify that all the steps have a status of Complete.
If the Status of all the steps is Complete, then the upgrade process completed successfully.
If the Status of any step is Incomplete, then 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 Whether 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, then 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 whether steps contain unacceptable errors
- If
summary.html is not already open in your browser, then navigate to siebsrvr\log, and locate the subdirectory for the upgrade process you want to review.
- In the desired upgrade process directory, click
summary.html to open the file in a browser.
- 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.
- 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.
- IBM DB2 and Oracle Database: In the detailed information for each step, check the Errors item.
If the value for Errors is None, then the step has no unacceptable errors.
If table lists one or more errors, then these errors are unacceptable and must be corrected. Click the links to the log files to obtain more information about the errors.
- MSSQL: In the detailed information for each step, check the Errors item.
If the value for Errors is None, then the step has no errors.
If there is a table or a link to a table listing errors, then do the following:
- Open the
errors.xls spreadsheet:
Windows: DBSRVR_ROOT \ DATABASE_PLATFORM \errors.xls
UNIX: DBSRVR_ROOT / DATABASE_PLATFORM /errors.xls
If an errors.rtf (Windows) or errors.txt (UNIX) file is present, then you can use either of these files. They contain the same content as errors.xls. The errors file lists benign errors that do not need to be corrected.
- Compare the errors listed in the Logparse
summary.html file to the list of acceptable errors documented in the error file.
The log files generated by Upgrade Wizard appear in the errors file as upgwiz1.log , upgwiz2.log , incrementing for additional log files.
- If you find the error in the
errors file, then the error is acceptable and no action is required.
If you find an error that is not listed in the errors file, then the error is unacceptable. You must correct the condition that caused the error.
- To help resolve unacceptable errors, navigate to 477324.1 (Article ID) on My Oracle Support. Common errors and how to resolve them are listed in this document. If the error is not listed or you cannot resolve it, then contact Oracle Global Customer 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, then familiarize yourself with the performance information in the summary file. To review upgrade performance in the summary file
- If
summary.html is not already open in your browser, then navigate to siebsrvr\log, and locate the subdirectory for the upgrade process you want to review.
- In the desired upgrade process directory, click
summary.html to open the file in a browser.
- On the
summary.html home page, Upgrade/Install Log File Navigation Page, locate the following columns:
- Performance Information for SQL
- Performance Information for DDL
- 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
|