Jump to content
Sign in to follow this  
Olypatchmaster

Problems with XML on FMS16 and Zulu

Recommended Posts

Our network person and I have done a bunch of troubleshooting and came up with this summary and a few questions.

Ever since we installed FileMaker 16 in our two-machine setup, Zulu has been failing. In the Zulu error log from C:\Program Files\360Works\Applications\logs:

Oct 2, 2017 8:44:59 AM PDT com.prosc.mirror.config.server.FileMakerServerInfo getHostAddressForProperties
INFO: Will use 127.0.0.1:16020 for direct WPE address.

Oct 2, 2017 8:45:05 AM PDT com.prosc.fmpjdbc.FmXmlRequest doRequest
INFO: Starting request: http://127.0.0.1:16020/fmi/xml/FMPXMLRESULT.xml?-db=DatabaseName&-lay=ProscNoSuchTable&-view

Oct 2, 2017 8:45:05 AM PDT com.prosc.fmpjdbc.FmXmlRequest setProductVersion
WARNING: Null product version; assuming 12

Oct 2, 2017 8:45:05 AM PDT com.prosc.fmpjdbc.FileMakerException <init>
INFO: com.prosc.fmpjdbc.FileMakerException: Error 959: XML Web Publishing is not enabled - Run the FileMaker Server deployment assistant and make sure that the XML web publishing checkbox is selected () username: domain\user / requestUrl:http://127.0.0.1:16020/fmi/xml/FMPXMLRESULT.xml?-db=DatabaseName&-lay=ProscNoSuchTable&-view


 I verified that the URL does indeed return an error code of 959. Playing around with it, I found that if you use the DNS name of the machine instead of the localhost IP:port (https://wpe.domain.edu/fmi/xml/FMPXMLRESULT.xml?-db=DatabaseName&-lay=ProscNoSuchTable&-view), the request returns an error 105 (expected response) instead. 
 
I poked around on the internet trying to find out more about this, and discovered the -dbnames command; again, it works fine on the main https port (https://wpe.domain.edu/fmi/xml/FMPXMLRESULT.xml?-dbnames), but returns a 959 on the Custom Web Publishing port of 16020 (http://127.0.0.1:16020/fmi/xml/FMPXMLRESULT.xml?-dbnames). So it’s like XML is enabled on port 443, but not for the Custom Web Publishing port 16020. How is that possible?
 
For reasons we don’t fully understand and haven’t figure out how to correct, both the FileMaker Master and the Worker machines ended up with the Web Publishing Engine. So I tried the port 16020 request on the Master server, and it works! Which is great, except we want it to work on the Worker machine, not the Database server which ended up with a WPE.
 
Some questions:

1)      We know XML is enabled on the main (port 443) site, what do we need to do to make work on the localhost:16020 site?
a. I hope this involves moving the ‘Web Server’ listed in the Admin Console to the Worker machine, but if not any info on what might be going on there would be great.
2)      If we can’t get the Worker machine to realize XML is enabled on port 16020, can we change the FM config so Zulu doesn’t use port 16020 ‘for direct WPE address.’?
3)      If we can’t do that, are there any issues with installing it on the Master, other than the obvious issue that we don’t want the WPE on that machine?

Thanks for any insight anyone might have.

Share this post


Link to post
Share on other sites

Did you ever get this resolved?  We are experiencing the same issue.

Share this post


Link to post
Share on other sites

We solved it by moving Zulu to the primary machine in our 2-machine setup, rather than the web direct secondary machine.

Share this post


Link to post
Share on other sites

We just had this issue recently after the client upgraded their FM server. Seems like XML API which we used to communicate with the CRM was switched off by default. Also, the guy who is their FM admin said that it's impossible to turn it back on via GUI so he had to turn it on via command line. Basically, XML functionality was not enabled.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Similar Content

    • By 360Works
      Top 3 Benefits of Using 360Deploy
      (Instead of Making Live File Changes!)
      Are you making development changes to live FileMaker files? We want to give you a better solution.

      Making changes to a live file is never the safest option. We wrote an article to give better approaches to upgrading, modifying, or making changes to a production FileMaker file on FileMaker Server.

      One of the options is to simply use 360Deploy to completely automate and safely deploy your development changes on a live file. Today, we are highlighting three benefits of using a data migration automation tool like 360Deploy.
      Read the Full Article
          Read the Full Article   Interested in improving your apps even more? Check out 360Works FileMaker tools!
      Product Name Product Description Portfolio Bundle All of our FileMaker Plug-ins for one discounted price Charts Easy-to-use charting for FileMaker CloudMail Send and track email marketing campaigns Email Send and receive emails, plus send SMS/Text Messages from FileMaker 360Deploy Automated, simple deployment of new database versions FTPeek FTP upload and download from your FileMaker database JDBC SQL access with JDBC Compatibility MirrorSync Sync FileMaker Go and Pro on a device without network connection, sync FileMaker Servers, and sync FileMaker with SQL databases, WordPress, Salesforce, or AWS databases Plastic Payment processing plugin RemoteScripter Trigger scripts on FileMaker Pro from the web or IWP SafetyNet FileMaker Server offsite backup Scribe Read and write PDF, Word, and Excel files, plus OCR functionality and PDF Merge/Splice in Scribe 4! ScriptMaster Adds many new functions & create custom plug-ins SuperContainer A better container field Web Assistant Access internet resources, URLs, and fill out web forms Web Services Manager Publish FileMaker scripts as XML Web Services Zulu FileMaker calendar sync - integrate with Google Calendar, Apple Calendar, and Exchange Calendar You can get a free fully-functional demo, learn more, or buy the product that meets your needs at any of the links above.

      If you need AWS consulting, custom FileMaker Plug-ins, or have any questions. Please email us at infobox@360works.com
        Stay updated with 360Works

       
       
    • By 360Works
      FileMaker DevCon Playlist and Products from 360Works to Help You Work Better
      Tune into Popular FileMaker DevCon Sessions from 360Works
      With more time at home, now is a great time to catch up on past recordings. Did you miss any of the FileMaker DevCon sessions from 360Works? We put together a playlist of our most popular sessions from the past two years so you can learn about FileMaker tools for sync and Amazon Web Services (AWS) tips all in one place.
      Watch the Videos About the featured products...
        360Works MirrorSync
      MirrorSync is an elegant synchronization product that can sync between any combination of FileMaker Pro, FileMaker Go, FileMaker Server, SQL database (MySQL, Oracle, SQL Server, or any database that supports JDBC), Salesforce, WordPress and Amazon RedShift and DynamoDB. For mobile devices, users can sync the hosted file with their FMGo or Pro clients, go off network to make changes, and sync again when a connection is available. For FileMaker Servers, MirrorSync allows a database to run in multiple locations, or to integrate different databases and make sure that changes to each server are reflected in the other server. MirrorSync 6 introduced tremendous improvements for FileMaker Developers such as automatic file transfers between servers, automatic version updates between servers, safer synchronization process, better handling of large files, and easier migration.
      360Works Zulu
      Zulu is an application that keeps your calendar events in sync with FileMaker records. It is able to sync with Apple Calendar, Google Calendar, and Exchange Outlook Calendar. You can manipulate the events in your calendar, and Zulu will write these changes to FileMaker records. The opposite is also true, updates to FileMaker records will be written to your calendar's events. Zulu 4 introduced improvements specifically for business workflows such as new support for Apple Reminders within FileMaker, one-click URL calendar subscriptions and improved publishing page for user-friendliness, better event handling, and improved filtering.
        You May Also be Interested in: 360Works Scribe
      While there was not a session for Scribe, we thought it was worth mentioning because of the overwhelming positive response we received for Scribe 4, which introduced OCR to easily scan documents in FileMaker and merge or splice PDF files in container fields. Scribe has always been able to automate processing of Microsoft Office and PDF files. It continues to allow you to populate forms, insert images, highlight changes between versions of documents, manipulate Microsoft Word and Excel tables, retrieve metadata from Excel table cells, and secure PDF files.
      Interested in more than one of the tools mentioned?
      Get the 360Works Portfolio Bundle Deal
      For less than the cost of 3 of our most popular plug-ins, you can get the entire 360Works product portfolio, all upgrades and most new releases for a year, and a single license key that works for all covered products.

      See exactly what is included in the Portfolio Bundle Deal.
      360Works Product List:
      Product Name Product Description Portfolio Bundle All of our FileMaker Plug-ins for one discounted price Charts Easy-to-use charting for FileMaker CloudMail Send and track email marketing campaigns Email Send and receive emails, plus send SMS/Text Messages from FileMaker 360Deploy Automated, simple deployment of new database versions FTPeek FTP upload and download from your FileMaker database JDBC SQL access with JDBC Compatibility MirrorSync Sync FileMaker Go and Pro on a device without network connection, sync FileMaker Servers, and sync FileMaker with SQL databases, WordPress, Salesforce, or AWS databases Plastic Payment processing plugin RemoteScripter Trigger scripts on FileMaker Pro from the web or IWP SafetyNet FileMaker Server offsite backup Scribe Read and write PDF, Word, and Excel files, plus OCR functionality and PDF Merge/Splice in Scribe 4! ScriptMaster Adds many new functions & create custom plug-ins SuperContainer A better container field Web Assistant Access internet resources, URLs, and fill out web forms Web Services Manager Publish FileMaker scripts as XML Web Services Zulu FileMaker calendar sync - integrate with Google Calendar, Apple Calendar, and Exchange Calendar You can get a free fully-functional demo, learn more, or buy the product that meets your needs at any of the links above.

      If you need AWS consulting, custom FileMaker Plug-ins, or have any questions. Please email us at infobox@360works.com
        Watch the Videos   Stay updated with 360Works


      Sincerely,

      360Works
      plugins@360Works.com
       
    • By daveinc
      Hi,
      I have a performance conundrum that I have not been able to figure out for the past month and a half or so and am looking here for some guidance. 
      We have a 9-year old FM system that we run our entire Production operation on. We have approximately 150 users in 9 locations across the US and Canada for this solution.
      We have a Windows Server 2012 VM with 14 CPU Cores, 60GB RAM, and an SSD Array SAN that we run our Production Server on. We have separate Drives configured for the Operating System and Data. All users not in the facility housing the server use Remote Desktop to access the system.
      The design of this system is not optimal for performance, but it has been running very well for the last 2 years (until early February 2020).
      In early February, it began to stall no matter what we did when we had more than 120 users or so connected and working normally.
      We identified several severely taxing actions, mainly Finds on related tables with millions of records, and eliminated those. No luck.
      We added unnecessary extra CPUs, RAM, and Disk space to no avail.
      We created a completely new VM with a fresh install of FM Server 16. No love.
      Finally in desperation, we moved the server to older, slower hardware with non-SSD hard drive array and voila! the system works fine again.
      This older VM is similar in every other way: Windows Server 2012, 14(slower) CPU Cores, 60GB(slower)RAM, FastSCSI Disk Array.
      As an anti-bonus, in thinking this would be temporary, we have both the OS and the Data on a single C drive on this older hardware.
      It works splendidly on this lesser setup.
      We had all variety of hardware experts in to make sure the newer/faster setup was performing correctly. We updated all firmware and restarted the whole setup. 
      All benchmark tests show the newer system to be considerably faster in all phases, especially Disk.
      We have no problems with any other VMs on this newer/faster setup(including some less intensive Filemaker Servers).
      The one thing that occurs on the newer/faster machine that DOES NOT happen on the older/slower one, is that it stalls and the Disk is consumed by writing tons of data to FMTEMPFM* files for an extended period of time while there is no increase in data being written to the .fmp12 files.
      This particular FM Server and dataset is the only one that this happens to. We have two other FM Servers on there that have 200 plus users 24 hours a day and nary an issue.
      Does anyone know what is happening when the Disk Monitor shows the System Process is writing tons of data to FMTEMPFM files and not writing any more data than normal to the .fmp12 files?
      Thanks in advance for any guidance.
      Dave
       
    • By DPaquin
      When opining the FMS localhost I try to enable the ScriptMaster Plugin. 
      For some reason I click to enable the plugin, I sometime been able to click on save sometime..
      However, each time I close the host reopen the FMS localhost, the plugin is ALWAYS disabled.
      Would someone have an idea?
      With regards!
      Daniel


    • By DPaquin
      When opining the FMS localhost I try to enable the ScriptMaster Plugin. 
      For some reason I click to enable the plugin, I sometime able to click on save sometime not able.
      However, each time I go back to the FMS localhost the plugin is ALWAYS disabled.
      Would someone have an idea?
      With regards!
      Daniel


  • Who Viewed the Topic

    4 members have viewed this topic:
    ehwalker  Kevin Chavez  Jesse Barnum  Freddy 
×
×
  • Create New...

Important Information

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