FME Form

FME 2022 Workbench is showing 'Error in Translation' after a successful Translation (See Screenshot). The Data Inspector window doesn't open after the translation. Is there a bug in FME 2022 causing this?What can I do to work around this issue?The log file is available on request.

Hi,  I am new to FME. I am having below error with one our jobs. I am not sure what is causing the issue because it is intermittent.Today it will throw an error the next day it is okay. *I have remove the structure of my table* 7239 Processing attribute 2 for LEAN or LEAN_AND_MEAN usage7240 Processed 2 elements with mode CLASSIC7241 Microsoft SQL Server Non-Spatial Writer: Query failed, possibly due to a malformed statement. Query Text `CREATE TABLE Projects.[Assets] Provider error `(-2147217900) CREATE TABLE permission denied in database 'TT'.'7242 Microsoft SQL Server Non-Spatial Writer: Failed to create the destination table for feature type `Projects.Assets'7243 A fatal error has occurred. Check the logfile above for details7244 ... Last line repeated 2 times ...7245 2022-12-09 05:03:02| 7.6| 0.0|ERROR |7246 A fatal error has occurred. Check the logf

I have two separate Route Feature Types and a bunch of Point and Line events. The Route features share a common alignment (on top of each other), but they have different measure values. For illustration purposes, think of them sort of like different units stored in the geometry measures, but without any sort of equation to be able to easily convert between the units. My plan was to overlay the Route sources to get a more granular set of lines with nodes wherever a node exists in either source, and with multiple measures named by the source it came from. Once I have that combined geometry, the event translation should be as simple as generating the dynamic segments based on the first route, dissolve the lines and read the second route measures from the feature, to get my translated event. In the example below, I rename the measures for each source before sending them in to the LineOnLineOverlayer but the output lines only have 1 of the 2 source measures. I also tried Intersector, but

Hi Community,I'm trying to convert MBTiles Raster format SQLite into ESRI File Geodatabase Raster. I have run the FME workbench from the above formats (default values) and it has created an output correctly, However the MBTiles contains much greater coverage that the resulting ESRI File. Am I missing some sort of parameter to ensure that all coverage is created rather than just a section of it? RegardsNZ

I've created a workbench in FME Database Edition 2022.1.3 that reads the existing metadata of a feature class in an ArcGIS Enterprise Geodatabase (SQL Server), and updates certain components of the metadata based on a table in another database where the feature class name matches the "Name" field in that table. This works for one feature class in the GDB at a time. Is there a way to iterate over all feature classes in the GDB and run the workbench against each one, one at a time? I've tried adding multiple feature classes as a Single merged feature type, and as individual feature types, and it is not updating the metadata as expected. It seems to update the metadata to the same values for all feature classes. thanks

I want to make sure objects resulting from the AreaOnAreaOverlayer are wider than 5 cm. For this I use a Tolerance value of 5 cm. In some situations however, it moves the border of objects more than that value (around 20 cm) where I would expect it would just create an object of 20 cm wide. I'm using FME 2021.1 build 21619. See the attached template for the data, the situation occurs near the red arrow:

I'd like to create a WB that is capable of QR code batch production to a PDF suitable for printing. The input would be a spreadsheet containing the QR codes (text) in a column. I have the QR Code Generator but not sure how to enable it to write multiple codes. Does anyone have experience with this or recommend a B build?

I have a workbench that reads features from a table from Microsoft SQL Server Non-Spatial and writes (Feature Operation: Update) into the same table. I have read and write permissions, reading is working fine but writing gets the following error message:Microsoft SQL Server Non-Spatial Writer: Connection failed. <connectionstring>. Provider error `(-2147467259) Named Pipes Provider: Could not open a connection to SQL Server [53]. ' Failed to open writer Failed to open writer f_22(CreationFactory): Failed to open writer I've tried several things, but none of them is working. I've read this https://knowledge.safe.com/articles/281/failed-to-connect-using-sql-server-2012-native-cli.html and this https://knowledge.safe.com/questions/39002/con

We have a unique number 0 and 00 to identify paying customer.I set (0 and 00) in the AttributeFilter but both values end up on either 0 or 00 depending on wich one in the list comes first.What am i missing here? or should i set up a tester instead for each number or text value? /Tim

Hello! I am using GeometryReplacer to convert a CSV file with a column containing WKT geometry. The column in question has the name "GEOMETRI, LINJE" and contains a linestring. When using GeometryReplacer, the result is a point with a point that seems to be the centre point of the coordinates of the linestring. As an example, the string LINESTRING (280696.375713613 6653063.17617913, 280698.536236071 6653059.93539544, 280707.427616957 6653067.91270913, 280704.353027305 6653070.5718137, 280696.12642256 6653063.17617913) converts to a point with coordinates 280701.671, 6653065.356, neither of which appears in the original linestring string. The coordinate system used is ETRS89.UTM-33N, which I set using a CoordinateSystemSetter before the GeometryReplacer. All of the LINESTRING () WKT-geometries become points. Does anyone have any insight as to why this happens and what I can do to make sure that GeometryReplacer produce

 IMX Writer: Detected in invalid table names 'RoofSurface'. This writer expects only specific table names. Please add a new IMX writer to see the valid table names I guess it has something to do with the original tables from my citygml. but how to tackle this issue? 

I would like to combine lines on the attributes in column A OR B OR C and so on. The "combine on attributes" is an AND condition. What would be the cleanest workaround to achieve this?

When I run the tool the "Band 0" values are staying the same after the reprojection transformer is run, any tips to get the new values for "Band 0"?

Hello,After migrating to FME 2022.2 (desktop and server), I get errors on each workspace that uses Oracle Spatial FeatureReader with a spatial filter:I tried these workspaces on FME 2022.0 and everything works fine...I don't really feel like reinstalling another version of FME Server, so any solutions/workarounds are welcome :)(Using spatial SQL queries instead of FeatureReader is not an option)

I have a workbench that uses the FileCopy writer to move and rename an uploaded excel sheet, this works well when testing through desktop but when run via FME Server (the file is uploaded into a parameter) the following Warning is thrown and the file doesn't get moved; 2022-12-8 13:48:54 | File Copy Writer: Ignoring the destination filename 'DummyFile.xlsx' because the source dataset '""C:\\ProgramData\\Safe Software\\FME Server\\resources\\system\\temp\\upload\\Data Updates\\Geo-CustomerServices-TradeEffluentImportToSQL.fmw\\dbryant\\DummyFile.xlsx""' was not a file. Destination file names are only used when the source dataset is a file Is this a known limitation of FileCopy? I could use a SystemCaller and/or Python to get the same result but equally feel that this should work.

I see how I can create a geometry using a creator where I can specify the geometry parameters. For example, creating an Clothoid by specifying Start X, Start Y, Direction etc. But these are all values that must be hand entered. How can pass these values into an "inline" Creator to set the geometries accordingly? I see 2DArcReplacer etc but not one for Clothoids. Is there a GeometryReplacer of sorts that would let you specify the type of geometry desired and which incoming attributes to assign to the relevant Geometry Parameters?

I need to convert a csv file into a shapefile in a .Net 6 windows application. I am looking for some assemblies or source code that does to use in the application. Does FSE provide such assemblies or have source code that can use the does this?

How to convert ArcGIS Online Quick Capture Latitude and Longitude coordinates to a projected X and Y coordinates?

Hi, This question is linked to a previous question I posted on the community, about the number accuracy of the Esri ASCII GRID writer of FME. Please see that question for more details and screenshot, but a quick recap of it; when I created a dummy raster with Real32 interpretation, in which an original pixel value would be '0.0250313',the rounded pixel value would become '0.025',but the Esri GRID File seems to convert to Real64 interpretation and stores the value as '0.02503128908574581',whereas I would like the rounded value '0.025' to be written to the file. I noticed that this could save up to 50% in the file size. I suppose that this item is related to the

In the Translation Log, it shows ArcMap 10.8.1, how do I change that to Pro 3.0.3, basically how do I move off ArcMap.

I'm trying to create a count that changes whenever it sees an empty row in a dataset. For example, I have the first 3 columns and would like to create a column similar to Test2 (see image below) that has a new count whenever there is an empty value in Test in the preceding row. Any ideas would be greatly appreciated!

I recently upgraded my FME Server (to 2020.2.4) and the unwanted file hierarchy for FileCopy output datasets in Data Download Zip files have returned! I now have an additional folder (called FILECOPY_1) in the output zip from a Data Download Service on Server. I've updated the Writers in Desktop (2020.2.4), but the edit functionality (Publish --> Edit Register Services --> More) seems to do nothing for the structure of the zip file for FileCopy outputs anymore after publishing (the old way is outlined here: https://community.safe.com/s/question/0D54Q000080hM9QSAU/how-can-i-change-the-folder-structure-returned-in-the-zip-file-from-fme-servers-data-download-service). I this a known bug, and is there a fix please? Many thanks!

simple question: Why does reading this netcdf fail with any (combination of)setting(s)? It works fine in Qgis https://www.ncei.noaa.gov/data/international-comprehensive-ocean-atmosphere/v3/archive/nrt/ICOADS_R3.0.0_1750-07.nc

I have put all of my parameters into the Private panel in the Parameters Manager, but they still display in FME Server 2021.1 unless I uncheck Published. What is the value of having to do both?

Here is the background. Esri uses subtype/domain objects in its GDB implementation instead of native RDBMS' relational tables with foreign key constraints. The result is often "nu-disciplined" databases from the RDBMS standpoint. I hope to create relational tables to protect data assets by extracting all the domains in our GDB.