Symptom
- Try to access on of the folowing table: MARDO1, MARDHO1 or MARCO1; through SE16N transaction, 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, MARCO1, 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.
SAP Knowledge Base Article - Preview