FME Flow

Hi,When I run a workspace via an App I get the following error:Microsoft Azure SQL Database Non-Spatial Writer: A suitable Microsoft SQL Server OLE Driver is not found. Install Microsoft OLE DB Driver for SQL Server from http://www.microsoft.com/en-ca/download/details.aspx?id=56730 I can see from earlier on in the logs that it failed to connect :Microsoft Azure SQL Database Non-Spatial Writer: Failed to connect using Microsoft OLE DB Driver 19 for SQL Server. Provider error ''. When I run the same workspace from “Run workspace” it connects and runs fine:Microsoft Azure SQL Database Non-Spatial Writer: Trying to connect using Microsoft OLE DB Driver 19 for SQL Server…Microsoft Azure SQL Database Non-Spatial Writer: Starting execution of BEGIN_SQL commands I tried deleting the app and creating it again but that didn’t seem to work. TIA

I am sure that there is a solution within fme flow automation, but meanwhile I am pulling my hair for not finding it…The scenario:Through a directory watcher triggered automation, I import the content of a variety of geopackage files into postgis tables with corresponding names. This part runs well.For some of these tables, I have ElasticSearch indices, which have to be rebuilt after table import. For the indexing, I have a repo on the flow server named Elastic-Indexer, and therein are workspaces with names corresponding to some of the tables. (n.b. not all tables have corresponding indexer workspaces)Now I try to build up a dynamic system that gets notified with the schema.tablename after import and runs - if it exists - a workspace with a matching name from the Elastic-Indexer repository. My first idea was to read the workspace names from that repository and call the workspace if the name matches, but a) I was not able to read the workspace names and b) this solution looks clunky whe

My FME Server dashboards are not working. When I try to run JobHistoryStatisticsGathering.fmw, it fails with:Terminator (TestFactory): Terminator: Termination Message: 'Translation Terminated: There was an error getting job history.Error Message: HTTP/1.1 404 - http://v01w-app-p0427/fmeserver/fmerest/v3/transformations/jobs/completed?limit=1000&offset=0'What file is it looking for? 

Has anyone come up with any easily quantifiable methods of testing the performance of the FME Flow user interface?I’ve sat with a stopwatch in the past but it’s a bit of a laborious process. 

Hi,We updated our FME Flow from 2023 to 2024.2.1 yesterday. After that workspaces that have connection to Arcis Online not inside our network are not working. Those that are in our internal network still work.Error message that we have is the same in all workspaces, we tried this also with a workspace that has only a reader and got the same issue. 53 2024-12-17 08:20:02 | Message Type: fme::internal::_v0::py::Exception 54 2024-12-17 08:20:02 | Python Exception <AttributeError>: 'NoneType' object has no attribute 'supportQueryStringAuthorization'

Hi.I’ve just upgraded my local FME Flow from 2024.0.1 to 2024.2.1 using an engine only upgrade.I.e. install FME parallel to the previous engine, and change the configured template path.The interface is thus still 2024.0.1.The FME Flow interface starts, but the engine never shows up in its list.I’ve tried to run the new fme.exe directly, and it seems to be running.What unforeseen pitfall have I stumbled into ?Cheers.

Hello,  I am using a no-fault FME Flow architecture: 2 engines. Should the engines be restarted regularly, for example, each month? What does Safe Software recommend?How often do you restart the engines? When do you restart the engines?

Hi Folks,I have previously installed and worked on FME Server, with my last usage being approximately 2–3 months ago.However, I am currently unable to log in, and the system displays the following error message:Could someone please assist in identifying the cause of this issue and guide me on resolving it?Thank you in advance for your support.

Hello :) I have some workbenches on the FME Server 2022 and I get for all of them the error:2024-12-11 13:37:46 | java.sql.SQLException: Query failed (#20241211_123746_28965_mxxee): Unknown transaction ID: f6d2afb3-c2fa-4417-970c-375bf47d1c9f. Possibly expired? Commands ignored until end of transaction blockIs that something I can fix or is it a Server error that only admins can fix? It is some time ago I was running the workbench. I tested one on my Laptop for a small country and it went good. all other countries are too big that is why I choose the FME Server. Any suggestions of what I can do?Vanessa

Hello, we noticed that with multiple scripts that have the feature portal service writer problems occurred:  This is part of the log file when trying to run the workbench script:Loaded Python module `arcgisonlinefeatures' from file `C:\Program Files\ArcGIS\Data Interoperability for ArcGIS Pro\python\fme-plugins-py311.zip\arcgisonlinefeatures\__init__.pyc' Writer `ARCGISPORTALFEATURES_2' of type `ARCGISPORTALFEATURES' using group definition keyword `ARCGISPORTALFEATURES_2_DEF' Loaded Python module `arcgisonlinefeatures' from file `C:\Program Files\ArcGIS\Data Interoperability for ArcGIS Pro\python\fme-plugins-py311.zip\arcgisonlinefeatures\__init__.pyc' Message Type: fme::internal::_v0::py::Exception Python Exception <ValueError>: invalid literal for int() with base 10: '<Unused>' ARCGISPORTALFEATURES writer: An error has occurred. Check the logfile above for details When running the script using a local .gdb as a writer there are no problems and the script runs fine. What c

We are running into issues with the user parameter file inputs for Automation Apps.  In this case our end user wants to upload a new csv file every time they run the automation app, and they want to upload it from their local computer/machine.  Right now the only way to accept this user input is to have the csv file uploaded to a data store in FME Server, prior to selecting it as a user parameter, and then running the automation app.  We noticed that this problem doesn't happen for workspace applications and they can upload local files directly as the end user, with no need to upload it to the data store in fme server prior.  Is it possible to have our end user run an automation app and upload the user parameter directly from their local machine?

I have a flow automation runs every 5 minutes, and will send out a notification email if a job failed. That becomes an issue if a problem that caused the job to fail hasn’t been resolved soon since the automation will continue to send out error email every 5 minutes.Is there any way to stop sending email after e.g. 10 emails or to reduce the frequency for sending error emails? I still want the automation to run every 5 minutes, even some job failed, but want to get just reasonable amount of error emails. 

Hello everyone-Hoping that someone may be able to help with this question!Is there a way to provide a specific required JSON Response body (for example:  {“status”:”OPERATION_OK}  ) to a 3rd party application in response to a successful post to an FME Flow Automation with a Webhook trigger? I feel like I’m missing something obvious here….Any help would be greatly appreciated!Mike

Upgrading from FME Server 2022 to Flow 2024.2, Very frustrating to see no Schedule Categories in FME Flow 2024.2! WHY ? Instead of finally making the tabular Schedules page sortable (how old is that idea?) or adding some useful filtering, it’s now time for tagging? Man!All my workspaces are organized by repository. Have been for years. My Schedules were organized by Categories, which matched Repository names. What was wrong with that? Go ahead and add tagging but why remove the categories? If I’m missing something, please let me know and I will gladly stand corrected. My real concern here is not with having to invent tags and changing my ways. Rather it’s the fear that Safe is becoming more like ESRI where changes seem to get rolled out not in an effort to improve the product but to make it look like the dev teams are constantly working. Please don’t follow their lead. FME has been my haven of sanity and productivity over the years when ESRI bugs shut me down. I can ignore the silly re

I'm running FME Server 2019.2 in Docker Swarm using a fairly standard compose file. In the past, we have had some minor issues with time synching, and the containers believing they were in UTC. Most of that has been resolved, however, we noticed today that we are unable to get a local timestamp generated from within a workspace, even though FME server logs in local time, and all of the containers are pulling time from their host.Using date, echo /etc/timezone or $TZ all return PST, however the workspace always returns UTC. I've got a volume on all our containers to use local host's timezone (/etc/localtime:/etclocaltime:ro) with no effect. Does anyone know what else I can look at to fix this? To be clear - all of our job schedules run localtime, but when trying to use date/time functions inside a workspace, UTC and localtime are the same according to FME. 

Recently upgraded our Dev environment to FME Flow 2024.1 (in situ)Previously we were connecting to WebMethods using Software AG(Nirvana)After installation, relevant .jar files have been added to the jms directory on the serverHowever, there is no connectivity.The error received isOM.safe.fmeserver.plugin.jms.JMSClientException: javax.naming.CommunicationException: JNDI setup failed on RNAME=nsps:REDACTED [Root exception is com.pcbsys.nirvana.client.nRealmUnreachableException: Realm is currently not reachable:Realm was still unreachable after max retry count - 0]This doesn’t appear to be hugely helpful as you get the exact same error if you use an incorrect provider URL. I can’t see anything in the logs that provides any additional informationAll evidence points to the location being reachable (testnet connection in powershell from the server) @steveatsafe - any ideas?

I have looked at this: https://knowledge.safe.com/articles/678/create-a-custom-download-link-for-results-from-dat.htmlI want to be able to set the exact-filename of the zip-file within FME Workbench for the download service. Si instead of the URL like this: http://fmeserver/fmedatadownload/FME_2D764B0C_1515155526785_73956.zipI want to be able to define a parameter in a workspace called:ZIPFILENAME = myfilename.zipSo the Datadownloadservice serves the file:http://fmeserver/fmedatadownload/myfilename.zipIn other workspaces I will have completely different zip-filenames.Any way to do this? I manage to create all the data within the correct file and use the filecopy to copy the file to the correct place (within fmedatadownload/) but I can not persuade the fME Datadownloadservice to use that zipfile and not create a random-zipfile.

Hi there,Successfully created an FME Flow Automation App (2023.1.1.1) that allows the user to upload files. However the customer doesn’t like the fact that the + Enter URL/Path link is shown.Where are the webpages stored on FME Flow? Can the html be modified to hide this link?

Hi Everyone,today I upgraded from FME Flow 2023.1.1.1 to 2024.2 (Express install) all went well and I do have a working environment. But I noticed something. Before the upgrade I made a screenshot of the license information and it said I had Additional Capabilities: After the upgrade (I installed a new fmelic file I received by mail from codes@safe.com ) these are missing: So, does anyone know how to fix this? If these capabilities are called upon in workbenches will they break? 

Good morning. According to this article I should be able to download resources using an URL similar to:https://fmeserver.example.com/fmerest/v3/resources/connections/FME_SHAREDRESOURCE_TEMP/filesys/testSpreadsheet.xlsxBut when I try to do so, instead of getting the file I get information about the file:http://sigdesafme.dfa.es/fmerest/v3/resources/connections/FME_SHAREDRESOURCE_DATA/filesys/GASTDM01/wrapper.logWhat I get in the web explorer is this: {"date":"2024-07-17T13:04:52+02:00","path":"/GASTDM01/","size":153839356,"name":"wrapper.log","type":"FILE"}Am I missing something?I have tried to change filesys for “download” or “downloadzip”, but the ZIP it downloads is empty.The version of FME Server is 2021.1.

Hello FME Community,We are currently using the following software versions:FME Desktop: 2021.1.0.0 (20210630 - Build 21607 - WIN64, Python 3.6-3.9) FME Server: 2021.1 (Build 21607 - win64, Python 3.6-3.9) ArcGIS Enterprise: 10.9.1 (Python 3.7.11/2.7.18) ArcGIS Pro: 2.7 (Python 3.7.9)And we did not encounter any compatibility issues with our current setup regarding Python versions (as expected).Now, we have a scheduled plan to upgrade our ArcGIS software to ArcGIS Enterprise 11.3 and ArcGIS Pro 3.1 this year, followed by an upgrade to our FME software next year.Since ArcGIS Enterprise 11.3 uses Python 3.11 and ArcGIS Pro 3.1 uses Python 3.9.16, could anyone please share if you have noticed any concerns or compatibility issues when using FME Desktop and Server 2021.1 with ArcGIS Enterprise 11.3 and ArcGIS Pro 3.1? Do we need to upgrade FME  before ArcGIS, from a technical performance and issues standpoint (please disregard tech support concerns for the purpose of this post)?

Hi all, We currently use imap to connect to office365. The FME Imap process currrently uses basic auth which will be disabled my Microsoft in October this year.  I understand that imap with Office365 will still work, but only with modern auth OAuth2. Does anyone have any experience with how to enable Oauth2 for FME IMAP, and can run thorugh how to do this. Thanks,

Hey guys, stumped with this one:I’m trying to find the distance of rail tracks between two stations - I’ve got the points for the stations and lines of the railway tracks but I need to find the route between the two stations and measure its distance.I’ve been able to limit the area but finding the most direct route and not measuring the distance of extra lines coming onto the route.Thank you in advance, any help is much appreciated.

Reading this: https://support.safe.com/hc/en-us/articles/25407546959629-Deploying-FME-Flow-on-AzureIt seems possible to deploy a finished setup on Azure using this product: https://azuremarketplace.microsoft.com/en-us/marketplace/apps/safesoftwareinc.fme-platform?tab=OverviewMy questions are. Is there anyone that have tried this approach (only 1 review right now)? And what are the estimated costs for the Azure infrastructure per month for this setup? I understand the costs are higher for more usage etc. However ther have to be a minimum estimated  cost for a “normal” system somehow.   

I have published a workspace to FME Flow. When I run it in FME Flow, I get this error in the log file:  Path Reader: Error opening the PATH Reader on folder '\\\\myservername\\T_DFshared\\FME Workflow\\All Reports to Folder5'. Could not find folder.​I checked and the server where the folder resides can communicate with the server that FME Flow is installed on.  The folder does indeed exist and has the files used in the workspace in it.  The workspace published from FME Form starts with a Directory and Pathnames Reader and runs with no errors in FME Form. ​Could this error be caused by the spaces in the folder names in the UNC path shown above or could something else be causing this error?