General

We have been using FME 2021.2 ( build 21789) and recently upgraded our SQL database to 2019. We started seeing timeout errors when the FME writer tries to connect to the SQL Server and keeps saying 2023-10-16 15:04:58|  2.2| 0.0|INFORM|Microsoft SQL Server Non-Spatial Writer: Trying to connect using Microsoft OLE DB Driver for SQL Server...We use windows scheduled task manager to run our jobs and this is causing some of the jobs block other FME jobs. Any ideas on what may be the issue.  Thanks,AD

After the update to version 2025.0.2, the writer is very very slow.  Am i the only one who noticed it?

fme form 2025.0.3 ，can not open it

Just looking to see if anyone has had similar issues? I'm using FME 2023.1.1 and I've been having some strange issues with Log file paths. I has a workspace run on a separate machine with a workspace runner and the job filed to submit because it couldn't find the log path. The log path was pointing to the original location on my machine. I took a look at the fmw in a text viewer and saw the path defined in full.  I reopened the workspace, moved a transformer and re-saved it. This fixed reset the log path back to "$(FME_MF_DIR)<workspace_name.log". This has happened at least twice now and I'm not able to reproduce it. Just wondering if anyone has run into the same issue at all.

Today I'm breaking my rule of never manually (or automatically) editing a workspace file, in order to dynamically update a choice-type user parameter.Question of the WeekThis question was asked by @philippeb who needs to send a list of names to a survey choice field. Q) Our employees fill a weekly survey about their health and their kids going to summer camp activities.The survey [fields] change in time, depending on the kids that subscribed. The subscribed kids are exported into an Excel file every week.  I thought to read the file with FME and push the kids into the survey every week. That way the list of kids in the survey could change without our help. And the kid (or his parent) could select his name to fill the survey.The issue is that we don't know any survey platform able to change automatically from a script. Do you know if any kind of platform could change when FME pushes new values into it?A) I know of a platform that could be used to provide a weekly survey: FME Server! Aft

While looking through a folder of workspaces with a text editor, I noticed that one workspace fmw file was not in the usual XML-like format. It was instead a JSON file with a leading header line:# application/x-fme-json-workspaceThe last build/saved metadata states "FME(R) 2020.0.2.1 (20200511 - Build 20238 - WIN64)" - however when I create a new workspace with this version, it is saved in the XML format. I tried a variety of FME Desktop versions from 2019 to the most recent 2022, none save to JSON, but all are able to open the JSON fmw. This question is in part simply out of curiosity, and also because I have made a small Python script that iterates over a folder to gather some metadata that the WorkspaceReader does not publish (luckily the attributes I'm looking for are in the same "path" in both formats).

Hello everyone,This is the FME news for 12th January, 2022. FME2021.2.2 UpdateAlthough 2022 is very close, we still release updates to 2021. In this case version 2021.2.2 was updated yesterday:  Except... a number of keen-eyed users noticed that the installed FME was still flagged as 2021.2.1. So what happened? Well, that's on us. We uploaded build 21805 when we meant to upload 21806. Sorry. We'll upload 21806 shortly. If you did install 21805 then you're one build short. What's missing in the extra build? Well, let's look at what's new in general. So 2021.2.2 is minor fixes (not new functionality) and there were fixes for: SchemaScanner transformerGeoJSON Writer (when writing Mapbox Styler properties)Log4j updates (see this page for the latest info)Cesium format (on a Japanese Windows machine) also a fix for version numbersHTTPCaller (GUI fixes)Garmin (improve reaction to incorrect GPSBabel version) Only the last item was part of 21806, so if you can live witho

I have always tried to use the databaseupdater but have always had issues with it.Why if i have a unique column with GFID values and i want to match that it gives the error.Microsoft SQL Server Non-Spatial Writer: Failed to write a feature of type `dbo.COGO_23' to the database. Provider error `(-2147217900) The data types text and text are incompatible in the equal to operator.'. SQL Command `UPDATE [dbo].[COGO_23] SET [GFID]=?, BLAHBLAHBLAHWHERE [GFID]=?'this is a flat mssql table with no geometry. 

Curious if the new version of Form, 2023.2.1.0 will support ESRI's new Date (only) or Time (only) formats? They are not appearing for me when connecting AGOL, but they appear when I connect to a FILEGEODATABASE.

Hey FME Lizard!In the HTTPCaller the Multipart Upload window is only showing two rows. Would be great to see more lines!So difficult to see the line I want when I have twenty. I have to click the narrows too many times...Thanks :)

Hello ,Is it possible to control the position of Upper left x and Upper left  y in a PDF formatter by setting their values in an attribute beforehand, so that the PDF formatter reads and uses them directly?I don’t want to keep adjusting the x and y positions directly inside the PDF page formatter every time I find that the output is not properly aligned. Do you have any tricks or suggestions to help me arrange my PDF layout more quickly?It takes a long time to design the PDF layout . Thanks in advance .

If we run SQLExecutor in FME workspaces in FME server 2022.2.2, then we can't connect to the Snowflake datasource. We have this problem in multiple workspaces that run on FME server and for multiple Snowflake databases/schemas. It raises this error:2023-6-29 15:14:13 | Performing query against SNOWFLAKE_NONSPATIAL dataset `snowflake_datalake_acc'2023-6-29 15:14:13 | No SNOWFLAKE_NONSPATIAL dataset name was specified (couldn't find a value for `R_1_DATASET' or `SNOWFLAKE_NONSPATIAL_DATASET')It has strange behaviour. When we load the same workspace, same input database/schema/role, same output database/schema/role, and different data table it can connect for some data tables, but it does not connect for other data tables. Is there a way to solve this? We got this problem when we switched to a new role in FME server for authorization to databases/schemas/tables in Snowflake. We already checked the database connection configuration in FME server multiple times and it is correct since it wo

I am going to read Data from ProjectWise. FME could read Folder trees (as attached picture) but accessing to folders is not possible. (my user name and passsword are correct)(Also I have the Bentley CONNECTION Client installed and logged in.)The IT guys said that they useAPI version 2.8.Is there any solution to solve this issue?Thanks in advanced  

Auto attaching transformer to a link is a great feature. But while moving multiple transformers some of them they attach to links without such intension. If not noticed it create a lot of problems.

I'm struggling to figure out a way for an initiating Feature to trigger 2 separate WorkspaceRunners simultaneously. In this case, Workspace 1 and Workspace 2 are completely independent of each other, and it doesn't matter to them if the other Workspace Fails or Succeeds. However, Workspace 3 DOES need to conditionally only run if Workspace 1 and Workspace 2 both succeed, and Workspace 1 and 2 must only report "Success" if they run with no errors. I hopefully set it up this way below only half expecting success, although it ended up that this still only ran the WorkspaceRunners in Sequence and didn't work, since WorkspaceRunner #2 waited until WorkspaceRunner #1 completed before pulling in the Initiator Feature. Note: Workspace 1 and 2 are completely different FMWs and completely different Parameter lists. 

Hello,In some cases, JSONFormatter writes a decimal point number with the full precision of floating point numbers.Example:Source{ "number" : 1.954, "string" : "1.954" }Formatted by JSONFormetter (FME 2021.2.2){  "number" : 1.9540000000000002,  "string" : "1.954"} I think this document is desired in many cases.{  "number" : 1.954,  "string" : "1.954"} Is there any way to prevent adding the excess decimal places?

Can anyone please explain why with only 1 feature being read, more than 1 can fail? Any help would be highly appreciated!Many thanks!!

Hi FME'ers,Here are the answers and results to yesterday's quiz:Answers1) Which of these transformers has a Stiffness parameter?DisplacerHullAccumulatorSpikeRemoverRubberSheeterEggBeaterThe answer is the Displacer transformer. This transformer is useful for moving features apart that are too close to each other (usually for cartographic purposes). The stiffness parameter controls how much a feature can be deformed in moving it.  Give yourself 3 imaginary bonus points (ibp) if you knew the answer already, 2 ibp if you figured it out from what the transformers do, and 1 ibp if you typed stiffness into Quick Add and pressed tab (great tactic).You get no ibp if you went through each transformer to check!2) The FME Mobile App that connects to FME Server is called...FME Server ExpressFME Data ExpressFME Mobile ExpressFME Workbench ExpressFME Vande Bharat ExpressIt's the FME Data Express. It's intended to allow mobile access to Server, with some data collection capabilities to

The FeatureWriter has an option to set the Table Qualifier. This makes it possible to use one writer for multiple database schemas.Unfortunately the FeatureReader is missing something similar which leeds to a lot of spaghetti. It would be a nice improvement if you can set in the FeatureReader the Table Qualifier (based on an attribute value). 

Hello together, I'm a bit confused. I have a workbench where I merge attributes from 3 data sources. The result should being saved in an FFS file. But the workbench throws an error at the end which is completely meaningless to me. This is the end of the log file:Translation was SUCCESSFUL with 25 warning(s) (919246 feature(s) output)FME Session Duration: 35 minutes 27.1 seconds. (CPU: 1867.5s user, 275.9s system)END - ProcessID: 25060, peak process memory usage: 17993084 kB, current process memory usage: 307928 kBTranslation was SUCCESSFULError running translation.On the one way the translation seems to be successful, in the other way there is an error running the translation. One strange thing is that there are two instead one FFS file being created by the writer of the workbench: Output.ffs (with 39 FTS files) and Output_1.ffs (with 9 FTS files), although I defined just the Output.ffs in the writer. In spite of the error I tried to load the Output.ffs into the Data Inspector. I also 

When publishing any workspace to FME server, with files that need to be uploaded, i get the following error. Publish failed - FME Server encountered an error and reported the following message.The resource name must not contain any of the following characters: \\ / : * ? " < > | & = ' + % # non have my files have these characters Its happening with any new workbence, and it doesn't seem to matter what the reader is. even simple workbence, with a reader straight to a writer fails to upload.  Wondered if anybody has encountered this.Using FME Server/desktop 2020.2

I have a shapefile with a coordinate system defined which I'm using to test my workspace. I'm using the coordinate system extractor to check if there is a coordinate system. The _coordsys attribute comes up empty. But the shapefile does have a coordinate system. Why might this be happening?

For my client we run a lot of translations on their FME server that write to Snowflake. For like 99% of the time that runs without any failures. However, occasionally we are getting the following run time error: "COM.safe.fme.jdbc.TranslationFailureException: net.snowflake.client.jdbc.SnowflakeSQLException: JDBC driver internal error: {0}." Unfortunately this is a rather non-descript error (I wonder what {0} is). Also this error only occurred after our upgrade from FME Server 2020 to 2022.2. Rerunning the exact same translation the next day so far did not result into this error. So, does anyone have an idea how to prevent this from happening? Frank

Is it possible to create a unified editor for both text and arithmetic?It would simplify the process of assigning variables to text rules or mathematical calculations, visible in a function dropdown box.For example: A rule definition can begin with a codeword, like Calc(....), to be processed as arithmetic or recognized by AI?

Hi All,  50 2022-2-2 18:19:13 | The Esri Product license used by this machine does not include licenses for the 'Advanced' licensing level51 2022-2-2 18:19:13 | Unable to perform any licensing related tasks. Please check your Esri ArcGIS Compatibility setting. This 64-bit version of FME requires ArcGIS Desktop along with 64-bit Background Geoprocessing; ArcGIS Pro; or ArcGIS Enterprise. Refer to this this article http://fme.ly/qua for more details52 2022-2-2 18:19:13 | A fatal error has occurred. Check the logfile above for details We have FME Server 2021.2.2 running with ArcGIS Pro. We have logged into Pro with a ESRI named user 'gisadmin_acc', this has an advance level license assigned to it. Pro opens and runs fine on the server machine.  We installed FME Server using an admin account called sa-pandora-fmeWe also installed ArcGIS Pro with this same sa-pandora-fme account. The instructions we have been following are here - https://community.safe.com/s/article/Using-ArcGIS-Pro-with-FM