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" "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.