SAP Knowledge Base Article - Preview

2200584 - SQL0904 "Resource limit exceeded"


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

Category                  Resource Shortage
Runtime Errors         DBIF_REPO_SQL_ERROR
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.




AS/400, OS400, DB4


"Resource limit exceeded" with "reason code 7" "return code 13" "ERROR => SQL error -904 with reason 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 for Me (Login required).

Search for additional results

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