topic Re: SAPSQL_ARRAY_INSERT_DUPREC in Application Development and Automation Discussions

SAPSQL_ARRAY_INSERT_DUPREC

Former Member — Thu, 26 Jan 2006 16:28:43 GMT

Hi All,

We are repeatedly getting this error while trying to create a delivery from VL01N. I would think this is due to duplicate entry but i checked the data and found that the entry does not exist in the concerned table (EIKP). Has anyone faced such an issue before? If so any idea why this happens?

Regards,

Hari.

Re: SAPSQL_ARRAY_INSERT_DUPREC

Former Member — Thu, 26 Jan 2006 16:41:00 GMT

Yes... it means that duplicate records exist.

Are you running VL01N in a batch process? If so, the COMMIT of all records to the DB will not occur until the batch program finishes (unless you call a COMMIT WORK explicitly after each VL01N).

Code the program (for now) to display all EIKP records TO BE CREATED to the screen for review.

Re: SAPSQL_ARRAY_INSERT_DUPREC

Former Member — Thu, 26 Jan 2006 16:46:36 GMT

There are a number of OSS notes for this. Search using SAPSQL_ARRAY_INSERT_DUPREC VL01N.

Rob

Re: SAPSQL_ARRAY_INSERT_DUPREC

Former Member — Thu, 26 Jan 2006 17:00:26 GMT

Hi,

Thanks for the replies, but no we are not using a batch process. An user was trying to create the delivery for a single order. I am trying to browse through the Notes but have not got any relavant ones yet.

Regards,

Hari.

Re: SAPSQL_ARRAY_INSERT_DUPREC

Former Member — Thu, 26 Jan 2006 17:10:22 GMT

This may be a configuration issue. we faced similar problem while creating orders and it came to be problem with Number range for orders. After increasing the number range it went through.

I would be interested to hear if your problem is resolved or not.

Re: SAPSQL_ARRAY_INSERT_DUPREC

Former Member — Fri, 27 Jan 2006 14:00:58 GMT

Hi harikrishnan,

1. If it was working fine before,

then how suddenly it stopped working now?

2. It basically problem related

to configuration.

3. and found that the entry does not exist in the concerned table (EIKP).

Which entry were u checking ?

How did u know which new number

is getting generated (even though its not saved )

regards,

amit m.

Re: SAPSQL_ARRAY_INSERT_DUPREC

Former Member — Fri, 27 Jan 2006 17:25:59 GMT

hi,

this may also be due to custom code in the user exits.

check for coding that manipulate standard structures( for ex. xvbap and yvbap in sales order exits). this manipulation by the code might end up in having duplicate records in X and Y structures that subsequently are used by SAP to update DB tables.

we had a similar prob in sales order. i found out that it was because of duplicate entries in xvbap.(because of updkz field modification by some code).

better luck.

Re: SAPSQL_ARRAY_INSERT_DUPREC

Former Member — Fri, 27 Jan 2006 17:31:13 GMT

Hi All,

Thanks for all the replies. I had been checking the entry from the internal table contents from ST22. This was a configuration issue; The number range was exhausted . We extended it and now everything is fine. Thanks once again for all the inputs.

Regards,

Hari.

Re: SAPSQL_ARRAY_INSERT_DUPREC

Former Member — Fri, 27 Jan 2006 17:47:06 GMT

Close the thread please (solved on own).

Rob

Re: SAPSQL_ARRAY_INSERT_DUPREC

Former Member — Fri, 27 Jan 2006 22:40:58 GMT

hiu, check the Document no ranges, that could also be a reason for SQL array error,

Re: SAPSQL_ARRAY_INSERT_DUPREC

Former Member — Mon, 26 Mar 2007 14:05:48 GMT

Hello

I have the same error SAPSQL_ARRAY_INSERT_DUPREC when sending mail through the Business Workplace , a dump is generated in st22 . This issue occured after an client copy fro Quality to Dev . According to SAPNOTE 581559 we extend the interval number range in fot the SO_OBJ_FOL object ( TA nsro) but the dump are still generated . In this thread I saw that harikrishnan balan solved the issue by extending the range value , but I wanted to know if futher action as needed after increasing this value . We tried to create an Workbench request for that repair and import it in DEV but it is not possible , due to the fact that DEV is not a consolidation system . Harikrishnan , can you explain me how did you increase that range ?

Thanks a Lot .

Best Regards

De Palma Lionel