Urgent Inserting a record corrupts index

Every time one of my users inserts a record into a table the primary index
becomes corrupt. I have deleted the indexes and rebuilt them 3 times. Other
than a network problem (which I am told there are none) what could be
causing this.

This process has not been modified since 06/01/2006.

VFP 7 SP 1

Thanks
Tom

Gene
Thu Nov 02 16:16:49 CST 2006

"Tom Libby" <tlibby@bigblue-usaNOSPAMNOVIRUS.com> wrote:

>Every time one of my users inserts a record into a table the primary index
>becomes corrupt. I have deleted the indexes and rebuilt them 3 times. Other
>than a network problem (which I am told there are none) what could be
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Why do you believe this?

>causing this.

It could be a network problem. VFP puts more of a load on a
network. The network may be flaky and good enough for some uses.

[snip]

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.

Tom
Thu Nov 02 16:34:13 CST 2006

Thanks for the reply. The network admin was using a program that displays
errors on the network and none where showing up. I kept saying there is a
network issue but since there are no errors and the Fox 2.5 Dos app they run
was not having any problems they did not believe me. So they finally got a
packet sniffer running and determined that a switch was having a problem.
After they unplugged the switch everything is back to normal.

Thanks again
Tom

"Gene Wirchenko" <genew@ocis.net> wrote in message
news:2grkk25vavnisc87qq7767icnu8vsomm13@4ax.com...
> "Tom Libby" <tlibby@bigblue-usaNOSPAMNOVIRUS.com> wrote:
>
>>Every time one of my users inserts a record into a table the primary index
>>becomes corrupt. I have deleted the indexes and rebuilt them 3 times.
>>Other
>>than a network problem (which I am told there are none) what could be
> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> Why do you believe this?
>
>>causing this.
>
> It could be a network problem. VFP puts more of a load on a
> network. The network may be flaky and good enough for some uses.
>
> [snip]
>
> Sincerely,
>
> Gene Wirchenko
>
> Computerese Irregular Verb Conjugation:
> I have preferences.
> You have biases.
> He/She has prejudices.

Gene
Thu Nov 02 17:02:37 CST 2006

"Tom Libby" <tlibby@bigblue-usaNOSPAMNOVIRUS.com> wrote:

>Thanks for the reply. The network admin was using a program that displays
>errors on the network and none where showing up. I kept saying there is a
>network issue but since there are no errors and the Fox 2.5 Dos app they run
>was not having any problems they did not believe me. So they finally got a
>packet sniffer running and determined that a switch was having a problem.
>After they unplugged the switch everything is back to normal.

I am glad to be of help.

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.

Jeff
Fri Nov 03 10:21:09 CST 2006

Hello Everyone,

Since at my place I am both the developer and the network admin, could you
please tell me more about how they diagnosed the network problem. Any ideas
or pointing me toward tools and references would be appreciated.

Thanks,
Jeff
"Tom Libby" <tlibby@bigblue-usaNOSPAMNOVIRUS.com> wrote in message
news:O0j2V8s$GHA.4864@TK2MSFTNGP04.phx.gbl...
> Thanks for the reply. The network admin was using a program that displays
> errors on the network and none where showing up. I kept saying there is a
> network issue but since there are no errors and the Fox 2.5 Dos app they
> run was not having any problems they did not believe me. So they finally
> got a packet sniffer running and determined that a switch was having a
> problem. After they unplugged the switch everything is back to normal.
>
> Thanks again
> Tom
>
> "Gene Wirchenko" <genew@ocis.net> wrote in message
> news:2grkk25vavnisc87qq7767icnu8vsomm13@4ax.com...
>> "Tom Libby" <tlibby@bigblue-usaNOSPAMNOVIRUS.com> wrote:
>>
>>>Every time one of my users inserts a record into a table the primary
>>>index
>>>becomes corrupt. I have deleted the indexes and rebuilt them 3 times.
>>>Other
>>>than a network problem (which I am told there are none) what could be
>> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
>> Why do you believe this?
>>
>>>causing this.
>>
>> It could be a network problem. VFP puts more of a load on a
>> network. The network may be flaky and good enough for some uses.
>>
>> [snip]
>>
>> Sincerely,
>>
>> Gene Wirchenko
>>
>> Computerese Irregular Verb Conjugation:
>> I have preferences.
>> You have biases.
>> He/She has prejudices.
>
>

W
Fri Nov 03 13:07:01 CST 2006

just google for 'network packet sniffers'
lots of them

"Jeff Grippe" <jgrippe@hilldun.com> wrote in message
news:12kmr9f86ubhu43@news.supernews.com...
> Hello Everyone,
>
> Since at my place I am both the developer and the network admin, could you
> please tell me more about how they diagnosed the network problem. Any
> ideas or pointing me toward tools and references would be appreciated.
>
> Thanks,
> Jeff
> "Tom Libby" <tlibby@bigblue-usaNOSPAMNOVIRUS.com> wrote in message
> news:O0j2V8s$GHA.4864@TK2MSFTNGP04.phx.gbl...
>> Thanks for the reply. The network admin was using a program that
>> displays errors on the network and none where showing up. I kept saying
>> there is a network issue but since there are no errors and the Fox 2.5
>> Dos app they run was not having any problems they did not believe me. So
>> they finally got a packet sniffer running and determined that a switch
>> was having a problem. After they unplugged the switch everything is back
>> to normal.
>>
>> Thanks again
>> Tom
>>
>> "Gene Wirchenko" <genew@ocis.net> wrote in message
>> news:2grkk25vavnisc87qq7767icnu8vsomm13@4ax.com...
>>> "Tom Libby" <tlibby@bigblue-usaNOSPAMNOVIRUS.com> wrote:
>>>
>>>>Every time one of my users inserts a record into a table the primary
>>>>index
>>>>becomes corrupt. I have deleted the indexes and rebuilt them 3 times.
>>>>Other
>>>>than a network problem (which I am told there are none) what could be
>>> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
>>> Why do you believe this?
>>>
>>>>causing this.
>>>
>>> It could be a network problem. VFP puts more of a load on a
>>> network. The network may be flaky and good enough for some uses.
>>>
>>> [snip]
>>>
>>> Sincerely,
>>>
>>> Gene Wirchenko
>>>
>>> Computerese Irregular Verb Conjugation:
>>> I have preferences.
>>> You have biases.
>>> He/She has prejudices.
>>
>>
>
>