0 Replies Latest reply on Jul 28, 2012 1:36 PM by jmrusch

    FMSE Dead after Database Server restart

    jmrusch

      Summary

      FMSE Dead after Database Server restart

      Product

      FileMaker Server

      Version

      FMSA 12

      Operating system version

      Mac Lion, Mac Snow Leopard

      Description of the issue

      One of my clients's database server (FMSA 12, Mac Lion) is crashing regularly.

      Anyway, it's simple to restart the database server in the admin console, but the FileMaker Scripting Engine (FMSE) doesn't automatically restart when the database server restarts.

      So any server script that tries to run aborts and the server log shows a message that tells you to restart FMSE using this command: fmsadmin start fmse.

      That command gives an error 10006 which apparently means "errAEWriteDenied or telCAUnavail: a CA is not available". My reaction -- "huh?" The client's IT guy thinks it has something to do with certificates, but he spent today making sure all certificates were installed and up to date (if those are the right terms), but we still see the same error. The only way we've figured out to restart the FMSE is to restart the whole machine.

      I am able to reproduce the problem on my copy of FMSA 12 running on Snow Leopard.

      Steps to reproduce the problem

      1. Crash your database server (in our case, all we have to do is any of a series of find requests on an external MSSQL data source using Actual Tech drivers and ESS, but that's another problem).

      2. Restart the database server using admin console.

      3. Server-based scripts will all abort until the FMSE is restarted.

      4. Can't restart the FMSE using command: fmsadmin start fmse (get error 10006).

      5. Must restart the whole FM Server machine to clear up the problem.

      Expected result

      After database server restart, server-based scripts should run.

      Actual result

      After database server restart, server-based scripts don't run because the FMSE is dead.

      Exact text of any error message(s) that appear

      Message in log: "restart FMSE using this command: fmsadmin start fmse"

      After issuing that command, we get error 10006.

      Configuration information

      Mac mini running Lion.

      Problem also occurs on Mac Pro running Snow Leopard.

      Workaround

      Restart the whole FM Server machine.