topic Re: SAPSQL_ARRAY_INSERT_DUPREC in VA22 in Application Development and Automation Discussions

SAPSQL_ARRAY_INSERT_DUPREC in VA22

Former Member — Fri, 31 Dec 2010 11:14:47 GMT

Hello All,

I am in a very critical situation right now...

One of our user had raised the issue regarding dump SAPSQL_ARRAY_INSERT_DUPREC .

However the dump is not available in the system for investigation.

Without dump I am unable to give the solution.

He had recommeded the sap note 278418 which can not be implemented in the system due to version mismatch.

Can anybody hepl me to tackle this dump?

Regards,

Reshma

Re: SAPSQL_ARRAY_INSERT_DUPREC in VA22

Former Member — Fri, 31 Dec 2010 12:13:21 GMT

The user has introduced in VA22 transaction records duplicated ( the unique key is duplicated in one or more records)

Re: SAPSQL_ARRAY_INSERT_DUPREC in VA22

Former Member — Tue, 08 Feb 2011 14:31:18 GMT

Hi Reshma,

I got the same issue with same dump : SAPSQL_ARRAY_INSERT_DUPREC in VA42.

I tried with SAP Note : 278418 , I have checked in the note in the system its not there.

If have any info let me know.

Regards,

Jayan.

Re: SAPSQL_ARRAY_INSERT_DUPREC in VA22

Former Member — Tue, 08 Feb 2011 16:24:34 GMT

Hi Reshma,

Check SM13 (if authorized) to find out the data and table causing the short dump. Also check ST22 as to my knowledge these dumps create a log.

Most likely this dump is caused by an "error" in an user-exit and therefore I would also check any recent coding changes to the various order exits.

In case you re-create the scenario in your QA system, debug the VA22 transaction while being in update debug mode which maybe can give you some more insight.

Kind regards,

Robert

Re: SAPSQL_ARRAY_INSERT_DUPREC in VA22

Former Member — Tue, 08 Feb 2011 17:19:34 GMT

Check the note 1278418.

You have to replicate the issue otherwise it will be difficult to predict.