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 | SAP Knowledge Base Article

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

Symptom

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


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) All versions.

Product

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

Keywords

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 ONE Support launchpad (Login required).

Search for additional results

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