It is tough to say why if it completes only 30% of the time. That would lead me to believe that it is a valid script. The fact that it runs from FM Pro without fail seems to say it might not be a connection issue. Are you accessing the file structure on the server?
Have you tried running the script with PSOS through FMP? Any different results?
There might be something in those particular data sets from that location that are causing a problem or the connection is so bad that it is causing an issue in the transferred data itself.
yes, we are accessing the files structure on the server, going to central server file layouts and doing finds there(and that's where the script is breaking).
I haven't tried running the script with PSOS, probably because we want it running on a schedule, but i can try that.
Does the error code 152 says anything else, like "aborted by user" is not so helpful, it should give more info where the error is happening, is it on the server files, the local files, or any info that might help troubleshooting such issues.
It might be related to a permissions issue.
Is it Windows or OS X or mixed environments?
Are you running any system level code alongside filemaker script steps in that script?
Two other machines might have different setups than the rest.