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

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 dataclip
      We have a couple of servers running on AWS. As of the middle of last week we suddenly are having connection problems. The server logs mostly lists error 10, sometimes error 51. These customers have poor internet connection, so we have set up a server and a client in the cloud. The users connects to the client through an RDP session. It is a Windows enviroment with one customer using Windows server 12 and FMS 14, the other Windows server 16 and FMS15. We use a seperate AD server to control the RDP access and accounts to the FMP server, clients have no acces to the FMS server.
      I have read previous posts on this issue. I do not think there can be any hardware issue, since the server is hosted with Amazon and both server and client are on an internal network. To be sure I have filed a support request with Amazon as well.
      The strange thing is that the error message sometimes occurs within a minute and then FMP freezes on the user while they are still working in the FM app. It is my understanding that error 10 occurs if the client does not respond to the server ping for 2 pings, so time out for this error should be 125 seconds. 
       

       
      These servers have been running without this issue for a long time now. Any idea why this has suddenly changed and why the error message errors while tghe users is using the FM app?
       
    • By jstewart30
      Running FMS 13 and trying to run a simple PHP page from my website to access a database, but I'm only getting a blank page.  Not sure if it's a port forwarding issue or a PHP issue, or something else.  If I put my .php file and the includes ("FileMaker.php" file and "FileMaker" folder from the FMS PHP .zip file) in the fmi-test folder on my FM server and access it locally (http://localhost/fmi-test/myphpfile.php), the PHP file works fine and returns data, so I don't think it has any inherent issues, and presumably my FMS is set up correctly.  Putting the same .php file and includes on my web server, though, results in a blank page only.  The includes are in the same directory as the php file itself.  Here's the php file (I've changed the IP address and database names to protect the innocent but they're correct):
       
      <?php
      error_reporting(E_ALL);
      ini_set('display_errors', 1);
      include_once('FileMaker.php');  /* have also used require, include, and require_once with no change */

      $fm = new FileMaker("MyDatabase", "http://myfilemakerserver:8888", "Admin", "");   /*no password*/
      $findCommand = $fm->newFindCommand("MyDatabase");
      $findCommand->addFindCriterion("Phone", "303-555-1234");
      $findCommand->setRange(0, 1);
      $result = $findCommand->execute();
      if (FileMaker::isError($result)) {
          echo($result->getMessage());
          return;
      }
      $record = $result->getFirstRecord();
      $name = $record->getField("Customer Name");
      $status = $record->getField("Status");
      echo("$name - $status");
      ?>
      Infuriatingly I get no errors or feedback, just a blank page when I run this file from my website (but again it works fine locally on the FM server machine). I've confirmed PHP is working on my website as I can do a simple phpinfo() file in the same directory and it runs fine and displays the PHP info.  If I direct a web browser to the same "http://myfilemakerserver:8888" (not the real address obviously, but it is port 8888) I get the "Filemaker Database Server Website" page, so the port forwarding seems to be correct.  I have port 8888 forwarding to port 80 of my FM Server.  I don't have port 443 forwarded to that machine as that's being used for another device on our network, but I assume if I'm not making "https" requests that it should work fine (but maybe that's my problem?).  
      I assume it's just something simple but I've been beating my head against a wall for the better part of the day on this.  Any help would be greatly appreciated.
    • By Martin Taylor
      Hi all experts (hopefully), I have just upgraded from FMS12 to FMS16. On the FMS12 server we are running a php solution. I have installed 16 onto a new server, uploaded all the databases (all successfully running) and have copied the php website to the new location on the 16 server. I can see the website from home (so I know the website is in the right place and the DNS s working) BUT I can't seem to connect to the database successfully. Any help would be much appreciated. Thanks in advance. 
      Oh, and it is accessed with https
    • 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
  • Who Viewed the Topic

    1 member has viewed this topic:
    scrumpto 
×

Important Information

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