Sfscleanup Deleted The Referenced Files (Doc ID 2071438.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Financial Services CRM - Version 8.1.1.6 SIA [21233] to 15.4 [IP2015] [Release V8 to V15]
Information in this document applies to any platform.

Symptoms

On : 8.1.1.6 SIA [21233] 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.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms