FME Flow

Hi, We have recently upgraded our FME Server 2021.* to FME Flow 2023.1.1.1 Build 23636. Many of our workspaces work fine but some have started to take much more time. 1h30m copying 619855 features from SQL server to PostGIS in FME Flow with 15828934!!!  warnings vs. 4m in FME Form with 530 warnings.  The warnings are of this type (both Flow 2023 and Form 2023 - none in FME 2021):2023-11-14 14:01:50| 186.1|  0.0|WARN  |POSTGIS Writer: Renamed user attribute 'DW_TimeStamp' to 'dw_timestamp' based on format constraints for invalid characters, length, and caseIs this behaviour due to the fact that our workspaces in FME flow 2023 still are in version 2021? Regards Jakob

In Manage Schedules, there is a column named "Total Runs"; this tells you how many times a Schedule has been run; is there a FME Flow Setting to have a particular Schedule "auto-refresh" the Total Runs at a specific interval? Currently, to view the total runs a user needs to refresh the page or step out of and back into Manage Schedules.  

I have a workspace where I am using the Emailer Transformer.  What is the best way to send a single email based on reading a list of 5 email addresses in an Excel Spreadsheet? Would I still use the Emailer Transformer? I am thinking there are parameters I need to change in the Emailer?

I have a FME 2022 Script that run against an Oracle Database and extract list of boundaries and output on to a FGDB. I would like to let User to run the script using a bat file, rather than intervene with the Script on FME workbench. I have a list of boundary IDs on an Excel that attached to the script then User can extract boundaries on the excel sheet. But I would like User to extract any boundaries begins with boundary ID ie: "AA-X-BB" I would like some help to understand how to write the script that the bat file extract all the boundaries begins with my ID rather than a single boundary.Any help would be appreciated. thanksPushpa

I have a private AWS server. I have a customer who uses power app to create rest api calls to fme server installed on this server. They need the server to be at a security level of https. They access fme server using the URL of the server through a gateway with an enabled port. Aws has its own security certificate but it charges a lot of money for a private CA. There are free websites out there but they want the domain registered. I can't register the domain of the AWS as it's a private server  I went through the safe http to https tutorial using a self signed cert (pfx) section. However, while I managed to get the fme server to use https an untrusted error comes up, even if I add the cert to trusted certificates. I suspect it's because it is a self signed cert. I've had to roll back fme server to http as the users couldn't access the rest API anymore.  This is my first dabble with security certificates but I can't see a solution around this. thanks for any adv

Is FME Server / Flow vulnerable for Apache ActiveMQ CVE-2023-46604 https://www.cve.org/CVERecord?id=CVE-2023-46604

FIXEDWe have encountered a strange problem on FME Server 2020.0.2: all of a sudden the Web Application Interface has stopped working.This happened right after I terminated a job that had run all weekend. In the logging of FME Server we can see all jobs are still run as usual, so it is just a problem with the Web Application Interface. This appears to be a Tomcat problem. The server runs Apache Tomcat 9.0.24. So we checked the latest catalina.<date>.log file. It contains the following error messages:06-Nov-2023 09:28:32.913 SEVERE [main] org.apache.catalina.core.StandardServer.await Failed to create server shutdown socket on address [localhost] and port [8005] (base port [8005] and offset [0])java.net.BindException: Address already in use: JVM_Bindat java.net.DualStackPlainSocketImpl.bind0(Native Method)at java.net.DualStackPlainSocketImpl.socketBind(DualStackPlainSocketImpl.java:106)at java.net.AbstractPlainSocketImpl.bind(AbstractPlainSocketImpl.java:387)at java.net.PlainSocketI

Hello, we would like to authenticate FME Flow users via „KeyCloak“ application. Our idea is that FME Flow would somehow be connected to the KeyCloak application. The moment a user wants to log in to FME Flow, he would be redirected to KeyCloak, authenticated. KeyCloak passes the information back to the FME Flow application, and user will be logged in. Do you have any experience with FME Flow-KeyCloak collaboration?Keycloak supports protocols OpenID Connect, OAuth 2.0 and SAML 2.0.

I've recently developed a Workspace App using FME Flow where users can enter search criteria, and the backend workbench processes this input to return an HTML results page with a list of database query results. I now need to implement a printing feature that allows users to print a selected row from the results table. Here's my current setup:I've added a print button to each row of the results table.When a user clicks this button, it triggers a webhook URL intended to initiate an FME Flow automation. This automation isn't yet configured but will be responsible for creating a printable document. My initial idea, which I'm open to feedback on, is as follows:Capture the data from the selected row and pass it to the webhook URL.Use the necessary workbench logic in the automation to generate a Word/PDF document with the chosen information.Allow the document to either be downloaded directly (preferred) by the user's browser or present it for printing. I’m aiming for t

I created a workspace that takes a zip file (nested zip), unzips it to a temporary folder (I used StartUp Python Script to do so). It then reads all the unzipped SHP files from the temporary folder (uses dynamic ESRI Shapefile Reader), reprojects all the files, filters them by feature type (to points, lines, polygons), checks for duplicate features and if the geometry is valid. Finally, it saves 3 output shapefiles:1. all point elements consolidate into one output shapefile2. all linear elements consolidate to one output shapefile 3. all polygon elements consolidate into one output shapefile  I would like the workspace to be independent of the input dataset (attributes). Because now when I run workspace with a second set of zipped shapefiles (with different attributes), I get shapefiles in the output with empty attributes that are in the first set of data. For example first dataset (which was used to create workspace) has ‘A’, ‘B’, ‘C’ attributes, second dataset has ‘D’, ‘E’, ‘F’, ‘G’

Hi community! I installed FME Flow 2023.1.1.1 on Ubuntu 22.04 with installer [1]. I choosesetup type "Distributed / Fault Tolerant" to use an existing Postgres instanceaccording to [2]. I then set up the Postgres database according to [3].I also changed proxyPort in /opt/fmeflow/Utilities/tomcat/conf/server.xmlto the correct port number. Then installed, enabled, and started the systemdunits according to [4]. Everything worked at this point and I could log in as admin and change thepassword as required. I could also log out and log in as admin. I thencreated a new admin user. When I logged out and try to log in as the new userthe landing page was stuck in an infinite refresh loop. I also deleted allcookies which did not have any effect on the constant reloading. The URL is https://view-db.vinci-energies.de/fmeserver/. I uninstalled FME Flow, dropped the fmeserver database, and installed FME Flowagain as before. Now the landing page doesn't even prompt for the admin loginan

Hi,Is it possible to download Automation workflow/save it to a file, so that it can be easily transferred to another FME Server/Flow?

Hi!We have configured FME Flow (2022.2.8) for OKTA SAML Authentication as per https://community.safe.com/s/article/Configuring-FME-Server-for-OKTA-SAML-Authentication On signing in with a username, password and MFA it redirects us back to the password page.The restV4.log or fmesaml.log never shows that we attempted to login. We tried to configure FME Flow for Azure AD SAML Authentication, but got the same outcome. Any ideas, please? Regards,Dmitry

I thought it would be as simple as Trigger (FME Flow System Event) -> Action (Log) ->External Action (Http Request that includes the information for the system event via the log ).

We're in the early stages of proposing external access to FME Server 2021.2 via a reverse proxy. I was wondering if it is possible to duplicate a service so that it can essentially run on multiple URLs since not all users will have access to the remote proxy (IT processes outside my control). I can see there is the possibility to create a new service but I'm unable to configure as required.Not sure if i'm overthinking this or missing something simple but any assistance would be greatly appreciated. Thanks

Hi everyone, I have a workspace/server app which has a Data Download service published. It produces a downloadable zip file of the writer results. We a user clicks ok to run the server app and the status is completed, the data download url is shown. I have an Automation however which receives a topic and this triggers another workspace to send an email with the job details (rest api).Is there a way to hide the above data download link URL and still create the url behind the scenes>

how to continue this workbench as no data have passed to next stage how can i redirect the data to final data if no data is passed in this step?

I have setup a FME Server Webhook trigger in the automations section and want to put the payload received into a database table by running a workspace after the action is triggered. Please help or advise if this is not the correct way? Thank you #Automation​ #Webhook

I have added a new team member into FME Server, with fmeuser role. Basically this user only care read and Run workspaces under Parks repository so in FME Server under  Repositories slide-down I set this configurationbut when I checked the user in the Server end point I am seeing this:As you can see two Samples and Tools repositories also listed there! When I check back in Server side, looks like there are some circled-checks on read and run options for these two! Now can you guys pleas let ne know how I can force this user to ONLY have access into Parks repository using the fmeuser role.  

I have a workspace that includes two Emailers that send emails based on what file is added to a folder. If a zero byte file is added to Folder A then an email will be sent; if a file that is more than zero bytes is added to Folder A then an email will be sent. It runs good in FME Form, it send two emails one notifying the recipient of a zero byte file added to Folder A and one email notifying the recipient of a non-zero byte file added to Folder A. But, after I publish this workspace to FME Flow, and create an Automation with the Directory Watch Trigger (triggered only when CREATE .... new file is added to the folder) that kicks off the workspace, it sends me 8 emails. Is this a bug with using the Emailer Transformer? I notice that in FME Flow I cannot view the Emailer parameters as I can with other Transformers.  Any ideas on how I can get this Automation to send me only two emails? ​

I am having difficulty attaching the Host Info Text File.Please advise how it can be submitted. Thanks in advance for your assistance.

Hi all!I have some odd issue,I set up my Gmail web connection like describe in here, test it, and everything's is good.But when I want to use this connection in Emailer, it doesn't give the option to choose this Gmail web connection, and it ask me to set up new and regular one, which fails with Google error 401: disabled_client.Can anyone help me?how can I force 'emailer' to take the right Gmail connection?Thanks!

Hello,We have updated FME Server from 2020 to 2022.2. Then there is something wrong with the upload files : We publish into FMEServer a workbench containing a "File/URL" User parameterThen we RUN the workspace 2 times : The file we upload has the same name, but the content of these 2 files is different--> FME Server doesn't update the file located here : FME Server\\SystemShare\\resources\\system\\temp\\upload\\ if we don't purge the folder (In case we change the file name, it works well.)We have not encountered this problem with FME 2020.2 Can anyone help?Thank youRonan

I'm trying to prep a road network for use in the ShortestPathFinder. I found a flow on FME's documentation that looks like it does what I need (it uses a road network to prep for routing).  The first three steps appear to have run fine, but I think the Snapper step keeps repeating. The following line has reached 100% completion 3 times but every time it does, it starts over doing the same thing: "Intersection operation processing one line against many others... 99.34% doneIntersection operation processing one line against many others... 99.87% doneIntersection operation processing one line against many others... 100% doneIntersection operation processing one line against many others... 0.52% doneIntersection operation processing one line against many others... 1.05% doneIntersection operation processing one line against many others... 1.58% done" Below is a screenshot of the flow I'm running.  Am I correct that one step just keeps repeating? If so, how do I correc

Hi, I'm looking for a way to add my own key:value pairs/object to the Webhook JSON-response. The default webhook JSON response is:{"serviceResponse": {   "jobID": 294,   "statusInfo": {      "mode": "sync",      "status": "success"   }}}Woud like to add something like:{"serviceResponse": {   "jobID": 294,   "statusInfo": {      "mode": "sync",      "status": "success"   }   "productData" : {      "productVariant" : "type1" // = $(productVariant)   }}} Not sure if it is possible at all. All suggestions are welcome.Thanks!