Skip to Content
0

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

Feb 11 at 07:50 AM

80

avatar image
Former Member

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Daniel Kennedy Feb 11 at 07:26 PM
0

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?).

Show 1 Share
10 |10000 characters needed characters left 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)
0