My Oracle Support Banner

SFSCLEANUP Deletes Attachment Files Generated by BIP (Doc ID 1436009.1)

Last updated on AUGUST 19, 2022

Applies to:

Siebel Life Sciences CRM - Version 8.1.1 [21112] to 8.1.1.9 [23016] [Release V8]
Information in this document applies to any platform.

Symptoms

In Siebel Reports, BI Publisher generate reports. These reports are stored as attachments in the Siebel File System (base table is S_XMLP_REPOUTPT).
When the sfscleanup utility is run with delete option, the S_XMLP_REPOUTPT_*.SAF files are marked Orphans (even the valid ones) and deleted.

Steps to Reproduce
This issue can be reproduced at will with the following steps:

1. Execute the sfscleanup utility in report mode (so the files will not be deleted), e.g.:
sfscleanup /u sadmin /p sadmin /c esia81_DSN /f "\\myserver\fs" /d siebel /n Y /r Y /x "C:\clean\sfscleanup1.log"

2. All S_XMLP_REPOUTPT_*.SAF files are marked ORPHAN, e.g.:
    S_XMLP_REPOUTPT_1-1BCA_1-5V.SAF ORPHAN
    S_XMLP_REPOUTPT_1-1BDE_1-5Y.SAF ORPHAN

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.