update termination message

[Former Member]

Hello friends,

In VF04, when I was trying to create one invoice for two debit memos, 70002730 and 70002729 I'm getting update termination message.

In runtime error we are getting below info.

Runtime Errors SAPSQL_ARRAY_INSERT_DUPREC

Kindly advise on this issue....

Thanks,

Bharat.

[Former Member]

Hello,

Check SM13 and also you might need to search OSS by transaction code for any code corrections.

Rajeev

[Former Member]

First thing you can do, as Rajeev suggested is to check SM13 to get the details of the error. You might even look at the dump to get the details.

We normally get this dump, if we are trying to insert a record in the database table, and there is already a record present with the same key.

Look for user exits and enhancement in that part of the code, and see how they are manipulating the data.

[Former Member]

Hi,

Thanks for your reply.

I am getting update termination in sandbox(SS4 s/m) and in SQ4 (quality) it's working fine. In production, the issue is not consistant. So,I did the debugging in SS4 and SQ4 and found the following result.

CALL FUNCTION 'SD_COLLECTIVE_RUN_EXECUTE'

EXPORTING

v60p_input_rv60a = gd_default_data

v60p_input_smart = ld_smart

v60p_input_sammg = ld_sammg

id_no_new_run = ld_no_new_run

id_invoice_list = ld_invoice_list

IMPORTING

v60p_output_vbsk = lt_vbsk

TABLES

v60p_input_vkdfif = lt_fvkdfi

v60p_output_vbfs = lt_vbfs

v60p_output_vbss = lt_vbss

EXCEPTIONS

OTHERS = 1.

I put a break-point at above FM in both the system(SS4and SQ4) , after execution of FM, the structure lt_vbss in tables parameters contains 2 entries in SS4 and only one entry in SQ4 system.

I suspect this could be the reason for update termination error in SS4 system. Kindly suggest.

Thanking you.

Bharat.