Symptom
- Try to access table MARDO1 or MARDHO1 through SE16N and you get a dump or system error related to Overflow.
- Error: Exception of class CX_SY_OPEN_SQL_DB. Database returned the SQL code 307. Error text: numeric value out of range: exception 71000307: not enough space for packed decimal#.
- Database returned the SQL code 307. Error text: numeric value out of range: not enough space for packed decimal (at pos 74)
- Posting a material through MIGO and you get a dump which mentions the same error as the item above (not enough space for packed decimal).
- Posting Goods Issue and error O3046 is presented.
- O3046 - Quantity overflow; $1 is larger than 9,999,999,999.999.
- O3046 - Quantity overflow; $1 is larger than 9,999,999,999.999.
- While accessing trying to open Plant Stock tab (or any other Stock related tab) on MM03 the following dump is presented:
Category ABAP programming error
Runtime Errors DBSQL_SQL_ERROR
Except. CX_SY_OPEN_SQL_DB
ABAP: Program SAPLOIB2_EXT_1
Application Component IS-OIL-DS-HPM
SQL error "SQL code: -10811" occurred while accessing table "MARDO1".
Read more...
Environment
- S/4 HANA
- SAP ERP
- SAP ERP Industry Solution - Oil & Gas
Product
SAP ERP all versions ; SAP R/3 Enterprise add-on for oil and gas all versions ; SAP S/4HANA all versions
Keywords
overflow, migo, material document, post, dump, lis, exclusive block, exclusive lock, OMO9, OMJI, CX_SY_OPEN_SQL_DB, SQL code 307, numeric value out of range, exception 71000307, not enough space for packed decimal, history, tables, MARDO1, MARDHO1, O3046, decimal, SQL code: -10811, sql error, , KBA , IS-OIL-DS-HPM , Hydrocarbon Product Management , 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.