0 Replies Latest reply on Jan 11, 2013 5:19 AM by RobertNl

    Scheduled script for read write to MS SQL db crashes

    RobertNl

      Title

      Scheduled script for read write to MS SQL db crashes

      Your post

           Hi there,

           We have a script that reads and writes from filemaker to MS SQL.
           When this script is started manually from the user interface there is no problem.
           When the script is started automatically from "schedules" in the admin console, The reading part is okay, but it crashes on the "write part.

           Checked ODBC on server as on local : okay
           Checked rights on db : Okay

           Working with :Filemaker version 11, OS version: windows server 2008 R2 standard 64b


           Any ideas on how to tackle this problem?

            

           Logging:

           2013-01-06 01:15:00 Server Events Information Schedule "import TKRs from QMM" running.
           2013-01-06 01:15:00 Server Events Information Schedule "import TKRs from QMM" has started FileMaker script "import TKR from QMM database".
           2013-01-06 01:15:00 Server Events Information Schedule "import TKRs from QMM" scripting error (16) at "info-system : Users-select-MSE : Perform Find".
           2013-01-06 01:15:00 Server Events Information Schedule "import TKRs from QMM" scripting error (802) at "info-system : import TKR from QMM database : Import Records".
           2013-01-06 01:15:00 Server Events Information Schedule "import TKRs from QMM" scripting error (401) at "info-system : import TKR from QMM database : Perform Find".