Replace Field Contents - Communication Error

[IT_User]

I have a customer that I am creating new DB for, but until then, they are using their old one.

 

They have this problem with their old one that when they do a Replace Field Contents it gives the error:

"Communication with the host was interrupted and could not be re-established.  All affected windows will be closed."

 

It only crashes when their one field is categorized by certain data.  If that field has any other data beside that one criteria (and they do a find to get that into a found set), then when they do a Replace, it does not crash.

 

The replace is not being done on the one field, it is being done on separate field(s), which are repeating field(s).  It doesn't matter if the replace is being done in a large found set or only a couple records.  They can manually type into the field without a problem.

 

They only have one table.  This layout does not use script triggers or hidden buttons.  If I create a new layout, and try to do the find on that one field, and then the replace, it will crash.  It won't crash other computers, but will crash individually on each, if performed on there.

 

They have Windows and they are connected through a VPN.

 

Both and the customer has posted on Forums.  The one solutions was to take it off the server, do a recovery on the file, and then upload it again.  That had worked, but only for a while.  The answer I was given was that either some other user had been in there when the Replace-Field Contents had been occurring or there was validation.  The fields don't have validation, and they have tried it with only one person in the system. 

 

Any help is appreciated, thanks!

 

http://forums.filemaker.com/posts/d29b09a0c0

[Rick Whitelaw]

The message you're encountering has nothing to do with what follows in your post. This is a network issue. The connection to the host was lost for some reason. As well, I see no indication that the app is crashing. When the client loses the connection to the host FileMaker will close all windows involved. However the application should still be active albeit with no windows open.

[IT_User]

Thank you, I couldn't find a general area to put this in, so I put it somewhere.  Thank you for letting me know where it should go, but I don't know how to move this.

 

And I believe you are are correct it doesn't crash the app, but it does close all windows.  It happens almost every time when they do the Replace Field Contents on a repeating field.

 

Do you know how to help diagnose or fix or something about this issue? Thank you!