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 laterInformation in this document applies to any platform.
Symptoms
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)
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 |
| Cause |
| Solution |
| References |