Are you seeing any offsets in the data? WHat I mean is the data being shifted to the right or left, out of its columns?
I have had that problem moving files accross the network. Sometimes when it happens, the delete flag for that record gets set.
Other than that, I have no idea. I would suspect a user has gotten bored and has started deleting the records.
>Hi All
>
>In a 2.6 system which has been up and running for the last 5yrs or so without problem, a "junction" table has suddenly incurred thousands of deleted records where no delete instruction has been issued by the application. I have had to hastily write a tool to RECALL the deleted records when they are discovered after a policyholder's enquiry.
>
>These records point driver(s) to vehicle(s) on single and fleet motor insurance policies. This, as you will imagine is a very serious issue. For all intent and purpose, we query a vehicle record to find there are no drivers! Of course there are, the pointer records in the junction table have been deleted and have to be recalled.
>
>I re-iterate, there is no single programmed scenario that would delete these records to anything like this scale? If we delete a driver on a policy, the individual pointer record is deleted. However, this is done individually and infrequently. We have suddenly been hit with this plague of deleted records in the last 48 hours.
>
>Is anyone aware of any environmental way that as a result of a system/workstation crash etc., records can be deleted without a DELETE command having been explicitly issued?
>
>Any comments welcomed.
>
>TIA
--Todd Sherman
-Wake Up! Smell the Coffee!