Bookshelf Home | Contents | Index | Search | PDF |
Upgrade Guide for Microsoft Windows > Postupgrade Tasks > Postupgrade Tasks for All Environments >
Updating File System Attachments
During the Siebel database upgrade, data from the inactive table
S_EMPLOYEE
was migrated toS_CONTACT, S_USER, S_EMP_PER
and data fromS_ORG_INT
was migrated toS_ORG_EXT
. Attachments inS_ORG_INT_ATT
were migrated toS_ACCNT_ATT
and attachments inS_EMPLOYEE_ATT
were migrated toS_CONTACT_ATT
.NOTE: If your upgrade to Release 7.5 was from Release 7.x, files from
S_WEB_CNTNT
were migrated toS_CB_ASSET_VER
.Data migration affects the physical file structure of the Siebel File System. Therefore, you need to run a utility to rename file attachments that correspond to inactive tables for Release 7.x so that they are accessible by Siebel eBusiness Applications. For example, this utility copies and renames all files named
S_EMPLOYEE_ATT*.SAF
toS_CONTACT_ATT*.SAF
and all files namedS_ORG_INT_ATT*.SAF
toS_ACCNT_ATT*.SAF
so that they correspond to new table names.
- Enter the following command from
SIEBEL_ROOT
\siebsrvr\bin
:
chng_file_sys.bat
SOURCE_TABLE TARGET_TABLE
"
FILE_SYSTEM"
SOURCE_TABLE
= name of the original, inactive, tableTARGET_TABLE
= name of the new table to which the original data was migrated"
FILE_SYSTEM"
= name of the directory where the file system resides (entered inside quotation marks)
chng_file_sys.bat S_EMPLOYEE_ATT S_CONTACT_ATT
"D:\DBSRVR_ROOT\Files"
Review the renamed files carefully to verify that they can be accessed by Siebel eBusiness Applications.
CAUTION: Make sure that attachment files for obsolete tables are renamed or copied to alternate locations.
For example, sinceS_EMPLOYEE_ATT
is migrated toS_CONTACT_ATT
, you need to rename a file such asS_EMPLOYEE_
12-1ABC
.SAF
toS_CONTACT_
12-1ABC
.SAF
.If you upgraded from Release 7.0.3 or 7.0.4, data in S_LIT was migrated to S_CB_ASSET_VER; therefore, you need to migrate files associated with migrated records. Perform the following steps to copy the files named S_LIT*.SAF and rename them to S_CB_ASSET_VER*.SAF, so that the files correspond to the new table name.
To migrate S_LIT files to S_CB_ASSET_VER
- Enter the following command from
SIEBEL_ROOT
\siebsrvr\bin
:file_upg_mm.bat
ODBC_SOURCE
USER_NAME
PASSWORD
TABLE_OWNER
FILE_SYSTEM_LOCATION SIEBEL_ROOT_DIRECTORY
"SIEBEL_DBSRVR_ROOT_DIRECTORY"
ODBC_SOURCE
= the ODBC source of the databaseUSER_NAME
= the database user namePASSWORD
= the password for the database user nameTABLE_OWNER
= the database tableowner (if your implementation is on iSeries, you can use the value provided forUser_Name
)- "
FILE_SYSTEM_LOCATION
" = the directory where the file system resides (entered inside quotation marks)- "
SIEBEL_ROOT_DIRECTORY
" = the directory where Siebel Server is installed (entered inside quotation marks)- "
SIEBEL_DBSRVR_ROOT_DIRECTORY
" = the directory where Siebel Database Server is installed (entered inside quotation marks)file_upg_mm.bat SEBL sadmin sadminpw SIEBEL "D:\
DBSRVR_ROOT
\Files" "D:\SEBLSRVR_ROOT
" "D:\DBSRVR_ROOT
"Review the renamed files carefully to verify that they can be accessed by Siebel eBusiness Applications.
Bookshelf Home | Contents | Index | Search | PDF |
Upgrade Guide for Microsoft Windows Published: 20 October 2003 |