FME Form

Hi, We have a complex FME bat, compound of 3 FME schemas that we produced in 2019 and it works with 2019.2.3.2 FME version. It is true that it takes about 24 hours.  With the newer versions of FME, meaning everything that is newer than 2021 or even latest's versions from 2020 we get the 'Adjusting Memory Resources' message while performing PointOnArea. We tried different options currently available on FORUMS, try split the data even more without results and and we would like some more ideas.  Below is an extract of the log file. 2022-11-13 10:43:20|4389.2| 15.4|INFORM|PointOnAreaOverlayer (OverlayFactory): Computing relationships between 11770563 input areas and 23979 input points 2022-11-13 10:54:54|4554.8|165.6|INFORM|ResourceManager: Optimizing Memory Usage. Please wait... 2022-11-13 12:40:57|10158.7|5603.9|FATAL |Insufficient memory available -- error code was 2 - please read the FME Help section 'Adjusting Memory Resources' for workarounds.  Thank you!

Hi, I am reading an Oracle spatial table (points) and i only want to write it to AGOL. I have 17624 records in the source. When the feature layer is created I only have 12.000 records. Or with another try I have 10.000 records. The table of the feature layer is also created and I see the atributes. In AGOL you get a thumbnail wich basically shows what you have created. That turns white so it looks like there is no geometry. When I open the layer the map is zooming to the right extend but also no points to view. i tried written the feature layer again with only one attribute in it. That went well. How can I solve this issue.FME desktop 2022.2.0.0. (build 22765)

I have a workspace that reads data from a long list of DWG files and writes specific features to a SHP file. The status the drawings could be anything, including corrupt so I have Rejected Feature Handling set to Continue Translation. When the workspace runs, I can see in the log that some DWG files are skipped for various reasons. A new problem occurs when it hits the attached DWG file. It is a Civil3d file and the log shows that FME finds a resource to read it, but then it just sits there and nothing happens for a few minutes until I get an error.  For now I have deleted the file from the list, but it would be better if the workspace would simply skip it and go on to the next file. How do I do this?

I have made a workbench that contains an Emailer. I did not notice this directly, but the Emailer is a Package. I saved the workbench to a network location so my colleagues can run the workbench as well. And wrapped it in a Workspace Runner workbench so the workbench is not open for editing when colleagues run the workbench. But since this year I notice that the WorkspaceRunner fails because the Emailer package is not installed. This Emailer is installed as soon as the Workbench containing the Emailer is opened. My workaround now is adding a Emailer Transformer to the WorkspaceRunner workbench so the Emailer is installed when this workbench is opened. Hope this helps others that use WorkspaceRunners and Packaged Transformers in there workbenches. 

Bulk copy failed on table 'tv.vagnat_framtida' using delimiter ':'. Error was 'ERROR:  invalid byte sequence for encoding "UTF8": 0xc3 0x3aCONTEXT:  COPY vagnat_framtida, line 33This error kept me busy for some hours exploring character encoding in shapefiles, FME and PostGIS. Which did not help. Not until I did some data digging and found the error.The data in a shapefile apparently comes from a qualified geodata store, and some long text fields have been truncated in the conversion to shape, leaving what appears to be incomplete character codes. And this causes PostGIS problems. The error message comes from deep within PostGIS. I have tried to cut a few bytes from the string with SubstringExtractor, but then the whole string became HEX. Very strange. Since it is invalid data, there seems to be no way of catching these characters with any of the FME string tools. And the error appears only in the Postgis writer, not before so it cannot be logged.Basically, I am looking for suggestions

I am trying to set up a database connection to my Snowflake 30-day free trial account. The connection parameters are shown below. When I test the connection, it takes a long time (about 5 minutes), and then get a Read timeout error as shown below. I have no problem login to Snowflake web console using https://IN17188.us-east-2.aws.snowflakecomputing.com. I use the account "IN17188.us-east-2.aws" in the FME database connection Account Name parameter. I use FME Desktop 2021.1.1. Anybody experienced this issue? I just try to follow the FME - Snowflake tutorial - https://www.safe.com/training/recorded/connect-data-even-geospatial-snowflake/ net.snowflake.client.jdbc.SnowflakeSQLException: JDBC driver encountered communication error. Message: Exception encountered for HTTP request: Connect to IN17188.us-east-2.aws.snowflakecomputing.com:443 [IN17188.us-east-2.aws.snowflakecomputing.com/3.20.44.68, IN17188.us-east-2.aws.snowflakecomputing.com/13.58.248.132, IN17188.us-east-2.aws.s

Can'i catch the contraints oracle with the FeatureWriter? I need to test the integrity of oracle and catch the exception and do something if an error occure.Execution of statement `UPDATE "MYTABLE" SET "STATUT_PRP_R" = :"STATUT_PRP_R" WHERE "OBJECTID" = :"OBJECTID"' did not succeed; error was `ORA-02290: violation de contraintes (PRP_AQU_BORNEINCENDIE_P_CHK) de vérification'. (serverType=`...

Hi. I'm trying to use FME to calculate the distance between a point on the perimeter of a polygon and another point nearby (within 10 miles). I'm using the latitude and longitude coordinate system but I need distances in miles and have not gotten very far on my own. Can anyone point me in the right direction? I'm already using NeighborFinder but can't seem to get the distances right. Thank you.

Hello FME Community,I have a shapefile that contains an ID column. the ID must be unique, but I have data records that have come twice.Only ID is the same and other columns are different.with DuplicateFilter I filter Duplicate. so I get features that came twice. I would like to know that which feature with which feature have the same ID.Thanks in advance for your help.

Hello, I am trying to create a Json schema using the Json Template but I receive the error: JSONTemplater_2 (XMLTemplaterFactory): The following error occurred near line 21, column 20 of the query:JSONTemplater_2 (XMLTemplaterFactory): invalid expression: syntax error, unexpected ":", expecting "," or ")"JSONTemplater_2 (XMLTemplaterFactory): An error occurred while executing the 'PROPERTIES' queryJSONTemplater_2 (XMLTemplaterFactory): The following error occurred near line 6, column 9 of the query:JSONTemplater_2 (XMLTemplaterFactory): An error occurred while executing the process-features functionIf I validate my Json on line seems to be correct but in FME doesn't work.Do you have some suggestion?Attached the file that I am using ThanksMax 

I have brought in an FBX as I need to carry out some coordinate transformations to it as part of our workflows. This is the fbx model in navisworks, units in metres, modelled in EPSG:27700: The model is orientated north, and the top left point is (330213.690, 376187.218, -2.7) When bringing this into FME, the coordinates are multiplied by -1:The same point within FME's data inspector is (-330213.6044, -376187.4125), which is equal (ish) to the above point, but multiplied by -1. The orientation is incorrect but this will be due to the coordinates being multiplied by -1. Is there a reason FME has inversed the coordinates when reading the FBX? Is this typical for reading FBX files? Also - what transformers would be required to make the coordinates positive / *-1 for each xy? Not z, it looks like the z coordinate has the correct sign. Thanks for your time,Tom       

I know the possibilities of headers, italics and bold in creating the workspace app, however I was thinking it would be also nice to give some text different colors. I was trying the markup code from the following stackoverflow link, however the text didn't appear in color on the workspace app :(. So I was wondering whether it's possible to style text in color in the workspace app.  I tried the following methods:<span style="color:blue">some *blue* text</span>.$\\color{color-code}{your-text-here}$ 

i have 4 reader+writer pairs. after the last reader-writer pair runs and completes, how do i get sqlexecutor to run only after the last pairing has completed?

Hello,  i have strange behavior of transformation raster from bil ESRI to ECW in version2. In previous version of FME script was working correctly, but now i receive raster in inncorrect EPSG :6619 instead 3006. In attachment i send simple sample. I need to use version 2 of ECW - due to clients requirements

I have a company website, to which i log in to get my data, the webpage is a .PHP that has several drop down menus for example Data 1, Data 2 , Data 3 etc, if you select Data1 for example, you get a sublist with more files,at the moment i choose a file from the sublist then i click a download CSV button. I have to do the same for over 100 subfiles. I am trying to find another way to achieve this. I was wondering whether someone could have an idea of how i can achieve this in fme? Maybe download the mainfile instead of the subfiles. Thanks,Keller.

Hello,I have a point dataset and I want to make an algorithm that operates like this:(1) Select a point;(2) Remove all surrounding points within a distance, entered as a fixed parameter (eventually this can be done using a bufferer + spatial filter);(3) Store the first initial point in a new dataset and repeat the process for the remaining dataset from step (2) to obtain a second point that will be stored with the first one and so onThe final result is to obtain a point dataset where no distance below a threshold exist ALONG WITH preserving the maximum number possible of pointsThank you very much in advance ! 

Hi, we have raster data (orthophotos) with a ground resolution of 8cm.Is there a possibility to downsample the ground resolution to 20cm? Based on some limitations we sometimes have to use 20cm ground resolution.Does anyone know if something like this is possible with the fme?

Hello guys, I am trying to consum a SOAP API to send data from FME desktop but I am getting the HTTP/1.1 500 Internal Server Error. Here is what I did: I have configured the API request in SoapUI copied the xml request and send it the HttpCaller transformer using the XMLTemplater.  I have enabled the authentication option in the HttpCaller and entered the username/password using the basic type.  Thank you in advance.

Hi! I'm desperately trying to find a way to identify the impact of disabling a specific network on the surrounding networks. So far by using the NetworkTopologyCalculator, I've been able to isolate all my water networks, separated by water valves. But here is an example of what I'm trying to do:If I have to replace the water pipe on the network A, I will close the water valves to isolate it. The impact would logically be that there would be no water reaching networks B-C-D-E. Is there any way for me to dynamically identify this in FME?Thanks in advance for your help!

Hello all I have a question regarding readers when used with possible empty directories and resulting error messages. In a FME workbench, a CSV reader reads all CSV files within a directory and then processes them. If one or more CSV files are present in the defined folder, the Workbench works perfectly. However, if there are no CSV files in the folder at the time of execution, an ERROR is issued:ERROR |CSV reader: Failed to open file '\\\\Auto-Import\\**\\*.csv' for reading. Please ensure that the file exists and you have sufficient privileges to read it. With the FME Desktop version 2019.2 that we are currently still using, I was able to set the Workbench to continue running even if an error occurred. However, this is certainly not the most ideal solution. Especially it is difficult to detect actual error messages in the log files.The Workbench is automatically executed every hour by the task scheduler. Another problem is that the CSV Reader is part of a Workbench that is sup

I want to remove all the extra pipe delimiters after the data. I would do it manually by I have over 10000 records. Please help.

I am trying to set up a hive connection and have followed the instructions in the docs.The issue is an error being thrown with a cryptic meaningCould not open client transport with JDBC...Invalid status 21Has anyone seen this before and have any pointers.  I've tried using generic jdbc driver and the one that shipped with HIVETrying to find a JAVA plugin for reader named `APACHE_HIVE'Hive Reader: Preloading JDBC Driver Class 'org.apache.hive.jdbc.HiveDriver'Hive Reader: Creating connection using connection string 'jdbc:hive2://x.y.z.a:10000:' and properties '{user=XXXXXXXX, password=************}' Hive Reader: Driver class 'org.apache.hive.jdbc.HiveDriver' is being loaded from '/C:/Users/XXXXXXXX/Documents/FME/Plugins/Java/hive-jdbc-3.1.3-standalone.jar'java.sql.SQLException: Could not open client transport with JDBC Uri: jdbc:hive2://x.y.z.a:10000: Invalid status 21  at org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:256)  at org.apache.hive.jdbc.HiveDriver.connec

New to the API world. I am trying to use HTTPCaller to auto-attach a pdf file as a response.I managed to use HTTPCaller to get all requests and auto-generate a response. However, I am unsure how to physically upload the file through the POST method. Here is the link to the API document: Enquiries API (1100.com.au)My HTTPCaller parameters:I keep getting: "HTTPCaller_4 (HTTPFactory): [1]: HTTP transfer error: Stream error in the HTTP/2 framing layer" error code.   

How could I extract only the string text before unknown digit numbers in specific column .but if the string start with digit numbers so keep the beginning numbers and remove other digit number at this value . or other method :i would like to remove any numbers at specific column and any letters and characters come after it . if the string start with digit numbers so keep the beginning numbers and remove other digit numbers at this column . my column includes :hghkdkfke 24a jdklfllfv 22-23 45jdkdkkf 22 ( djskkr) Target hghkdkfkejdklfllfv45jdkdkkf FME 2021Thanks in advance

Trying to automate some ArcGIS Server monitoring and am struggling to get a token using HTTP Caller. I think there may be a bug on the ESRI end (surprise!). But before I post on their forum, I wanted to pin the FME world. I'm making a POST to here:myserver.domain:6443/arcgis/admin/generateTokenwhich is the same place I go for manually obtaining a token. As query parameters I have:client : requestipf : json as Headers:Content-type : application/x-www-form-urlencoded Accept : text/plainI have tried both putting username/password in Body and Query. Neither works. If I grab a token manually and pass it in the HTTP Caller as parameter, I have no trouble making a connection to the same URL. Has anyone gotten this to work, or has a clue where I'm going off course? Thanks