FME Flow

Hello, We are running FME Server 2020.1.0.1 and are trying to connect it to our AD to allow users to login and run automations. We keep getting the below error and we are not sure what to try next. Unable to establish connection to directory server (91) Port: 636 Connection Type: SSL Authentication Type: Basic

Is it possible to retrieve the advanced information from Automations (like 'Queued Job Expiry Time' and 'Running Job Expiry Time') from the FME Server API? I would like to automatically check if these options are used for all my automations.

Is it possible to format an Excel file with FME to create drop-down lists (function data validation in Excel)? I have multiple excel files that need multiple drop-down lists and a supplier excel sheet with all values. In total there are hundreds of drop-down lists that need to be created, therefore wonder if there could be some solution available with FME.

Hi All, I have a workbench built in FME Desktop 2019.1 which I am planning on deploying to FME Server 2019.1. This workbench does incremental updates to records in a SQL Server database on the basis of updates delivered in XML payloads. The workbench consists of an XML reader, various transformers to transform XML data into the required format, and a SQLExecutor to run an 'upsert' in SQL Server (we elected not to use a SQL Server Writer). XML payloads are delivered to a directory on a file share of some kind (probably FTP, maybe SMB - this is an implementation detail, I can map the directory as a network drive of some kind if required). We do not need to handle any kind of geospatial data. What I am trying to do is determine a way to trigger the workbench in FME Server by a file being dropped into a directory, and then, once the workbench has run, move the file to another archive directory. I can see that triggering an Automation in FME Server on the basis of a change in a directory is

I have successfully used FME Data Express with csv files being uploaded directly from the users iOS mobile device. However I now need to have the users upload a .htm file instead of csv for the same type of workflow. It works fine on the browser using a FME Server app to upload a htm, however when using a htm table reader in the FME Data Express app, where the green + sign should be to add a file, I get [Unsupported] Source Dataset. I would like to know what file formats are supported for direct mobile device upload on iOS for FME Data Express, so I can try to develop some sort of workaround.

I have set up static IP adress for the cloud instance as I assume this is necessary?

x = [‘ab’, ‘cd’] print(len(list(map(list, x)))) Source: Python programming tutorial

I would like to know how to set an emailer to a workspace from FME Workbench to send emails to a group of recipients once there is a status change.

I am struggling with an Express with a Distributed Engine installation, see this article: https://community.safe.com/s/article/separate-engine-installation. All steps in the documentation and this article have been followed carefully. The core machine is running as it should, and so is the FME Engine service on the distributed engine machine. Unfortunately, the Distributed Engine Host does not appear in the Hosts list under Licensing & Engines/Engines page in the WebUI. What could possibly be wrong?

The error is 'Unauthorized request by user due to lack of proper permissions' All other API-request seems to work fine. I checked all the permissions, and i have all permissions. Anyone an idea why this is not working. Screenshot Using FME Server build 20787)

Hi, I followed this guide: Sending email, Part 1: Setting up a topic and an email subscriber (safe.com) And we know our port is 25. I followed the guides and troubleshooting, turned the Allow Less Secure apps ON in gmail as well. But still I get stuck on the Creating the email subscription step, the validate gets this error: SSL error occurred. Ensure connection security and port are correct. Unrecognized SSL message, plaintext connection? I am on company server via VPN so I cannot access the services.msc or make changes to the firewall. Any idea if I entered something wrong?

Hi everyone, I'm running FME Server 2020.2.1 Build 20806 on a Linux Debian 10.6 host. I need to run a workspace that writes to a sqlite database previously uploaded in the shared resource data directory, but the workspace fails complaining it can't write to a read-only database. I discovered that when I upload a file in the shared resource data directory through the Web User Interface, the owner user:group of the file is root:root and not fmeserver:fmeserver as expected. After changing the ownership of the file (the sqlite database in this case) to fmeserver:fmeserver using the shell of the operating system, the workspace runs fine. This is obviously a workaround which is not suitable for a production environment with several users. Can anyone help me solving this issue? Thanks!

I have published a workspace to FME Server enabling the Data Streaming service with parameter Include Writers in Stream set to the output from a File copy writer. This output is a PDF file and the MIME type parameter of the writer is set to application/pdf. When executing the workspace in FME Server, the PDF opens as text inside the browser. Shouldn't it open as a PDF file inside the browser or show the dialogue to save it? This is what shows in the browser: To give some context to the problem, the workspace builds an html that is transformed to PDF using the HTML2PDFConvertor. To be able to stream the HTML2PDFConvertor output (the PDF file), I've set the output PDF path to the FME Server temp directory and I've used a File copy writer to 'move' the PDF file again to FME Server temp directory. This works as a kind of hack to be able to stream the PDF.

Hi FME team, I have a workflow on FME Server scheduled every day @ 8am. The workflow reads a HTML Table which is updated every day @ 7am. I am using a simple HTML Table reader, where the URL is always the same, as is the 'Tables/Lists to read'. If I run the workspace with FME Desktop, it runs fine. If I then publish this workspace to FME Server and trigger it to run, it runs fine. However, if I set the workspace to run on a schedule, i.e the next day, the workspace fails and I get the following error message (I have removed the actual URL for sensitivity): 185 HTML Table Reader: Could not open HTML file 'https://exampleURL/Example.php' for reading. '<class 'OSError'>': 'Invalid argument'. Notes: my organisation requires each URL called by FME Server to be 'whitelisted'. The URL in question has been whitelisted and I can access it via the browser from the server on which it runs. The previous data source was a CSV download link and this returned the same error message when following the

I am having issues with a Directory Watcher UNC Path. I was able to get it running in our Test environment. However, in the Production environment, I keep getting this error in the Automation Log: 801013 : Could not retrieve file listing. I've checked the following during my troubleshooting: Confirmed domain account has 'log-on as service' rights Confirmed domain account is running the FME Server services Confirmed domain account as full access to the UNC path Confirmed that I can connect and add UNC path and was able to add it as a resource to FME server and that I see files showing up in FME Server UI. (Resources>Directory) I'm running FME Server 2020.0.1 (Build 20218 - win64). I am able to validate the directory when I configure the 'Directory Watch' trigger in the Automation. I am just trying to read a UNC path with simple .txt files. Am I missing something in my troubleshooting? Thanks in advance. -Mark

Hi there, I have ran into trouble when I am trying to install a distributed Engine to a Core machine installed With Express Install. That kind of installation is proposed by Safe in this article https://community.safe.com/s/article/separate-engine-installation. Installation of the distributed Engine is described in the documentation: https://docs.safe.com/fme/html/FME_Server_Documentation/AdminGuide/Adding_FME_Engines_on_Separate_Machine.htm. The core machine was Installed first, using Express installation The FME Server System Share was shared (on the core machine). The user that will be running the engine service has been granted full control to the share The directory exists: Yes, the directory is accessible: Yes, the directory is empty: No. The requirement that the directory should be empty confuses me. It was filled up during the installation of the core, so how could it be? How should I go around this?

I am using the SpatialRelator for populating a list of adjacent polygons for specific polygons of a geojson polygon layer. I tried the "Requestor Intersects Supplier" and "Requestor Touches Supplier" predicates but they also include those polygons touching at only one point. I only want those sharing a line, so I have a ListElementFilter taking only the following relationship masks: FF2F11212 and FF2F1F212. The problem is that the process is much slower when adding that custom transformer. It is even worse when I use the "FF2F11212 FF2F1F212" value in an attribute in the "spatial predicates to test" field. Can you think of a more performant way to obtain the adjacent polygons into a list? Thanks! Olivier

We have installed both 32 and 64 bit version of fme on same machine. We are running a bat file that has the following struncture: fme python script.py which runs fine and is using the fme 64bit version(that was the first one installed on the computer). Afterwards we have installed the 32 bit version on same machine and we are tring to use a bat file that has the same structure as the one mentioned above but running the 32 bit fme version. Has anyone an ideea about how can this be done? Thanks :)

I upgraded our production FME server from 2019.2.1 to 2020.1.3, but restoring/importing the fsconfig file which was backed up from 2019.2.1 did not do anything. Did not see any errors though. I did the same upgrade on our test server two months ago without any issues. Wondering if anybody had experienced the same issue or knew how to diagnose the issue.

Hi. I've had a close look at the FME Server API. It seems that I can download a list of uploaded workspaces in a server repository, and get the timestamps of their upload. I can compare those timestamps to the file timestamps of my master repository on a file share, and determine which ones that need to be updated on the server. And there is a nice function to replace an item (PUT /repositories/< repository >/items/< item > ), but the notes say: Note: This endpoint is for internal use by FME Workbench and is not supported for external applications. Does this means that automating uploads to an FME Server is undocumented and impossible as-is ? Or is there another way (apart from hacking via a file access) ? Cheers.

Hello, I'm curious if there are any potential security issues with a data download application via the result download link. How long do these download links last? Can they be scraped by bad actors? It seems even with an authenticated application the results URL is still publicly accessible in this format: https://[servername]/fmedatadownload/results/FME_[A-Z0-9staticstring]_[0-9string(datestamp perhaps?)]_[0-9]*4.zip Is this already an encoded token? Thanks!

I'm trying to write a new FGDB to a network location using FME Sever. In FME Desktop it writes out fine. In FME server the error message is: Geodatabase Error (-2147024894): The system cannot find the file specified. Could not open File Geodatabase dataset for writing FME server has write access to this location. It will write feature classes to an existing FGDB, but it wont create a new one. I have tried both the Esri Geodatabase (File Geodb Open API) and Esri Geodatabase (File Geodb) writers. Any idea's why it works in Desktop but not in Server?

I was having some problems with DateTimes on FME Cloud (East Coast cluster) and managed to come up with a solution, but decided to do some reading and checking. I can confirm that my instance is set to Central time, as is my admin account. For some reason, DateTimeNow() returns time in UTC with no offset shown. So my main question: is this by design? It's not the same behavior as in FME Server, so I have to make specific adjustments to workspaces - bummer. I did a quick search and came across a very good and detailed article about the subject by @mark2atsafe​ . Towards the bottom, it states: Timezones and FME Server: I’ve always had problems with timestamps when I’m in one timezone (Central -6:00) but FME is running on a cloud-based server in a another timezone (say Pacific -8:00). Now I don’t have to worry. The DateTimeNow() function lets me specify standard UTC time, so it doesn’t matter where my server is based. I can also ask for local time both with or without timezone. Well, it s

Hi there, I have some features in the NAD83 CSRS datum and while things run on FME Desktop, it fails on FME Server when there is reprojection: Reprojector: Reproject: Could not reproject the geometry of the preceding feature: CS-Map Reprojector: Unable to load grid file for 'NAD83_to_CSRS' | CS-Map Reprojector: This grid may either be available at the government agency applicable to the geographical area or in the FME Reprojection Grid Add-on at: | http://www.safe.com/support/support-resources/fme-downloads/ or http://www.safe.com/support/support-resources/fme-downloads/beta/ | CS-MAP Reprojector: Please visit following link for more information on obtaining Canadian grid files: https://knowledge.safe.com/articles/789/where-to-source-canadian-grid-shift-files-not-incl.html | CS-MAP Reprojector: No transformation found to get from 'CSRS.UTM-12N (CSRS)' to 'EPSG:3857 (WGS84_SPHERICAL)'. Add CsmapReprojector transformers with explicitly chosen transformations I went to look for the transf

Is it fair to assume that I won't be able to configure Esri ArcGIS Python with FME Cloud and would have to deploy FME Server instead?