Siebel System Admin, Install and Upgrade (MOSC)

MOSC Banner

ddl.ctl

edited Dec 16, 2016 12:54AM in Siebel System Admin, Install and Upgrade (MOSC) 4 comments
 Hi, We are upgrading from 8.1.1.10 to 8.1.1.11
 We ran into error while doing IRM. I was just wondering if any one else has the same problem.
ddl imp is trying to run the below query on DB and errors out .
alter table S_SRC alter column "MUTUAL_EXCL_FLG"                nchar(1)             not null

Error Msg: 

[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert the value NULL into column 'MUTUAL_EXCL_FLG', table 'PRO_SAS_DB.dbo.S_SRC'; column does not allow nulls. UPDATE fails.


At DB level MUTUAL_EXCL_FLG is set to Nullable.


Vijay

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center