topic Re: IDOC Process Failing : The ABAP/4 Open SQL array insert results in duplicate database records. in Application Development and Automation Discussions

IDOC Process Failing : The ABAP/4 Open SQL array insert results in duplicate database records.

Former Member — Thu, 10 Dec 2015 20:36:43 GMT

Hi Experts,

Need Help for which I'm facing a issue when IDOC is Processing.

We have back ground Job which triggers for every 10 Mins for Processing IDOCs which is used to create Purchase Request.

Processing is happening with Prog: RBDMANIN. When processing few Jobs are going to Dump with Error: The ABAP/4 Open SQL array insert results in duplicate database records.

It was happening at :

145 DESCRIBE TABLE db_eban LINES sy-tfill.

146 IF sy-tfill GT 0.

>>>>> INSERT eban FROM TABLE db_eban.

148 IF sy-subrc NE 0.

149 MESSAGE a807 WITH 'EBAN'.

I tried to use logic to avoid the Duplication. But it didn't worked.

Kindly suggest me how resolve this issue, is there any process to delay the IDOC process ?

Re: IDOC Process Failing : The ABAP/4 Open SQL array insert results in duplicate database records.

karthikeyan_p3 — Fri, 11 Dec 2015 06:54:53 GMT

Hi RK,

Which IDOC type are you using? Is that a standard IDOC type or custom?

Is the PR number available in IDOC & are you trying to create PR with the same number?

Thanks,

Karthikeyan

Re: IDOC Process Failing : The ABAP/4 Open SQL array insert results in duplicate database records.

PeterJonker — Fri, 11 Dec 2015 10:10:50 GMT

Can you not use MODIFY from table db_eban in stead of INSERT ?