Runtine time error in P50 while creating Sales order SAPSQL_ARRAY_INSERT_DUPREC

[former_member486356]

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

[former_member182371]

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

[Former Member]

Hi

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

[Lakshmipathi]

Have a look at OSS note 1278418

[former_member182371]

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

[Lakshmipathi]

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