Buffering Issue

[Former Member]

Hi

My issue is

There is no data in the ztable as of now earlier there was data but i have deleted it.

when im trying to insert into ztable thrwoing an error duplicates are not allowed inspite there is no data in the ztable.

could anyone has any solution for this.

Moderator message: please use a more meaningful subject line next time.

Edited by: Thomas Zloch on Mar 29, 2010 11:37 AM

[Former Member]

Hi

Find the below things you can do it an SE14 and check again.

GO TO SE14 Transaction -

---

> Activate adjust database -

---

> Delete data

[Former Member]

Activate the table using SE14 Database utility, click on the button activate and adjust with radio-button on delete entries if there isnt any data in the table. If you still face any problem check if any indexes are created with unique index and reply back.

[Former Member]

Hi,

try SE14 and adjust the database table.

Afterwards try inserting again.

Cheers,

André

[Former Member]

Still im facing the same problem

when i have replaced modify with insert its working fine but with insert im not able to do.

but in quality server and pre=production server with insert it is working fine but in dev server it is not working

[Former Member]

Hi

Have you included in the mandt field also in the strcture for the table which you trying to insert. If not included the mandt field inculded it. Sometime it will create propblem. check and let me know.

[Former Member]

Hi

I have included the mandt filed in the table structure

im not able to understand why it is working fine in quality and pre-production server

[Former Member]

Hi

Have you checked in the fields are in the order for your program as similar in the table.

[Former Member]

yes they all are in the same order

[Manohar2u]

It sounds there is data in table.

Do a SELECT from tthis table. And if you see some data coming and you dont want DELETE it from program.

May you haven't delete from SE14 - utility properly.!!

[ThomasZloch]

How do you know it's a buffering issue? Are you inserting from an internal table? Are you sure the internal table does not contain entries with duplicate keys? Is it possible that you changed your coding in development so it doesn't work there any more?

Thomas

[Former Member]

hai ,

Hope in your development system data is not there and you are trying with modify command

wtih update or insert try in the development system

Regards

K Vinay Kumar