Sfscleanup Deleted The Referenced Files
Last updated on MARCH 02, 2017
Applies to:Siebel Financial Services CRM - Version 184.108.40.206 SIA  to 15.4 [IP2015] [Release V8 to V15]
Information in this document applies to any platform.
On : 220.127.116.11 SIA  version, System Admin
sfscleanup deleted the referenced files
The SFSCLEANUP utility was scheduled to run to delete the orphan attachments. But the job deleted 2 million attachments out of total 3 million files, which were not orphan and had correct reference in the tables.
This issue occurred in production, and had a severe impact where most of the users lost the attachments.
Before we run the utility again, we would like to know the reason the utility deleted the correct attachments.
The command line used to run the utility is below:
SIEBEL_DATA_SOURCE=****** ; export SIEBEL_DATA_SOURCE
SIEBEL_TABLE_OWNER=****** ; export SIEBEL_TABLE_OWNER
SIEBEL_REPOSITORY="Siebel Repository" ; export SIEBEL_REPOSITORY
$SIEBEL_ROOT/bin/sfscleanup /U $dbuser /P $dbpwd /F /gpfs/siebel/fs /X $SIEBEL_ROOT/log/sfscleanup_sh.log
When analysed the log file of the utility, it has marked the attachments as orphan and deleted them
S_CONTACT_ATT_1-JSXA-1811_1-JSX8-1EC.SAF ORPHAN DELETED
But we also find the entry for this file in the S_CONTACT_ATT table.
Could you please let us know on the earliest on this issue.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms