Siebel 8.1.1 upgrep process takes long time to insert rows in table S_ASSET_BU

(Doc ID 1560045.1)

Last updated on MARCH 06, 2016

Applies to:

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

Symptoms

When upgrading a Siebel version form 8.0 sea to 8.1.1.10 sia in development upgrade, upgrep step, poor performance is encountered during INSERT SQL statement. It is taking more than 4 hours.

insert into S_ASSET_BU
..

select .. from S_ASSET

where BU_ID not in ('0', 'No Match Row Id') and
not exists(select 'x' from S_ASSET_BU
where (ROW_ID = S_ASSET.ROW_ID) or
(ASSET_ID = S_ASSET.ROW_ID and BU_ID = S_ASSET.BU_ID
and CONFLICT_ID = S_ASSET.CONFLICT_ID))

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