SAP Knowledge Base Article - Preview

2018525 - Msg 1919 can't create index on text, image, unitext datatype - SAP ASE

Symptom

  • Customer is running SAP Adaptive Server Enterprise (ASE) and Sybase Replication Server (SRS) in a Warm Standby Setup
  • Some of the tables contain text, unitext, image or rawobject columns
  • Msg 1919, Level 16, State 1:
    Server 'ASE', Line 1:
    Column 'c' -- Can't create index on a column of TEXT, IMAGE or UNITEXT data
    type.
  • 1> alter table t_text_alter modify b text null
    2> go
    Msg 13907, Level 16, State 1:
    Server 'ASE', Line 1:
    ALTER TABLE 't_text_alter' failed. You cannot modify column 'b' to
    TEXT/IMAGE/UNITEXT type.
    Msg 11050, Level 16, State 51:
    Server 'ASE', Line 1:
    Adaptive Server cannot process this ALTER TABLE statement due to one or more
    preceding errors. If there are no preceding errors, please contact Sybase Technical Support.

Read more...

Environment

  • Adaptive Server Enterprise (ASE)
  • Dataserver

Product

SAP Adaptive Server Enterprise 15.7

Keywords

Msg 1919, Level 16, State 1, Msg 13907, Text, Unitext, Image, datatype, column , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-REP , Sybase Replication Server (standalone) , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.