My Oracle Support Banner

Upgrade From IP16 to Siebel 22.x or Later Changes MSSQL Server Column Data Type From NVARCHAR(MAX) TO NTEXT (Doc ID 2932713.1)

Last updated on MARCH 07, 2023

Applies to:

Siebel Tools - Version 22.11 and later
Information in this document applies to any platform.


After Siebel 22.11 upgrade from IP16, all MSSQL Server Column of data type nvarchar(max) were changed to ntext data type with the below Error

An online operation cannot be performed for index 'EIM_COMM_U1' because the index contains column 'COMM_TEXT' of data type text, ntext, image or FILESTREAM. For a non-clustered index, the column could be an include column of the index. For a clustered index, the column could be any column of the table. If DROP_EXISTING is used, the column could be part of a new or old index. The operation must be performed offline.

Checked in sql server studio and shows column as ntext but in IP16 it shows as nvarchar(max)


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

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