Thank you for your post.
Once a server side script completes, it should remove itself as a client. However, keep in mind that if records are locked on a client machine, a script performed on the host cannot access uncommitted data or change the contents of those records until the lock is removed, and this may lead to the script waiting for those committed changes. Is this a possibility?
In your Perform Script on Server, do you have the option for Wait for Completion?
Perhaps it would be helpful to know what script steps you are performing on the server.
Any other information you can provide may be helpful.
It's not perform script on server (PSoS), it's a scheduled server side script.
The script step is NEW record (and by the way this script step can't be concerned by locking anyway)
There was the zombie FMPServer user connected to that DB but FMPServer user was not listed in connected clients.
That alone is the problem, and should never be possible.
This situation only occurred once to me with a 302 error "table is user by another user" error.
Howewer, I often, since fms 13 (before was in 11), noticed such zombie FMPServer user. But with less consequences.
I checked the Devecenter file for irruption, there wasn't any.
Thank you for the clarification and additional information.
How often does the schedule run? Once a day? Once an hour?
Do these ghost connections only occur for one file? How many tables are included in the file?
Is there anything "out of the ordinary" in the event.log that corresponds to the time the schedule was run.
Several time a day, 4 times / hour
Only this time on this file with 302 error. But also on other file. In the file there's 7 tables, but not related
nothing un-ordinary, except the 302 error provoked by those zombie
By the way,
Right now I'm having a zombie FMPServer on another file.
But hard to know if this is due to same problem, because I didn't restart (just closed the offending file).
I tried to sample fmserver, with osx monitor app but doesn't seem to work. Nothing in log
The zombi are still here, if you want me to do some clever terminal tricks that's the right time to ask
Since this is also happening in another file, what are the scheduled scripts performing on those files/tables, and how often are those scripts run?
What field options do you have on the table where you receive the "Table is in use by another user" error. That is, do you have a Serial Number option where it is generated on commit? What follows the New Record script step? Is there a Commit Records script step following the New Record step?
Did you have a prior version of FileMaker Server where this was running properly?
Any additional information you can provide about the scheduled script and/or event.log and/or system log might be helpful.
Oh sorry, I think I got confused and misnterpreted data.
The problem is that on Clients you have the User name,
While on the database pane you have Computer name and account name.
So actually, on that screen shot there's no issue. The 3 FMPServer is the computer name of the 3 127.0.0.1 Clients.
That'd be nice that in the file pane there was the client name, so we could compare easily.
Sorry for that wrong report, you can delete it. Now I need to understand why the 302 error