1 Reply Latest reply on Jun 8, 2012 4:39 AM by Mike_Mitchell

    Database Server Crashing - ODBC/ESS related?

    jmrusch

      I have a client running FMSA 12 on Lion; they just converted earlier this week. Mostly going okay, except one server script (that has been running fine nightly for over a year on FMSA 11) crashes the database server. The FM Server log shows nothing.

       

      I set up some logging within the script itself to narrow down the problem. It turns out to be a find on a timestamp field in an MS SQL Server database (BlackBaud) that is accessed via ESS using the Actual Tech Driver for SQL Server (latest version, 3.1.4). I can cause the crash if I attempt the same find from my copy of FMA 12 accessing the hosted database.

       

      Other finds on other fields in the same MS SQL Server database table work correctly.

       

      I'm able to replicate the crashing behavior if I try to sort on that same timestamp field.

       

      Any thoughts, ideas or suggestions would be much appreciated.

       

      Thanks,

      Julie

        • 1. Re: Database Server Crashing - ODBC/ESS related?
          Mike_Mitchell

          Julie -

           

          This isn't my best area, but two thoughts come to mind:

           

          1) Indexing. Are there indexes built on this timestamp field? If this is a large SQL table, and there are no indexes, we might be hitting a timeout issue.

           

          2) Timestamp format. Depending on the format the SQL Server database is using, FileMaker might be choking on the format in which the timestamp is stored. (This is an idea I'm throwing out; I don't have a good solution for it.)

           

          Just a couple of ideas to think about.

           

          Mike