Jump to content

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


This topic is 2565 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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!

Link to comment
Share on other sites

  • 2 weeks later...

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
Link to comment
Share on other sites

This topic is 2565 days old. Please don't post here. Open a new topic instead.

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
×
×
  • Create New...

Important Information

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