Skip to Content
avatar image
Former Member

Sales Order created in SAP even message shows with system error in SAP PI

Hello Experts,

My scenario is JDBC to RFC for Sales Orders.

data triggered from database (JDBC) through SAP PI to (RFC) ECC...will create Sales Orders, Invoices & respective Accounting Documents in SAP...immediately PROXY will trigger from ECC with Sales Order, accounting Document Numbers to Database(JDBC) through SAP PI.

i got the below error in SAP PI when ever pushing more than 1000 rows from DB & not reprocessed through PI but still in SAP we can see Sales Orders & accounting Documents generated for the triggered data which are still in system error status at PI.

Please help me on this how to handle with No memory Error & with docs created in SAP for each retry interval even in error state (created duplicate doc's for each retry)..

Thanks in Advance.

error.png (88.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 11 at 07:26 PM

    Good morning. The key to your problem will lie within your ZRFC_SALES_ORDER function.

    • What functions/classes/etc are you using the create the sales orders within the custom RFC? So we can start to trouble shoot your duplicate issue
    • Is the proxy (ERP to JDBC database scenario) called from within your Z Function? I suspect you are creating a proxy object for each record but I want to confirm. (If this is the case please just reuse your proxy object and create it only once).
    • Please provide your code for your function

    Duplicate Sales Orders can be prevented if you have appropriate configuration in place to check the external reference. It can also be prevented during processing routines for idocs, in your case your Z function you can also put a check in with your own code though this is less desirable due to potential performance impact. (I hope your integration scenario in this instance is Asynchronous?).

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thank You so much for your inputs Daniel....

      • Is the proxy (ERP to JDBC database scenario) called from within your Z Function? I suspect you are creating a proxy object for each record but I want to confirm. (If this is the case please just reuse your proxy object and create it only once). Yes PROXY Called within Z Function..
      • Duplicate Sales Orders can be prevented if you have appropriate configuration in place to check the external reference. It can also be prevented during processing routines for idocs, in your case your Z function you can also put a check in with your own code though this is less desirable due to potential performance impact. (I hope your integration scenario in this instance is Asynchronous?) Yes Asynchronous.
      • code.txt
      code.txt (14.4 kB)