Post Installation Database Update

Post Installation Database Update (the PostInstallDBSetup utility) runs whenever you install the latest monthly update as an update for an existing deployment of Siebel CRM 17.x or later. Where applicable, you run the PostInstallDBSetup utility on every Siebel database (both development and Runtime Repository environments).

Note: Post Installation Database Update is integrated with Siebel Enterprise Server installer and it applies to update installations only; it does not apply if you are installing a new Siebel database or running an Incremental Repository Merge.

The PostInstallDBSetup.zip file, located in the siebsrvr\bin folder, contains the payload for PostInstallDBSetup. Unzip the file to review the updates that the PostInstallDBSetup utility will run.

The PostInstallDBSetup utility runs several processes to ensure that the customer database schema, manifest, and seed data is up to date for the current monthly update release.

You can select whether to execute, defer, or skip running the PostInstallDBSetup utility during the update installation, as follows:

• Execute. Select this option if you want the installer to collect the database details you provide (see Database Configuration in Siebel Enterprise Server Installer) and run the PostInstallDBSetup Utility. This option is selected by default.

• Defer-Generate DDL files only. Select this option if you want the installer to collect the database details you provide (see Database Configuration in Siebel Enterprise Server Installer) and generate an SQL file containing Data Definition Language scripts for running the PostInstallDBSetup utility manually later.

  If you select this option, the installer does not run the PostInstallDBSetup utility and you must manually run the PostInstallDBSetup utility later after completing the update installation. For more information, see Postpone Running Post Installation Database Update.

• Skip. Select this option if you do not want the installer to run the PostInstallDBSetup utility and to ignore any data you specify. For example, use this option in installation cases where PostInstallDBSetup is not required. For more information, see Skip Post Installation Database Update.

You must provide valid values to the PostInstallDBSetup utility. If the utility does not complete correctly or if you provide invalid values, then the utility exits. Where applicable, you must then run the PostInstallDBSetup utility manually, as described in Rerunning Post Installation Database Update.

After the PostInstallDBSetup utility has completed running (see step 3 in Database Configuration in Siebel Enterprise Server Installer), a Post Installation Database Update Report is automatically generated.

Post Installation Database Update should be run as part of the server installation process, but can also be run manually in situations where you require DBA assistance to make schema changes. For more information, see Postpone Running Post Installation Database Update.

Other activities and utilities that Post Installation Database Update is responsible for running include the following:

• WSRanking utility. For more information, see Logging and Diagnostics.

• WFUpgrade utility. For more information, see Logging and Diagnostics.

• TaskUpgrade utility. For more information, see Logging and Diagnostics.

• REP_VER_NUM creation. For more information, see Siebel Repository and Workspace Version Tracking

• Workspace enables List of Values. For more information, see How PostInstallDBSetup Fully Workspace Enables List of Values

Note: After applying a Siebel CRM monthly update, the PostInstallDBSetup utility must be successfully run before attempting to use any Siebel CRM component.