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 for Me (Login required).

Search for additional results

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