My Oracle Support Banner

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

Last updated on FEBRUARY 04, 2019

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

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.