topic Re: SAPSQL_ARRAY_INSERT_DUPREC Runtime Error for Z table in SM30 in Application Development and Automation Discussions

SAPSQL_ARRAY_INSERT_DUPREC Runtime Error for Z table in SM30

Former Member — Fri, 23 Oct 2009 09:10:08 GMT

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

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.

Re: SAPSQL_ARRAY_INSERT_DUPREC Runtime Error for Z table in SM30

Former Member — Fri, 23 Oct 2009 09:27:07 GMT

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.

Re: SAPSQL_ARRAY_INSERT_DUPREC Runtime Error for Z table in SM30

Former Member — Fri, 23 Oct 2009 09:44:07 GMT

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

Re: SAPSQL_ARRAY_INSERT_DUPREC Runtime Error for Z table in SM30

Former Member — Fri, 23 Oct 2009 10:26:31 GMT

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

Re: SAPSQL_ARRAY_INSERT_DUPREC Runtime Error for Z table in SM30

Former Member — Mon, 26 Oct 2009 06:23:46 GMT

hi all.

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

I was really surprised.

However thank you very much.