FME Form

I just updated to version 25.2 and my oracle reader is failing and throwing this warning (not an error):An error occurred while fetching from query `SELECT a.*** FROM *** a' : OCI_SUCCESS_WITH_INFO: ORA-24347: Warning of a NULL column in an aggregate functionWhich causes Translation FAILED with 0 error(s) and 1 warning(s) (0 feature(s) output).My colleague tried the same on version 25.1 and whilst he also gets the warning his translation does not stop and he gets all features to work with. (As did I before my update)Ignoring the fact that the view should be fixed, is there a way to continue the translation with all features? Troubleshoot option Ignoring failed readers simply skips the reader and thus returning zero features.Furthermore I did see a few changes regarding oracle in the changelogs but I could not pinpoint which one is referring to this problem.

Is it possible to switch the Versioning in an Enterprise Geodatabase (on SQL Server) from "traditional" to "Branch Versioning" without touching FME Workspaces containing Esri Geodatase Readers and Writers (GEODATABASE_SDE)? In a first attempt in the test environment, everything seems to be running like before, after we switched to Branch Versioning of our feature classes.  A quick look in the geodatabase tables seems to prove that the internal fields like GDB_ARCHIVE_OID, GDB_FROM_DATE, ... are filled correctly.  Can it really be that simple? Does FME support the switch to Branch Versioning while keeping the Workspaces untouched? Of course, this would be a dream, but this seems too good to be true.     

I am taking a polygon that is the floor of a building, I am then clipping out the exterior wall and the room polygons on it to get the square footage of the space between the walls. However, it is filling in polygons at random when writing to our SDE. When I write these polygons to a .gdb, that behavior doesn’t happen. I have tried to not simplify the geometry, used the donut extractor to only take the outershells, orientor to only choose right facing polygons, etc. Anything else I should try?Preview of the polygon in FME:Polygon in GDB:Polygon in SDE: 

This...may be complicated to explain. We are trying to create Feature Service webhooks in ArcGIS Enterprise. ESRI documentation indicates that this can either be accomplished with the admin Portal (which very few users have access to) or via the “administrative API”https://developers.arcgis.com/rest/enterprise-administration/server/create-webhook/The only way to access the administrative API is to acquire a session token (SSO, username/password, other authentication types are not accepted).In ArcGIS Enterprise, the generateToken endpoint is no longer used, the OAUTH2 “Token” endpoint has superseded it. There is a preliminary authorization step that must be completed before accessing the “Token” endpoint.https://developers.arcgis.com/rest/users-groups-and-items/authorize/https://developers.arcgis.com/rest/users-groups-and-items/token/Authentication in our environment is done via OAUTH2/SAML so when trying to access the “Authorize” endpoint via an HTTPCALLER, the response that I’m gettin

Hi!I have a workspace containing four Writers that write tables to a geodatabase. One of the writers is not working as expected. When i press “Run workspace” some of the attributes get null on almost all of the rows. It seems to filtered on one of the attributes (an attrribute called Name) since it is the same names that ends up null. The transformer in the step just before the writer looks as it should, so something goes wrong in the writer, not somewhere in the workspace. The strange thing is that when i press “Run to this” on the problematic writer, everything works as expected and there is no null values anymore. I don’t get any error messages. Using FME Workbench 2025.2Hope someone has any idea of what could be wrong, or if it is a bug?  

I have a workbench which takes a dem raster and clips it at various points, it converts the raster clips to the point cloud and extracts the highest value for each segment.  i then want to be able to use the highest point with the radiate line generator to show additional lines before being clipped and calculated.  I have tried a 2dforcer, aggregator and others to get the Radiate Line Generator to work, but it fails every time.. any idea how to get points from the workflow, and what have i missed..??If i try the Radiate Line Generator with a ‘normal’ point dataset then everything works fine and as expected..  

Hi,Into an Esri ArcGIS Portal Feature Service Writer sending data to ArcGIS Portal what is the difference between Publishing and Spatial.There is nothing about Spatial in the documentation.Thanks.

The failed feature type issueWe are reading in many featureclasses using GEODATABASE_SDE reader in workspace and recently noticed an issue in FME Form (24.1) where it only throws a warning“A table name ‘HeritageSites_Exclusion’ could not be found in the geodatabase as either a featureclass or table. This may be due because the current user does not have permissions to see HeritageSites_Exclusion”The rejected feature handling is set to TerminateThe workspace runs in success, although this missing table was joined upon and is necessary for the right outcome. I guess I’m posting here to see if others have/had this issue, where only a warning of a missing featuretype is given… we believe it should be an Error WorkaroundObviously, we can place NoFeatureTesters and connect a Terminator to the NoInput port. This is alot of work, so we looked into parameters of the GEODATABASE_SDE reader moreUnsure how the Reader parameter “Ignore Failed Readers” truly works. It seems designed very early on to

The Clipper can subset a raster by geospatial extents, while the RasterSubsetter can both subset and pad a raster by number of pixels, but is there a simple way to pad a raster to a given polygon/geospatial extent?My two ideas are to eitherUse the RasterSubsetter to pad the raster by a large amount of pixels and then the Clipper to bring it back to size.OrRasterize the polygon to the same resolution as the image with a background/NoData value and mosaic the two together.Neither seem particularly efficient. 

Is anybody familiar with setting up readers from SmartSheet in FME so that you can potentially make/send updates to the SmartSheet directly from FME?

Good morning yall, Im banging my head trying to find the issue as to why I cannot read this.I have TemppathnameCreator before my google drive connector. google drive is saving a folder to that temp locationfeature reader is supposed to grab that drive folder and read a csv out of it.Ill paste some screenshots below. Hopefully is some setting in the feature reader. Much help is appreciated!

Trying to understand how the AreaGapAndOverlapCleaner works. Set to Fill All Gaps No and Repair Method Priority (Edge Preserving) with a tolerance of 1mSo why does it change the boundary of this polygon where it neither overlaps or is a gap (it’s the edge of coverage) 

Hi there!I get tons of these messages from some workspaces created with FME 2020 (in Norway) and now  migrated to FME 2024: The Startup Python Script changed the current FME process locale from 'Norwegian Bokmål_Norway.utf8' to 'C' and FME has restored it back to 'Norwegian Bokmål_Norway.utf8'. It is undefined behavior to change locale and doing so may cause unexpected errors. For more information, visit http://fme.ly/PythonLocaleErrorI have read the post http://fme.ly/PythonLocaleError carefully, but it does not give me anything. I have nothing such as import arcpy or locale.setlocale() in my Python-code. The example message above is particulary strange, I don’t even have a Python Startup Script. So something is absolutely confusing here.No Startup ScriptAnother example:PythonFactory script changed the current FME process locale from 'Norwegian Bokmål_Norway.utf8' to 'C' and FME has restored it back to 'Norwegian Bokmål_Norway.utf8'. It is undefined behavior to change locale and doing

Hello,I am creating PDF files using FME and am experiencing a serious performance issue (the process is very slow).I have a PDF template that I read and merge with my data so that each ID gets its own template. I use specific X,Y coordinates to write text at the correct positions in the PDF, and then I use the ID in the PDF writer to generate one PDF document per ID that includes both the data and the template.The output is correct and matches my expectations; however, exporting all records with the template takes a very long time.I was thinking to use  the PDF Page Transformer, but rebuilding the pages also takes a significant amount of time.Is there any way to improve performance and make my current solution faster without completely rebuilding the workflow? thanks in advance FME 2021

I’m having trouble finding examples for JSONTemplater when working with a JSON array input attribute.The incoming data looks like this:{"layers": [ { "defaultVisibility": true, "geometryType": "esriGeometryPolygon", "id": 1, "maxScale": 0, "minScale": 0, "name": "Parcels", "parentLayerId": -1, "subLayerIds": null, "type": "Feature Layer" } ]}I’m interested in extracting the first array member id value into an object like this:{"layers": [{"id": 1}]}I can almost get the data into what I want in two steps, first extracting the value with a query json["layers"][0]["id"] and then using the JSONTemplater to use the id value, but bizarrely the value 1 is cast to string “1” byt the templater, which is invalid for downstream work.Anyone know how to make what I want in one step with JSONTemplater?  Thanks.

I have rasters with one alpha channel and one grey channel. I need to ensure that the grey band is grey8. How do I coerce only the grey band and leave the alpha band untouched?The RasterInterpretationCoercer will change both bands and I have not found any other transformer that fits my requirements.  

I’m trying to run some workspace through Task scheduler with FME Form. I’m using an Emailer package and when I run the task as my user, everything is fine. But When I run it as local system it always fails as it can’t find the package. I tried defining Shared folder and setting up environment variables, but couldn’t make it work.As for setting up shared connections it works fine, but not with packages.What would be the right setup for this?

Can FME create a pg database tables with attribute names that have upper cases? I know that this is possible in postgres - column names are case-sensitive when double-quoted. But no matter which parameters of PostgreSQL writer I select (standard/dynamic writing, with checked or unchecked option to Lowe Case Attribute Names in Table Creation Parameter), FME keeps replacing double-quotes with underscores and output is always folded to lowercase.  Is it something that can be bypassed? 

Before I file a bug report, I thought I would post here.  I used to be able to right-click in the Data Preview and get the ‘Zoom to Selected Feature’ for the CAD geometry.  The last few versions of FME have not had that available.  What gives?Please see the attached.Currently using the latest build:  FME(R) 2025.2.2.0 (20260106 - Build 25827 - WIN64)

I’m trying to convert those attribute values whichever has comma into an array.Attribute A has values - "ABC" and "ABC","DEF" and "ABC","DEF","GHI".Desired output -“ABC”["ABC", "DEF"]["ABC", "DEF",”GHI”]Any inputs are appreciated. Thanks very much!Tagging ​@danilo_fme , ​@david_r 

I am trying to create a single ArcGIS Enterprise Feature Service that contains multiple layers using the Feature Writer transformer using the ‘Esri ArcGIS Feature Service’If I run it for a single layer, it works fine but as soon as I try for multiple layers, it fails with an error message.“No layers/tables are found matching the name ...” Are there settings that need to be enabled to allow it to write multiple layers or does it only work for a single layer? 

Hi I’m clipping point clouds with a polygon (1km x 1km), the inside result goes through a rasterdemgenerator with a cell spacing of 0.5m and I write it away as a geotif. When I compare the result with the polygon I see that the geotif is 0.25m bigger than the polygon. I know it has something to do with how a pixel is considered. As a polygon or as point in the center or something, but it doesn’t make any sense to me as you can divide 1km perfectly by 0.5m… It should be 2000 pixels by 2000 pixels right? How do I solve this? I tried playing with the clipper settings. Like changing “determine cell location by” to bounds and some other things. I got a result that’s 0.25cm smaller, but never an exact fit. 

FME 2025.1.3.0 Build 25643I downloaded the new ArcGIS Feature Service Package and set up a connection using the Esri ArcGIS Online OAuth Web service. When I attempt to insert a new feature into an existing AGOL feature service using the default values of the Esri ArcGIS Feature Service format, I get a warningWARN  |ArcGISFeatureServiceWriter: The field 'GlobalID' has a NotNull constraint, but it is NULL, missing, or empty. Skipping feature...The feature is not committed but the FeatureWriter or Writer (I tested both) shows success and the number of features written as 1. Without reading through the warnings, I wouldn’t know there was a problem.Since I’m inserting a feature I don’t have a globalid! And the field is noneditable in the feature service, so it seems like an odd error.Messing around with the settings I found that if I made sure the GlobalID field was exposed in the User Attributes and in the Advanced Parameters “Use GlobalID” was set to Yes, then the feature would insert. Bu

Ya, tokopedia memiliki WhatsApp resmi yang bisa langsung di hubungi di Nomor +62859^3460^8879.

Hi all,I am fairly new to FME. What I wanted to implement I was able to figure out with the community here or the trainings at the Safe academy. But now I struggle as I do not understand, where my mistake is.Goal: I need to write features with a dynamic schema. So, I added via Readers a “Reader as Resource”. It is an Excel file from where I want to use a specific sheet. There a added my columns which shall be written to my target source. Writing a FFS file works as expected by using the following configuration.One important note: a sheet in excel has a limitation for the name. As I need to create a dynamic workbench which can read different source files and handle a different amount of dynamic columns per source file, I want to name it like the feature type - but shortened to what Excel can handle.Dynamic Schema Definition configured and working As I need also to write the same data to an EGDB, I use the JDBC format - with the same configuration:  This does not work as expected. I have