topic Runtine time error in P50 while creating Sales order SAPSQL_ARRAY_INSERT_DUPREC in Application Development and Automation Discussions

Runtine time error in P50 while creating Sales order SAPSQL_ARRAY_INSERT_DUPREC

former_member486356 — Fri, 28 Oct 2016 07:25:35 GMT

Hi Folks,

I need help in a issue as we are facing runtime time dump in only P50 system while creating sales order in VA01. When we are creating sales order in VA01 sales order is getting created but in blackened it is giving the runtime error SAPSQL_ARRAY_INSERT_DUPREC. So after creating sales order in VA01 when we try to check this sales order in VA02 and VA03 it is showing error that this sales order is not exist in database.

dump.png

Re: Runtine time error in P50 while creating Sales order SAPSQL_ARRAY_INSERT_DUPREC

former_member182371 — Fri, 28 Oct 2016 07:49:39 GMT

Hi,

it seems a duplicate entry is being created.

what is the value of OBJECT in sentence

insert (object) from table da_xvbpai?

Best regards,

Pablo

Re: Runtine time error in P50 while creating Sales order SAPSQL_ARRAY_INSERT_DUPREC

Former Member — Fri, 28 Oct 2016 07:53:00 GMT

It seems there are duplicated records in partener data, it's strange error and in my experirence an error like yours is usually due to a modification by some user-exit

Anyway you can try to check which table is in OBJECT and which data are inDA_ XVBPAI

You can run the saving in debug with option Update Debugging activated

Re: Runtine time error in P50 while creating Sales order SAPSQL_ARRAY_INSERT_DUPREC

Lakshmipathi — Fri, 28 Oct 2016 08:04:36 GMT

Have a look at OSS note 1278418

Re: Runtine time error in P50 while creating Sales order SAPSQL_ARRAY_INSERT_DUPREC

former_member182371 — Fri, 28 Oct 2016 08:12:28 GMT

that OSS note seems to be for VA21/VA22 and the OP was for VA01

Re: Runtine time error in P50 while creating Sales order SAPSQL_ARRAY_INSERT_DUPREC

Lakshmipathi — Fri, 28 Oct 2016 08:59:04 GMT

I think that the coding correction whatever recommended will also solve your sale order issue since both the quotation and sale order are being stored in same tables. You can try in DEV