Preparing Siebel Address Data for Upgrade

Upgrades:

• From Siebel CRM 8.0.x (SEA) to Siebel CRM 8.1.1.x (SIA)

• From Siebel CRM 8.1.x (SEA) to Siebel CRM 8.1.1.x (SIA)

• From Siebel CRM 7.8.2 (SEA) to Siebel CRM 8.1.1 (SIA)

Environments: Test, Production.

Databases: All databases.

At Siebel CRM version 7.7, the way address data is stored changed. To prepare for the revised storage scheme, you must verify that there are no records with the same row IDs within or across the tables S_ADDR_PER and S_ADDR_ORG.

Caution: There must be no duplicate row IDs in these tables or the upgrade will fail.

To prepare address data for upgrade

1. Run rpt_dup_addr_rowids.sql against the Siebel database. The script is located in the following directory:

   Windows: DBSRVR_ROOT\database_platform

   UNIX: DBSRVR_ROOT/database_platform

   In these paths, database_platform is the database type, for example DB2.

2. Review the output generated by the script.

3. If the output contains records with duplicate row IDs, then use Siebel Enterprise Integration Manager or the application to delete unwanted records.

4. After addressing all the duplicate row IDs, rerun the script and verify there are no more duplicates.

Related Topic

Preparing Siebel Territory Management Rules for Upgrade