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 8.1.1.14 [IP2014] to 15.7 [IP2015] [Release V8 to V15]
Information in this document applies to any platform.

Symptoms

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...

Cause

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