topic Re: DUMP "SAPSQL_ARRAY_INSERT_DUPREC" WHILE MODIFYING A SALES ORDER in Application Development and Automation Discussions

DUMP "SAPSQL_ARRAY_INSERT_DUPREC" WHILE MODIFYING A SALES ORDER

Former Member — Tue, 07 Oct 2008 13:07:05 GMT

Hi,

when I modify a certain sales order document I get a Dump with the error "SAPSQL_ARRAY_INSERT_DUPREC" in INSERT_POS_IN_DB

Any ideas?

Thanks in advance,

Re: DUMP "SAPSQL_ARRAY_INSERT_DUPREC" WHILE MODIFYING A SALES ORDER

Former Member — Tue, 07 Oct 2008 13:10:16 GMT

any exits or enhancements on the VA01 transaction. I am thinking the error is from the custom implementation what you did, are you adding any entries to the item/header in the user exits (xvbak/xvbap internal tables). confirm this once.

Re: DUMP "SAPSQL_ARRAY_INSERT_DUPREC" WHILE MODIFYING A SALES ORDER

Former Member — Tue, 07 Oct 2008 13:21:38 GMT

Hi, I am trying to modify VBAK-LIFSK, even though it has happened in other fields.

Any suggestion?

Re: DUMP "SAPSQL_ARRAY_INSERT_DUPREC" WHILE MODIFYING A SALES ORDER

Former Member — Tue, 07 Oct 2008 13:29:27 GMT

instead of modify you may be using the APPEND check it once.

show the code what you are doing..?

Re: DUMP "SAPSQL_ARRAY_INSERT_DUPREC" WHILE MODIFYING A SALES ORDER

Former Member — Tue, 07 Oct 2008 13:38:21 GMT

Hi,

I am modifying VBAK-LIFSK though VA02 and after saving the document I get the DUMP.

Re: DUMP "SAPSQL_ARRAY_INSERT_DUPREC" WHILE MODIFYING A SALES ORDER

Former Member — Tue, 07 Oct 2008 13:55:28 GMT

i guess...then internal table in which you are inserting a value is a sorted table.

try using:

insert wa into table itab.

or it you are inserting a duplicate record in DB

Edited by: Amit Gupta on Oct 7, 2008 3:56 PM

Re: DUMP "SAPSQL_ARRAY_INSERT_DUPREC" WHILE MODIFYING A SALES ORDER

Former Member — Tue, 07 Oct 2008 13:58:55 GMT

there is no enhancements/exits implemented. check in MV45AFZZ , just keep a break point in SAVE_DOCUMENT_PREPARE and see the internal table contents XVBAK, XVBAP and let me know.

Re: DUMP "SAPSQL_ARRAY_INSERT_DUPREC" WHILE MODIFYING A SALES ORDER

Former Member — Tue, 07 Oct 2008 16:12:09 GMT

Hi,

Thanks all!!!! This issue has been solved. It was due to a TO that we imported this morning.

Best regards,