MirrorSync Utility Error 802: Unable to open file

[Mr. Scott]

Now that I can open the utility, and it allows me to select the database name from a list, I get an 802 error (unable to open file):

I have verified that I have fmxml enabled for my privilege set.

Any suggestions? I already researched the 802 error on FileMaker's knowledge base, but did not see anything relevant towards fixing our problem here.

- - Scott

[Jesse Barnum]

Are you certain that the FMXML privilege is enabled for the particular username and password that you are entering into that form? If it was enabled for some other user, it would show in the list of databases (which matches the behavior you're seeing), but you would get an 802 error when you try to proceed (which also matches what you're getting).

[Mr. Scott]

I think am certain… Here's a screen shot:

[Jesse Barnum]

This sounds to me like just a glitch in the FileMaker Web Publishing Engine. You can verify that it's not a MirrorSync problem by testing the URL in your browser:

http://gps.corp.apple.com/fmi/xml/FMPXMLRESULT.xml?-db=AnalysisData&-lay=ProscNoSuchTable&-view

What you should get is an error 105 (no such layout). What you are actually getting is an 802 (no such database). I would recommend stopping and starting the Web Publishing Engine to see if that fixes it, and if that fails, you might need to restart the computer where the WPE is running.

[Mr. Scott]

Thanks Jesse. Here's the result of that URL:

This XML file does not appear to have any style information associated with it. The document tree is shown below.

<FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult">

<ERRORCODE>802</ERRORCODE>

<PRODUCT BUILD="09/14/2011" NAME="FileMaker Web Publishing Engine" VERSION="11.0.4.400"/>

<DATABASE DATEFORMAT="" LAYOUT="" NAME="" RECORDS="0" TIMEFORMAT=""/>

<METADATA/>

<RESULTSET FOUND="0"/>

</FMPXMLRESULT>

[Jesse Barnum]

Yeah, it shouldn't give you that if you've enabled the FMXML privilege set.

Is this what you get after restarting the WPE and/or the computer that it's running on?

[Mr. Scott]

Jesse…

Does this require ODBC/JDBC be enabled as well?

We are restarting the WPE, and I will try again. If that doesn't work, we will reboot (lots of users, so it takes a little time to ensure they are safely "off the raft")

- - Scott

[Jesse Barnum]

No, you don't need to enable xDBC on the server.

I've run into this problem before myself during testing, where FileMaker WPE incorrectly reported an 802 "file not available" error until I restarted - sometimes restarting the WPE fixed it, otherwise a full machine reboot was necessary.

[Mr. Scott]

We are still getting the same result as before, but after a system reboot, I now get this:

[Jesse Barnum]

Are you able to access the MirrorSync home page in your browser at http://serverAddress/MirrorSync? If not, then it sounds like the Web Publishing Engine is not running - maybe it's not set to automatically launch at startup.

[Mr. Scott]

For whatever reason, we had to uninstall, then reinstall MirrorSync. Now we can access the MirrorSync home page in a browser, and it downloads the java utility app.

However, we are back to getting as far as the 802 error again. Very frustrating. I went through all of this without a hitch on a test machine before initiating deployment on our production server. I'm sure it has something to do with our system and/or environment, but am still determined to get this working today.

Any more ideas, Jesse?

- - Scott

Oh… I uploaded the demo file that was included with MirrorSync (Contact Management.fp7) and it generates the same 802 error, so it doesn't appear to be an issue with the fmxml priv's within the file.

[Al3x]

Hello,

I also have the same problem.

The Web Publishing Engine is running (I can access the MirrorSync page in the browser).

Mr. Scott did you managed to solve this?

here is my error message:

Error from server: 802: "Unable to open file" - Check to make sure that the database file is hosted on FileMaker Server, and that the 'fmxml' extended privilege is enabled for your privilege set. (JDBC URL: jdbc:fmp360://localhost/TrackingAnywhere_DEV, SSL: false / request URL: http://localhost/fmi/xml/FMPXMLRESULT.xml?-db=TrackingAnywhere_DEV&-lay=ProscNoSuchTable&-view)

and here is what i get when accessing the url directly:

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE FMPXMLRESULT SYSTEM "http://localhost:80/fmi/xml/FMPXMLRESULT.dtd" PUBLIC "-//FMI//DTD FMPXMLRESULT//EN">

-<FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult"><ERRORCODE>802</ERRORCODE><PRODUCT VERSION="12.0.1.150" NAME="FileMaker Web Publishing Engine" BUILD="3/15/2012"/><DATABASE NAME="" TIMEFORMAT="" RECORDS="0" LAYOUT="" DATEFORMAT=""/><METADATA/><RESULTSET FOUND="0"/></FMPXMLRESULT>

[Al3x]

I found what was the problem:

I had to change the name of the layouts that I used to sync fields and the name of the database to not contain "weird" characters ( "_" "|" ).

[Mr. Scott]

Awesome recovery. Thanks for posting the results!

- - Scott

[Brian S]

I am running into the exact same problem and the answers in this post have not helped me solve it.  This was running perfectly in my test environment.

[Will Slaughter]

Guys,

I've seen this before as well, even when a reboot doesn't solve the problem, sometimes redeploying the server corrects it.

 

Just click the 'edit server deployment' link from the Admin console, and run through the settings, leaving them as they were before. Usually after doing this, MirrorSync, and the link Jesse provided will function correctly instead of resulting in error 802.

 

Hope that was helpful

 

Cheers,