2200584 - SQL0904 "Resource limit exceeded" | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2200584 - SQL0904 "Resource limit exceeded"

Symptom

SQL0904 happens during daily operations, and can be any transactions with access to certain table.
You will have short dumps, and SM21 errors.

ST22: 
Category                  Resource Shortage
Runtime Errors         DBIF_REPO_SQL_ERROR
OR
Runtime Errors         DBIF_RSQL_SQL_ERROR

SM21: Database error -904 at FET access to table MARA

DEV_w* trace:
***LOG BY4=> sql error -904   performing FET on table MARA   [dbrepolo     302]
***LOG BY0=> Resource limit exceeded. MSGID= Job=039535/PRDADM/WP66 [dbrepolo     302]

Job log:

System object REPOLOAD  REPO0002 partially damaged. Internal dump ID
  00000000. Error class 2, device number X'0052'.
Failure for device or member MCH0007 file REPOLOAD in library R3PRDDATA.
Resource limit exceeded.

 


Read more...

Environment

AS/400, OS400, DB4

Keywords

"Resource limit exceeded" with "reason code 7" "return code 13" , KBA , BC-DB-DB4 , DB2 for AS/400 , 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.