topic Error SAPSQL_ARRAY_INSERT_DUPREC in program "LCLVFF10" in Application Development and Automation Discussions

Error SAPSQL_ARRAY_INSERT_DUPREC in program "LCLVFF10"

Former Member — Mon, 02 Apr 2012 10:46:39 GMT

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.

Re: Error SAPSQL_ARRAY_INSERT_DUPREC in program "LCLVFF10"

madhu_vadlamani — Mon, 02 Apr 2012 10:56:07 GMT

Hi Srinivas,

Can you explain in which transaction you got the error.

Regards,

Madhu.

Re: Error SAPSQL_ARRAY_INSERT_DUPREC in program "LCLVFF10"

Former Member — Mon, 02 Apr 2012 11:04:27 GMT

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.

Re: Error SAPSQL_ARRAY_INSERT_DUPREC in program "LCLVFF10"

Former Member — Mon, 02 Apr 2012 15:35:42 GMT

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