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 to S_CONTACT, S_USER, S_EMP_PER and data from S_ORG_INT was migrated to S_ORG_EXT. Attachments in S_ORG_INT_ATT were migrated to S_ACCNT_ATT and attachments in S_EMPLOYEE_ATT were migrated to S_CONTACT_ATT.

NOTE:  If your upgrade to Release 7.5 was from Release 7.x, files from S_WEB_CNTNT were migrated to S_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 to S_CONTACT_ATT*.SAF and all files named S_ORG_INT_ATT*.SAF to S_ACCNT_ATT*.SAF so that they correspond to new table names.

To upgrade file attachments

• Enter the following command from SIEBEL_ROOT\siebsrvr\bin:

  chng_file_sys.bat SOURCE_TABLE TARGET_TABLE
"FILE_SYSTEM"

  where:

  • SOURCE_TABLE = name of the original, inactive, table
  • TARGET_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)

    Example

  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, since S_EMPLOYEE_ATT is migrated to S_CONTACT_ATT, you need to rename a file such as S_EMPLOYEE_12-1ABC.SAF to S_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"

  where:

  • ODBC_SOURCE = the ODBC source of the database
  • USER_NAME = the database user name
  • PASSWORD = the password for the database user name
  • TABLE_OWNER = the database tableowner (if your implementation is on iSeries, you can use the value provided for User_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)

    Example

  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