SAP Knowledge Base Article - Preview

2206520 - Error 644 on ERP systems installed using SWPM SP08 - SAP ASE for Business Suite

Symptom

You are running SAP Business Suite set of applications on SAP ASE database; specifically, SAP MRP - PP (Manufacturing - Product Planning) applications.

  • You find recurring ST22 short dumps --  Error: SQL error "SQL code: 21" occurred while accessing table "AUSP" (or accessing table "RESB").
  • Further review of the short dump shows that a DELETE on the AUSP / RESB table is failing. Corresponding error in the ASE log is Error 644 on the index id 4 (AUSP~N1 or RESB~ZA1 respectively) --

Error: 644, Severity: 21, State: 5 Index row entry for data row id (168302226, 97) is missing from index page 168305789 of index id 4 of table 'AUSP' in database 'XXX'. Xactid is (165838513,83). Drop and re-create the index.
Error: 644, Severity: 21, State: 5 Index row entry for data row id (477529, 34) is missing from index page 648465 of index id 4 of table 'RESB' in database 'XXX'. Xactid is (4181693,51). Drop and re-create the index.

  • 'dbcc checkindex' on the offending indexes repeatedly fails with Errors 9996 and Error 7928
  • Rebuilding the indexes does not help - above dbcc errors persist
  • Rebuilding the table along with all indexes does not help either

 


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP Enterprise Resource Planning (ERP) 6.0
  • SAP MRP (Manufacturing)
  • SAP PP (Product Planning)

Product

SAP ERP 6.0

Keywords

644, AUSP, RESB, MRP, Manufacturing, PP, drop, index, CR788324, CR785554 , 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 for Me (Login required).

Search for additional results

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