Jump to content
The site is updated on a beta version. Maintenance tasks are running so search and index may not function at this time. ×

Error code not included in Help files


Recommended Posts

After upgrading to FM Server 16, I am seeing that the automatic daily script executed from the server side is no longer doing so without error. The script sends email reminders to workshop presenters scheduled within 4 days. The error code, which I record in a log, is 119. However, that code isn't listed among the error codes listed in the online help:

https://fmhelp.filemaker.com/help/16/fmp/en/#page/FMP_Help%2Ferror-codes.html%23

Knowing the meaning of the error may provide useful information that will help me reconfigure the email account settings for the command Send Via SMTP Server.

Thanks.

 

Link to post
Share on other sites
  • Replies 5
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Posted Images

can you post the relevant entry from the FMS event log when it executes the schedule?  Any FM errors are reported in the event log.

Also post the part of your own log and walk us through how you log your own things.

Also, FMS16 will be out of support in about 6 months from now (https://www.filemaker.com/support/product-availability.html) so why upgrade to that version and not 17 or 18 and buy yourself more time?

Link to post
Share on other sites

I can't seem to easily share or store the export of the error log from FM Server 16 because I have limited privileges where it is hosted. But I was able to take a screenshot of enough of the log for you to observe that likely every script step results in an error. Please see the attached file "fm server error log.png."

As for my own log, I believe the error is ultimately generated by a Send mail command. The result, if non-zero, gets passed to the script that invokes the Send step and then added to a log that I maintain myself. The log lets me keep track of any issues with the automatic daily script. For the most recent error, please see the attached file "error log item.png."

I don't believe the issue is actually related to our upgrading in the fall to FM Server 16, because I can now see that the overnight script did execute fine in early January. This issue must be related to a recent migration to entirely new computers (and possibly a new Windows server) after a recent malware (ransomeware) infection that penetrated my college's firewall. (My college of course had a backup, so the ransomware just cost us all a ton of time and trouble.)  I will be simultaneously pursuing the issue with my IT support person, but since his understanding of FileMaker is basic, any insight you can provide as to the likely source of the problem would be quite helpful.

As for why we chose 16, it was to minimize the disruption to my colleagues who occasionally need access to the database. I chose the highest version of Server that would be compatible with their versions of Filemaker Pro. But, yes, I will probably need to ask them to upgrade anyway at some point in the not too distant future.

Thanks again, Wim.

Jerry

 

fm server error log.png

send script step.png

error log item.png

Link to post
Share on other sites

Looking at that last screenshot, the error code is not 119.  That's just the id of that error log record.

The error is 1502, which is "connection refused by the SMTP server".  Double-check the SMTP server account info, SSL/TLS options and ports,...

Link to post
Share on other sites

Apologies for that misreading of the code, and thanks for the quick response. I suspect that there’s an underlying cause having to do with the recent changes to our computing infrastructure. Otherwise, why all the script errors? Also, the SMTP settings work when I send from my own computer. I’ll pursue this with my IT staff. 

Link to post
Share on other sites

It could be that the SMTP server is set up in such a way that it does allow connections from just any machine.  If your FMS machine is new then it may be as simple as getting it white-listed.

As to the other errors in the event log: I don't think that those would be caused by the infrastructure changes.  Error 3 for instance means that the script step is not server-compatible. Error 101 indicates the use of "go to next - exit after last", which is an innocent error.

So vet your scripts to remove or branch around the incompatible script steps.

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.

  • Similar Content

    • By Philip Sommers
      I currently administer a Filemaker 16 Server and only use Oracle Java for the admin console (web publishing is turned off). We want to get rid of Java rather than start paying for it. Rather than upgrade to FMS18, is it possible to use OpenJDK instead of Java for the FMS16 admin console? If so, is there anyone that can provide some guidance on how to do that?
    • By "... you mean these fans?"
      Mr. Ignoramus
      We have a solution in Canada where we moved the db from a hosting company to a LAN ( customers building ) They are using a Mac OS machine running FileMaker 16 server.
      We access the FM 16 server via apple's remote access, having trouble locating where we would put the index.html and php files for our web form that we used when we were hosting on an outside hosting company.  The hosting company put the html/php file in the folder that designated our account number. 
      My question is this ... where would we put the two web files; index.html (form) and the .php (create record in FM) file on the FM 16 server.  I can not seem to locate the instruction via the documentation FM is providing.  Have done several internet search ...
      I am gathering information to pass to the individual helping us with the FM server at location.
      Anybody able to provide a link or guidance I would be grateful.
      Thank you.
       
    • By jduncan
      Hello,
      We recently upgraded from FMS 14 to FMS16 and one of our databases won't open via WebDirect due to the way it's named:  the database title has an ampersand ("&") in it.  This worked just fine for FMS14, but not for FMS16.  The easiest solution seems to be to change the database title.  I'm a little hesitant to jump into this because of a large number of externally held containers.  How would one safely go about changing the database name (I'd like to change the "&" to "and") without losing the linked containers? 
      In case anyone's wondering, I didn't name the database; I inherited it.
    • By ShelCOYS
      Hi, I have fm 14 server running on a mac mini. I have recently upgraded to FM16 running Mojave on 2 x local macs. We started with one license, where only one of us could use FM at a time (as we knew), I have since bought another copy and and reinstalled FM16 on the local mac with the new serial number but the server still seems to think we are using the same copy?? and we are getting the attached error. I have completely uninstalled FM locally but still does not work. I have asked my FM guy, as well as 2 or 3 other people but everyone seems to be stumped?? Is there any way of clearer the cache which may be holding this old information? Any help would be much appreciated.

    • By Gaohan
      Dear all,
      I'm new here so forgive me if not posted in the correct location. We have the following situation for which we do not know how to continue:
      We have Filemaker server running on a windows server. The server is accessed through its local ip address (in the 10.10.10.x block). For an internal application I would like to extract information from a FileMaker database for usage in another application. Initially, I used the xmlresultset grammar. It works for when requesting the databases hosted on the server (i.e. : http//10.10.10.x/fmi/xml/fmresultset.xml?-dbnames returns the expected result). However, when I attempt to retrieve a list of layouts that are available I keep getting an empty body result:
      http://10.10.10.x/fmi/xml/fmresultset.xml?-db=Test&-layoutnames Returns the following contents (Note the content-length = 0):
      [Chrome section: General] Request URL: http://10.10.10.x/fmi/xml/fmresultset.xml?-db=Test&-layoutnames Request Method: GET Status Code: 200 OK Remote Address: 10.10.10.x:80 Referrer Policy: no-referrer-when-downgrade [Chrome section: Response header] Content-Length: 0 Content-Type: text/xml;charset=UTF-8 Date: Mon, 19 Nov 2018 16:01:06 GMT Server: Microsoft-IIS/10.0 X-Content-Type-Options: nosniff X-Frame-Options: SAMEORIGIN X-Powered-By: ARR/3.0 X-XSS-Protection: 1; mode=block [Chrome section: Request headers] Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8 Accept-Encoding: gzip, deflate Accept-Language: en-US,en;q=0.9,nl;q=0.8 Authorization: Basic XXXXXXXXXXXXX Cache-Control: max-age=0 Connection: keep-alive Cookie: JSESSIONID=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX.jwpc1 DNT: 1 Host: 10.10.10.x Upgrade-Insecure-Requests: 1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.77 Safari/537.36 I specifically made a layout that should return content as a table view of the records.
      I have verified with PHP, and it shows the same problem.
      I have read on some forum that layouts should be made available through web-publishing as well. How to do this? I cannot find it in the documentation.
      What else am I missing?
      Hoping for an answer!
  • Who Viewed the Topic


×
×
  • Create New...

Important Information

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