[FX.php List] FMS 10 setting up XML returns sometimes empty record sets, and sometimes fields and data working

[Dale Bengston]

It is possible to display a record with corrupt data pasted in one of  
the fields, but probably not that field. I have experienced this back  
to CDML and FileMaker 4.1. Anytime a specific record was part of a  
found set, and the field that had the corrupt data was on the layout  
being queried, I'd get no data back. Other layouts that did not  
include that field behaved as expected.

I suspect this is most likely to happen in scenarios where there is  
client-server access to FMP fields as well as web-based access.

Roger's point is a good one as well. Failing hard drives can lead to  
intermittent problems. I chased one of these for months before I  
looked at SMART status. Doh! Could have saved myself a lot of trouble.

Dale

On Oct 20, 2009, at 9:15 AM, Leo R. Lundgren wrote:

>
> 20 okt 2009 kl. 15.40 skrev Roger Moffat:
>
>>
>> On Oct 20, 2009, at 8:56 AM, Dale Bengston wrote:
>>
>>> Off-and-on problems can be due to data corruption as well.
>>
>> And a variant on this that hit my FM Server 9 machine - it would  
>> occasionally stop serving, even though the machine was still on,  
>> although not fully - some processes had crashed usually. After a  
>> restart it would be back to normal for some weeks usually.
>>
>> Eventually it didn't come back, and it turned out the drive had  
>> suffered enough SMART failure that it wouldn't proceed.
>>
>> So a new hard drive later the machine has been up for the 49 days  
>> since I replaced the drive. So I assume that the drive failing was  
>> what had been causing the earlier problems too.
>
>
> Something to note is that with the current problem at hand, the one  
> Gjermund and I have experienced, no records disappear. They are  
> visible from within FileMaker, it's just that they don't show up  
> using XML/fmapp.
>
> -|
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list