Sfscleanup Deleted The Referenced Files
(Doc ID 2071438.1)
Last updated on FEBRUARY 01, 2019
Applies to:Siebel Financial Services CRM - Version 220.127.116.11 SIA  to 15.4 [IP2015] [Release V8 to V15]
Information in this document applies to any platform.
On : 18.104.22.168 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.
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