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 126.96.36.199 SIA  and later
z*OBSOLETE: Microsoft Windows Server 2003
Version: 188.8.131.52  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.
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":
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.
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