SAP Knowledge Base Article - Preview

2483958 - Errors 716, 2628 on INSERT and DELETE with compressed indexes - SAP ASE 16.0 for Business Suite

Symptom

  • During regular runtime operations, dialog work processes (mainly INSERTs) fail with a short dump (Error 2628 or Error 716) on multiple tables:

Short text: SQL error 5702 when accessing table "ABCD". 
----------------------------------------------------------------------------------------------------
|What happened?                                                                                    |
|    Error Text of the Database: "[ASE Error SQL21][SAP][ASE ODBC Driver][Adaptive                
|     Server Enterprise]WARNING - Fatal Error 2628 occurred at Jun 5 2017 7:21AM.                  
|     Please note the error and time, and contact a user with System Administrator  (SA) authorization.

  • SM21 system log shows INSERT work processes failing with

SQL716: Unable to allocate memory of size 16384 bytes from the 'compression info' pool.

  • SM21 and ST22 errors will reference the affected table.
  • The ASE errorlog contains one or more of the following  messages:

ICOMP_ROWBUF2 is already used

Error: 716, Severity: 16, State: 33
Unable to allocate memory of size 16384 bytes from the 'compression info' pool

Error: 2628, Severity: 21, State: 2
In database 'SID', page 42680079 is linked forward to page 29819435, but that page is linked backward to page 29774630. Please report this internal error to SAP Technical Support.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0 SP02 and above for Business Suite

Product

SAP Adaptive Server Enterprise 16.0 ; SAP ERP 6.0

Keywords

index, compressed, CR808636, CR#808636, 808636, index_compression, reorg, rebuild , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , Bug Filed

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.