Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Error SAPSQL_ARRAY_INSERT_DUPREC in program "LCLVFF10"

Former Member

‎2012 Apr 02 11:46 AM

0 Likes
862

hi All,

We got an error "SAPSQL_ARRAY_INSERT_DUPREC" in Production system for the program LCLVFF10, when I see the description it appears like it tried to insert an existed record into KSSK table.

As it was from standard code, is there any option to get it solved by BASIS or Admin.

Or do I need to search for a Note. I checked the note 140106, can anyone let me know whether it suits our requirement or not.

Thanks in Advance

Srinivas.

3 REPLIES 3
Read only

madhu_vadlamani
Active Contributor

‎2012 Apr 02 11:56 AM

0 Likes
702

Hi Srinivas,

Can you explain in which transaction you got the error.

Regards,

Madhu.

Read only

Former Member

‎2012 Apr 02 12:04 PM

0 Likes
702

Hi Sriniva,

It might be number ranges issue. Have you created any new number ranges in the system. If so, please check the old number ranges and create new number ranges differently.

Regards,

Gangadhar.

Read only

Former Member

‎2012 Apr 02 4:35 PM

0 Likes
702

Hello Srinivasa,

There can be two reasons , one you an inconsistent record on the database. Second , if you have incorrect current number on the number ranges.

For the first reason, you will need to run few reports . Please check if report RCCLZUOB solves the issue.  Notes 74603 and 493414 has additional information on this.

For the second reason , Please check Table NRIV, OBJECT = CU_INOB and check the current number. Please ensure it is higher then the last number stored on table INOB.

Please let me know if that doesnot help

Thanks

Amber