SEA To SIA Upgrade Fails While Updating Table S_PER_ORG_UNIT (Doc ID 1593035.1)

Last updated on DECEMBER 01, 2016

Applies to:

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

Symptoms

Upgrade from 8.1.1 SEA to 8.1.1.10 SIA

When attempting to run upgrep,
the following error occurs.

ERROR
-----------------------
UPDATE S_PER_ORG_UNIT SET RELATION_TYPE_CD = 'N/A' WHERE RELATION_TYPE_CD IS NULL
DBCLog DBCLogError 1 00000002525a06f0:0 2013-10-13 12:23:37 [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'RELATION_TYPE_CD'.
UpgradeLog UpgradeError 1 00000002525a06f0:0 2013-10-13 12:23:37 [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'RELATION_TYPE_CD'.
UpgradeLog UpgradeError 1 00000002525a06f0:0 2013-10-13 12:23:37 Error in function UTLOdbcExecDirect
UpgradeLog UpgradeError 1 00000002525a06f0:0 2013-10-13 12:23:37 Error executing sql statement (
UPDATE S_PER_ORG_UNIT
SET RELATION_TYPE_CD = 'N/A'
WHERE RELATION_TYPE_CD IS NULL).
UpgradeLog UpgradeError 1 00000002525a06f0:0 2013-10-13 12:23:37 Error executing statement (RUN_SQL_10) in file (pret_sea.sql).
UpgradeLog UpgradeInfo 3 00000002525a06f0:0 2013-10-13 12:23:37 Close database connection.
UpgradeLog UpgradeError 1 00000002525a06f0:0 2013-10-13 12:23:37 Execute SQL file action failed.
UpgradeLog UpgradeError 1 00000002525a06f0:0 2013-10-13 12:23:37 Error executing action (Prepare for table creation SEA).
UpgradeLog UpgradeInfo 3 00000002525a06f0:0 2013-10-13 12:23:37 Status Message (Errors encountered)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. upgrade from 8.1.1 SEA to 8.1.1.10, the error occurs during upgrep, pret_sea.sql execution

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