Siebel CRM 8.1.1.11 Merge exit "Operation aborted due to general error"

(Doc ID 1604417.1)

Last updated on MARCH 01, 2018

Applies to:

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

Symptoms

On : 8.1.1.11 SIA [23030] version, Upgrade

When attempting to run IRM Delta Merge,
the following error occurs.

ERROR
-----------------------
"The Wizard Encountered Errors During Merge"

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. install 8.1.1.11
2. run IRM steps, it fails during delta merge execution

NOTE: The same issue has been noticed for full Siebel upgrade processes, for instance from 8.1.1 SEA to 8.1.1.11 SIA.


irm_merge0.txt shows the error :

"Operation aborted due to general error "

with no other meaningful previous error

 

Siebdev.log shows the error :

SQLError Statement 0 00000002528b17e4:0 2013-11-19 16:18:15 SQL Statement:
UPDATE SIEBEL.S_MERGE_LOG_ATTR SET CONFLICT_RES_TYPE = 'Info' WHERE MERGE_LOG_ID = '1-51KYL' AND CONFLICT_FLG = 'Y' AND (ATTRIBUTE IN ('Comments','Column Span','Sequence','Layout','Language Locked') OR ATTRIBUTE LIKE 'Upgrade%' OR ATTRIBUTE LIKE 'Item%' ESCAPE '\' )

DBCLog DBCLogError 1 00000002528b17e4:0 2013-11-19 16:18:15 [tp][ODBC Oracle driver][Oracle]ORA-00904: "CONFLICT_RES_TYPE": invalid identifier

but this column exist on S_MERGE_LOG_ATTR

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