SAP Knowledge Base Article - Preview

3425710 - Quantity overflow while posting through MIGO or accessing MARDO1/MARDHO1 table for some specific materials

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.

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