Best Answers

I’m creating a workspace that reads 7-8 tables from a file geodatabase and then writes them into tables in a SQL database.  One of the tables is sometimes present and sometimes missing (that is expected).  I need to create a workflow where when the table is present we write the data into the SQL table and when it is not present we just truncate that same table in the SQL database.  I currently have a gdb reader connected to a tester that passes when fme_feature_type Like MSAG_To_RCL_Synchronization. This works when the table is there but when it’s missing the reader just closes and gives the message “The table name 'MSAG_To_RCL_Synchronization' could not be found in the Geodatabase as either a feature class or a table” and closes before any input gets to the tester. Any ideas on how to conditionally test if a table exist or not and then either write the data or truncate a SQL table. 

It seems I have no place to force FME to include the code_verifier parameter in the request body to obtain a token (see requirements below). Any ideas of how to work around this in FME? The postman equivalent is selecting the grant type as "Authorization Code (with PKCE)". I can use the same challenge and verifier more than once, just need to include it in the body rather than a querystring.  Per the platform's API docs: Parameters sent in Request Body, Form-URL Encoded. (cannot use JSON or querystring)code=<code received in callback url>client_id=<Application OAuth Client ID>client_secret=<Application OAuth Client Secret>grant_type=authorization_coderedirect_uri=<User redirect URL (from step 4)>code_verifier=<User Generated Code Verifier>  

I have the exact same issue as is described here: That topic is closed, so I'm starting a new one over here. I got the error “Check the geometry of such feature is valid and is not too small for the resolution”, while updating a feature. I use FME Form and Flow 2025.1.2 and ArcGIS Pro 3.3.1 with ArcGIS Enterprise 11.3.At first I also thought the issue only occurred in FME Flow, not in FME Form. But now I'm checking the issue again and it is also in Form.In my case I use the ChangeDetector to check if the feature exists and if so if it is changed. If it existed and is changed, I'm also using the Update Mode in a FeatureWriter. I tested with not updating the spatial column, but that didn't make any difference. I still got the error. And I am positive the geometry didn't even change: setting the ChangeDetector to only check geometry sends the feature to the Unchanged port.I don't really understand the solution in the other topic, but it seems I have to delete some data. But that sort of d

​Hi everybody, I have a similar issue to the one the creator of this thread has: The difference is that I'm dealing with donuts. The workaround from Takashi (buffer issue location → dissolve → aggregate) doesn’t work with donuts. The reason why this doesn't work is explained here: The GeometryValidator reports self-intersections in the wrong place for donuts. If I buffer the issue location, part of the donut that doesn’t need to be buffered gets buffered, and the actual issue location remains a problem. I also tried the GeometryValidator repair function, but this didn’t work either. Attached is an example workflow which uses some public data that I use in the real workflow. You can download this data here (to big to attach): https://daten.gdz.bkg.bund.de/produkte/vg/vg250_ebenen_0101/aktuell/vg250_01-01.utm32s.shape.ebenen.zipThe workflow shows one example of the problem and my current workaround. Unfortunately, I can’t share the real workflow. In the real workflow, however, many geome

I believe there’s an issue with the tolerance values greater than 0.5 not being respected when using the NumericRasterizer transformer.With tolerances like 0 and 0.5, I can see a difference in output. However, a tolerance value of 1.0 has no change in the output. Output from NumericRasterizer with tolerance set to 0.0, with the input vector overlayed  Output from NumericRasterizer with tolerance set to 0.5, with the input vector overlayed  Output from NumericRasterizer with tolerance set to 1.0, with the input vector overlayed   Going by the documentation, it explicitly states that a tolerance of 1.0 will draw all pixels touched by the input vector line, which can been seen above as not being seen in the output. Work flow and NumericRasterizer parameters  Documentation of the tolerance parameter from the corresponding version of FME Flow   I have test values such as 0.7 0.8, 0.9, and 0.999 with no luck. Does anyone know if this is intentional or a bu

I know I’m using an older version but upgrading is not an option. I was using a background map that is no longer supported so trying other ones. I have a Bing API key but get this error when attempting to display the background:“(1):Python Exception <IndexError>: list index out of rangeAn error has occurred. Check the logfile above for details(2):Python Exception <IndexError>: list index out of rangeAn error has occurred. Check the logfile above for details”And I can’t find anything in the log file about it. This error message is listed as a known error for later versions of FME Desktop and Flow, but not for 2022.Can anyone offer any advice or assistance in getting a simple background map to work? 

HelloWe have just updated FME Flow to 2025.2.4. As we also need the qfieldcloud-sdk module, I installed it with pip-install "C:\Program Files\FMEFlow\Server\fme\fmepython313\python.exe" -m pip install qfieldcloud-sdkSomehow this installation got mixed up and the module was installed in python 3.12"C:\Program Files\FMEFlow\Server\fme\fmepython313\python.exe" -m pip show qfieldcloud-sdkName: qfieldcloud-sdkVersion: 0.13.0Summary: The official QFieldCloud SDK and CLI.Home-page: https://github.com/opengisch/qfieldcloud-sdk-pythonAuthor:Author-email: Ivan Ivanov <ivan@opengis.ch>License:Location: C:\Program Files\FMEFlow\Server\fme\fmepython312\Lib\site-packagesRequires: certifi, charset-normalizer, click, idna, pathvalidate, requests, requests-toolbelt, tqdm, urllib3Required-by:(» Location: C:\Program Files\FMEFlow\Server\fme\fmepython312\Lib\site-packages)Previously, we used FME Flow 2024.1.2.1, which used python 3.12, FME Flow now uses python 3.13 and as the module is installed in

I need to use a Oauth2 token as password to connect to a PostgreSQL database. The problem is that when I try to paste a stringline over 245 characters the connection fails. When reopening the connection parameters the password is red and says ‘Value not allowed’. On another laptop (FME 2022.2) it all works fine. Any idea what causes this problem?

This seems like is should be so simple, but I can’t get it to work! I want to take a CSV file that has Feature Class Names, FieldPrefixs, and Feature types. For example:FeatureClass, Prefix, FeatureTypeRoads, Road, LineWildLandUrbanInterface, WUI, Polygon. This CSV file will be dynamic, meaning that the Feature Classes that will be summarized will change.I then have a SummaryPolygon Feature Class which defines the polygons on which to summarize. I want to iterate through the CSV file, summarize the data for each CSV record, and then add two fields with the prefixs (ie Road_Miles, Road_MilesPerAcre or WUI_Acres and WUI_PercentArea) to the SummaryPolygon. I thought the workspace runner would work well for this, but the Child workspace isn’t updating/showing the new fields that were created after each iteration. Meaning the schema isn’t dynamically updating with the two new fields on the next iteration. In my Reader, I have Workflow Options set to Single Merged Feature and Merge Feature T

I want to embed a DB connection in my workspace without the password being saved in the workspace.A password should not be saved in an FME workspace file. But I want the connection details to be saved in the workspace file.What I've tried:- If I leave the password blank, the workspace does not run because the connection requires a password. I could save the workspace with a blank password. But if I want to run the workspace, I need to edit the Reader/Writer or Transformer properties and enter a password. FME detects this as unsaved changes in my workspace and it could easily happen that the workspace gets saved with the password by accident. This is a stupid solution.- I could create a user paramter for the password field. When I run the workspace, I have to make sure that the "Save As Parameter Default Values" option in the parameters dialogue is disabled. To ensure that, I could add a custom message to the parameters dialogue telling the user to be careful and not to save the paramet

Hello, I’m trying to convert decimal coordinates into a DMS format with hemisphere indication. Example : 1.4861803 ; 43.5713123 Target format : 1°29’10.2491” E ; 43°34’16.7243” NIn my workflow, i used DMSCalculator transformer to split the coordinates into degrees, minutes and seconds. This part works correctly.However, I am now stuck when trying to reconstruct the final formatted string. Does anyone know the best approach to rebuild this format ?Thanks advanced,

I am working on a project creating building footprints from a lidar point cloud. However, the original lidar point cloud being used has some portions of buildings classified with “unassigned” values which has created incomplete building footprints. Are there any suggestions how I could identify these “unassigned” building values to fix the building footprint?

I’m having an issue where the FME Workbench application is not loading correctly. I have added an image below, the bottom of the application is all white and just above that is a portion that hasn’t rendered correctly. I cannot get it to load things from the history, even though it acts like it has loaded. It feels like a rendering issue.Anyone else ever have this issue. Do I just need to reinstall it?

As I understand things, currently one can only use the Esri enterprise geodatabase formats on a Windows host. When moving to kubernetes it is then needed to use queue control to direct those jobs to Windows VMs, which is not ideal.When can we expect those drivers to also work on Linux? And is the problem on the Esri side or the Safe Software side?

I need to update environmental data in our system. The input data comes from an ESRI Shapefile, and I am using FME 2021.2. The output is stored in Oracle Spatial.However, the system that reads the data from Oracle only accepts simple polygons. When I try to insert multipolygons, part of the geometry is ignored by that system.Is there a way in FME to convert multipolygons into single polygons while maintaining a 1:1 relationship between input and output features?If I use the Deaggregator, the number of records grows exponentially, which is not viable for our database.I also started working with FME recently, so I may be missing a simpler or recommended approach.What would be the recommended way in FME to transform multipolygons into valid simple polygons without increasing the number of features?

My long time transformer friend FMEFlowLogFileRetriever is not avaliable in FME 2025. The error asked me to use HTTPCaller to retrieve the job log file. So I used this rest point in the HTTPCaller’s Request URL with GET - https://my-fme-flow-hostname/fmerest/v3/transformations/jobs/@Value(jobid)/log. I tried the Basic and Web Connection authentications, but both gives the error “HTTPCaller (HTTPFactory): An error occurred while accessing the URL 'https://my-fme-flow-hostname/fmerest/v3/transformations/jobs/98/log'”. I have no problem publishing using the same Web Connection for the authentication, so don’t understand what the issue is. The jobid = 98 was run successfully on the FME Flow.

I have JSON response from an API that looks a bit like this (tidied up for the purpose of showing here):{ "member": [ { "id": "OBF-123", "fieldspec": [ { "assetattrid": "FIELD01", "assetattribute": [ { "datatype": "NUMERIC", "description": "Length" } ], "numvalue": 13.4 }, { "assetattrid": "FIELD02", "assetattribute": [ { "datatype": "ALN", "description": "Fruit type" } ], "alnvalue": "Banana" }, { "assetattrid": "FIELD03", "assetattribute": [ { "datatype": "ALN", "description": "Class" } ], "alnvalue": "N" } ] }, { "id": "OBF-124", "fieldspec": [ { "assetattrid": "FIELD02", "assetattribute": [ { "datatype": "ALN", "description": "Fruit type" } ], "alnvalue": "Apple" }, { "assetattrid": "FIELD01", "assetattribute": [ { "datatype": "NUMERIC", "description": "Length" }

Hi Community,I tried to use a DB Connection as Deployment Parameter and set it as Default value in the User Parameters in Workbench as shown in Screenshot below. However when I publish this workspace to Flow the User Parameter with DB Connection is empty and I need to select again the DB Connection manually (2nd Screenshot).Is this an expected behaviour? In my logic the User Parameter should be set automatically (works like this e.g. for Text Deployment Parameters as User Parameter). A workaround I found was to delete the User Parameter before deployment then the Job in Flow uses directly the correct DB Connection.Thanks for your response in advance - BR Kai. Deployment / User Parameter Settings in WorkbenchUser Parameter Settings in Flow 

Hello!After an update from FME-flow 2024 to 2025 and after the update some roles are not able to open the repositories under workspaces. They get the message ‘Unauthorized request by user <user> due to lack of proper permissions or the object does not exist’. I'm a superuser and able to open the repositories. Is there a new option under User Management I'm not aware of? Or does someone know a solution?

We recently upgraded our FME Flow from version 2019 to FME 2025.2.1. Although we encountered several issues during the upgrade, the system is now running. However, we are facing a new error when executing an existing workbench. The workbench reads data from an Oracle table and generates GML and GeoJSON files. The files are generated successfully, but at the end of the process, the following error appears: 190 2026-1-20 14:33:00 | Router and Unexpected Input Remover (RoutingFactory): No geometry mapping entry found for 'fme_line' in metafile 'E:\Server\fme\metafile\ORACLE_SPATIAL.fmf'. Please visit http://www.safe.com/support Has anyone encountered this issue before? Any guidance would be appreciated.  

hi All, i am currently using FME2015, May i check if we are able to use openJDK to replace JRE so that we do not need to use Java Oracle license? Thank you.

Hi there,Just finished a fresh install of FME Flow 2025.2.1.I was configuring the backups and noticed that the output files were not getting a timestamp.Looking at the httpcallers they both submit using the non-timestamped attribute:If Append Date is No:If Append Date is yes:What it should be: Thanks,Marc

I’m reading Survey123 results into FME where one question allows multiple selections. The answers come through as a comma-delimited string (e.g. Need_PD,Need_TMA,Frozen).I want to validate the responses against a known list of allowed values (CSV/XLSX), so that: each selected value is validated individually any invalid or new value (even if it hasn’t appeared yet) is flagged I don’t need to handle every possible combination of selections I understand that Tester “Cached Values” only shows existing data values and that Survey123/ArcGIS domains aren’t directly usable here.What is the recommended transformer pattern to: split the multi-select field so I can edit testers for looking for certain selected options and not others

Hi all,I am struggling to get the following to work. In my IT environment we use APP-v to deploy FME workbench. Now I want to automate the license within the package. So I installed FME workbench but is automatically opens the licensing manager, which is nice but I want to specify the license myself. What file can I make that I can implement in the application so it instantly recognizes its license. I tried the admin guide but did not work. We have floating licenses.So what file can I make to specify the license within the application, so that users don't have to enter it themselves. 

I have a list of points which I want to connect to lines. But one line should contain only points with a specific value in a field. At the end I want to have multiple lines in one feature class. How can I do that?