Error in sfscleanup log : Unable to find table INVALIDS_ORPHANS in the Siebel Repository and Cannot move directory. (errno = 2)

(Doc ID 2190017.1)

Last updated on AUGUST 31, 2017

Applies to:

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

Symptoms

On : 8.1.1.11 [IP2013] version, System Admin

When attempting to run sfscleanup, the following error occurs.

ERROR
-----------------------

GenericLog GenericError 1 0000000257df0070:0 2016-09-19 10:44:03 /siebelfs/att/att_DR: Cannot move directory. (errno = 2)
GenericLog GenericError 1 0000000257df0070:0 2016-09-19 10:44:03 /siebelfs/att/att: Cannot move directory. (errno = 2)
GenericLog GenericError 1 0000000257df0070:0 2016-09-19 10:44:20 Unable to find table INVALIDS_ORPHANS in the Siebel Repository
SQLError Statement 0 0000000257df0070:0 2016-09-19 10:44:22 SQL Statement:
SELECT FILE_REV_NUM,ROW_ID FROM SIEBEL.S_ACTIVITY_ATT
DBCLog DBCLogError 1 0000000257df0070:0 2016-09-19 10:44:22 [DataDirect][ODBC lib] Function sequence error
GenericLog GenericError 1 0000000257df0070:0 2016-09-19 10:44:22 [ODBC][0][S1010] [DataDirect][ODBC lib] Function sequence error


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. source siebenv.sh
2. Run the command as below
./sfscleanup /U sadmin /P **** /C <> /D SIEBEL /F "/siebelfs" /X "/siebel/siebsrvr/log/SFSCleanup_log.txt" /M /siebelfs/discard /G Y /N Y

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot clean up orphan records.

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