Error 100 is file missing. Do you have an open file script step that opens the second/FileMaker file.
Also check that the fms server system account has access to the external FileMaker file.
Both files are on 11 Server Advanced. When I open remote the file with this script it pulls and pushes the data like it was designed to do. But when I run the same script from the server, the script pulls in the data from the Oracle table into an array. But when the script tries to Set Fields in the external filemaker table, it does not create any records in the table and the server log says that the script has had an 100 error every time it executes a Set Field step.
This script runs on a client, but not on the server session?
The files are almost certainly not in the same folder on the FM server. When running on the server, you have to tell it specifically where the external file is located. When running interactively, each file can "see" the other files that are hosted on the server.
See this FM help page. http://www.filemaker.com/help/html/create_db.8.32.html
You need to add a second file reference in the external file reference specification in the form of:
Foldername is the name of the sub-folder that the other file is stored in and dbfilename is obviously the name of the dB file.
When done, you will have the following in the external file reference:
I wasted 10 hours bug tracking until I found this thread.
Thank you both for posting....else I'd be in lalalala land.