We have reset all users FileMaker related profile fields. Please take the opportunity to update your information,  this will provide background to members whom read your posts. Click here.

Jump to content
Sign in to follow this  
bwalsh

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

Recommended Posts

bwalsh    0

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
ggt667    6

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 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?
    • By mr_mike
      I'm looking for both guidance and software to assist in FileMaker Change Control.  With over a 100 deployed solutions across multiple servers the process change management from dev > test > production is very labor intensive.  BaseElements helps a lot but it is only one part of the puzzle.  Porting the data from production > test across these solutions and then doing UAT and QA is again, labor intensive.
      How are others handling this?  Is there some software or process documents I'm missing?  I'd welcome any input to this topic.
      Mike
    • By Jason Mundok
      I have a website that is displaying FileMaker data using the PHP API. Is there a way for the web site to display the basic text formatting from a FileMaker field? For example, a few words in the comments field are bold in FileMaker and I would like them to also be bold on the website. Thanks for any ideas.
×