Siebel IRM on the Microsoft SQL Server database fails with: cannot change a TEXT, NTEXT or IMAGE column

(Doc ID 2097376.1)

Last updated on FEBRUARY 15, 2016

Applies to:

Siebel CRM - Version [IP2014] to 15.7 [IP2015] [Release V8 to V15]
Information in this document applies to any platform.


Siebel upgrep process for a Siebel Upgrade or Incremental Repository Merge (IRM) process to Siebel CRM IP2015 failing with:

[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'S_BRDCST_MSG'.
modify col S_BRDCST_MSG."MSG_BODY" nvarchar(2000) not null: cannot change a TEXT, NTEXT or IMAGE column:

writeExecDDL error (UTLOdbcExecDirectDDL pDDLSql).
writeExecDDL error (UTLDbDdlColModify).
Error in MainFunction (UTLDbDdlDbMerge).
Error in Main function...


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms