5 Replies Latest reply on Sep 10, 2012 10:18 AM by Slinky66

    Debugging Intermittent Client Errors -1728

    Slinky66

      Title

      Debugging Intermittent Client Errors -1728

      Post

      All,

       

      I am new to Filemaker and it seems I only get involved when something breaks so here is my issue:

       

      On one of our Filemaker Server 11 databases, a user has been getting intermittent errors when running a script, attached to a button.

       

      Unkown Error: -1728

       

      What are the debugging options? Since the error is happening on a client machine, where would the error be logged? Client? Server?

       

      Thank you!

      filemaker-error-2.png

        • 1. Re: Debugging Intermittent Client Errors -1728
          philmodjunk

          Do other users on other machines ever get this error? Are they using the same version of FileMaker Pro as this user? Are they performing the same script with exactly the same records?

          Is the client using FileMaker Pro 11 or an older version of the software? If they are using an older version of the software, this script might include a feature that was first added to FileMaker in a more recent release of the product.

          You could make a copy of this script and insert a series of Show Custom Dialog steps--each with a different message, to narrow down exactly what portion of the script trips this error.

          • 2. Re: Debugging Intermittent Client Errors -1728
            Slinky66

                 Thanks, Phil. Nobody else has been able to reproduce this error on other client machines. The application was developed with Filemaker 10 and that's what the client is running. Based on what I've learned, the error happens right before a "show layout" command. (see below). I am wondering if the set command that happens before the error (set theInventoryID to contents of cell "ID" of current record) can be the issue? What's the best practice in FM to bullet-proof against that?

                 set theDatabaseName to "Sweetwater F&B POs"
                 set theCellName to "Product ID"


                 tell application "FileMaker Pro"
                     set theInventoryID to contents of cell "ID" of current record
                  
                     
                     tell database theDatabaseName
                        -- error happens here
                         show layout "Inventory - All Quantities"
                         show every record

                       ...

            • 3. Re: Debugging Intermittent Client Errors -1728
              Slinky66

                   Is this how to trap an error in FM?

                    

                   set theDatabaseName to "F&B POs"
                   set theCellName to "Product ID"
                   tell application "FileMaker Pro"
                       try
                       set theInventoryID to contents of cell "ID" of current record
                       on error
                       display dialog ("Make sure all inventory ids are valid")
                       end try

                        tell database theDatabaseName
                           --get the intended previous inventory record    
                           show layout "Inventory - All Quantities"
                           show every record
                           set theStartDates to field "DateCounted" of table "Inventory"

                    

                   ...

                    

              • 4. Re: Debugging Intermittent Client Errors -1728
                philmodjunk

                     Not owning a Mac, My experience with Applescript is much too limited to help you.

                • 5. Re: Debugging Intermittent Client Errors -1728
                  Slinky66

                       Thanks, anyway. My syntax is correct.