1909651 - Unable to create a table, returns Error 103 identifier name is too long - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

1909651 - Unable to create a table, returns Error 103 identifier name is too long - SAP ASE

Symptom

  • Connecting pre-15.x client to ASE 15.5 or 15.7 
  • 'create table' will fail if the table name or column name exceeds 30 characters

Msg 103, Level 15, State 205:
Server 'ase157', Line 2:
The identifier that starts with '<long identifier name>' is too long.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0
  • Sybase Adaptive Server Enterprise (ASE) 15.5
  • Sybase Adaptive Server Enterprise (ASE) 15.0
  • SAP Sybase Software Developer Kit (SDK)

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise SDK all versions ; Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise 15.5

Keywords

Message 103, alter table, defncopy, reorg rebuild, trace flag 7717, large identifier, objects with long name , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

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.