Jump to content
Sign in to follow this  
bwalsh

Error 802 - "Unable to open file" - how to debug?

Recommended Posts

Hi, I am relatively new to FileMaker. I am a PHP developer currently working on a project that involves the FMS custom web publishing PHP API. I was able to successfully connect using the API, but the connection is no longer working. The error message says only "Unable to open file". My research says that this could be due to the database file not being open, or to a permissions issue.

I can see in the FMS admin console that the database file is open, with "normal" status. The FMWEBDIRECT and PHP columns both have full circles, indicating that the database should be accessible through the PHP API. Both the web server and the web publishing engine are on, with green checks, and PHP is activated.

I am using the same username and password that worked previously. I checked again in the database security settings and confirmed that the username and password are still correct and that the user account has the "fmphp" privelege. What else should I look for?

In the web publishing error log I see entries that say:
 

127.0.0.1:63876 [USERNAME] - 802 563 "fmi/sml/fmresultset.xml?-db=[DB]&-lay=[LAYOUT]&-findany"

Does the PHP API use the XML API? Also, here is the full var_dump() of the error object:

 

object(FileMaker_Error)#6 (9) {
  ["_fm"]=>
  &object(FileMaker_Implementation)#2 (3) {
    ["V73ee434e"]=>
    array(9) {
      ["charset"]=>
      string(5) "UTF-8"
      ["locale"]=>
      string(2) "en"
      ["logLevel"]=>
      int(3)
      ["hostspec"]=>
      string(16) "http://127.0.0.1"
      ["recordClass"]=>
      string(16) "FileMaker_Record"
      ["prevalidate"]=>
      bool(false)
      ["database"]=>
      string(11) "DD_Personal"
      ["username"]=>
      string(14) "xxxx"
      ["password"]=>
      string(12) "xxxx"
    }
    ["Vea4b3413"]=>
    NULL
    ["V9a3dcbce"]=>
    NULL
  }
  ["error_message_prefix"]=>
  string(0) ""
  ["mode"]=>
  int(1)
  ["level"]=>
  int(1024)
  ["code"]=>
  string(3) "802"
  ["message"]=>
  NULL
  ["userinfo"]=>
  NULL
  ["backtrace"]=>
  array(7) {
    [0]=>
    array(6) {
      ["file"]=>
      string(90) "/Library/FileMaker Server/Web Publishing/publishing-engine/php/el capitan/lib/php/PEAR.php"
      ["line"]=>
      int(945)
      ["function"]=>
      string(11) "__construct"
      ["class"]=>
      string(10) "PEAR_Error"
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(5) {
        [0]=>
        NULL
        [1]=>
        string(3) "802"
        [2]=>
        NULL
        [3]=>
        NULL
        [4]=>
        NULL
      }
    }
    [1]=>
    array(7) {
      ["file"]=>
      string(101) "/Library/FileMaker Server/Web Publishing/publishing-engine/php/el capitan/lib/php/FileMaker/Error.php"
      ["line"]=>
      int(52)
      ["function"]=>
      string(10) "PEAR_Error"
      ["class"]=>
      string(10) "PEAR_Error"
      ["object"]=>
      *RECURSION*
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(2) {
        [0]=>
        NULL
        [1]=>
        string(3) "802"
      }
    }
    [2]=>
    array(7) {
      ["file"]=>
      string(129) "/Library/FileMaker Server/Web Publishing/publishing-engine/php/el capitan/lib/php/FileMaker/Implementation/Parser/FMResultSet.php"
      ["line"]=>
      int(48)
      ["function"]=>
      string(15) "FileMaker_Error"
      ["class"]=>
      string(15) "FileMaker_Error"
      ["object"]=>
      *RECURSION*
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(3) {
        [0]=>
        &object(FileMaker_Implementation)#2 (3) {
          ["V73ee434e"]=>
          array(9) {
            ["charset"]=>
            string(5) "UTF-8"
            ["locale"]=>
            string(2) "en"
            ["logLevel"]=>
            int(3)
            ["hostspec"]=>
            string(16) "http://127.0.0.1"
            ["recordClass"]=>
            string(16) "FileMaker_Record"
            ["prevalidate"]=>
            bool(false)
            ["database"]=>
            string(11) "DD_Personal"
            ["username"]=>
            string(14) "xxxx"
            ["password"]=>
            string(12) "xxxx"
          }
          ["Vea4b3413"]=>
          NULL
          ["V9a3dcbce"]=>
          NULL
        }
        [1]=>
        NULL
        [2]=>
        string(3) "802"
      }
    }
    [3]=>
    array(7) {
      ["file"]=>
      string(122) "/Library/FileMaker Server/Web Publishing/publishing-engine/php/el capitan/lib/php/FileMaker/Implementation/CommandImpl.php"
      ["line"]=>
      int(84)
      ["function"]=>
      string(5) "parse"
      ["class"]=>
      string(28) "FileMaker_Parser_FMResultSet"
      ["object"]=>
      object(FileMaker_Parser_FMResultSet)#5 (17) {
        ["Vcb5e100e"]=>
        string(3) "802"
        ["Vf5bf48aa"]=>
        array(3) {
          ["build"]=>
          string(10) "10/27/2016"
          ["name"]=>
          string(31) "FileMaker Web Publishing Engine"
          ["version"]=>
          string(10) "15.0.3.308"
        }
        ["V1ea7e575"]=>
        array(7) {
          ["database"]=>
          string(0) ""
          ["date-format"]=>
          string(0) ""
          ["layout"]=>
          string(0) ""
          ["table"]=>
          string(0) ""
          ["time-format"]=>
          string(0) ""
          ["timestamp-format"]=>
          string(0) ""
          ["total-count"]=>
          string(1) "0"
        }
        ["V9f81f3c0"]=>
        array(0) {
        }
        ["Vaae0d98d"]=>
        array(2) {
          ["count"]=>
          string(1) "0"
          ["fetch-size"]=>
          string(1) "0"
        }
        ["Vae581270"]=>
        array(0) {
        }
        ["V6e52c40b"]=>
        array(0) {
        }
        ["Ve13f1c92"]=>
        NULL
        ["V43432a31"]=>
        NULL
        ["V51bc3e3b"]=>
        NULL
        ["V26005321"]=>
        NULL
        ["V6468d939"]=>
        NULL
        ["_fm"]=>
        &object(FileMaker_Implementation)#2 (3) {
          ["V73ee434e"]=>
          array(9) {
            ["charset"]=>
            string(5) "UTF-8"
            ["locale"]=>
            string(2) "en"
            ["logLevel"]=>
            int(3)
            ["hostspec"]=>
            string(16) "http://127.0.0.1"
            ["recordClass"]=>
            string(16) "FileMaker_Record"
            ["prevalidate"]=>
            bool(false)
            ["database"]=>
            string(11) "DD_Personal"
            ["username"]=>
            string(14) "xxxx"
            ["password"]=>
            string(12) "xxxx"
          }
          ["Vea4b3413"]=>
          NULL
          ["V9a3dcbce"]=>
          NULL
        }
        ["V5431b8d4"]=>
        resource(28) of type (Unknown)
        ["V6de51026"]=>
        bool(false)
        ["_result"]=>
        NULL
        ["_layout"]=>
        NULL
      }
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(1) {
        [0]=>
        string(563) ""
      }
    }
    [4]=>
    array(7) {
      ["file"]=>
      string(130) "/Library/FileMaker Server/Web Publishing/publishing-engine/php/el capitan/lib/php/FileMaker/Implementation/Command/FindAnyImpl.php"
      ["line"]=>
      int(17)
      ["function"]=>
      string(10) "_getResult"
      ["class"]=>
      string(32) "FileMaker_Command_Implementation"
      ["object"]=>
      object(FileMaker_Command_FindAny_Implementation)#4 (19) {
        ["_findCriteria"]=>
        array(0) {
        }
        ["Vd65662c5"]=>
        array(0) {
        }
        ["Va9136a07"]=>
        array(0) {
        }
        ["Vf951bdce"]=>
        NULL
        ["V83f28691"]=>
        NULL
        ["V85fd701e"]=>
        NULL
        ["V6da136ea"]=>
        NULL
        ["V568aa2ec"]=>
        NULL
        ["_fm"]=>
        &object(FileMaker_Implementation)#2 (3) {
          ["V73ee434e"]=>
          array(9) {
            ["charset"]=>
            string(5) "UTF-8"
            ["locale"]=>
            string(2) "en"
            ["logLevel"]=>
            int(3)
            ["hostspec"]=>
            string(16) "http://127.0.0.1"
            ["recordClass"]=>
            string(16) "FileMaker_Record"
            ["prevalidate"]=>
            bool(false)
            ["database"]=>
            string(11) "DD_Personal"
            ["username"]=>
            string(14) "xxxx"
            ["password"]=>
            string(12) "xxxx"
          }
          ["Vea4b3413"]=>
          NULL
          ["V9a3dcbce"]=>
          NULL
        }
        ["_layout"]=>
        string(23) "BW Newsletter2Go Import"
        ["V7a2db0ea"]=>
        NULL
        ["_script"]=>
        NULL
        ["_scriptParams"]=>
        NULL
        ["_preReqScript"]=>
        NULL
        ["_preReqScriptParams"]=>
        NULL
        ["_preSortScript"]=>
        NULL
        ["_preSortScriptParams"]=>
        NULL
        ["V0b9a204c"]=>
        string(16) "FileMaker_Record"
        ["_recordId"]=>
        NULL
      }
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(1) {
        [0]=>
        string(563) ""
      }
    }
    [5]=>
    array(7) {
      ["file"]=>
      string(103) "/Library/FileMaker Server/Web Publishing/publishing-engine/php/el capitan/lib/php/FileMaker/Command.php"
      ["line"]=>
      int(137)
      ["function"]=>
      string(7) "execute"
      ["class"]=>
      string(40) "FileMaker_Command_FindAny_Implementation"
      ["object"]=>
      object(FileMaker_Command_FindAny_Implementation)#4 (19) {
        ["_findCriteria"]=>
        array(0) {
        }
        ["Vd65662c5"]=>
        array(0) {
        }
        ["Va9136a07"]=>
        array(0) {
        }
        ["Vf951bdce"]=>
        NULL
        ["V83f28691"]=>
        NULL
        ["V85fd701e"]=>
        NULL
        ["V6da136ea"]=>
        NULL
        ["V568aa2ec"]=>
        NULL
        ["_fm"]=>
        &object(FileMaker_Implementation)#2 (3) {
          ["V73ee434e"]=>
          array(9) {
            ["charset"]=>
            string(5) "UTF-8"
            ["locale"]=>
            string(2) "en"
            ["logLevel"]=>
            int(3)
            ["hostspec"]=>
            string(16) "http://127.0.0.1"
            ["recordClass"]=>
            string(16) "FileMaker_Record"
            ["prevalidate"]=>
            bool(false)
            ["database"]=>
            string(11) "DD_Personal"
            ["username"]=>
            string(14) "xxxx"
            ["password"]=>
            string(12) "xxxx"
          }
          ["Vea4b3413"]=>
          NULL
          ["V9a3dcbce"]=>
          NULL
        }
        ["_layout"]=>
        string(23) "BW Newsletter2Go Import"
        ["V7a2db0ea"]=>
        NULL
        ["_script"]=>
        NULL
        ["_scriptParams"]=>
        NULL
        ["_preReqScript"]=>
        NULL
        ["_preReqScriptParams"]=>
        NULL
        ["_preSortScript"]=>
        NULL
        ["_preSortScriptParams"]=>
        NULL
        ["V0b9a204c"]=>
        string(16) "FileMaker_Record"
        ["_recordId"]=>
        NULL
      }
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(0) {
      }
    }
    [6]=>
    array(7) {
      ["file"]=>
      string(64) "/Library/FileMaker Server/HTTPServer/htdocs/newsletter/index.php"
      ["line"]=>
      int(32)
      ["function"]=>
      string(7) "execute"
      ["class"]=>
      string(17) "FileMaker_Command"
      ["object"]=>
      object(FileMaker_Command_FindAny)#3 (1) {
        ["_impl"]=>
        object(FileMaker_Command_FindAny_Implementation)#4 (19) {
          ["_findCriteria"]=>
          array(0) {
          }
          ["Vd65662c5"]=>
          array(0) {
          }
          ["Va9136a07"]=>
          array(0) {
          }
          ["Vf951bdce"]=>
          NULL
          ["V83f28691"]=>
          NULL
          ["V85fd701e"]=>
          NULL
          ["V6da136ea"]=>
          NULL
          ["V568aa2ec"]=>
          NULL
          ["_fm"]=>
          &object(FileMaker_Implementation)#2 (3) {
            ["V73ee434e"]=>
            array(9) {
              ["charset"]=>
              string(5) "UTF-8"
              ["locale"]=>
              string(2) "en"
              ["logLevel"]=>
              int(3)
              ["hostspec"]=>
              string(16) "http://127.0.0.1"
              ["recordClass"]=>
              string(16) "FileMaker_Record"
              ["prevalidate"]=>
              bool(false)
              ["database"]=>
              string(11) "DD_Personal"
              ["username"]=>
              string(14) "xxxx"
              ["password"]=>
              string(12) "xxxx"
            }
            ["Vea4b3413"]=>
            NULL
            ["V9a3dcbce"]=>
            NULL
          }
          ["_layout"]=>
          string(23) "BW Newsletter2Go Import"
          ["V7a2db0ea"]=>
          NULL
          ["_script"]=>
          NULL
          ["_scriptParams"]=>
          NULL
          ["_preReqScript"]=>
          NULL
          ["_preReqScriptParams"]=>
          NULL
          ["_preSortScript"]=>
          NULL
          ["_preSortScriptParams"]=>
          NULL
          ["V0b9a204c"]=>
          string(16) "FileMaker_Record"
          ["_recordId"]=>
          NULL
        }
      }
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(0) {
      }
    }
  }
  ["callback"]=>
  NULL
}

Any help would be much appreciated!

Share this post


Link to post
Share on other sites
Posted (edited)

I'm not sure if you want to debug that, after all you have no access to the source code and for better or worse making a change is not really appreciated by FileMaker, Inc

My 2 cents worth install nginx, configure reverse proxy. Then close the file, and reopen the file.

You should be set for weeks of non-interrupted FileMaker WPE action.

Edited by ggt667

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this  

  • Similar Content

    • By Tony Morosco
      Hello,
      I am trying to convert a custom web publishing site in php, from FM Server 12 to FM Server 15.    We've updated the Windows machine that hosts it (to a shared server on the recommendation of IT) and installed FM Server 15.  
      Direct opening of the existing scripts always yields 0 results, though the database hasn't changed.  
      Is there some setting, somewhere, that I am oblivious to?   I've consulted user's manuals, IIS settings, web postings, ...
      Attached is a copy of the website I am running.
      I can point you to the existing website, though I doubt it would be useful.  The beginning part of this website are script tracking errors.  I've been inserting them, trying to track down where this error is creeping up.  So please ignore.
      Please ask any additional questions, I am sure there are many.
      Cheers,
      Tony
       
       
      PublicPortal.zip
    • By Richard Carlton
       
      PHP VIDEO 2 - Process Walkthrough: https://youtu.be/yAQX0B9Hfyk
      PHP VIDEO 3 - Sample Code Review: https://youtu.be/9thUCa_q_eY
      Download Sample Code: http://fmstartingpoint.com/links/dl_proc.php?idc=CPN_S0067
      Live PHP Page to try out: http://fmstartingpoint.com/links/dl_proc.php?idc=CPN_R0068
      FileMaker CWP Guide: https://fmhelp.filemaker.com/docs/16/en/fms16_cwp_guide.pdf
    • By jamescv7
      XML error: No memory at line 1
      Greetings, this error occurred when the Filemaker API cannot generate a bunch of records. (1000+ records and above)
      I've adjusted the time out settings for PHP even the memory limits.
      Is there any possible solution for this?
       
      According to some information, the error turns out that the 10 MB XML scripts is unchangeable.
      thanks.
    • By Ken d'Oronzio
      FREE fmREST.php – Simplifies & manages PHP connections to FileMaker 16’s REST-based Data API.
      The newly released FileMaker Server 16 now offers REST access to your FileMaker databases. There’s more about that how this impacts PHP developers here.
      The bottom line is that to use REST as part of your PHP solution, you would usually need to write a series of cURL functions and you would have to manually manage connecting & disconnecting from your server, and saving your tokens.
      This is a pain!
      We know it’s a pain, because we have spent the last several weeks rolling REST functionality into soSIMPLE Calendar.
      We created this class file to make it easier to manage dynamic REST sessions for soSIMPLE and our custom development. The goal of the class file was to help PHP developers start using the new REST engine as quickly and easily as possible.
      We’ll also be updating it with new features. If you’d like to add something to it, please let us know.
      What fmREST.php does:
      Makes every REST call available as a PHP function. Automatically login into FileMaker Server whenever you call any REST functions Saves your token for 15 minutes to reuse Checks for a broken or disconnected token and automatically reconnects and runs your function again Where do I get it?
      You can download the fmREST class file here.
    • By GisMo
      I have a php script that takes two PDF files and merges them into one file. I am using this in conjunction with the insert from URL script step. 
      The way the script works is it takes two PDFs in container fields and base64encode each files. Then, those two base 64 strings are POSTed via insert from URL.
      I've tested the script forwards and backwards and it does combine the PDF files reliably. The issue is when posting from FileMaker. What typically happens is the first page is combined twice and that's my resultant PDF. 
      My php script checks that both inputs are different and throws an error is they are identical. I don't get any errors there.
      Is there a way to POST a file from insert from URL?
×

Important Information

By using this site, you agree to our Terms of Use.