update terminated error while doing changes in sales order

[Former Member]

Hi

We had found below error message while trying to save a sales order

RV_sales_document_update

Report-LV45UF0V

Row 265

Error details-SAPSQL_ARRAY_INSERT_DUPREC-671

This had happened for 2 sales orders alone..

"SAPSQL_ARRAY_INSERT_DUPREC" "CX_SY_OPEN_SQL_DB"

"SAPLV45U" or "LV45UF0V"

"VBEP_BEARBEITEN"

We are not using any user exit for VBEP...

Can u please tell us how to overcome this error

Regards

Sudha

[Former Member · Accepted solution]

Hi Sudha,

Please check the table VBEP, for seeing wether a record with same primary keys have already been created.

The error you are getting is because the program is detecting a record with same primary keys already exist in table VEBP.

Hope this helps,

Abhishek

[Former Member · Accepted solution]

hi

Problem is solved.

[Former Member · Accepted solution]

How was it solved ? I have the same Issue.

<< Moderator message - Everyone's problem is important. But the answers in the forum are provided by volunteers. Please do not ask for help quickly. And consider opening your own thread on this >>

Thanks

Abhinav

Edited by: Rob Burbank on Jan 12, 2011 4:08 PM

[Former Member]

Hi Sudha,

did you solve this problem?

I have the same issue.

Thanks in advance,

António

[Former Member]

HI,

We generally encounter such errors when and SQL sts is trying to perform an INSERT operation into a table which already has a record.So plz check for duplicasy of data.

Cheerzz..

Subbzz..

[Lakshmipathi]

Dear Sudha

Please check this thread

[SAPSQL_ARRAY_INSERT_DUPREC |;

thanks

G. Lakshmipathi