topic Re: SAPSQL_ARRAY_INSERT_DUPREC in Application Development and Automation Discussions

SAPSQL_ARRAY_INSERT_DUPREC

Former Member — Fri, 23 Sep 2011 09:39:22 GMT

Dear All,

I am getting dump for INSERT operation while I am doing update by using program "SAPLV05I" with Function module "SD_PARTNER_UPDATE".

Client.............. 900

Language key........ "E"

Transaction......... "VA01 "

Program............. "SAPLV05I"

Screen.............. "RSM13000 3000"

Screen line......... 2

Runtime Error: "SAPSQL_ARRAY_INSERT_DUPREC"

Exception: "CX_SY_OPEN_SQL_DB"

> INSERT (OBJECT) FROM TABLE DA_XVBPAI.

Can anyone tell me the reason & solution for this?

Best Regards,

Rahul Asthana

Re: SAPSQL_ARRAY_INSERT_DUPREC

Former Member — Fri, 23 Sep 2011 09:44:21 GMT

We can only say that in internal table DA_XVBPAI there are records with the same keys....why? It's hard to give an answer.

If your transaction is "standard" you should check SAP OSS note

If you have implemented some user-exit you should check if those exits update the internal table XVBPA in correct way

Max

Re: SAPSQL_ARRAY_INSERT_DUPREC

former_member204244 — Thu, 26 Mar 2015 07:04:36 GMT

Hello,

I am also getting similar dump in Production But if I am debugging in QA system,then no error and dump is coming.

Can you please help me if You know the reason.

Thanks A lot,

Ishani

Re: SAPSQL_ARRAY_INSERT_DUPREC

former_member323315 — Fri, 05 Feb 2016 17:02:22 GMT

In my case, For the delivery partner procedure, it was assigned one with many partners related to Sales Order, then I changed it to LF and it worked fine.