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

[Former Member]

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 ?

[Former Member]

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 ?

[karthikeyan_p3]

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

[PeterJonker]

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