Siebel Database Upgrade Guide > Postupgrade Tasks for Siebel Applications >
Configuring Siebel Products and Quotes Data
Upgrades from: Siebel 6.x. Environments: Production test, production. This topic is part of an upgrade process. See How to Perform a Siebel Database Upgrade. You may need to adjust or configure some customizable products and quotes after upgrade. Customizable Products
After upgrading to Siebel 7.7.x, the administrator must verify that customizable products work as needed. In order to do so, the administrator must validate and release customizable products for use. This action is performed in the Product Administration screen. If the administrator does not release customizable products after the upgrade, customizable products are not active. Packaged products do not require additional modifications in the postupgrade process. Quote Items
After upgrade, run the following script to fix an issue where quote items had trailing spaces added accidentally. Running this script is mandatory. update S_QUOTE_ITEM
setROW_ID = rtrim(ROW_ID)
, ROOT_QUOTE_ITEM_ID = rtrim(ROOT_QUOTE_ITEM_ID)
, PAR_SQ_ITEM_ID = rtrim(PAR_SQ_ITEM_ID)
, PORT_VALID_PROD_ID = rtrim(PORT_VALID_PROD_ID)
, PROD_PORT_ID = rtrim(PROD_PORT_ID)
, INTEGRATION_ID = rtrim(INTEGRATION_ID)
;
commit
;
File System Attachments for Quotes
During the upgrade, quote attachments from S_QUOTE_ATT are migrated to S_ORDER_ATT . This updated the records in the database and the pointer to the physical file, but did not update file system attachments, which use a naming convention that includes the name of the table they are associated with: TableName_RowID_Revision #.saf . You must run a script to copy and rename certain files named S_QUOTE*.SAF to S_ORDER*.SAF so that they correspond to new table names. To update the file names of quote attachments
- Navigate to the following directory:
Windows: SIEBEL_ROOT \bin
UNIX: $SIEBEL_ROOT/bin
- Type the following command:
Windows:
odbcsql /s "ODBC_DATASOURCE" /u TABLEOWNER /p PASSWORD /separator / /a /c rem /e /h /o FILESYSTEM_LOCATION/MV_QUOTE_TO_ORDER_ATT_NT.bat /l LOGFILE_LOCATION/MV_QUOTE_TO_ORDER_ATT_NT.log SCRIPT_LOCATION/ MV_QUOTE_TO_ORDER_ATT_NT.sql /v y
UNIX:
odbcsql /s "ODBC_DATASOURCE" /u TABLEOWNER /p PASSWORD /separator / /a /c rem /e /h /o FILESYSTEM_LOCATION/mv_quote_to_order_att_unix.ksh /l LOGFILE_LOCATION/mv_quote_to_order_att_unix.log SCRIPT_LOCATION/ mv_quote_to_order_att_unix.sql /v y
where:
"ODBC_DATASOURCE" = Data source of the database (entered in quotation marks)
TABLEOWNER = Tableowner
PASSWORD = Tableowner password
FILESYSTEM_LOCATION = Location of the file system
LOGFILE_LOCATION = Location of the log file
SCRIPT_LOCATION = Location of the script
|
|
|
|
/s |
"ODBC_DATASOURCE"
|
Data source of the database (entered in quotation marks) |
Y |
/u |
TABLEOWNER
|
User name to log into database |
Y |
/p |
PASSWORD
|
Password to log into database |
Y |
/a |
Not applicable |
Turn on ODBC auto-commit for session |
N |
/c |
rem
|
Remark. Specify the string that begins at comment (at the beginning of the line) |
Y |
/o |
FILESYSTEM_LOCATION
|
Directory where the file system resides |
Y |
/l |
LOGFILE_LOCATION
|
Write errors and status to log file specified here |
Y |
|
SCRIPT_LOCATION |
Location of the script |
Y |
/v |
Not applicable |
Turn on statement printing at execute |
N |
- Change your directory to the file system, then type the following command:
Windows: MV_QUOTE_TO_ORDER_ATT_NT.BAT
UNIX: mv_quote_to_order_att_unix.ksh
|