Error In Import Of SIFs And Seed Data For IRM Siebel 8.1.1.10

(Doc ID 1582683.1)

Last updated on MARCH 02, 2017

Applies to:

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

Symptoms

We have just upgraded our DEV environment from Siebel Public Sector 8.1.1.7 (QF0703) to 8.1.1.10 (QF0102001), and we are experiencing some errors when it comes to the Incremental Repository Merge (IRM) process.

I have just performed the steps in http://docs.oracle.com/cd/E14004_01/books/UPG/UPG_IRM_Merge.html (Importing SIF Files and Seed Data for an Incremental Repository Merge), and when reviewing the log files after I ran the import.bat file, I could see some errors, please have a look at ddlimp.txt and dataimp_Seed.

In the logs, we find the following:

Filename = dataimp_seed.log

Invalid object name 'dbo.S_TAG'.

2013-07-29 15:29:15 SQL Statement:
select t.ROW_ID, t.CREATED, t.CREATED_BY, t.LAST_UPD, t.LAST_UPD_BY, t.MODIFICATION_NUM, t.CONFLICT_ID, t.NAME, t.DB_LAST_UPD, t.DB_LAST_UPD_SRC, t.DESC_TEXT from dbo.S_TAG t

2013-07-29 15:29:15 [Microsoft][SQL Native Client][SQL Server]Statement(s) could not be prepared.

2013-07-29 15:29:15 37000: [Microsoft][SQL Native Client][SQL Server]Statement(s) could not be prepared.

2013-07-29 15:29:15 DATAIMP-ERR-1124: Unable to import table "S_TAG" (UTLOdbcOutputBind select).

Filename = ddlimp.log

013-07-29 15:29:15 [Microsoft][SQL Native Client][SQL Server]There is already an object named 'CX_AGR_ROUTE' in the database.

2013-07-29 15:29:15

2013-07-29 15:29:15 S0001: [Microsoft][SQL Native Client][SQL Server]There is already an object named 'CX_AGR_ROUTE' in the database.

...


2013-07-29 15:29:15 writeExecDDL error (UTLOdbcExecDirectDDL pDDLSql).

2013-07-29 15:29:15 writeExecDDL error (pOperCallback UTLDbDdlOperTblCreate).


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