Upgrade Wizard Aborted At Alter S_USER_EVENT Table

(Doc ID 2389176.1)

Last updated on MAY 29, 2018

Applies to:

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

Symptoms

On : 17.5 [IP2017] version, Upgrade

When attempting to upgrade from Siebel 15.18 to 17.5,
the following error occurs.

ERROR
-----------------------
2018-03-01 15:40:00 Merging table S_USER_EVENT ...
2018-03-01 15:40:00 Adding 3 column(s) in batch ...
2018-03-01 15:40:00 column BUILD_NUMBER
2018-03-01 15:40:00 column DATA_PURPOSE
2018-03-01 15:40:00 column LOGIN
2018-03-01 15:40:00 SQL Statement:
alter table S_USER_EVENT
  add "BUILD_NUMBER" varchar2(30 char) not null
  add "DATA_PURPOSE" varchar2(30 char)
  add "LOGIN" varchar2(50 char) not null
2018-03-01 15:40:00 [1076673536][ODBC 20101 driver][20101]ORA-01758: table must be empty to add mandatory (NOT NULL) column

2018-03-01 15:40:00
2018-03-01 15:40:00 60: [1076673536][ODBC 20101 driver][20101]ORA-01758: table must be empty to add mandatory (NOT NULL) column
2018-03-01 15:40:00
2018-03-01 15:40:00 alter table S_USER_EVENT
2018-03-01 15:40:00 add "BUILD_NUMBER" varchar2(30 char) not null
2018-03-01 15:40:00 add "DATA_PURPOSE" varchar2(30 char)
2018-03-01 15:40:00 add "LOGIN" varchar2(50 char) not null


STEPS
-----------------------
The issue can be reproduced at will with the following steps:


1. Configure and use Usage Tracking Pattern (UPT) in previous Siebel version.

2. Run upgrep for upgrading to IP2017

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, upgrade can not continue.

Changes

 

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