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

Last updated on MAY 28, 2014

Applies to:

Siebel Life Sciences CRM - Version 8.1.1 SIA [21111] 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

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