SAPSQL_ARRAY_INSERT_DUPREC Runtime Error for Z table in SM30

[Former Member]

Dear Experts.

I am fasing an issue in Table maintainence., by SM30. for a ZTable.

If I am trying to enter an already existing record, insted of throwing an error, it is throwing a Runtome error showing that

Runtime Errors SAPSQL_ARRAY_INSERT_DUPREC

Exception CX_SY_OPEN_SQL_DB

An exception occurred that is explained in detail below.

The exception, which is assigned to class 'CX_SY_OPEN_SQL_DB', was not caught

in

procedure "TABLE_DB_UPD" "(FORM)", nor was it propagated by a RAISING clause.

We are on Ecc 6.0.

Please help me to sort this issue.

Thanks in advance,

Regards,

Rahul.

[Former Member]

Hello

You may insert only one record with unique key.

If such record already exists in table you can't insert more with same key.

[Former Member]

Hi,

Have you added any new primary key into the Ztable..? If you have altered the primary keys delete the table maintenance and generate it once again. If the records are already there the table maintenance will not allow to enter the same records with similar records.

Best Regards,

Senthil

[Former Member]

Hi Rahul,

did you change teh format of the table or the keylength?

did you replace any standardreoutines using the SE54?

have you created a view for the maintenance dialog, then check your key fields in the view definition!

robert

Edited by: Robert Rein on Oct 23, 2009 12:31 PM

[Former Member]

hi all.

Surprisingly, on it's own it is executing fine.

I was really surprised.

However thank you very much.