Updating File System Attachments

Upgrades: All upgrades.

Environments: All environments

This topic is part of an upgrade process. See Performing a Siebel Database Upgrade.

Filenames of attachments include the attachment table name. If an upgrade migrates the records in an attachment table to a new attachment table, you must run a utility to update the file system attachment names.

Oracle provides a utility to update attachment filenames in the Siebel File System. The following table lists the input table name to use when you run the utility. The utility updates all files containing the table name you specify.

For example, if you specify the tables S_OLDTABLE_ATT and S_NEWTABLE_ATT, the utility updates the files system attachments by copying all attachment files containing the string S_OLDTABLE_ATT to attachment files containing the string S_NEWTABLE_ATT.

Upgrade Path	Old Table	New Table
Upgrades from: 7.5.3, 7.7.x, 7.8.x and 8.0. Siebel Insurance only.	S_INSCLM_BL_ATT	S_INVOICE_ATT

To update file system attachments

Navigate to the following directory:
Windows: SIEBEL_ROOT\bin
UNIX: $SIEBEL_ROOT/bin
Run the following utility:
Windows: chng_file_sys.bat OLD_TABLE NEW_TABLE "FILE_SYSTEM"
UNIX: chng_file_sys.ksh -s OLD_TABLE -t NEW_TABLE -f "FILE_SYSTEM"
where:
- OLD_TABLE. The name of the attachment table in the release you are upgrading from. This table is obsolete in the new release.
- NEW_TABLE. Attachment records in OLD_TABLE were migrated to NEW_TABLE in the new release. The utility copies file system attachments containing the string OLD_TABLE to attachments containing the string NEW_TABLE.
- "FILE_SYSTEM". The name of the directory where the Siebel File System attachments reside (entered inside quotation marks)
  Windows example:
```
chng_file_sys.bat S_INSCLM_BL_ATT S_INVOICE_ATT "C:\siebfile\att"
```
  UNIX example:
```
chng_file_sys.ksh -s S_INSCLM_BL_ATT -t S_INVOICE_ATT-f "/usr/siebel/siebfile/att"
```
Review renamed files carefully to verify that they can be accessed by Siebel Business Applications.
For example, since S_INSCLM_BL_ATT is migrated to S_INVOICE_ATT, verify that files such as S_INSCLM_BL_12-1ABC.SAF are renamed toS_INVOICE_12-1ABC.SAF.