topic Re: Buffering Issue in Application Development and Automation Discussions

Buffering Issue

Former Member — Mon, 29 Mar 2010 06:25:39 GMT

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

Re: Buffering Issue

Former Member — Mon, 29 Mar 2010 06:32:31 GMT

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

GO TO SE14 Transaction -

> Activate adjust database -

> Delete data

Re: Buffering Issue

Former Member — Mon, 29 Mar 2010 06:32:35 GMT

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.

Re: Buffering Issue

Former Member — Mon, 29 Mar 2010 06:33:02 GMT

Hi,

try SE14 and adjust the database table.

Afterwards try inserting again.

Cheers,

André

Re: Buffering Issue

Former Member — Mon, 29 Mar 2010 06:58:00 GMT

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

Re: Buffering Issue

Former Member — Mon, 29 Mar 2010 07:12:21 GMT

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.

Re: Buffering Issue

Former Member — Mon, 29 Mar 2010 07:15:59 GMT

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

Re: Buffering Issue

Former Member — Mon, 29 Mar 2010 08:32:19 GMT

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

Re: Buffering Issue

Former Member — Mon, 29 Mar 2010 08:53:26 GMT

yes they all are in the same order

Re: Buffering Issue

Manohar2u — Mon, 29 Mar 2010 09:08:34 GMT

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.!!

Re: Buffering Issue

ThomasZloch — Mon, 29 Mar 2010 09:38:20 GMT

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

Re: Buffering Issue

Former Member — Mon, 29 Mar 2010 09:49:21 GMT

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