Skip to Content
avatar image
Former Member

Express document "Update was terminated" received from author posting document in f-02

Hi to all,

               We are posting document in f-02 everything goes fine and we are getting the success message and system is generating  one document number. But when we are checking it in tcode  fb03  system showing error message that document does not exit.

we have already check the number ranges everything is fine .I have checked the sm13 there system show below details :

Error Details : ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC

report : LGLIUF1A     row : - 1,324

i have set breakpoint on row 1324 in report LGLIUF1A but the breakpoint is not triggering.

Thanks and Regard

Manoj Rawat

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

8 Answers

  • Best Answer
    avatar image
    Former Member
    May 04, 2013 at 08:10 AM

    Hi,

    Its a DUPLICATE RECORD ERROR i.e. the code tries to INSERT records with same key combination that already exist in the DB. Try UPDATE DEBUGGING to stop at the point where ever that UPDATE is taking place.

    Choose Settings -> System/Update Debugging to activate either before proceeding.

    Cheers,

    Arindam

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 04, 2013 at 08:17 AM

    Hi,

    When the program try to insert data into FAGLFLEXA table it throws the error.

    In update debugging check if the same key combination exists.

    If so then try to debug the transaction before saving and then check how the internal table for FAGLFLEXA insert in constructed.

    Regards,

    Arun

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 06, 2013 at 10:10 AM

    Hi to all ,

                    thanks for reply . ya program is going to insert record in table FAGLFLEXA in report LGLIUF1A at line 1324 as i mention earlier in my post. As you guys to ask me to activate update debugging mode it's taking me  inside  post_document function module but inside that i am not  able to find FAGLFLEXA itab. even i am not able to debug the  LGLIUF1A report where system is inserting record in FAGLFLEXA table, after selecting  updating mode in debugger.

    still looking for solution!!

    Thanks and Regards

    Manoj Rawat

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      Have you debugged other update FM.

      There will be some FM other than POST_DOCUMENT. Try to debug all the FM one of them will try to update the FAGLFLEXA table.

      Regards,

      Arun

  • avatar image
    Former Member
    May 04, 2013 at 07:53 AM

    Hi Manoj Rawat

    SAP Note 196113 - SAPSQL_ARRAY_INSERT_DUPREC

    Check this link also http://scn.sap.com/thread/1996440

    Regards,

    Bastin.G

    Add comment
    10|10000 characters needed characters exceeded

  • May 06, 2013 at 11:22 AM

    There should be a related dump in ST22, there might be more helpful information available. Since it seems that only standard code is affected, there might be a solution already, did you search for SAP notes with keywords like SAPSQL_ARRAY_INSERT_DUPREC and LGLIUF1A ?

    Thomas

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 06, 2013 at 12:39 PM

    Manoj,

    As thomas suggested look for sumps in ST22. That will give you a more clear picture on which include and which line number. That should tell you which table update fails.

    Another thing you can do is to open SM13 and figure the which process dumped. The one in red color with status as error. double click on that row and you will find more information.

    Next you can put a break point from SM13 and perform a repeat update. This will alos help you understand which table has the duplicate record.

    Thanks,

    Vikram.M

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 10, 2013 at 06:28 AM

    Hi everybody ,

                          issue is solved, the problem was  related to number ranges .

    thanks to all .

    Manoj Rawat

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 11, 2014 at 01:15 PM

    Hie Friends , I am getting same error msg while posting goods reciept(GR) : MIGO

    Express document "Update was terminated" received from author MMS

    Its related with MM - FI integration ( FICO module)

    Add comment
    10|10000 characters needed characters exceeded