Skip to Content
0

Runtine time error in P50 while creating Sales order SAPSQL_ARRAY_INSERT_DUPREC

Oct 28, 2016 at 07:25 AM

76

avatar image

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

dump.png (58.5 kB)
10 |10000 characters needed characters left characters exceeded

Have a look at OSS note 1278418

0

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

0

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

1
* Please Login or Register to Answer, Follow or Comment.

2 Answers

max bianchi Oct 28, 2016 at 07:53 AM
1

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

Share
10 |10000 characters needed characters left characters exceeded
Pablo Casamayor Oct 28, 2016 at 07:49 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded