I wanted to let you know of an experience I had, an issue I encountered twice and finally figured out this morning. This cost me a number of hours… so thought it would be a good idea to save a few of yours in case you encounter the same kind of issue.
Encounter of the First Kind
I delivered a solution build to a client for user testing. He contacts me to say that products don't show up when opening a product pick list. I attempt to reproduce the error on my system. No go! I contact the client and he shares his screen and, lo and behold, I see the issue. The product pick list gets its data from an external file. I open the external file directly and no problem… and suddenly the issue is no more. We try again and again to reproduce the issue to no avail. Sigh!
Encounter of the Second Kind
Two weeks later, today, I deliver another build for user testing. He tells me there is a problem resetting passwords. I look at the code, find an error and promptly send a revision. He contacts me again, saying the issue remains, and asks that I do more testing prior to sending him builds. I hate that speech.
I spend hours trying to reproduce any user management issue… and can't. I contact the client. He shares his screen. Now the problems are piling up. I share my screen. We go through the same motions… but I encounter no problem whatsoever. The client restarts his computer… just in case. No go! I repackage the files and send anew. No go! He shares his screen again and I invoke the debugger to see what is happening when buttons are clicked.
100 - File is missing. Yet it's there. I manually open the file and, suddenly, everything works again. What gives?
I recall details that seemed unimportant at the time. FileMaker displayed a dialogue saying the file was already uploaded and hosted on a server. Did I want to open the local or hosted file? There is also an option to never show this dialogue from then on. This looks an awful lot like a problem I had with the iOS SDK when the iOS app attempted to connect to a server with a certificate issue. It simply would not.
If you intend to deliver files to a client and these files have already been uploaded, I recommend you add a step to your prep work prior to packaging them. Open each file on your system and click the option to never show the dialogue again. You don't even need to enter a username and password for the option to stick. I tried this today and it solved the issue.
Hope this helps.