Skip to main content
  • EN

General

A read-only category for lost FME Form topics. We hope to move them shortly.

  • 4,042 Posts
  • 13,932 Replies
4042 Posts
aguan
Contributor
aguanContributor
asked in General
Unable to connect to Snowflake, got read time out error

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

8540
jhu_20
Contributor
B
bluelight84
asked in General
Calculating distance in miles between point and polygon

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.

880
M
arash_hokm
Contributor
arash_hokmContributor
asked in General
determine which feature with which feature have the same ID

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.

150
srinivasgg
Contributor
joy
Enthusiast
joyEnthusiast
asked in General
Is it possible to style text in color when creating a Workspace App on FME server?

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}$ 

1090
joy
Enthusiast
P
padraig.brosnan
asked in General
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?

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?

50
nielsgerrits
VIP
L
lianaolianov
asked in General
Delete points below a distance from every point within a dataset

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 ! 

2600
L
erich_st
Contributor
erich_stContributor
asked in General
Readers (CSV / Trimble JobXML) when used with empty directories

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

150
erich_st
Contributor
badgerseatfrog1
Contributor
badgerseatfrog1Contributor
asked in General
SharePoint online connector transformer special character in filename error (#)

It seems that any file with a # in the filename won't download when using the SharePoint online connector transformer. I want to download using the _fullpath method.  Simply --> if the filename is FOO_1 it works. If it's FOO#1 it doesn't. The rejection code is SHAREPOINT_ERROR , the URL it's trying to DL is:SharepointOnlineConnector: Error making request to https://graph.microsoft.com/v1.0//sites/ac[HIDDEN]%20November%20#4.jpg: The resource could not be found.Is there any way to get around this? I have tried the URL ENCODER and STRING REPLACER transformers to try and manually encode the # symbol but it doesn't like this. Presumably because it's trying to encode it "again" I can tell my users to stop using a # symbol in the filename but would rather solve it more elegantly and retain the original name.  Link to transformer:https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Transformers/Transformers/sharepointonlineconnector-pkg.htm

140
badgerseatfrog1
Contributor
elpone
Contributor
elponeContributor
asked in General
Hive JDBC: connection issue - Invalid status 21

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

17980
steveatsafe
Safer
gogopotter90
Contributor
gogopotter90Contributor
asked in General
How could I extract string text before unknown digit numbers from column

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

839
gogopotter90
Contributor
agelfert
Contributor
agelfertContributor
asked in General
Has anyone successfully obtained a token from ArcGIS Server (10.9) using HTTP Caller?

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

4453
agelfert
Contributor
joy
Enthusiast
joyEnthusiast
asked in General
pathname seedfile FeatureWriter invalid with FME resource

In preparation for publishing and running a script on Fme Server, Iam writing the pathnames as follow in fme dekstop for the seed and cell files. The cell file is not red, while on the other hand the filename is not recognized for the seed file.I am not quite sure why that is the case. In the normal writer of v8 this doesn't occur, but then I face other problems in terms undefined macro. The problems don't occur when I use hard pathnames, but then they are not useful when I publish the script to FME server

110
dustin
Influencer
peter.frohberg
Contributor
peter.frohbergContributor
asked in General
How can I store securely an API token which is used for authentication within a HTTPCaller?

Hi everyone, I want to use an API via the HTTPCaller. The authentication is done via an API token. Is there a way to securely store the API token like the username / password combination within a Web Connection? We place our created FME Workspaces in a git repo and don't want to put any authentication data there .  Thanks for your answers in advance. :-)Peter

3650
peter.frohberg
Contributor
ronmak
Contributor
ronmakContributor
asked in General
Why don't I see "power" attribute from a GPX file?

It's been a while since I posted but I am doing something different and after spending some time looking in the forums for a solution, I thought I would just post it.  It's probably something simple, but I have limited experience with FME. I downloaded a GPX file from my bike computer and want to do some data processing on it, but when I view the file in FME Inspector, I am missing the "power" attribute which appears in the GPS as shown below.     <trkpt lat="43.7513380" lon="-80.5606200">    <ele>335.6</ele>    <time>2023-01-07T13:02:24Z</time>    <extensions>     <power>36</power>     <gpxtpx:TrackPointExtension>      <gpxtpx:atemp>20</gpxtpx:atemp>      <gpxtpx:hr>89</gpxtpx:hr>      <gpxtpx:cad>51</gpxtpx:cad>     </gpxtpx:TrackPointExtension>    </extensions>   </trkpt>I do get the time, temperature, hr and cad, but not <power>.I expect it has something to with the fac

3560
ronmak
Contributor
f.kemminje
Contributor
f.kemminjeContributor
asked in General
Emailer not working in 2022 ver

I used the 2021 fme workbench emailer. The version from 2021 was functional. It is currently not functioning in the 2022 version. It displays an error message that reads, "No module called Chardet." The 2022 version had to be deleted, and I had to return to the 2021 desktop.

590
danminneyatsaf
Safer
peteratqfes
Contributor
peteratqfesContributor
asked in General
Extracting latitude and longitude exif from blobs

Hi, It's not entirely clear whether this has been solved or not already. I'm using FME 2022.1. I have a portal feature service with has jpegs as attachments. I want to read the exif metadata from the blobs. jpeg_exif_gpslatitude jpeg_exif_gpslongitude jpeg_exif_gpsimgdirection If I use the RasterReplacer method I lose all exif metadata. 

2210
peteratqfes
Contributor
daniel.m.getz
Contributor
daniel.m.getzContributor
asked in General
Is a 400 error with salesforce writer an issue with the data or on the salesforce permissions?

I can read tables from salesforce without an issue so it's probably not a credentials problem. But I am trying to write a record from excel to a table in salesforce and I am getting a 400 error. The error messages are pretty vague, only that it fails to write and that the Create Job Must be a POST. Any idea what would cause this issue? Do I have too few fields in the table that would otherwise be required?  Received HTTP response header: 'HTTP/1.1 400 Bad Request' from [salesforce instance here]Salesforce: HTTP 400SALESFORCE writer: A fatal error has occurred. Check the logfile above for details... Last line repeated 2 times ...Translation FAILED with 5 error(s) and 1 warning(s) (1 feature(s) output)  <error xmlns="http://www.force.com/2009/06/asyncapi/dataload"><exceptionCode>InvalidUrl</exceptionCode><exceptionMessage>Create Job must be a POST request</exceptionMessage></error>

1350
heatherwillis
Contributor
R
rob_nason
asked in General
Creating Channel Networks

In QGIS there is a tool to create channel networks across a LiDAR surface. Is there a similar tool or process in FME?

110
R
F
fizquierdo1973
asked in General
Use a variable with INLINE QUERY

Hello, I need to use a variable in INLINE QUERIERThis is valid SQL but I can't get it to run in FME. The print is just for testing. I would ultimately use the variable as a concatenation string. DECLARE @ccount as varchar(20) set @ccount = (select top 1(CYCLE) from CYCLE) print @ccount 

2750
M
L
lianaolianov
asked in General
Fix a minimum distance within a 2D point dataset

Hello,I have a 2D set of points within which I want that no pair of points stay within a distance inferior to a threshold of my choice. The supplementary points have just to be deleted. How can I perform that? Thank you in advance.

100
L
S
sondre
asked in General
Python Integration

I'm trying to use FME purley through Python and have successfully executed the "WorkspaceRunner.py" sample code, calling it via FME:fme.exe python fmeobjects/samples/Python/WorkspaceRunner/WorkspaceRunner.pyI have since tried to create my own program but which throws an exception that I would appreciate to get some guidance on. Here my code: import osimport sys os.add_dll_directory(r"C:\Program Files\FME")sys.path.append(r"C:\Program Files\FME\fmeobjects\python39") import fmeobjects runner = fmeobjects.FMEWorkspaceRunner()workspace = "testWorkSpace.fmw"runner.promptRun(workspace)Error message:fmeobjects.FMEException: FMEException: 1: Failure running workspace 'testWorkSpace.fmw'Importing the FME modules seems to work and I'm using the same interpreter as with the WorkspaceRunner.py sample. "testWorkSpace.fmw" is an empty workspace.I also found that when executing WorkspaceRunner.py without going through fme.exe i get the following error:FMEWorkspaceRunner: Error in dialog creation duri

2459
S
dor1411993
Contributor
dor1411993Contributor
asked in General
Sde and Postgres database writing problem

Hello everyone.I have a problem with writing an SDE database that sits on top of postgis DB.I manage to connect in the FME to the database both from the postgis / postgres readers and from the sde reader.I can read the data, the problem is that I can not write properly.I want to update the database, and no matter what I do, I do not see the changes in th database.It is divided into two parts:When I write directly to postgis, I have a lot of warnings, but I was told that Total Features Written 1As it should be.But in practice I do not see the changes in the database at all!And when I write down to sde, it gives me lots of Errors, but Total Features Written                            1 as it should be,but still no change in the DB.I tried every possible variation in feature operation, insert, update- and nothing changed.Only when I did an experiment with delete, it managed to delete the features for some reason.Does anyone have an idea how to overcome this and write directly to the datab

1444
J
f.kemminje
Contributor
f.kemminjeContributor
asked in General
calculate Perpendicular distance between road centerline to property polygon

I have a road center line and private properties beside(left and right) to road center line.I want to find out the distance between the road centerline and private properties (perpendicular to the road centerline)both the sides(left and right) for every kilometer. Generate points along the road centerline for each kilometerCalculate perpendicular distance from a point to private property polygons(left and right)Add attribute left1=min distance (left property polygon and right1=min distance to private property right side

1490
ladisrikanta123
Participant
ladisrikanta123
Participant
ladisrikanta123Participant
asked in General
Water Network Analysis

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!

620
ladisrikanta123
Participant
joy
Enthusiast
joyEnthusiast
asked in General
how to define pathnames in FME server?

I am fairly new to Fme server and I have mostly only experience with FME desktop. I was running succesfully a script with Fme desktop. However when I published the script to fme server and I run the script, then I get the following error: I have slightly changed the names of the path due to security issues. DESIGN WRITER: Failed to copy the seed file '\\\\NotRealdomainName\\aplroot$\\A-APLDATA\\FMESERVER\\repositories\\Notrealrepositoryname\\Seed.dgn' to the destination data file 'C:\\Klic_Tijdelijk\\_Bomenanalyse.dgn'. Either the path to destination does not exist or the file is in use by other program I think the issue lies that I wouldn't be have to use hard pathnames in FME Server. Does anyone know how I should define the path names in FMe server? 

1840
sanaeatsafe
Safer

Badge Winners

Show all badges

Community Stats

31,773
Posts
120,715
Replies
39,397
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.