topic Re: DataBase table Data issue in Application Development and Automation Discussions

DataBase table Data issue

Former Member — Wed, 24 Jun 2009 13:42:13 GMT

Hi Experts,

I have one custom table and I have inserted data's from one Custom program. The data's from the program stored into the table perfectly. Now the problem is after that the saved data's disappeared unknowingly.

May be the data deletion process is done by any program. Now my question is How to find the Data's of Database table getting deleted? If its done by any program How can I found that program exactly.

I was used Event trace. But there is no use.

All suggestions will he Highly Appreciated.

Thanks All.

Re: DataBase table Data issue

Former Member — Wed, 24 Jun 2009 13:52:31 GMT

Hi,

Did you use commit work after insertion of records in your program. If not use COMMIT WORK after Inserting the records.

Regards,

Satish

Re: DataBase table Data issue

Former Member — Wed, 24 Jun 2009 13:52:35 GMT

Do a where used list for the table and look for programs that delete.

Rob

Re: DataBase table Data issue

former_member189420 — Wed, 24 Jun 2009 13:53:49 GMT

Hi Nandini,

Have you used commit work statement in your program after uploading the data into your custom table?

Regards,

Anand Patil

Re: DataBase table Data issue

Former Member — Wed, 24 Jun 2009 14:00:40 GMT

Use Tran : SCU3 to track table changes. But logging for the table needs to be activated which is done in the technical attrinutes of the Table.

Also Run report RSVTPROT .

Re: DataBase table Data issue

Former Member — Wed, 24 Jun 2009 14:05:26 GMT

Thanks For all the replies. I didnt used Commit work. So I'll check it out and revert back to you.

And Rob Now im checking the Programs using where used List.

Thanks Again.

Re: DataBase table Data issue

Former Member — Wed, 24 Jun 2009 14:12:04 GMT

There is an implicit COMMIT at the end of the program. This shouldn't be a problem.

Rob

Re: DataBase table Data issue

Former Member — Thu, 25 Jun 2009 12:01:19 GMT

Thanks All. Using where used list I found the code and removed it. Thanks Again.