Table Entries are not Updated

[former_member593777]

We have created custom table to store the trip approval information .

In this table new record is inserted when the trip is created and sent for approval.

1.We can see this new record in Se11.

2.Same record should be updated when the trip is approved.

Probelm : But when the trip is approved the record is disappered from the table.

We can't see the record from se11.Some times records are updated correctly.

3. After the trip approval,we are using selct query in which we are

selecting the updated approval information.This select query returns sy-subrc value 0.4.We have maintained size category 2 (Data records expected: 7.000 to 28.000) .

Entries stored in the table are 49,128.5.This functionality was working fine before upgrade.

Now also it is working fine in our quality system but not in production system.

Please do the needfull.

[Former Member]

Hi,

Are you able to replicate this scenario? If yes then you can debug the code.

Also, the check the program which is supposed to update the trip information if it has any deletion code. Check for conditions on which this deletion code might be triggered. And then validate with the condition during which the trip get's deleted.

I think this will give you a fair amount of idea

Regards

Nishant

[Former Member]

Hi Nagendra,

As it is a z program, through degugging you can find out what the problem is, easily. Just put some breakpoints in the code and see what is happening when the trip is approved.Before you are selecting the updated information through the select query, something is happening because the sy-subrc is 0.

So, check the code between the approval step and the select query to retrieve the updated information.

Because you are saying that it is working fine in QA, but not in Production, there might be some other problems. I don't think there is any problem with the code.

Try to increase the size category of the table and then try to debug and see.

Hope this helps.

Please reward if useful.

Thanks,

Srinivasa

[former_member593777]

Hi ,

Thanks for your reply.

Do we need to adjust the database after changing the technical settings for custom table?

As our problem is only in production we are unable to debug the code and find out teh exact problem.

But the same user who is facing the problem did the same process in quality ,it works fine.

Some time entries are disappeared(deleted) and sometimes not updated.

Best Regards,

Veena.

[Former Member]

You just need to activate it after changes in technical settings

I recommend you raise a request for debugging in production and then de-bug. Sometimes the issues can only be solved at the source of the problem. Sometimes until you actually observe in Production you are not able to determine settings/scenarions in which this might be happening.

Regards

Nishant