Best Answers

FIXEDWe have encountered a strange problem on FME Server 2020.0.2: all of a sudden the Web Application Interface has stopped working.This happened right after I terminated a job that had run all weekend. In the logging of FME Server we can see all jobs are still run as usual, so it is just a problem with the Web Application Interface. This appears to be a Tomcat problem. The server runs Apache Tomcat 9.0.24. So we checked the latest catalina.<date>.log file. It contains the following error messages:06-Nov-2023 09:28:32.913 SEVERE [main] org.apache.catalina.core.StandardServer.await Failed to create server shutdown socket on address [localhost] and port [8005] (base port [8005] and offset [0])java.net.BindException: Address already in use: JVM_Bindat java.net.DualStackPlainSocketImpl.bind0(Native Method)at java.net.DualStackPlainSocketImpl.socketBind(DualStackPlainSocketImpl.java:106)at java.net.AbstractPlainSocketImpl.bind(AbstractPlainSocketImpl.java:387)at java.net.PlainSocketI

Got a situation where I would like the store attribute values, @Value(attribute_name), in some HTML code which itself is stored in a SQL table. The idea is that the @Value(attribute_name) will be different for each of our clients, sending them a personalised email based on their own data. Currently FME reads the table in and keeps everything as plain text, @Value(attribute_name) does not get replaced with the appropiate attribute value. Is there a way to get FME to recognise the attribute names in the HTML code and replace it with the appropiate attribute values? if I copy and paste the HTML code into atttributecreator then it works as expected, however we would like to manage all this in SQL server - saving us having to update the workbench everytime there is a change required to the HTML Thanks

Hi, I'm trying to create a connection with my enterprise ESRI account, but only have the option to enter a username and password, when I can only connect to this account via SSO. Any idea how to work around this? I have set up a web connection to my ESRI account but it doesn't automatically connect to the map service through this.

FME(R) 2023.1.1.1 (20231011 - Build 23636 - WIN64) Hello As stated in the subject line, the Feature Caching icons can be seen in the "Main" tab but not showing in the "Custom Transformer" Tab at all. However the features are cached. So I think they are just missing.   ThanksSameer

Is there a way of validating that the data contained in an attribute is valid based on a table of values?I know I can use a CSV list in a tester with 'in'. But my table of preset values is 4-500 entries long, and has the possibility of change, is there a way of comparing directly to this table, or using the table to populate the CSV value (maybe through a parameter?) automatically?

Hi,I'm trying to convert a DGN file wiht mixed geometries: most of them are read by FME; but not all. It seems like the geometrytype "smart solid/surfaces" isn't read by FME Desktop at all? Is it possible to read those geometrytypes? We really need them ;-)Added this message are pictures of the same file showed in MicroStation and in FME Desktop. Also added is the DGN file.

Hello everyone, I'm working on creating a Geopackage, and I've added a new table (feature type) to indicate the relationship between several other tables. How can I add features to this table without taking the original feature type or feature from the reader.

Now that LDAP/Active Directory reader have been put on the deprecation list in FME 2023, I'm trying to find an out of the box solution in FME to update my workbenches and continue using it.  

My input attributes have numeric or string values, with possible empty string values.I would like to replace empty string values with Null. When I use the option "Substitute Missing, Null and Empty by: Default Value", and set "Default Value: <null>", nothing happens. The values remain unchanged (with empty string values). I can get the desired result with the help of "Action:Set Value" and Value: Conditional Value -> If ATTRIBUTE IS EMPTY -> Value <null>". I know I can use the Null Attribute Mapper transformer, and the Set Conditional Value method above, but using the"Substitute Missing, Null and Empty by: Default Value" option seems the most elegant to me. Have I misunderstood the purpose of "Substitute Missing, Null and Empty by: Default Value" or am I using it the wrong way?

I have an Esri ArcGIS Binary Grid and a line shapefile. The shapefile was produced by the Surface Draper transformer, so it is 3D and has Z values at the verticies from the same Grid. The Z values that I would like to generate at a 10m interval can be output to a csv, instead of being applied to the shapefile: that is, I do not require verticies to be created in the shapefile at a 10m interval. Just need the interpolated Z values every `10m down the line. Thanks!

Hello - I would like to use the attribute creator in FME to generate a StartDate and EndDate. The EndDate should calculate the last date of the previous month and the StartDate should generate the first date of the previous month. There is no data to refence so I would like to identify todays data and then use the logic to get the Start and EndDate.  The idea would be to use these dates as parameters when calling an API. Does anyone have any suggestions on how I can implement this. many thanks 

Hello - I have several fields in hh:mm:ss format and I want to sum the total number of seconds from all parts all the field. For example:01: 10: 30 would total 4230 seconds  Does anyone know the best way to achieve this? I am brining the data in from an API and have used the JSONFragmenter to tabularise the data.  I assume the current data type for the fields is string as that's the default for FME?

To ensure our database's data integrity, which is periodically enriched with measurement data governed by users, we use FME to create data validation reports in Excel. With these reports, users can correct their data iteratively.  To make this work, we use SQL statements stored as attributes in a table. Depending on the report to be generated, SQL statements are fed into a SQLExecutor transformer as attributes. At the time of writing, we employ close to 500 validation queries, each with their own set of columns as well as amount of columns. The picture below shows how the queries are inserted into the SQLExecutor as an attribute.  This is then routed to a dynamic Excel writer by using the SchemaSetter custom transformer. The Excel report is generated as expected, except for the column order, which is sorted alphabetically instead of the order specified by the (dynamic) SQL queries. Is there a way to preserve the column order specified by the SQL queries instead of having them sorte

Reading las/laz from network drive suddenly throws error: LAS reader: Failed to open file for reading. Please ensure that the file exists and you have sufficient privileges to read it. Other filetypes works fine eg. JSON. Also, if I move the las/laz files and read the from my local machine it works fine.Any ideas why this happens? (My user have full priveliges on the folders and it's content also I have tried setting full access for anyone on the folders.) Thanks

I created a workspace that takes a zip file (nested zip), unzips it to a temporary folder (I used StartUp Python Script to do so). It then reads all the unzipped SHP files from the temporary folder (uses dynamic ESRI Shapefile Reader), reprojects all the files, filters them by feature type (to points, lines, polygons), checks for duplicate features and if the geometry is valid. Finally, it saves 3 output shapefiles:1. all point elements consolidate into one output shapefile2. all linear elements consolidate to one output shapefile 3. all polygon elements consolidate into one output shapefile  I would like the workspace to be independent of the input dataset (attributes). Because now when I run workspace with a second set of zipped shapefiles (with different attributes), I get shapefiles in the output with empty attributes that are in the first set of data. For example first dataset (which was used to create workspace) has ‘A’, ‘B’, ‘C’ attributes, second dataset has ‘D’, ‘E’, ‘F’, ‘G’

Experiencing, Schema features output from the SQLExecutor only after the Data features. This is causing issues for dynamic workspace. Currently managing this by connecting FeatureHolder to the Result (Data features) port of SQLExecutor, to hold the Data features and let the Schema features reach dynamic writer first. From the above screenshot it can be noticed that, Schema features are started coming out only after the Data features. To address this, required either of the below for SQLExecutor.Schema features output first before Data features all the time.Required "Output Schema Before Data Features" parameter,  similar to SchemaScanner. FME version: 2022.2.2

I want to pass a feature class name into a workspace and have the workspace tell me if the feature class exists in my SQL enterprise geodatabase. The purpose is if the Feature Class exists I want to backup the existing feature class, then truncate its data and append new data into it. If the Feature Class doesn't exist I want to create it. I've tried the Schema (any format) method with no luck (when you pick ESRI geodatabase SDE if requires you to select the table you want to check against manually and I want to pass in a parameter). I really thought there would just be an "Exists" transformer, but sadly I can't find one. Any suggestions would be greatly appreciated.

Hi everyone, I am looking for the right transformer to do a simple table manipulation here. So I have T1 (a table with multiple columns) and T2 (a table with a single column representing groups). I would like to duplicate T1 n number of times (n = number of groups in T2) where each row in T1 would be copied to be represented in each group to give T3 as a result.  Thanks in advance!

Hi community! I installed FME Flow 2023.1.1.1 on Ubuntu 22.04 with installer [1]. I choosesetup type "Distributed / Fault Tolerant" to use an existing Postgres instanceaccording to [2]. I then set up the Postgres database according to [3].I also changed proxyPort in /opt/fmeflow/Utilities/tomcat/conf/server.xmlto the correct port number. Then installed, enabled, and started the systemdunits according to [4]. Everything worked at this point and I could log in as admin and change thepassword as required. I could also log out and log in as admin. I thencreated a new admin user. When I logged out and try to log in as the new userthe landing page was stuck in an infinite refresh loop. I also deleted allcookies which did not have any effect on the constant reloading. The URL is https://view-db.vinci-energies.de/fmeserver/. I uninstalled FME Flow, dropped the fmeserver database, and installed FME Flowagain as before. Now the landing page doesn't even prompt for the admin loginan

I completed all lessons of Connect to Data, yet my status didn't change to Completed. Also, I attended the FME Accelerator live webinar, yet my status hasn't been updated either. What am I missing?

Hi, I am running FME from the command line. I was wondering, because I've never been able to work it out, is there a way to make it so that FME does not report anything to the console window so there isn't as much text? Or at least less text? For example I don't want to report all this progress text  The way I am calling FME is like this:fme WORKSPACE.fmw ^ --PARAM_1 ABC ^ --PARAM_2 123 Any help would be appreciated thanks

Hi, My workspace attached only takes information from the Website and shows values in the log. How Can I expose the response in attributes using Python caller? Thank´s

Since I upgraded to FME Form 2023.1 the transformer list options , such as "Upgradable Transformers" and "Incomplete Transformers" are missing in the Navigator, even when I have transformers in my workspace which are incomplete or can be upgraded. Is there a way to enable this option?  

Hi,I haven't quite been able to work this out. Is there a way to check if FME form is licensed from the command line? Before you try to open FME. I ask because I am making a batch file and I wish to check before it starts to let the user know if they need to update itAny help would be appreciatedRegards

I'm working with groups of features and I want minimize the number of blocking transformers in my workflow. Right now I'm using a Sorter to sort features in each group and a PythonCaller to make some attribute manipulation and comparison. Both transformers block the flow so  I wanted to get rid of the Sorter and do the feature sorting inside the PythonCaller but I don't see how to do it.Once I have the list of features, what should I do to sort them by one or any number of attributes? Thank you! import fmeimport fmeobjects class FeatureProcessor(object):     def __init__(self):        self.feature_list = []     def input(self, feature):        self.feature_list.append(feature)     def close(self):        pass     def process_group(self):        for feature in self.feature_list:             ## ...