Siebel 8.1.1.10 Patch Upgrade Failed At IRM Import Step (Doc ID 1549574.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel System Software Upgrade - Version 8.1.1.9 [23016] and later
Information in this document applies to any platform.

Symptoms

Environment
=======

8.1.1.9 [23016]/ SQL Server 2005 SP2

Description
========

You are getting errors while running IRM process.

ddlimp shows the errors below


DBCLog DBCLogError 1 00000002516d1030:0 2013-04-17 13:42:43 [Microsoft][SQL Native Client][SQL Server]The statistics '_dta_stat_327268521_1_269_9' is dependent on column 'PAR_ROW_ID'.

SQLDBUtilityLog SQLDBUtilityLog 3 00000002516d1030:0 2013-04-17 13:42:43 37000: [Microsoft][SQL Native Client][SQL Server]The statistics '_dta_stat_327268521_1_269_9' is dependent on column 'PAR_ROW_ID'.

SQLError Statement 0 00000002516d1030:0 2013-04-17 13:42:43 SQL Statement:
alter table S_ORG_EXT alter column "PAR_ROW_ID" nvarchar(15) not null

DBCLog DBCLogError 1 00000002516d1030:0 2013-04-17 13:42:43 [Microsoft][SQL Native Client][SQL Server]ALTER TABLE ALTER COLUMN PAR_ROW_ID failed because one or more objects access this column.

Impact
======

Not available.

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