Siebel Remote: Database Extract Fails After Upgrade with errors SBL-SMI-00077 and '[Microsoft][SQL Server Native Client 11.0][SQL Server]Index (...) does not exist' (Doc ID 2081283.1)

Last updated on JULY 11, 2017

Applies to:

Siebel CRM - Version 15.2 [1P2015] and later
Information in this document applies to any platform.

Symptoms

Siebel Remote / Replication / Anywhere - on version: 15.2 [1P2015]

On a Development environment, Database Extract Fails after upgrading to IP2015

After upgrading from Siebel Public Sector 8.2.2.4 PatchSet 16 to IP2015 PatchSet 2 (upgrade has completed correctly) - the environment was up and running.
But when trying to run Database Extract (DbXtract) in order to get local databases for all developers, that keeps failing.

ERROR
-----------------------
[Microsoft][SQL Server Native Client 11.0][SQL Server]Index 'S_EVT_ACT_F3' on table 'dbo.S_EVT_ACT' (specified in the FROM clause) does not exist.
DBXTRACT: Database returned error.
...
SBL-SMI-00077: Component error, see the trace file for more information

The complete section from DbXtract log showing the problem:

 

Trace TracingInfo 3 000002ee56490888:0 2015-11-16 15:35:26
Part 1: Initializing temporary tables...
SQLError Statement 0 000002ee56490888:0 2015-11-16 15:35:27 SQL Statement:
insert into #S_DOCK_ITEM_ACT_T (ROW_ID)
select DISTINCT ea.ROW_ID
from dbo.S_SRC s,
dbo.S_EVT_ACT ea WITH (INDEX (S_EVT_ACT_F3))
where s.ROW_ID = ea.SRC_ID
and s.SUB_TYPE in ('PROMOTIONAL_EVENT','PLAN','OTHER')
DBCLog DBCLogError 1 000002ee56490888:0 2015-11-16 15:35:27 [Microsoft][SQL Server Native Client 11.0][SQL Server]Index 'S_EVT_ACT_F3' on table 'dbo.S_EVT_ACT' (specified in the FROM clause) does not exist.
Trace TracingInfo 3 000002ee56490888:0 2015-11-16 15:35:27 DBXTRACT: Database returned error.
Trace TracingInfo 3 000002ee56490888:0 2015-11-16 15:35:27 37000: [Microsoft][SQL Server Native Client 11.0][SQL Server]Index 'S_EVT_ACT_F3' on table 'dbo.S_EVT_ACT' (specified in the FROM clause) does not exist.
Trace TracingInfo 3 000002ee56490888:0 2015-11-16 15:35:27
Part 4: Deleting from temporary tables...
Trace TracingInfo 3 000002ee56490888:0 2015-11-16 15:35:27 Error while processing client "DVU-BJAH". Results may be incomplete.
Trace TracingInfo 3 000002ee56490888:0 2015-11-16 15:35:27 2015-11-16 15:35:27
GenericLog GenericDebug 5 000002ee56490888:0 2015-11-16 15:35:27 Process Name: Database Extract, Status: Completed with Errors, Message
Trace TracingInfo 3 000002ee56490888:0 2015-11-16 15:35:27 ODBC call returned error
Trace TracingInfo 3 000002ee56490888:0 2015-11-16 15:35:29 ERROR: 1 client(s) failed with errors, 0 client(s) successful
GenericLog GenericError 1 000002ee56490888:0 2015-11-16 15:35:29 (smisched.cpp (923) err=1376333 sys=0) SBL-SMI-00077: Component error, see the trace file for more information


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, developer users cannot have their Local DBFs extracted and initialized.

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