Data

I am receiving a vaige AreObjects error '-2147216072'. That said, it appears to be different than the other questions posted here (such as this, this, and this). The actual error I'm receiving is "An error occurred while flushing the cursor for the table/feature class 'my_table_here'. The error number from ArcObjects is: '-2147216072'. The error message from ArcObjects is: {Underlying DBMS error [[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 5 (""): The supplied value is not a valid instance of data type float. Check the source data for invalid values. An example of an invalid value is data of numeric type with scale greater than precision.]}"The workflow does write some data, up to 32,000 records into an SDE table using the ArcSDE Geodb writer (there should be 33,001). It will also run without error if I remove a portion of

When using the Mongo3 reader, I have real slow connection via FME Desktop, while these connections in Python or other Mongo clients are really quick. Some examples cases where it is extremely slow:creating a Mongo connection + viewing all the available collectionspicking a collection + displaying it on the Workbenchrunning the FMW file from Workbench, even with filterAll these step can take up to 6min each, for a simple connection. Is there any way to make it faster, like ignoring all the attributes and just use raw JSON (and nothing else)? Listing all the collections from a Mongo server takes a few milliseconds in Python...I use FME Desktop 2019.2.1.0 (20191202 - Build 19813 - WIN64)Mongo version is 4.0.13

I used to convert to/from Norwegian standard format SOSI, but since my latest FME update SOSI seems to have disappeared, I'm left with SOSI/GML which (I think) is not the format I need. What has happened here?

I have created a workspace that converts shapefiles (.shp) into Cesium 3D Tiles using the Cesium3DTiles writer. It works pretty well but I'm wondering if I can control how my geometries are broken up into tiles. I've played around with the area and volume calculator to set the cesium_priority property to control when tiles should appear at different zoom levels but I see tiles that span the whole US for instance and I want to sub divide the tile based on a grid or maybe an attribute. Is something like that possible? This picture shows a volume that spans the US that may have some geometries on the west and east coast. Instead I may want a tile for the west coast and another tile for east coast at this zoom level. I can provide my workspace if needed. Thanks! 

Hi,I need help by creating ACAD block in FME. There are more DWG files with buildings, one building per file, filename=BuildingID. I need to merge them into one DWG file, where each building should result into one block with block_name=BuildingID. I can simulate it in ACAD, but I need to do it for hundreds tiles, with hundreds buildings each.Attached are two buildings DWG (5296285, 5356200) and result file with blocks (5300_340000). Thank you very much for any help! 

 For example, I have a CreateNode Field in one table, I have to filter out Null and populate these null values Using the second table that has the same field name. the output is not something It should be. I have attached a screenshot of my workspace. Any help would be greatly appreciated!

Hello, Can you tell me if FME is compatible with SAP R / 3? Is there a connector for this system in FME? Did anyone used this? Thank you! Nicu

Hi All,I am trying to convert ERSI shapefile(LOD0) to Cesium 3D Tiles using FME 2017 Writer. Here is my workspace :When i use Cesium to visualize it, bounding volume of tile is skew like this:I use Cesium's Template code to visualize(change url to my tileset path) so i guess my code is fine.Could anyone help me on this?Thank you,

We have an ArcGIS Online hosted feature service that has ArcGIS attachments. Using FME, I have no problem downloading the feature service to a feature class in an ESRI file geodatabase, including the attachments. Now our users edited the downloaded feature class, I will need to upload the feature class to ArcGIS Online to overwrite the content of the previous hosted data. Overwriting the feature data works fine, but I can't find a way to bring along the attachments. I am trying to do a truncate/insert operation. Any idea how to do this correctly?

Hello!I have a layer in AGOL named "park furniture".I want to make a backup via FME to a FGDB named the same.Im wondering if there is any example of a workspace were i can see wich transformers i need to use if i want to make a backup from a feature layer in AGOL to a FGDB. I dont have any schema in the FGDB but want to use the one from AGOL and also transfer the domains and attachments straight into the FGDB.  Or is it better to make a copy in Arcgis Pro first and the keep overwrite/update the FGDB.  /Tim

Hello we have an AutoCAD drawing that contains some 'wipe out' features i.e. polygons that sit above other data and hide the information that is underneath it. All of the wipe outs have the 'Display but not plot' setting in AutoCAD but for some reason they are not being read into FME.I have the 'Ignore Frozen Layers' and 'Ignore Hidden Layers' settings in the reader set to No but that does not seem to make a difference.  The snapshot is an example of where the wipe out is used in the sample drawing  Does anyone have any advice on how to read these layers into FME as I need to replicate what AutoCAD does when creating a TIFF / PDF output.

Hi folks, For some unresolved reason, our ArcGIS Server 10.7.1 crashes intermittently. Like randomly after a week or a few weeks or month or two, it just crashes. When I check the Server logs for what appears around the crash timestamp, there are a number of SEVERE errors that follow the pattern of "Error performing query operation Wait time of the request to the service <SERVICE> has expired." It's a specific set of services, enterprise feature classes as their source, usually the same culprits appear in these error messages so I thought it might be associated with some web apps that may be experiencing strangely heavy use at sometimes outside of main business hours. I've already had Esri Tech Support investigate this but they couldn't figure out what's causing the issue either. But I recently changed the source of one of these services to point to a shapefile instead. At the next Server crash, this layer did not have its name show up among the e

Is it possible to transform .gdb files into .ifc files. If yes, what transformers do you use? Sincerely Thomas

This is an error I get when I try to refresh an existing layer in a feature service on ArcGIS Online. ArcGIS Online Feature Service Writer: 'addResults' error for a feature in 'Environmental_Inspections'. The error code from the server was '1000' and the message was: 'String or binary data would be truncated.The statement has been terminated.'Has anyone else run into this?

I am trying to use DatabaseUpdater but it appears not to work with a versioned SDE Table. Is there a work-a-round?

How can I convert raster boundary to polygon? Raster Domain is equivalent tool in ArcGIS / Pro.

Can FME desktop call Open API data after receiving coordinate information from a file? Basically the client will supply a lat/long from CSV file and then we want use those coordinates to get data from our API source. Request format: https://<apiURL>/data/lat={lat}&lon={lon}&exclude={part}&appid=[API KEY]

Attached my ifc file. I changed the ending from ifc to txt. 

I have CAD file with nomber of layers, each layer represent landuse, i want to knew what transformer i should use to convert the CAD file into GIS personal database , the output to be one feature class and landuse use to be saved in one field.

Hi,Just wondering if it is possible to transfer photos from one AGOL feature layer to another using a unique ID - maybe via a join or something similar?I can read features and their attachments using the AGOL Feature Service Reader, join them up with the destination dataset, but I cannot write the photo attachments using the AGOL Feature Service Writer.The geometry and attributes are written but not the photos.Thanks,

Hello,I have about 5000 DWG files that have a lot of excess layers that have no element. I would like to use FME to delete or clean up the layers that have no element. I would be grateful if you could help me, which transformations can help me with this.thank you in advance 

HiI've set up a Workspace that does the following; Dissolves a MapInfo Polygon layer, adds a Counter and Attribute Creator then produces a 2d Oriented Bounding Box (and saves a MapInfo table) Chops the Bounding Box including the Longest and Shortest values (and saves a MapInfo table as well), adds aother Counter then a Sorter & Sampler and then saves the result as a MapInfo table with the longest line from the Chopped table In total there are 197 polygons in the source table which becomes 13 Groups when dissolved. However, the final Table containing the Longest line for each Group is incorrect as some of the lines are the shortest ones. There are the correct number of lines though (13). I've attached the FME workspace and a zip file with the source MapInfo table. If anyone would be interested to run the Workspace and see where i've gone wrong. I've tried using other columns within the Sorter and Sampler transformers but still get the same result. It may be the Sorte

I want to write a DWG containing a mesh (it is one feature in FME), but it always gets split up into strips with a specific number of vertices like there is a limit (see image). Is there anything I can do about it or is it just a restriction by the DWG format? I'm not very familiar with the DWG datatype, so maybe there is another autocad entity that is better suited?

Hi, I have a jp2000 file and a j2w file with the georeferencing, but I would like to have the georeferencing at the jp2000 header. Is there any way to do that? Thanks!

I'm copying PDF files from a source folder to a destination folder. The destination folder is named with today's date (.../outgoing/October-11-2021/).I used the AttributeCreator to create and format the date attribute called "Date_today" and set filecopy_dest_dataset to "Date_today".This all works well, the PDF's are copied into the date folder, however, I also get another empty date folder created in the folder that the workbench is in.Fanout is off. Any ideas how I can stop this extra folder being created?