FME Flow

Hi!I need help in configuring FME Form to run RCaller.FME is not local in my machine; instead, I'm remoting in to a server to run Form from there. It's prompting me this error message:    RCaller (InlineQueryFactory): Failed with exit code 1 when executing R script. Output was: Error in library("sqldf") : there is no package called 'sqldf'    Execution halted    Failed to execute scripted code.I followed the steps indicated in https://docs.safe.com/fme/2017.0/html/FME_Desktop_Documentation/FME_Transformers/Transformers/rcaller.htm. I configured the default paths and R Plugin files in: "C:\Program Files\R\R-4.4.1\bin\Plugins" and the Plugins folder contains the following files:    assertthat    BH    bit    bit64    blob    chron    DBI    digest    gsubfn    magrittr    memoise    pkgconfig    plogr    prettyunits    proto    RCpp    RSQLite    sqldfI am not sure what's causing the error. Any help or piece of advice greatly appreciated.Thanks,Wilfredo 

Hello Forum., This sounds like it’s a straightforward function. I’ve looked but can’t see an obvious way of doing it. I’m looking at FME Flow>Schedules>Manage Schedules. I want to be able to see the last time that a selected schedule item actually run. A bonus would be to see a successful/not successful flag too. Alternatively, this information could be captured in a log. But there doesn’t appear to be log option on that page, nor is there a column stating last time run. Or am I just missing it? Thanks,Stuart   

Hi,  I am using FME Flow (desktop) and I need to make workspace for producing map reports (image or PDF) like a layout in QGIS or ArcGIS, but as I know it is not so easy. What I need:a basemap (preferred areal, but standard would be good as well)  visualize my line layer georeferenced on the top of it some additional informations (tables, map legend etc.) around the map Does anyone know an easy solution/approach fir this, or FME is simply not for such a visualization and I should search for other tools to do it?  Thanks for the help!  

Good morning,I amplanning to upgrade FME 2018 server to FME 2023 , I have 200-250 ETL in 2018. Usually how many ETLs in 2018 will be impacted on the average when upgrading to FME 2023.  On the average, how long it takes to upgrade from FME 2028 to FME 2023, the whole process. I know it depends on the organization setup but just in general how long it takes to upgrade. Thanks

Hey peeps, I'm currently trying to import a project to FME Flow. The problem is that when I only try to select the relevant items for that environment, it still imports and overwrites the other categories. For database connections I don't experience any problems. There is an option to choose whether to overwrite the existing ones or not on the third page. But for all the other items it seems to be all or nothing. Any advice that doesn't tell me to exclude the items from the project, would be welcome.

My co-worker doesn’t see the popup 'Register Service' whenever they publish a workspace to FME server. I generally see one and the service ‘Job Submitter’ is ticked. Does my co-worker need this to run their workspace on the server? 

Hello,I’m trying to write files into a Shared Network Folders via an automation in FME Flow running a workspace.The Shared Network Folders were mounted onto the VM Server and then added to the Resources in the FME Flow app with the credentials from “user1”.After adding the shared network folders to the Resources in FME Flow I can see the files and folders inside them and I can download and read the files and folders via the FME Flow interface without problems. But when I’m trying to upload files/folders or create a folder directly in the share it gives me an error indicating issues with access rights. I find it weird that I can see, read and download folders but not upload them, but I guess it is because the credentials used by FME Flow to access the shared network folders are not the ones from “user1” but from the service user account that FME Flow uses, like “fmflow” user or something like that.Question is how can I find out what is the user used by FME Flow to access the shared netw

In the 2024.x versions of FME Flow, will the URL continue to contain ‘fmeserver’ or will it be changed to ‘fmeflow’? Example: https://mydomain/fmeserver vs. https://mydomain/fmeflow If, by default, the URL will continue to have ‘fmeserver’ in it, can we change that in a configuration file?Asking as we may need to run both FME Server 2022.x and FME Flow 2024 in parallel while migrating some legacy 32-bit Esri solutions. Thanks,Mark

A few co-workers have left the company and have forgotten to share their workspaces on the FME server with myself and others. Is there a way for the FME admin to share those workspaces that are being used in automation and schedules with us?

We are slowly moving from an old platform to a newer, in this case FME 2018 to FME 2023. We cant move all our scripts at the same time so we need to find a solution that can be handled over a period of time. We have a lot of  flows which uses a startscript and a lot of subscripts. Each flow is dependent on that specific other flows has ended before next one starts. Example:We have three flows, A, B and C. A must be done before B can start. B must be done before C can start and so on. In todays solution we run the flows on the same engine which will secure that some flows has ended before next one starts. All our jobs are scheduled but it doesn’t matter if flow A is taken a little longer time than normal because even if flow B is scheduled to run 02:00 AM but flow A finishes at 02:25 AM, flow B is queued and will start as soon as flow A ends. But if we just move flow B to the new server we have a little problem. It can’t start before flow A is finished which runs on the old server. What

In FME Flow, you can set up automation so that a workspace restarts if the job fails. However, if a job is canceled (for instance, it exceeds the max. queue time), this is not possible. Or have I missed something?

Hi, I’m looking for the best way to let end users decide whether to trigger a second workspace based on result (html data stream service) from first workspace. Is it possbile at all using eg. an automation app? If possible I also want to make use of the same parameters in both workspaces to make sure the geographic extent is the same.My case is that workspace 1 runs some calculations to get costs. These costs need to be accepted by end user (Yes/No) before ruinning next workspace which produces som files. If possible I want to make use of the same parameters in both workspaces since it should make use om the same geographic extent.Thanks for any ideas

Hello,  I’m building a workflow to process multiple input files. When running from FME Flow some of the files are read correctly from this location:  /data/fmeflow/resources/system/temp/upload// but for some of them I’m getting this error: File does not exist: $(FME_DATA_REPOSITORY)/When running from FME Form I’m getting the same error: File does not exist: $(FME_MF_DIR)For some reason this this happens only when more than 21 files are processed (does not matter the size of the file). Do you have any idea how to fix it?  Thank you.  

I’m not sure what version of FME Flow this feature was removed in, but in versions prior to 2023.1, there used to be a “Reset” button on the Schedules page so if any parameters were changed in the FME Workspace, you can just press the “Reset” button and it would automatically update the parameters based on the workspace.That functionality is now gone, which makes it slightly more difficult and inconvenient to update schedules.You can see in the screenshot below, that I took from an FME Server 2018 training manual, that the “Reset” button exists. But in this screenshot below in our FME Flow 2023.1 environment, the “Reset” button is not there. While it’s not a big deal, it is a minor inconvenience and I’d like to understand the logic behind Safe removing this functionality.

Good morning,I am trying to open tutorials for the Demos using this link:https://engage.safe.com/demos/When I am truing to go to the Tutorial, I have this browser window opening up:https://community.safe.com/Can someone let me know if this is an issue or there might be a different link? Thank you.

Hello. We were using some extra libraries like pymssql and Arcpy in some shutdownscripts/startupscripts on our FME Server 2021  with python2.7  and integrated the libraries with sys.path.append ("C:\\Python27\\ArcGISXX.X\\Lib\\site-packages") like in this article https://support.safe.com/s/article/importing-arcpy-troubleshooting-ideasThis was working fine.Now we should upgrade to python3.x and arcgis pro with a new Server/Flow Version.I tried the old method but this isn’t working anymore. I found this article but for the server it’s a dead link https://support.safe.com/s/article/choosing-a-different-python-interpreter-installati Is there a similar way for arcgis pro and python3 to use pymssql in FME Server/Flow?

FME Flow 2023.2.2.We are modifying most of our workspaces and automations to take advantage of deployment parameters but we are finding some difficulties to fully use them inside automations.As an example, we often write data to SFTP directories both inside workspaces and automations. FTPCaller URL, user and password can easily be configured through deployment parameters but I can’t see how to use deployment params to configure SFTP Directory external action host, port, user and password. Is there any trick to do so?If there’s no possibility to do so we’ll have to rebuild a number of workflows to write data to SFTP together with other related actions inside workspaces instead and I’d prefer to keep the SFTP Directory actions and error control inside the automations as they make the whole thing more graphic and manageable. 

I have automations that read sql tables an read the filenames in specific tables. in order to iterate through the records the automation updates a flag (i.e. PF = 0, 1, 2, 3) The automation runs on an interval and gets the next record PF=0 and sets the flag according to how far it gets through the automation. It’s seems like it would take quite a bit to rig a method to get the PF=0 count and corelate that to how many times the automation runs. I am looking for suggestions on how i could determine there are no more pf=0 records and stop the automation. Is there a transformer for Flow that will use data to stop the automation?Probably with python (right?) non python?

The connection works in FME Form, but while uploading the workspace I get the following 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 https://xxxxxxxxxxxxxx/fmeapiv4/databasetypes/Microsoft SQL Server (JDBC) returned status code 422. Any tips and help greatly appreciated.

I got an error from FME 2019.2 and FME 2022.1. The error is " Python Exception <OSError>: Could not find a suitable TLS CA certificate bundle, invalid path: C:\\Program Files\\PostgreSQL\\15\\ssl\\certs\\ca-bundle.crt".Anyone has idea how to fix?

Hello All, We are currently using FME server as an integration platform. There are many FME jobs (triggered via external system call) that writes data in to database via ArcGIS portal service. Is it possible to (hold)queue all the jobs in FME server when ArcGIS enterprise will be down  ? Also, would like to know if there is a provision to hold all the jobs that is directed to a specific queue? Thanks,Naveen

Hi all,I’m having an issue getting some Flow App users to be able to successfully write to an ArcGIS SDE database. I am getting the following error.“An error occurred while attempting to retrieve the connection parameters from the connection file ‘SDE Connection’”This had previously been working fine, but with the upgrade from 2022 to 2023, connecting to SDE now requires a stored database connection, which then gets uploaded when it is published. Previously, at 2022, I think it was just storing the UNC pathing to the SDE connection file, and as long as FME Flow had access to this folder, everything was fine.Initially the App users were set up with Access permission to the Flow Workspace Apps, and nothing else. After a bit of hunting around I then added Access permission to the Connections, as this seemed like it might be necessary.But unfortunately this seems to have made no difference, and the users are still getting the same error.Are there any other permission requirements that are

Hi All,  I am seeking assistance in developing an FME workflow to perform clearance analytics for both roads and power lines in terms of trees - utility vegetation management. Our source data includes:Mobile Laser Scanner (MLS) Point Clouds: Representing the surrounding environment. The data includes the canopy and branch classification of each individual trees. Pre-defined Clearance Profiles (Vectors): Defining the acceptable clearance zones for roads and power lines. Linear Reference Data (Polylines): Representing the road edges or power line geometry.Workflow Goal:The objective is to identify and classify obstacles within the pre-defined clearance profiles. This involves:Spatial Analysis: Identify point cloud data falling within the designated clearance profiles. Obstacle Classification: Classify the identified points as potential obstacles. Obstacle Dimensioning: Measure the dimensions of the classified obstacles.Risk Assessment Output:Based on the identified obstacles, we aim to g

Hi.I’ve encountered this before, but now it blocks the saving of a 28K large table, and is so no more a mere nuisance.It seems that FME fails to catch that SQL statements fails typically due to constraints in the database. FME happily reports that all posts were saved, although none were in this case.My latest error message from the log file looks like this:Microsoft SQL Server Spatial Writer: Failed to write a feature of type `VEJLE_GADELYS.Elledning' to the database. Provider error `(-2147217873) The INSERT statement conflicted with the FOREIGN KEY constraint ...Because FME fails to catch these errors, and thus not failing in the automation, we’re putting invalid datasets into production.This is bad.

I have two questions about hosting on the FME Flow Hosted ServiceThe first is, when the Cloud Flow is offline, is it possible to show another page or change the standard offline page? I am trying to save some costs to run the Cloud instance for only certain hours, and it would be nice to give users feedback, which informs them of the times the service is live.The second is,how can I use my own domain for the Flow Cloud Hosting? I would like to change it for pure simplicity and because it avoids confusion to users who don't know what fme is. Is there simple ways to change these two things, any help would appreciated, or links on how to achieve this. RegardsFred