SAP Knowledge Base Article - Preview

1866094 - SQL Error 2622 - SAP ASE

Symptom

You are running SAP Business Suite applications on SAP ASE.

You find dialog work processes to abend. The developer traces show the following errors:

ERROR: -1 in function ExeNormalModify (execute) [line 21924] (21) [ZZZZZ] [Sybase][ODBC Driver][Adaptive Server Enterprise] WARNING - Fatal Error 2622 occurred at Apr 17 2013 12:04PM. 
Please note the error and time, and contact a user with System Administrator (SA) authorization.
ERROR: -1 in function ExeNormalModify (execute) [line 21924] (30046) [08S01] [Sybase][ODBC Driver]Connection to Sybase server has been lost. ASE Terminated the connection. All active transactions have been rolled back.
ERROR: -1 in function ExeNormalModify (execute) [line 21924] (1157) [ZZZZZ] [Sybase][ODBC Driver][Adaptive Server Enterprise]Insert free space value 21312 in page header of DOL datapage 43924353 belonging to object id 293648458 in database 'DES' is incorrect. It has been recomputed and is now 21312.
ERROR: -1 in function ExeNormalModify (execute) [line 21924] (5702) [ZZZZZ] [Sybase][ODBC Driver][Adaptive Server Enterprise]ASE is terminating this process


Corresponding errors in the ASE errorlog are:

Error: 2622, Severity: 21, State: 4 Insufficient room on this page to insert a row of length 438. Page pointer = 0x0x14b669c000, pageno = 43714566, status = 0x911, ptnid = 532700648, indexid = 0, level = 0.

The error is accompanied by a stacktrace referencing the functions: dol_putdrow()->dol_data_insert()->dol_insert()->ins_insert()

The Error 2622 may refer to different data pages belonging to the same table. In order to determine the name of the affected table, please do the following in isql:

use <SID>
go
select object_name(<object id referenced in the error above>)
go

 dbcc checktable on the affected table reports Error 9993:

Mismatch between the 'ncfs counter' value (2275) in the page header of DOL datapage 43714566, partition ID 532700648, and the actual amount of garbage (0) in the page.
The total number of data pages in partition 'ABC~_1085905717' (partition ID 1085905717) is 34945.

 


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite

Product

SAP ERP 6.0

Keywords

2622, 9993, reorg, , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.