jpfuentes2
New Member
I have a 10.1B progress hosted on a 64 RHEL box. We made the switch from 9.1E to 10.1B over a year ago and thus far haven't experienced any serious problems until lately.
We have a certain table where records are being removed from the table without a known cause. My problem is two-fold: 1) the same set of records are being deleted 2) it is occurring at different times of the day. We use a mix of ODBC/4gl scripts and I cannot find anything that would cause this. The first reason being that we do not have any cron jobs set up on our servers to run any kind of app that would even come near that table, much less delete records. Also, as I said, the records are being deleted at different times: sometimes during work hours and sometimes not (I have a cron job which copies the table so that I can audit).
The other issue is that our progress software is provided by another vendor which means I cannot directly contact progress for support. I had our vendor do an online index check which did nothing. Last Wednesday I had him do an offline index rebuild and I have not seen any records deleted yet. They would normally have been deleted by now.
The offending table has 26 fields and 3 indexes. The primary is a username field with 2 others. My problem is further compounded by the fact that it is the same records being deleted each time and in increments. What I mean by this is the same records for that username are being deleted everyday, but in incremental steps.
My mind tells me it is an irrational belief to hold that the database is surgically removing the same records. It makes more sense to believe that some kind of cron job is deleting records by a particular query for that username; however, access is limited to the machine and I have already inspected those points of entry.
Does anyone have any ideas? Could it possibly be that the offline index rebuild solved our problem? If so, does anyone have any potential explanations?
We have a certain table where records are being removed from the table without a known cause. My problem is two-fold: 1) the same set of records are being deleted 2) it is occurring at different times of the day. We use a mix of ODBC/4gl scripts and I cannot find anything that would cause this. The first reason being that we do not have any cron jobs set up on our servers to run any kind of app that would even come near that table, much less delete records. Also, as I said, the records are being deleted at different times: sometimes during work hours and sometimes not (I have a cron job which copies the table so that I can audit).
The other issue is that our progress software is provided by another vendor which means I cannot directly contact progress for support. I had our vendor do an online index check which did nothing. Last Wednesday I had him do an offline index rebuild and I have not seen any records deleted yet. They would normally have been deleted by now.
The offending table has 26 fields and 3 indexes. The primary is a username field with 2 others. My problem is further compounded by the fact that it is the same records being deleted each time and in increments. What I mean by this is the same records for that username are being deleted everyday, but in incremental steps.
My mind tells me it is an irrational belief to hold that the database is surgically removing the same records. It makes more sense to believe that some kind of cron job is deleting records by a particular query for that username; however, access is limited to the machine and I have already inspected those points of entry.
Does anyone have any ideas? Could it possibly be that the offline index rebuild solved our problem? If so, does anyone have any potential explanations?