Sfscleanup Utility Marks Valid Files as ORPHAN (Doc ID 2142081.1)

Last updated on AUGUST 31, 2017

Applies to:

Siebel CRM - Version 15.4 [IP2015] and later
Information in this document applies to any platform.

Symptoms

On : 15.4 [IP2015] version, System Admin

ACTUAL BEHAVIOR
---------------
Not sfscleanup utility works correctly

Hi Oracle Support!

We got a problem.
After the transition from version 8.1.1.10 to 8.1.1.15 sfsfklinap utility does not work correctly.

We run the utility with the following options:

sfscleanup / U SADMIN / P PASSWORD / F \\ sfs \ sblfsprd \ FS \ aa / X C: \ TEMP \ logs \ sfslog1.txt / N Y / C LETO_PROD_DSN / D SIEBEL

Before switching to a new version of the system, utility identifies files as invalid, after the transfer tool has identified them as ORPHAN.

Earlier results were as follows:

  CURRENT: 1156824
  ORPHAN: 16000
  ANCIENT: 6543
  INVALID: 135000

Now the results are as follows:

  CURRENT: 1156824
  ORPHAN: 155127
  ANCIENT: 6543
  INVALID: 8

Please help with problem resolution, for whatever reason the files are defined as INVALID ORPHAN?

 

EXPECTED BEHAVIOR
-----------------------
When sfscleanup is ran, it must generate the INVALID & ORPHAN records properly.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. sfscleanup / U SADMIN / P PASSWORD / F \\ sfs \ sblfsprd \ FS \ aa / X C: \ TEMP \ logs \ sfslog1.txt / N Y / C LETO_PROD_DSN / D SIEBEL


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot distinguish between the files that are marked as invalid and 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