Server Side Scripting Bug

[Robert Schaub]

[7:27:56 PM] Robert Schaub says: Today I discovered and reported to FileMaker as a bug

In FileMake 9 Server , you can now shedule the server to run a script inside any file.

Good So far..

Here's the bug

Loop

Perform Script [Your Script Name]

Go To Record [Next] [Exit After Last]

End Loop

The result ends in an error when it reaches the End Loop

The error is 101 Missing Record.

This causes the server side script to crash and any others after it will not be run.

The Work Around after hours of experimenting

Loop

Perform Script [Your Script Name]

Go To Record [Next] [Exit After Last]

Exit Loop If [Get(RecordNumber) = Get(FoundCount)

End Loop

After the last record it exits loop and the end loop is never executed, therefore the

101 error message is never reported and live goes on.

Those of you with a script debugger try it and click on the option pause at error.

[Steven H. Blackwell]

Which version of FileMaker Server 9 is this? Is it 9.0v3? Also, what is the exact version of the OS on the machine running FMS9?

Steven

[Robert Schaub]

Hi Steven,

The servers 9.v3 are on Macs 10.4.x i believe

Clients use XP with either Advanced or Pro

Try creating the script I posted above and Use the Debugger with pause at error option on.

After exiting from last record and hitting the end loop statement it returns the 101 Missing Record error.

When you run this as a scheduled script on a server the script stops and you get an email message that it failed. I now think this also causes the server to max out on memory and the server must be restarted.

[bobthedog]

Thanks for the fix. It's still present in FM10 server, which is quite annoying.

[ron_hesse]

I can confirm the behavior is still present in FMSA 11 as well. Also chopper's workaround is slightly flawed. As written it will never perform the desired script steps on the last record. The order should be instead:

Loop

Perform Script [Your Script Name]

Exit Loop If [Get(RecordNumber) = Get(FoundCount)

Go To Record [Next] [Exit After Last]

End Loop

[Fitch]

Have you tried this with Allow User Abort [ Off ] and/or Set Error Capture [ On ] ?