FME Form

Does the SchemaScanner add an extra character to the fme_varchar(n) attribute?

Greetings,I have a weird issue where the ESRI FGDB writer runs with NO error messages.It writes out to an ESRI Shapefile, but the FGDB has 0 records???This is the FME output Total Features Read                                                      68587=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-                           Features Written Summary=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-Hazards_3857_20230613_Geom                           11021Hazards_3857_20230613_NoGeom                         11021Hazards_3857_Geom                                    11021============================================================================Total Features Written                                                   33063   The output in the FGDB? Any assistance is appreciated, it is really frustrating. 

Hi,I have a floating license for FME. I want to know how this FME license validation works ?Is it like license is checked everytime when I run a script through command line / FME Workbench OR it checked only once when we open the FME workbench ?

I am getting an error when run a workbench on FME Flow. The workbench supposed to extract shapefile from S3 bucket and write it to the database.The shapefile has very complicated and big area in it. Not sure if it matters. The total size is 300Mb. Log file has just this error: Job doesn't fail, it looks like it is stuck. It lasts for hours, more than 12 hours. I had to cancel it.  I thought that the problem is explicit with shp.xml file. But I checked previous uploads and there were successful ones. Even with this file.  Please advice.

Hello. We have floating licenses in our office so they keep rotating time by time.I have created a batch file for running a workbench with multiple workspace runners in it. Now, when I run the batch file and if by chance, no licenses are available that time, what will happen? Will my workspace go in an infinite loop till a specific timeout or will it try to trigger for acquiring the license every 1 minute or so and then start running the workbench?This actually matters more because there is an AWS machine which turns on on a scheduled time and triggers the batch file on startup. The workbench starts running by itself. Any suggestions/ideas on this? If this is not possible, any alternatives other than FME server since it is the last approach that we will go for as of now. Thanks,Shivam

The FME exported obj model has no name attribute, it is all defaultobject, how to set it, I need to use cesium to design a simple query system to associate attributes through nodename

Hi, I am reading a bunch of asci files and use a raster mosaicker and trying to write to a raster or mosaic dataset.I have trued seting creating new attributes geodb_raster_path set to fme_dataset and geodb_raster_type to 'Raster'. or 'Raster Catalog'I am getting error message: The raster type 'Raster Catalog' for mosaic dataset 'zzDataset' is not supported by the installed ArcGIS version 

Currently trying to UPDATE isolated features within an existing Versioned sde table (ArcPro Only) using the Esri Geodatabase (ArcSDE Geodb) writer. Considerations: Schema has been Imported from DatasetTransaction Type has been set to: Versioned Edit SessionSuccessfully written to a TEST.gdbTable has been READ into workbench, joins and ETLs applied to data, then attempting to WRITE to same table back in SDEHave toggled Ignore Relationship Info to no availError Code:Error while updating feature in the table/feature class 'Addressing'. The error number from ArcObjects is: '-2147207389'. The error message from ArcObjects is: {}

Hello. I would like to ask. I have a workspace where, see the attachment, I have set a time filter (red frames). I would like to store various dates in this format in the database, for example the date for each specific month. Each cycle, a new date from the database would be automatically replaced by this filter based on the number of validly executed workspaces. Can this be solved somehow? I would probably solve the individual cycles with some kind of "counter" transformer, it will be more complicated to insert the date. Go in the direction of some parameterization? How do I ensure that the correct date is always set on the test filter? Thank you very much

I am doing the completion date subtracted by number amount(200 days) using Subtract Interval or Interval between dates using the completion date - DateTimeNow. the FME rejection code is INVALID_INPUT. Any suggestions is greatly appreciated

Can we migrate the data directly to Esri UN model geodatabase instead of migrating to Asset Package GDB, using FME Desktop?

Hello, I have a dataset that looks similar to the image shown and I need to create the value in the attribute ROUTE shown in red. I need to create a new value for ROUTE whenever Duration>1 or Duration is Null. The data needs to be sorted firstly by Name, then by TimeStamp.Then, whenever the previously mentioned condition of (Duration>1 or Duration is Null) is met, a new value needs to be created for ROUTE. How do I create a new value (with for example a new sequential number) whenever I come across (Duration>1 or Duration is Null) in my sorted data?

Just a minute ago I did discover something I did not know yet: it is possible - to my surprise - that it is possible to retrieve a password stored in a User Parameter using a simple ParameterFetcher!Passwords stored in User Parameters are encrypted (see e.g. this post), but the ParameterFetcher just returns the decrypted password in plain text... :-(So everybody with access to a workspace with passwords and FME Workbench can just use this fetcher to retrieve all passwords.OK - maybe I have been a little naive... :-) But this is surely something to take into consideration.

I have a logfile I need to extract some info from but I'm not sure what to use. Here's an example of what I have.<Msg time="2023-06-05T19:55:23,511" type="INFO" code="9029" source="Rest" process="35236" thread="1" methodName="" 

Hi, just wondering if anyone can interpret this log message for me and tell me how to change the workspace encoding under Windows, if that will help. Thx! (am including all the software version details for reference) Starting translation...Current FME version: FME 2022.1.1.0 (20220728 - Build 22623 - WIN64)FME_HOME is 'C:\\Program Files\\FME\\'FME Desktop Smallworld Edition (floating)Permanent License.Machine host name is: FBC-19-0068lOS Locale Name   : en_USOS Locale Encoding : windows-1252Process Encoding  : UTF-8FME API version: '4.0 20220615'FME Configuration: FME_BASE is 'no'FME Configuration: FME_MF_DIR is 'I:\\GISSBX\\ELECTRIC\\FBC_010_CA_Dashboard\\MXD/'FME Configuration: FME_MF_NAME is 'Condition Assessment Dx.fmw'FME Configuration: FME_PRODUCT_NAME is 'FME(R) 2022.1.1.0'Operating System: Microsoft Windows 10 64-bit (Build 19044)...The workspace was authored with a system encoding of 'windows-1252'. This will be the encod

I have SQL SERVER DATA where ii need to migrate views only to Snowflake is there any way to create the views in FME and migarte data SQL Views to snwflake

I have a polygon (shp or minfo format) assuming it has an area of 5 square miles. Need to reduce the area by 70% resulting to 3.5 square miles now but still keeping somewhat the outline but of a smaller size (like polygon output shrinks) due to the applied percentage. SCALER transformer is closed to what I need but it only applies the percentage to the total perimeter of the polygon and not the area. Any transformer that could do this?

Hi,I need to calculate the least-cost path from a destination point to a source. In ArcGIS I use COST PATH based on the least-cost distance raster (by Cost Distance tool in ArcGIS).is there a way to do something similar in FME? is the Network cost calculator transformer appropiate?Best regards,Felipe Verdú

Hi, FME communityI hope everyone is doing great, I am creating 3d tileset for cesium js and it is getting created successfully, but when I am using 3d tile validator tool(cesium team has implemented a validator tool here https://github.com/CesiumGS/3d-tiles-validator) then I am getting my tileset is invalid because of some errors, I do not know how to overcome of these errors using FME, please anyone if knows how to fix these errors, please let me know. please find the errors below:-   "type": "CONTENT_VALIDATION_ERROR",   "path": "data/data7.b3dm",   "message": "data/data7.b3dm caused validation errors",   "severity": "ERROR",   "causes": [    {     "type": "BINARY_INVALID_ALIGNMENT",     "path": "data/data7.b3dm",     "message": "The byte length must be aligned to 8 bytes",     "severity": "ERROR"    }   ]  },  {   &

What would be the most convenient technique for querying data stored on Azure Data Explorer (ADX) from FME Workbench? Should this be done via a HTTPCaller?

But I cannot find the proper way to do it here. I am sure it shouldn't be complicated but I am new to FME with thousands of questions. This is just one of them 😅

HI. I would like to ask FME team about how to see the contents of storage inside of FME flow, and how to manage/delete the storage (temporal storage or primary disk) of FME flows. I would like to reduce unnecessary payment/charges, so please kindly let me know. Thank you. 

I am working with two datasets and I am trying to use Spatial fuzzy matcher to find if there is a similar name nearby within the mentioned distance in this transformer but wherever the fuzzy ratio is 1 it is not there.EG : here I am tryimg to find if there is 'Heavy inlet' in another dataset or similar string, it has mentioned its fuzzy ratio as 1 but there is nothing similar to this near or in the entire dataset.:

I have some floor plan DWG drawing with gaps (walls) between the rooms. The desired result is to make it simplified floor plan, i.e. keep just one line between the rooms.There are hatches that forms the basic shape of polygons to begin with. So far I could get rid of gaps by buffering twice (positive and negative), dividing overlaps and dissolving small artefact sliver polygons to bigger ones. Later snapping the segments. The result is more or less satisfying, I just wonder if there's more elegant solution. For example the snapper (segment) doesn't maintain the orthogonality and makes "crooked" lines...Thanks for any suggestions.

Is there a way to easily pull all of the SQL statements out of all of the SQLExecutors in a workspace? I have several automations that I need to do this for and some of them have hundreds of SQLExecutors in them.