topic Re: Short Dump SAPSQL_ARRAY_INSERT_DUPREC in Application Development and Automation Discussions

Short Dump SAPSQL_ARRAY_INSERT_DUPREC

Former Member — Tue, 20 May 2014 07:17:15 GMT

Hi Experts,

I am getting a the short dump SAPSQL_ARRAY_INSERT_DUPREC after executing report SDRQCR21 at line 1258

INSERT VBBE FROM TABLE DA_XVBBE.

Please help.

Re: Short Dump SAPSQL_ARRAY_INSERT_DUPREC

Former Member — Tue, 20 May 2014 07:24:19 GMT

Hi Rahul,

this error come when some one re-enter same key record in the table . I think system trying to insert same reord in the table VBBE.

Please check your system SM58 entry and try to delete or re-organize that record .

goto SM58 tcode then log file-> re-organize and set user name who resend this record or using * and after that check checkboxes from screen and execute.

I think this problem will be re-solved.

Regards,

Prasenjit

Re: Short Dump SAPSQL_ARRAY_INSERT_DUPREC

Former Member — Tue, 20 May 2014 07:28:13 GMT

Hi Rahul

Please refer notes 33267.

Regards,

Archer

Re: Short Dump SAPSQL_ARRAY_INSERT_DUPREC

Former Member — Tue, 20 May 2014 07:30:44 GMT

Hi,

I think check your data transfer, Definitely the duplicates are existed in your internal table DA_XVBBE.

- check the records again!

Re: Short Dump SAPSQL_ARRAY_INSERT_DUPREC

Former Member — Tue, 20 May 2014 07:37:12 GMT

Hi Rahul,

But a break point in Insert command and check for which record you are getting error ? Is it for all the records or in some particular scenario ?

Thanks,

Prakash

Re: Short Dump SAPSQL_ARRAY_INSERT_DUPREC

RaymondGiuseppi — Tue, 20 May 2014 14:57:26 GMT

Did you look for OSS notes for your version ?

33267	SDRQCR21 cancels with duplicate record
25444	SDRQCR21: Recovery of sales and delivery requirements
1023578	SDRQCR21 not fixing when wrong plant or material in VBBE
1562605	CALL_FUNCTION_REMOTE_ERROR SAPSQL_ARRAY_INSERT_DUPREC

Regards,

Raymond