Runtime error SAPSQL ARRAY INSERT DUPREC in AFAB

[Former Member]

Hi All,

We are facing runtime error at the time of running AFAB for the year/Period 2011/09.

Please help me to resolve this issue.

Regards,

Juhi

[nishansap]

Dear Juhi,

This error means that a transaction / program was attempting to commit  information to the database that would result in a duplicate entry in a table with primary key.

If this is your Production system search on OSS for a solution, if this is a QA or DEV box - check number range object settings etc.

First Check your number range setting AS08

Thanks,

Nishan Dev

[Former Member]

Hi Nishan Dev,

It is Dev system.

Please update me what we have to do resolve this issue.

Regards,

Juhi

[nishansap]

Juhi,

I already refered you for DEV System, pleae check your number ranges setting on AS08

Thanks

Nishan

[Former Member]

Hi

NIshan,

In the table TABA value is deleted and in the table ANLP value is still display that's why run time error is coming.

Please suggest what we have to do.

Regards,

Juhi

[nishansap]

You cannot delete it from ANLP, if you have removed them from TABA, please enter new or same number range with year 2013 to 9999 and try to run the AFAB

Thanks

Nishan Dev

[Former Member]

Dear Nishan Dev,

Error is resolve by entering the value in table TABA.

We display all the document number range in FB03 using document type and update in table TABA.

And run the AFAB now runtime error is resolve.

Thanks & Regards,

JUhi