Skip to main content
  • EN

FME Flow

A space to discuss FME Flow

2509 Posts
aashnaparikh
Contributor
aashnaparikhContributor
asked in Architecture
FME Logs and DataBase

What is the process to access the database on the FME Server just so that we could have a trail of files that users ingested and the outputs that were generated? What are some of the best practices we can implement that can be helpful at the time of audit ?

282
hkingsbury
Celebrity
wil
Contributor
wilContributor
asked in Automation
Flow 2024 Parameter assignment, integers not recognized

I am creating an Automations proces and when assigning the parameters to an integer field  get the following message: Must be a whole number. Decimals are not supported.In the Automations first a csv is read for creating all sorts of parametersIn here there are no decimals.In the workspace tm_data has the Type int16In the Automations writer it is also defined as integer.But when assigning the parameters, I receive the error. This applies for all integers I use in this.This is a automations proces that I also build in Server 2021 and I didn't have this issue but in Flow 2024 I can't get any further because of this error.Is there something I do wrong or is this a bug?

404
kgnadt
Observer
alisonsep
Contributor
alisonsepContributor
asked in Architecture
FME Flow site down-Windows update?

Hi, I was wondering if anyone else has experienced this? Yesterday my site access for FME Flow worked fine and today it won’t work at all; I get 404 error.The only thing that seemed to occur between yesterday and today is a Windows Security update. Has anyone else experienced this? I have stopped/started all services; uninstalled the update and restarted the machine but nothing seems to work to get the site back up. I feel like rolling back to a backup is the only option.  Thanks!

333
alisonsep
Contributor
mathiku
Supporter
mathikuSupporter
asked in Automation
Log - what's taking so long?

I have a job running that takes 10 minutes and generates 19.000 rows in the log. The runtime is not the issue here, I'm just curious to out some numbers on time-spent.What’s the best way to find out where the time is spent?I suspect a few specific transformers, but since this is probably a common question I wonder what other people are doing.

528
virtualcitymatt
Celebrity
lhcamm
Contributor
lhcammContributor
asked in Security
How could share web connection with only access permission not full permission?

Hi,I would like to ask if there is a way to share webconnections to group of users with partial permission (ie only access permission) not full permission. the issue with full permission that the shared users can be able to delete web connections I shared. I have to tried to take off their manager and create permission but still wont be able to let them do not remove the share connection.We are looking for a way can do partial permission setting up. Thank you very much. 😁 

172
lhcamm
Contributor
joy
Enthusiast
joyEnthusiast
asked in Automation
Data Dowload only returns one output [FME Flow 2024.2.1]

Hello everyone, I encounter a similar problem to the following post from 4 years ago.I am able to write several output files (2 .dgn files) in FME Form. However when I publish the script to FME Flow and run  the script in the form of a workspace I only get one output result back.I already looked into the Data Download Service Properties when I publish the script to FME Flow and both writers are already included in the Writers in Download attribute. So I am not sure why I don't get both files in the zip file. The files don't have the same name. The weird thing is also that the dgn file I get back from FME Flow has the same name as the zip file, while in FME Form they get the name I have defined in the writers (Bomen.dgn and Kabels_Met_Buffers.dgn).Another finding is when I look into the translation log on FME Flow, it looks all features are written (23000 features). I know that 18000 features are in one file and 5000 features in the other file. So it looks like all feature are written, 

575
joy
Enthusiast
nikolajolesen
Contributor
nikolajolesenContributor
asked in Flow Hosted
conditional visability in FLOW doesn't work properly?

in a FME FORM i have made some user parameter, that takes in input; one of them have a conditional visibility based on whether another user parameter has an input of > 100. When i run the creator in FORM, and input a number abobe 100,  it works, but when i publish it to FLOW the conditional visibility doesn’t work.then, if I change the condition to “is 100” instead og “> 100” and republish, it works.is this a bug, or is there a work around?  

448
nikolajolesen
Contributor
michaelh
Contributor
michaelhContributor
asked in Deployment
FME Flow: how to download an xslx or docx file or, if that's not possible, how to name the zip file appropriately?

Hi -I could use a hand. We are working with FME Flow 2024.1.1 with work spaces being generated in FME Desktop 2024.1.1.The data download service is working fine, but we would like to be able to do one or two things:Is it possible to just download a .docx or xslx file without it being zipped? It is one other step that our end users don’t need. If not, is it possible to name the zip file according to report for the area we are working in, something like: BostonStreets_20250203.zip. An example of the output we are seeing, and would like to change, is attached. We can name the files within the zip file whatever we want, no problem.Any help or suggestions are appreciated!Thanks! 

231
j.botterill
Influencer
thomastupuivao
Contributor
thomastupuivaoContributor
asked in Deployment
Error when uploading workspace to FME Flow from FME Form. "Failed to update definition of database type Microsoft SQL Server

Workspace I’m uploading from FME Form (2024.0.1.0) returns this error.  Failed to update definition of database type 'Microsoft SQL Server (JDBC)' - FME Flow encountered an error and reported the following message.Database type Microsoft SQL Server (JDBC) cannot be edited.Request to http://XXXXXXXXX/fmeapiv4/databasetypes/Microsoft SQL Server (JDBC) returned status code 422. Is a workspace that has SQL Executors pointing to a SQL Server database and outputs results to a XLSX file on my laptop.Any help would be appreciated. 

926
mattmatsafe
Safer
kieran.odonnell
Contributor
kieran.odonnellContributor
asked in Architecture
FME Flow via Microsoft Entra application proxy

Hi FME community,I’ve recently been asked if FME Flow supports access via the Microsoft Entra application proxy. Has anyone configured this and can confirm it is supported?I believe it’s very similar to the setup explained in the documentation below, but I haven’t been able to find any documentation referencing the Microsoft Entra application proxy.https://support.safe.com/hc/en-us/articles/25407571916173-Use-a-Reverse-Proxy-with-FME-Serverhttps://support.safe.com/hc/en-us/articles/25407364847885-Using-IIS-and-ARR-as-a-Reverse-Proxy-in-FME-FlowThanks!

251
hkingsbury
Celebrity
fmejohn93
Contributor
fmejohn93Contributor
asked in Automation
FME form trying to create a folder when it should create a file

This job works fine in FME Workbench 2024.2. But in FME flow, when I try to run the workspace, it’s trying to create a folder instead of a .xml file. See screenshots

494
fmejohn93
Contributor
larsatomkeere
Contributor
larsatomkeereContributor
asked in Flow Hosted
Connecting to MSSQL from Flow Hosted

We have an FME Flow Hosted instance running and I need to connect to an MS SQL Server. I have seen from the Reader/Writer documentation that MS SQL is not supported from FME Flow Hosted.Does anyone have a suggestion how we could still connect to MS SQL?The question is very relevant to us, since we plan to migrate to an FME Flow that will also run from an Linux-instance, which seems to be the cause why it isn’t possible to connect to MS SQL. N.B. Our current FME version is 2024.0.3.

382
larsatomkeere
Contributor
dellerbeck
Contributor
dellerbeckContributor
asked in Automation
Automation Parameters are Resetting

If you have an existing automation and need to make a change, you make your changes and publish \\ overwrite in FME Forms. Once you go to the automation and stop it, all parameters are reset to defaults. This happens even to workspaces that were not updated. This has happened the last 2 or 3 releases, currently we are onFME Flow 2023.1Build 23619 - win64

35610
marlloess
Participant
sarvani
Contributor
sarvaniContributor
asked in Architecture
FME Flow - ORA-12154: TNS:could not resolve the connect identifier specified

Hi AllCurrently we are facing some weird issueWe have a FME workspace which is running fine in FME Form (2024.2.3 - 64 bit), we have published to FME Flow (2024.2.3) and when we ran the workspace from FME Flow, it started throwing below Ora error (changed ServerName & UserName values to XXX to hide)-“ Error connecting to Oracle database: message was `ORA-12154: TNS:could not resolve the connect identifier specified'. (serverType=`ORACLE8I', serverName=`XXX', userName=`XXX', password=`***', dbname=`') “I have cross verified the below from my side on FME Flow (Windows Server) and I’m not sure what I’m missing, please suggest how can I overcome this issue in FME Flow.We are not connecting to Oracle using local naming (tnsnames.ora file) instead using LDAP TNSPING ServiceName - resulted correct response  Ensured both Oracle Client 32 bit and Oracle Client 64 bit paths are part of ‘Path’ environment variable under system variablesFME Flow windows services (Application, Core, Database, E

301
hkingsbury
Celebrity
deanhowell
Influencer
deanhowellInfluencer
asked in Automation
AWS SNS Issue

I have a 2023.2.1 workbench that reads in a JSON file using the TextLine reader, does some FME magic and the outputs the results for FME Server (Flow) to use.2023.2.1 workbench to process JSONThe reader parameters are set to read the whole file at onceThe workbench is published to FME Flow 2023.2.1 and is used in an Automation that gets an AWS SNS message with the JSON info in the message of the SNS. The SNS is received as expected but the message appears to be reading each line as a separate source and as such it never processes the file as expected.  Any advice as to what I am doing wrong in the process?

232
deanhowell
Influencer
vxn43
Supporter
vxn43Supporter
asked in Automation
Directory Watch in Automation does not watch

Hello, I am using FME Flow 2021. I have an Automation that uses Directory Watch. When a file is added to the “Directory to Watch,” the Automation should run. But it does not run when a new file is added. I can run it manually, and it works as expected. In my screen capture below, it seems I need to add something to “Events to Watch for” to trigger. What am I missing?  

243
dylan.at.safe
Safer
lifalin2016
Contributor
lifalin2016Contributor
asked in Deployment
"There was an error submitting the job" running under AD account

Hi list.I have a local FME Flow development setup using 2024.2.3Originally all of its 4 services ran as Local System, but the workspaces need to access files on a file share on another server, and so I tried changing the services (except database) to Local Network Service without much success.Our production servers (2022) do run with an AD account, so I have som experience with this approach. I therefore changed the development Flow to run under my AD account.The interface seems to be working ok, but now whenever I try to run a workspace, it errs with “There was an error submitting the job”.Why is this different ? What am I missing here ?Any insight is appriciated.Cheers

131
dylan.at.safe
Safer
asellars
Participant
asellarsParticipant
asked in General
Receiving a 422 when re-publishing a service that uses a Notification Service

Hi all, I am trying to modify a workbench and re-upload it to the server (2020.1 to 2020.1) and am getting back an error that: The following readers or writers are included in an enabled service, but are not present in the workspace: [SourceDataset_JSON]Request to xxx returned status code 422. This has only happened since we updated the server from 2020.0 to 2020.1. The workbench takes incoming JSON from a notification service using a topic and subscription and runs it through the workbench and dumps it into an Esri Portal FS.  This error is odd because there is only one reader and one writer in the service.  If anyone else has seen this problem please let me know. Thanks!-Adrian

6365
mathiku
Supporter
ecx
Supporter
ecxSupporter
asked in Automation
Data streaming service doesn't display HTML page, stuck loading

Hello all, I have a FME flow web-app (image 1). I am attempting to get a message to the user in certain circumstances via HTML output (image 2), which displays a message via the browser to the user if certain conditions are met, via redirecting the web-app page, e.g. there is an issue with their edits (image 3)image 1image 2image 3, text printed through the browserThis works, sort of. but its not good enough for end users, as the page redirects, but is blank and is stuck in a perpetual loading state. Until the user hits the ‘stop refresh’ (X) on their browser, then the message (image 3) appears.My questions are:How can I make this work without the user having to hit the stop refresh button?Will that page redirect stop the rest of the FME process from running/committing changes? Is there a way to link this to a terminator? if I can terminate the process the perpetual refresh may also stop.   I have the services set up like this:Or, are there any alternative ways to get a message to the

293
j.botterill
Influencer
mproctorbrown
Contributor
mproctorbrownContributor
asked in Deployment
System Email config for Microsoft Exhange Online with OAuth

This article covers setting up FME Form & Flow Emailer transformers, but doesn't cover the System Email setup in FME Flow.https://support.safe.com/hc/en-us/articles/25407404506253-How-to-Connect-to-Microsoft-Exchange-Online-using-OAuth-2-0-Microsoft-Modern-AuthenticationThat page has much fewer settings available than the transformers:The docs don’t mention how to use Client ID (UI notes this as Microsoft OAuth only)https://docs.safe.com/fme/html/FME-Flow/WebUI/System-Email.htm What are the steps needed to set up System Email with Microsoft OAuth?Do we need to register an SMTP Account & Password rather than use Client ID / Client Secret?

363
j.botterill
Influencer
smclaugh1
Contributor
smclaugh1Contributor
asked in Deployment
Brand FORM UI

We have 3 different FME servers, how can we modify the FLOW UI so that you can easily distinguish one server from the other?

544
hkingsbury
Celebrity
alisonsep
Contributor
alisonsepContributor
asked in Automation
Issue with FTPCaller on Flow but now on Form (desktop)-Could not resolve hostname

Greetings!I have a simple workbench that runs without issue on Form (v2025.0) that uses a CSV reader that lists File_name, file_url in which the url is a SFTP://hostname:22/path/filename.typ The CSV reader is linked to the FTPCaller.This process works fine on Form (desktop) and loads the files to the respective server and path.However, when the workbench is run from the server, is runs Successful-but does not load the files; in the log there is an error: FTPCaller (FTPFactory): FTP/FTPS/SFTP transfer error: Could not resolve hostname Any suggestions on why?

404
alisonsep
Contributor
f.kemminje
Contributor
f.kemminjeContributor
asked in Automation
Emailer Transformer Error in FME Workspace while running fme from "CMD prompt"

Dear Team,I have an Emailer transformer at the end of my FME workspace (FMW file) that is configured to send a completion notification to my Gmail account. However, I am encountering an error when it tries to send the email.I have already updated the Emailer transformer, Python, and other relevant components, but the issue persists. But from desktop it runs perfectly. only when i run from command prompt it gives error.("D:\Program Files\FME2024\fme.exe" D:\fvt2\1_spatial_tables_ver9.fmw )Could someone in the group please help me identify what might be causing the problem?Thank you in advance for your support.Best regards,Farook2025-04-29 05:17:31|1614.6|  0.5|STATS |DateTimeStamper (TeeFactory): Cloned 1 input feature(s) into 1 output feature(s)2025-04-29 05:17:31|1614.6|  0.0|STATS |CRCCalculator_2_Executor (ExecuteFunctionFactory): Executed FME Functions on 1 input feature(s) -- 1 feature(s) completed and 0 feature(s) rejected2025-04-29 05:17:31|1614.6|  0.0|INFORM|Successfully close

262
nielsgerrits
VIP
koen
Contributor
koenContributor
asked in Deployment
ArcGIS Portal Web Connection as Published Parameter

I am trying to read/write from ArcGIS Portal in FME Flow with a parameterized Web Connection, but am not able to select a connection in FME Flow. I used these steps to set everything up succesfully: https://support.safe.com/hc/en-us/articles/25407772142733-How-to-Create-an-ArcGIS-Enterprise-Portal-Web-Connection-OAuth-2-0 ✅ FME Form I created:a webservice named 'Esri ArcGIS Portal MyCompany’ several web connecions: ‘user1 Esri ArcGIS Portal MyCompany’, ‘user2 Esri ArcGIS Portal MyCompany’This works fine in FME Form and I can read from ArcGIS Portal. ✅ FME FlowI published these service, connections and workspace to FME Flow as described, and this runs fine as well. As long as the connection is hardcoded in the workspace. ❌ FME Flow with Portal Connection ParameterNow I want to create a parameter for this connection, so I can choose in FME Flow which connection to use, but that doesn't seem to work.When creating the parameter the only supported service is 'Esri ArcGIS Portal (Template)’,

361
ebygomm
Influencer
helmoetz
Supporter
helmoetzSupporter
asked in Deployment
silent install fme-flow-2024.2.3-b24825-win-x64.exe

Hi, we are trying to perform a silent install for fme flow 2024.2.3. Because the installer installs on-the-fly some additional software like CLR Types for SQL Server and the Visual Studio Redistibutables, we cannot use our old method of copying a pre-extracted set of cabinet files, as suggested in the installation manual. We have to execute the self-extracting archive and supply the installation properties as a quoted string. We tried a couple ways of coding the properties (single quotes, double quotes, 8-fold quotes) however the script simply seems to install the additional software and then presents in a non-silent mode the fme-flow installer dialog box (see attachment). Anyone have any ideas? Our simple install script is attached to this question too. ​@david_r maybe?

375
hkingsbury
Celebrity

Badge Winners

Show all badges

Community Stats

31,233
Posts
118,432
Replies
38,828
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.