Production-like Upgrade For The Test Environment Failed - Upgrep (Doc ID 1619809.1)

Last updated on JULY 20, 2016

Applies to:

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

Symptoms

Environment
========

V8.1.1.7 SEA

Description
=======

During the upgrade from V7.5.3 SEA to V8.1.1.7 SEA, you are encountering the following error



DBCLog DBCLogError 1 0000000252e110c8:0 2014-01-23 15:26:00 [Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 's_get_next_rowid_proc'.

UpgradeLog UpgradeError 1 0000000252e110c8:0 2014-01-23 15:26:00 [Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 's_get_next_rowid_proc'.

SQLError Statement 0 0000000252e110c8:0 2014-01-23 15:26:00 SQL Statement:
  exec tmp_ws_port_oper

DBCLog DBCLogError 1 0000000252e110c8:0 2014-01-23 15:26:00 [Microsoft][SQL Native Client][SQL Server]Cannot insert the value NULL into column 'ROW_ID', table 'SiebelDB_BIN.dbo.S_WS_PORT_OPER'; column does not allow nulls. INSERT fails.

UpgradeLog UpgradeError 1 0000000252e110c8:0 2014-01-23 15:26:00 [Microsoft][SQL Native Client][SQL Server]Cannot insert the value NULL into column 'ROW_ID', table 'SiebelDB_BIN.dbo.S_WS_PORT_OPER'; column does not allow nulls. INSERT fails.

SQLError Statement 0 0000000252e110c8:0 2014-01-23 15:26:00 SQL Statement:
  exec tmp_ws_port_oper

DBCLog DBCLogError 1 0000000252e110c8:0 2014-01-23 15:26:00 [Microsoft][SQL Native Client][SQL Server]The statement has been terminated.

UpgradeLog UpgradeError 1 0000000252e110c8:0 2014-01-23 15:26:00 [Microsoft][SQL Native Client][SQL Server]The statement has been terminated.

UpgradeLog UpgradeError 1 0000000252e110c8:0 2014-01-23 15:26:00 Error in function UTLOdbcExecDirect

UpgradeLog UpgradeError 1 0000000252e110c8:0 2014-01-23 15:26:00 Error executing sql statement (

exec tmp_ws_port_oper).

UpgradeLog UpgradeError 1 0000000252e110c8:0 2014-01-23 15:26:00 Error executing statement (RUN_SQL_1910) in file (preschm.sql).

UpgradeLog UpgradeInfo 3 0000000252e110c8:0 2014-01-23 15:26:00 Close database connection.

UpgradeLog UpgradeError 1 0000000252e110c8:0 2014-01-23 15:26:00 Execute SQL file action failed.

UpgradeLog UpgradeError 1 0000000252e110c8:0 2014-01-23 15:26:00 Error executing action (Prepare for index creation).

UpgradeLog UpgradeInfo 3 0000000252e110c8:0 2014-01-23 15:26:00 Status Message (Errors encountered)


Impact
=======

Critical because Global training scheduled next week. Project already delayed

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