My Oracle Support Banner

Siebel sfscleanup utility Deletes Invalid Files (Doc ID 2147840.1)

Last updated on FEBRUARY 08, 2019

Applies to:

Siebel Call Center - Version 8.1.1.14.5 [IP2014] and later
Information in this document applies to any platform.

Symptoms



ACTUAL BEHAVIOR
---------------
When executing sfscleanup utility a lot of referenced files were marked as Invalid and then deleted


EXPECTED BEHAVIOR
-----------------------
When executing the sfscleanup utility the valid files should never been market as INVALID and then deleted.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:


1. At the command prompt, change directory to the bin subdirectory within the Siebel Server root directory.

2. Execute the command below:

 

 sfscleanup /u <username> /p <password> /C <odbc_datasource> /D <siebel_table_owner> /f <path_filesystem> /x <path_output> /R Y /Q Y /I 500 /T 240 /N Y /S Y

 

Where

 

/U  User name ID
/p  User name password
/C  ODBC_data_source
/D  Siebel_table_owner
/F  Paths for file system directories
/X  Path for output file
/R  Set this value to Y to generate only a report file. If it is set to Y, then the report file contains only the columns File Name and File Type. The default value is N.
/Q  Set /Q Y if you want the utility to perform a query by file attachment records. This parameter allows you to run the utility for a limited period of time and provides other ways to manage how the utility runs. The default value is N.
Note: When you are using /Q Y, you can also use the parameters /I, /O, /S, and /T. Otherwise, these parameters have no effect.
/I  Set /I to the number of file attachment records to query. The default value is 300. The utility processes records and files in batches based on the specified number of records. After those files have been processed, the utility processes more records and files in another batch.
/T  Set /T to the number of minutes to run the query. When the utility reaches that time, the last processed file attachment record is noted in a temporary directory and the utility exits. Later, you can resume the previous run by using /S Y.
/S Use /S Y to resume the previous run, from the next unprocessed record, where information about the last processed record is available in a temporary directory. The default value is N.
/N  Determines whether old versions of file attachments are to be removed. To remove old versions, set this value to Y. The default value is N.
/G  Set this value to remove garbage files or non-Siebel files. The default value is N.

 

 

Example: sfscleanup /u SADMIN /p <SADMIN_PWD> /C esia16_DSN /D siebel /f C:\Siebel\ses\gtwysrvr\fs /x C:\Siebel\ses\gtwysrvr\sfs.log /R Y /Q Y /I 500 /T 240 /N Y /S Y

 

 

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.