topic Re: Update temination error on coding user exit - EXIT_SAPLCOIH_009 in Application Development and Automation Discussions

Update temination error on coding user exit - EXIT_SAPLCOIH_009

Former Member — Thu, 04 Aug 2011 04:32:00 GMT

HI All,

I am working on approval of a work order in IW32 for which I am coding within a user exit EXIT_SAPLCOIH_009 which gets triggerred at the time of saving the work order. This will update the AUFK table and send a mail to a recipient. But when I save the work order after approving it, it gives me an error saying "Update Termination error". I checked within the SM13 transaction and ST22 for dump analysis, it says "The ABAP/4 Open SQL array insert results in duplicate database records.". Can anyone tell me what could have gone wrong and how I can rectify this. Your help is greatly appreciated.

Thanks in Advance

Edited by: Jeyakanthan A on Aug 4, 2011 11:53 AM

Re: Update temination error on coding user exit - EXIT_SAPLCOIH_009

JL23 — Thu, 04 Aug 2011 05:21:01 GMT

do you manipulate key fields in the user exit?

Re: Update temination error on coding user exit - EXIT_SAPLCOIH_009

Former Member — Thu, 04 Aug 2011 05:23:10 GMT

No I am not manipulating the key field (AUFNR). I have created a customised include within AUFK and I am only updating those fields.

Re: Update temination error on coding user exit - EXIT_SAPLCOIH_009

Former Member — Thu, 04 Aug 2011 05:38:12 GMT

ABAP/4 Open SQL array insert results in duplicate database records.".

Error is due to inserting duplicate record in table which is already existing.Take help of abaper,debug,analyze

code which may be cause of error using ST22.If it is application error,apply appropriate sap note.

Re: Update temination error on coding user exit - EXIT_SAPLCOIH_009

Former Member — Thu, 04 Aug 2011 05:51:21 GMT

In this exit, I am first updating a structure CAUFVD and then using this structure values, I am updating other similar structures and the table using PERFORM caufv_upd(saplcobh) USING caufvd_imp. I have not modified this perform. It already exists. Is this perform creating this error

Re: Update temination error on coding user exit - EXIT_SAPLCOIH_009

Former Member — Thu, 04 Aug 2011 06:26:48 GMT

It is appropriate to move this thread from ERP MM to [Enhancements and Modifications |; for getting suitable responses.