SAP Knowledge Base Article - Preview

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

Symptom

  • On SAP systems running ASE 160 SP02 PL04 and above, following problem is observed --
  • During regular runtime operations, dialog work processes (mainly INSERTs) to 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 for Business Suite

Product

SAP ERP 6.0

Keywords

index, compression, 716, 2628, INSERT, compressed, indexes , KBA , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , BW-SYS-DB-SYB , BW on Sybase ASE Database Platform , 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.