Example of a Siebel Development Environment Upgrade Flow
This topic presents the flow of steps in part of a typical development environment upgrade. The steps are extracted from an actual driver file. To perform an upgrade, the Upgrade Wizard reads the steps in a driver file and performs the commands the steps contain. The driver file type used in this example is as follows:
Upgrade: Siebel Industry Application (SIA) 8.0 to Siebel SIA 8.1
Environment: Development
Upgrade mode: upgrep
Database: Oracle Database
Multilingual: No
The following table lists the steps in the driver file. The Script or Input File column in the following table lists the SQL file or input file that is executed in each step. The Comment column provides a brief explanation of what the SQL file or input file does. The SQL files used for an upgrade and the contents of the SQL files vary depending on the upgrade mode and database.
Step |
Script or Input File |
Description |
|---|---|---|
Determine collation sequence of database. |
Not applicable |
Determines database sort order. |
Verify repository name |
rename_existing_repositories.sql |
Renames Siebel Repository to Prior Customer Repository. |
Remove interface tables |
dropif-db.sql |
Removes all Siebel Enterprise Integration Manager tables. |
Remove database triggers |
trigdrop-db.sql |
Removes all dynamically created triggers. |
Remove database-level functions and procedures |
drop_db_func_proc.sql |
Removes the exchange rate function: exrate. |
Prepare for table creation |
pret.sql |
Removes specified tables. Performs DDL operations such as adding columns to tables. Performs DML operations such as revising date formats. |
Create temporary tables for SIA |
ddlimp utility ddl_temp_sia.ctl as input |
The input file specifies the structure of the tables to be created or updated. These tables are used to perform data migration and other DML changes. |
Prepare for table creation for SIA |
pret_sia.sql |
Drops specified tables. Performs DDL operations such as adding columns to tables. Performs DML operations such as revising date formats. |
Create and update tables |
ddlimp utility ddl.ctl as input |
The ddl.ctl file specifies the structure of tables to be created or updated. |
Create temporary tables for stored procedures |
ddlimp utility ddlsptbl.ctl as input |
The input file specifies the structure of temporary tables to be created or updated. |
Household data migration for FINS |
Household_Mig_Fins.sql |
Creates and populates specified temporary tables. Then migrates data to them and performs DML operations. Migrates data back to primary tables. Drops temporary tables. |
Prepare for index creation |
preschm.sql |
Performs DML operations. Moves data between tables. Changes data in existing fields based on specified conditions. |
Prepare for index creation for SEA |
preschm_sea.sql |
Same as preschm.sql. |
Prepare for index creation for SIA |
preschm_sia.sql |
Same as preschm.sql. |
Create indexes |
ddlimp utility ddl.ctl as input |
The input file specifies the structure of indexes to be created. |
Delete old license key |
delappkey.sql |
Deletes the Siebel license key from S_APP_KEY. |
Preparation of prior customer repository |
SWTClob.jar |
The SWT to OD Conversion Utility converts Siebel Web Templates to an Object Definition Layout. Converted Web templates are stored in the database. |
Import seed data |
dataimp utility seedupg0.inp as input seedupg1.inp as input seedupg_locale.inp as input |
Prior to importing seed data, dataimp deletes existing seed data. The seedupg* files contain filters that dataimp uses to prevent deleting seed data that you have modified or seed data meeting specified criteria. Unmodified seed data has a last update date (LAST_UPD) of 1980-01-01. Dataimp does not delete records where LAST_UPD is later than this date. |
Upgrade data after seed data import |
upg_data_afterseed.sql |
For customers who have not converted to UTC time, sets the UTC value in S_SYS_PREF to False. For customers who have converted to UTC time, the script takes no action. |
Upgrade data after seed data import SIA |
upg_data_afterseed_sia.sql |
None. |
Set system preference for codepage for DB |
set_codepage.sql |
Sets the database codepage in the S_SYS_PREF. |
Set system preference for Unicode codepage for DB |
set_unicode.sql |
Sets the Unicode codepage to UTF-8 in S_SYS_PREF. |
Update version component information |
upd_upgcomp.sql |
Updates the S_UPG_COMP table with the product release level. The S_UPG_COMP table stores version information for application executable programs. |
Run Oracle-specific DDL commands |
ddlora.sql |
Creates Oracle-specific DDL information, such as default storage parameters for docking objects, repository objects, and seed objects. |
Import common ancestor repository |
repimexp utility Standard Siebel Repository as input |
Imports the Standard Siebel Repository into S_REPOSITORY. For example, if you are upgrading from Siebel 8.1.x, then this command imports the standard Siebel 8.1.x repository. |
Remove EIM columns and indexes |
rmv_anc_eim_proc_col_ind.sql |
Removes Siebel Enterprise Integration Manager processing columns and indexes from the Prior Customer Repository and the common ancestor repository (Standard Siebel Repository). This prevents the repository merge from preserving Siebel Enterprise Integration Manager columns incorrectly. The merge will preserve only those Siebel Enterprise Integration Manager columns shipped with the new release. |
Update Siebel database version |
update_ver.sql seeduver.sql |
The update_ver.sql script creates a temporary table, S_APP_VER_TEMP, which contains new version information for the database schema. The seeduver.sql script updates S_APP_VER with this information. |
Import New Customer Repository |
repimexp utility Imports New Customer Repository |
Imports the New Customer Repository into S_REPOSITORY. Revises schema version information in S_APP_VER. |
Encryption Upgrade |
EncryptionUpgrade.jar |
Siebel Business Applications allow customers to encrypt sensitive information stored in the Siebel database, for example, credit card numbers, Social Security numbers, birth dates. This information cannot be viewed without access to Siebel Business Applications. Sensitive data can be encrypted by using AES (Advanced Encryption Standard). This utility identifies the RC2 encrypted columns and upgrades their data to the AES. This utility updates the logical layer of data for columns which are candidates for encryption. |
Restore database version |
restore_ver.sql |
Uses S_APP_VER_TEMP to update the schema version information in S_APP_VER. Drops S_APP_VER_TEMP. |
Upgrade repository data SIA |
repos_upgrade_sia.sql |
None. |
Upgrade repository data |
repos_upgrade.sql |
Makes specific repository-related changes to repository records and to other tables. |
Set repository workflow domains to MLOV |
set_multilingual.sql |
None. |
Install SQL packages |
seeduver.sql |
Verifies that versions are set correctly in S_APP_VER. |
Install SQL packages |
ifstrg.sql |
Sets storage parameters for Siebel Enterprise Integration Manager tables. |
Install SQL packages |
ifindxstrg.sql |
Sets storage parameters for Siebel Enterprise Integration Manager table indexes. |
Install SQL packages |
pkgseq.sql |
Adds a suffix to row IDs in the S_SEQUENCE table. Ensures that row IDs are unique. |
Install SQL packages |
pkgldel.sql |
Defines s_txn_log_del_proc. Procedure periodically deletes transactions from S_DOCK_TXN_LOG. Also deletes rows from S_DOCK_TXN SET. Prevents need for large rollback segment. |
Install SQL packages |
trgreset.sql |
Ensures that denormalized rows in S_TERR have correct values. |
Install SQL packages |
ddlseq.sql |
Sets sequence numbers for specified tables. |
Install SQL packages |
pkgvis.sql |
Creates function that modifies how Oracle optimizer does visibility check. |
Install SQL packages |
delete_dock_rules.sql |
Deletes Prior Customer Repository routing rules from S_DOC_VIS_RULE that meet specified conditions. Attempts to preserve rules added using Docking Wizard. |
Create database-level functions and procedures |
db_func_proc.sql |
Creates or replaces the currency exchange rate function: exrate. |
Set primary children in data tables |
gen_primary1.sql |
Sets primary child for S_DOC_QUOTE. |
Set primary children in data tables |
gen_primary2.sql |
None. |
Set primary children in data tables |
gen_primary3.sql |
Sets primary child for S_LOY_PROMO. |
Set primary children in data tables |
gen_primary4.sql |
None. |
Fix column alignment for custom objects |
AlignApplet.jar |
Applet alignments are executed based on the
data type of the field. The following alignments are executed across
the entire Repository for a similar look and feel for fields:
|