My Oracle Support Banner

Sfscleanup Deleted The Referenced Files (Doc ID 2071438.1)

Last updated on MARCH 01, 2018

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

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
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.