My Oracle Support Banner

Missing Column in the Table "S_PER_ORG_UNIT" (Doc ID 488832.1)

Last updated on JANUARY 29, 2020

Applies to:

Siebel System Software - Version 7.7.2.2 SIA [18356] and later
z*OBSOLETE: Microsoft Windows Server 2003
Version: 7.7.2.2 [18356] SVE Com/Med

Database: Oracle 9i

Application Server OS: Microsoft Windows 2003 Server

Database Server OS: Sun Solaris 8



This document was previously published as Siebel SR 38-1938501831.

Symptoms

The Upgarde wizard runs into the following error message:

alter table S_PER_ORG_UNIT modify
RELATION_TYPE_CD                                  default 'N/A' not null
2005-04-25 17:13:26     [DataDirect][ODBC Oracle driver][Oracle]ORA-02296: cannot enable (SIEBEL.) - null values found

This happen when the wizard is running the SQL statement in the sql file "pret_sia.sql":

RUN_SQL_190_IGNORE_ERROR =
UPDATE S_PER_ORG_UNIT
SET RELATION_TYPE_CD = 'N/A'
WHERE RELATION_TYPE_CD IS NULL
/

After looking at the 6.3 DB Schema I could not find the column "RELATION_TYPE_CD ". This might be an error in the SQL and should be reviewed by the support team.

It appears like the original problem is caused by the upgrade running in parallel windows.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
 Message 1

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.