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

[Former Member]

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

[bastinvinoth]

Hi Manoj Rawat

SAP Note 196113 - SAPSQL_ARRAY_INSERT_DUPREC

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

Regards,

Bastin.G

[arindam_m]

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

[former_member184497]

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

[Former Member]

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

[former_member184497]

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

[ThomasZloch]

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

[Former Member]

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

[Former Member]

Hi everybody ,

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

thanks to all .

Manoj Rawat

[Former Member]

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)