Discussion:
data corruption - wierd
(too old to reply)
John York
2008-12-03 20:54:21 UTC
Permalink
One of my clients has a table where the last 484 records the dataa has
shifted ONE character to the left.

ie:

the first field is a 6 character field with a 6 character acct number in
it. the second field is a four character Field with a three character
map number in it The data SHOULD be
SMI001 001
JON006 045

What they have is

MI0010 01
ON0060 45

Some of the fields are logical - and the field to the left now has a F
in it (for false appently)

the numerical fields are fine - just the character fields have this shift
84 records with this problem

The only clue I have is that the field to the left needs to be a
charcter field for this shift to have taken place

John

Anyone have any ideas?? I'm stumped

This table is the parent table with several child tables associated with
it - but again it is onlkly the last 4
Glenn
2008-12-03 22:17:40 UTC
Permalink
Post by John York
One of my clients has a table where the last 484 records the dataa has
shifted ONE character to the left.
the first field is a 6 character field with a 6 character acct number in
it. the second field is a four character Field with a three character
map number in it The data SHOULD be
SMI001 001
JON006 045
What they have is
MI0010 01
ON0060 45
Some of the fields are logical - and the field to the left now has a F
in it (for false appently)
the numerical fields are fine - just the character fields have this shift
84 records with this problem
The only clue I have is that the field to the left needs to be a
charcter field for this shift to have taken place
John
Anyone have any ideas?? I'm stumped
This table is the parent table with several child tables associated with
it - but again it is onlkly the last 4
I don't know how it happened, but I has a similar problem, except my
data was "striped." Each successive record was one character more to the
left, and you could see a "strip" while browsing. I believe it was a
disk problem. May not be the same as yours, but something to think about.

Glenn
John York
2008-12-03 23:27:22 UTC
Permalink
might be - this is a networked situation - BDE and app on each
workstation - data on the server
Post by Glenn
Post by John York
One of my clients has a table where the last 484 records the dataa has
shifted ONE character to the left.
the first field is a 6 character field with a 6 character acct number
in it. the second field is a four character Field with a three
character map number in it The data SHOULD be
SMI001 001
JON006 045
What they have is
MI0010 01
ON0060 45
Some of the fields are logical - and the field to the left now has a F
in it (for false appently)
the numerical fields are fine - just the character fields have this shift
84 records with this problem
The only clue I have is that the field to the left needs to be a
charcter field for this shift to have taken place
John
Anyone have any ideas?? I'm stumped
This table is the parent table with several child tables associated
with it - but again it is onlkly the last 4
I don't know how it happened, but I has a similar problem, except my
data was "striped." Each successive record was one character more to the
left, and you could see a "strip" while browsing. I believe it was a
disk problem. May not be the same as yours, but something to think about.
Glenn
Lysander
2008-12-04 09:44:31 UTC
Permalink
Post by John York
One of my clients has a table where the last 484 records the dataa has
shifted ONE character to the left.
only 1 (one!) possible reason: faulty hardware.

the problem is to find out which part it is.

Can be anything from network adapter or cable or switch/hub or even RAM
or HD on any of the involved machines.
John York
2008-12-04 12:35:10 UTC
Permalink
Thanks to all

I am going to try and get them to bring in their hardware people on
this. I only hope their backup system has been working correctly

John
Post by Lysander
Post by John York
One of my clients has a table where the last 484 records the dataa has
shifted ONE character to the left.
only 1 (one!) possible reason: faulty hardware.
the problem is to find out which part it is.
Can be anything from network adapter or cable or switch/hub or even RAM
or HD on any of the involved machines.
Rick Gearardo
2008-12-04 14:39:14 UTC
Permalink
Check to see if they made any changes to the server. I added 1g nics to my
Novell server a few years ago not realizing how much power they drew. They
actually slowed the spin rate of the HD and corrupted all the data.

Reinstalling the old nics solved the problem.

Rick
Post by John York
Thanks to all
I am going to try and get them to bring in their hardware people on this.
I only hope their backup system has been working correctly
John
Post by Lysander
Post by John York
One of my clients has a table where the last 484 records the dataa has
shifted ONE character to the left.
only 1 (one!) possible reason: faulty hardware.
the problem is to find out which part it is.
Can be anything from network adapter or cable or switch/hub or even RAM
or HD on any of the involved machines.
John York
2008-12-04 15:03:32 UTC
Permalink
talked to them this AM

They said "the server is new - it is only 3 years old" - they never shut
it off, the baxkup system has been scheduled to run every night at
midnight, but they haven't gotten a good backup in over a week. Sure
sounds like a hardware problem to me.

Their hardware guy is supposed to come in today - we'll see what he has
to say

thanks again to everyone

John
Post by Rick Gearardo
Check to see if they made any changes to the server. I added 1g nics to my
Novell server a few years ago not realizing how much power they drew. They
actually slowed the spin rate of the HD and corrupted all the data.
Reinstalling the old nics solved the problem.
Rick
Post by John York
Thanks to all
I am going to try and get them to bring in their hardware people on this.
I only hope their backup system has been working correctly
John
Post by Lysander
Post by John York
One of my clients has a table where the last 484 records the dataa has
shifted ONE character to the left.
only 1 (one!) possible reason: faulty hardware.
the problem is to find out which part it is.
Can be anything from network adapter or cable or switch/hub or even RAM
or HD on any of the involved machines.
Andrew Shimmin
2008-12-05 04:25:33 UTC
Permalink
Post by Rick Gearardo
Check to see if they made any changes to the server. I added 1g nics to my
Novell server a few years ago not realizing how much power they drew. They
actually slowed the spin rate of the HD and corrupted all the data.
Reinstalling the old nics solved the problem.
So why not just upgrade the server power supply? I would take 1gbs over 100mbps any day.

regards, andrew

Loading...