1. Database Upgrade Guide
  2. Reviewing the Hierarchical Merge Report

Reviewing the Hierarchical Merge Report

This task is a step in Process of Upgrading Siebel Development Environment from Siebel CRM 8.1.1.x (SIA Repository). Use this task to review the hierarchical merge log files.

The hierarchical merge report is generated in HTML format for Application Hierarchy objects, which are Application, Screen, View, Business Component, Applet, Table, Business Service, Business Object and Workflow Process. This report allows you to review the tree of a particular object and see exactly what has been changed in the Application Hierarchy. If an object on which the currently selected object depends has changed, then you can drill down on that object and get a better idea of the testing effort involved.

The report is generated in the SIEBSRVR_ROOT\log\upgrep_dev_*\output directory and is named MergeReport.html.

When you run Incremental Repository Merge on Microsoft Windows, the HTML report is generated automatically once the incremental repository merge has completed. On UNIX, you must generate the hierarchical merge report manually, by running MergeReport.bat. Typically, you run this report after running incremental repository merge. For Upgrade, you also must generate the hierarchical merge report manually. MergeReport.bat is located in the $SIEBEL_HOME\reppatch directory.

You are prompted to specify values for the following parameters, which are required to generate the report. Where necessary, you must enclose parameter values in double-quotes.

  • Tools Installation Folder

  • ODBC Data Source Name

  • Database Table Owner

  • Database Table Owner Password

  • Table Owner User Name

  • Tablespace Name

  • Index Space Name

  • 16k Tablespace Name

  • 32k Tablespace Name

  • Is DB Unicode or Not

  • Grantee Role (SSE_ROLE)

  • Repository Name

  • Full Path of Directory in Which to Generate HTML Report

  • Full Path of Log File to Run Patch

  • Database Platform (Oracle, MSSQL, DB2UDB, or DB2390)

  • Merge ID for Report Generation. This value can be identified in Siebel Tools. Log in to Siebel Tools, navigate to Screens menu, then Application Upgrader, Application Upgrade Object List. Select a record and get the row ID from Help, About Record.

  • Generate Report for Latest Merge Run. Enter Y to generate report. Enter N to display all available Merge Log ID.

  • Retain Files for Debugging. Enter N to retain files for debugging. Otherwise, enter Y.