11-30-2007 7:26 AM
hI ALL,
My functional consulatant is facing the problem in the system while he is doing some PO work...it shows some error message like "Error process:SAPSQL_ARRAY_INSERT_DUPREC"...
He is asking me what's the issue...is anything u r working on it....bit i didnt do anything and working on some other program which is not at all relevant to his part.
pls do advise ur comments.
thanks & regards
sankar
11-30-2007 9:43 AM
Hi,
If you try to insert/save the same values for the primary key in a table,it will throw such type of error.That is you should enter the same combination of values for primary key in a table.Primary key/Combination of Primary Key should be able to identify the record in database table uniquely.For eg., MARA table should have different material number for each record.
11-30-2007 9:36 AM
This error arises when a program tries to insert a record into a table on the database, with the same key as a record already on the database.
If this is happening in a standard SAP program, then you or the functional guy should check on OSS for a fix, or log a call with SAP.
If it's happening in your own, you'll have to fix the program yourself.
ST22 will show you details about the error.
matt
11-30-2007 9:43 AM
Hi,
If you try to insert/save the same values for the primary key in a table,it will throw such type of error.That is you should enter the same combination of values for primary key in a table.Primary key/Combination of Primary Key should be able to identify the record in database table uniquely.For eg., MARA table should have different material number for each record.