SAP Knowledge Base Article - Preview

1962697 - Potential offset of column and variable-length columns in table exceeds limit of 8191 bytes in DOL tables using create or alter table - ASE


  • Running command "ALTER TABLE " or "CREATE TABLE" generates warning:

Potential offset of column '<columnname>' (<nnnn> bytes) and subsequent variable-length columns in table <tablename> exceeds limit of 8191 bytes
for column-offset of variable-length columns in DOL tables. Future inserts to this table may fail.

  •  Message 4982 may also be reported:

 Msg 4981, Level 20, State 1
 Column offset, 9008 bytes, for variable-length column number 2 exceeds the maximum start offset for variable-length columns in DOL
 tables (8191 bytes). The lock scheme for the object 't1' was not changed.



SAP Adaptive Server Enterprise (ASE) All versions.


SAP Adaptive Server Enterprise 12.5 ; SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise 15.5


Potential offset column-offset variable-length columns DOL datapages wide rows 16K 8K 4K 2K long broad datarows allpages , 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 for Me (Login required).

Search for additional results

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