- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Flow

FME Flow

A space to discuss FME Flow

2326 Posts

Recently active

Most replies Most views Newest first

vxn43Supporter

asked in General

Lettered Path vs UNC Path and Access Database

I have a workspace where the Reader reads an Access database using a lettered drive path (K:\\projects\\databases\\access.mdb) The Writer writes to the same database using the same lettered drive path. When I publish this workspace to FME Flow without uploading/selecting files, the Database Path under Published Parameters is empty. But, when I change the database paths in my workspace to a UNC path (\\\\gisserver1\\projects\\databases\\access.mdb), I publish the workspace (without uploading/selecting files) and I see the UNC path to the Access Database populated in Published Parameters - Database Path. If my workspace reads from a lettered drive path and the database is Microsoft Access, when I publish the workspace, do I need to upload/select files? This would upload the Access database to FME Server.

Is there a way to customize the webhook url in FME flow hosted?

633

1 year ago

petria

asked in Architecture

FMEflow 2023 installation not working

I'm trying to install HighAvailamility setting (2 windows server , Oracle DB) fmeflow2023 windows (fme-flow-2023.0.0.3-b23319-win-x64.exe) Environment:2 FMEflow servers, Windows server 2022 standard editionsystem fileshare , Windows server 2022 standard edition fileserverOracle, Oracle 19c EE with Data guard Installion done fmeflow servers and it doesn't work.Trying to open web page (from local fmeflow server) it just give empty page with Fme:flow image. C:\\Program Files\\FMEFlow\\resources\\logs\\installation , folder is empty. Where to get help ? what is safe.com support address ?Is there any support from safe.com ?

161

1 year ago

vxn43Supporter

asked in Automation

Notifying when an automation has completed its run or not

I have created an Automation in FME Server. It is triggered by a Schedule and runs a single workspace. What is the best way to have an email automatically sent to me notifying that the automation has finished running and succeeded or the automation did not succeed. In FME Server, I see under Automations - Notifications (Classic). But I am not clear on exactly how to set up the email notification. Here is what I have done so far, and it does not seem to be sending me an email after the automation has run. Any suggestions?

413

1 year ago

vxn43Supporter

asked in Automation

Using workspace with disabled connector and transformer in an Automation

I need to publish a workspace into FME Server that has a disabled connector and disabled transformer. In FME Desktop 2021, the workspace can run successfully with these disabled. If I publish this workspace to FME Server 2021 and create/run an Automation, will FME Server recognize the disabled connector and transformer and not run them?

1 year ago

mourabitikram1

asked in Automation

hi i have to add some properties in the ifcpropertysinglevalue for the objects in an ifc file but those properties i need to inject them in a certain propertyset and under some conditions ( if i have for example IFCFLOWFITTING i need to add x propert

132

1 year ago

stalknechtContributor

asked in Flow Hosted

Can an existing python library be updated on FME Flow hosted?

I'v been succesfull in loading additional python site-packages on FME flow hosted.Now I have a site-package that needs a newer verion of numpy then the one that's allready in the standard installation.Can I upgrade numpy on the FME Flow hosted environment?

Scheduled Service Failing

I have a service that runs on a schedule that regularly fails to connect to a hosted ArcGIS Online service. If I manually resubmit the same failed service it succeeds. I have other scheduled services that use the same AGOL connection without any problems. I have tried recreating the scheduled task, republishing the service, and re-authenticating the connection. Does anyone have any ideas why this scheduled service is failing but succeeds when manually running and other scheduled services using the same AGOL connection succeed?

1 year ago

mikebrooks

asked in Automation

How to stop automation from continuing to send emails

Hello all, I have had an automation running for the better part of a year and I set it up to send me emails (post topic on failure). I needed to revise this and set up 2 separate automations to separate the types of jobs, daily vs every 30 minutes. Prior to setting up the new automations, I stopped the original and deleted it. It is still sending me emails now. I also made sure I replaced every instance where it was tied to a schedule, and I deleted the topic itself, and I am still getting emails. It has been stopped and deleted for over a month now and I am searching for a solution to end the emails. Any help or suggestion would be appreciated. Example below, it is sending failure notifications from over a month ago:{"automation.id":"cac0de02-77e3-4c13-b330-dba1175dfaf7","workspace":"CMPT CG Future Allocation VW.fmw","timeRequested":"Wed-31-May-2023 05:00:00 PM","requestKeyword":"SERVER_SCHEDULER","ti

1 year ago

sknaps

asked in Security

Hi, I get an error message because of a permission. Had anyone a similar error?

Error executing SQL command ('TRUNCATE TABLE "quali"."wa_hydrant"'): 'ERROR: permission denied for table wa_hydrant'Error truncating table 'quali.wa_hydrant'. Assuming table exists and attempting to appendError executing SQL command ('COPY "quali"."wa_hydrant" ("gis_id", "gesellschaft_bd", "gemeinde", "standortwerk", "_rbe", "_fehler_nr", "_fehler", "_pruefdatum", "_fme_prozess", "_temptext1", "_temptext2", "_temptext3", "_temptext4", "_temptext5", "_temptext6", "_temp_num1", "_temp_num2", "_temp_num3", "_temp_num4", "_temp_num5", "_temp_num6", "fstatus_id", "geom_pt") FROM STDIN USING DELIMITERS ':' WITH NULL AS 'NULL''): 'ERROR: current transaction is aborted, command

513

1 year ago

virtualcitymattEvangelist

asked in General

Anyone have any ideas or tips on how to move submitted jobs to a new queue?

We (rarely) get a glut of job submissions to some of our FME Server queues (Running on FME Cloud). These glut of jobs usually come from someone who has automated a bunch of submissions (we're totally fine with that). We want these jobs to be processed, but at the same time we still want to be able to handle other user requests in a timely manner. I created an idea over here which would help me: https://community.safe.com/s/bridea/a0rDm000001Sf7kIAC/option-to-move-submitted-queued-jobs-to-new-queue It outlines the scenario in more details. Just looking for tips or idea on how to work around this. The service in question is essentially just a clip and snip but depending on what the user wants the request can take anywhere between 10 seconds and an hour or so to process.

How does having Automations running constantly affect performance?

I'm just wondering if there's an impact on performance having multiple automations running constantly. They are triggered by a schedule within the automation to run once per day.

1 year ago

earlwContributor

asked in Flow Hosted

FME Flow Hosted with on prem Remote engine

Is it possible to use FME Flow Hosted with a Remote engine located on an internal network. Thinking that this configuration would minimise FME Flow core maintenance, Simplify firewall rules, provide access to internal network resources like file system shares and databases... If it is possible, is there any documentation on how to setup this configuration.Cheers,e.

803

1 year ago

raychien

asked in Architecture

How To Reset FME File Association for all users?

Hi All We've recently deployed FME 2021.2.0.1 Desktop (64-bit) to a new server environment shared by many users.After some time we realized that this installation has somehow changed File association for JPG to associate with FME Data Inspector. This is unintended and very undesirable. What's the best way to reset the JPG File association to whichever program it was prior to the FME Desktop install? If I change this setting manually through Windows options (assuming I get local administrator rights), does this get propagated to all user profiles? Also we are running a Citrix server environment. Any help is much appreciatedThanks!

373

1 year ago

nielsgerrits

asked in Architecture

FME Desktop installation resets file extension defaults.

When I install a new version of Desktop on my (Windows) machine, all my file extension defaults are reset. (I have to choose which software I want to open a .xlsx file when selected in File Explorer, again.) I think this is recent behavior? Do I miss a setting during installation? Can it be made undone?

295

1 year ago

mr_fmeEnthusiast

asked in Automation

Update sheet in Sharepoint

Hi, I have a spreadsheet in sharepoint where one of the sheets needs to be updated weekly, from another sheet that is in another file in sharepoint. I tried using the sharepoint connector but it makes me lose cell color, formulas and other formatting. The ideal would be just to delete a sheet inside a sharepoint file and insert a new sheet, without harming the other sheets. How can FME help me with this?

How to get notified about MQTT-connectors disconnecting?

We sometimes have a problem with our MQTT-connector that is disconnecting (always running on our FME Server), but it only shows in the log as a warning. 21318 2021-5-17 11:08:21 | MQTTConnector: Unexpectedly disconnected from broker. Will attempt to reconnect automatically... Error: Connection Refused: unacceptable protocol version. Restarting it works just fine, but it didn't try to reconnect, or at least no log message about it. It was haulted like that for 10 days until I manually stopped & started it … When this happenes, the job seems to be running like normal, and you manually has to go into the log (when running) to see that the job has stopped receiving data from the MQTT-provider. I had to implement a separate test on a different FME Server job to check whether sensordata came in or not, but the optimal would be to get a notification (eg. by email) if the connection is not reestablished within a few seconds. Looking forward to suggestions & future updates. Kenneth.

732

1 year ago

aaronContributor

asked in General

How to grant read-only access to FME Server schedule

I created an FME Server role that provides read-only access to view FME workspaces published there (i.e. - Workspace Viewer). I would also like to add read-only access to view items under Schedules but only see options for Full Access or None for a role's permisssions. is there a way to provide read-only acccess to Schedules? We are currrently running FME Server 2020.1.2.1 (Build 20624).

132

1 year ago

sergeParticipant

asked in General

Change Rows to Columns

I have a flow source Movie Role ActorM1 R1 A1,A2M1 R2 A1,A3M2 R1 A2 and I need to switch to the vue Movie R1 R2M1 A1,A2 A1,A3M2 A2how is it possible, I tried AttributePivoter but didn't find a way to switch rows to columns. The Roles list is not known before, so it should take all unique roles as columns.

171

1 year ago

arthyContributor

asked in Automation

How to define the time on FME serevr so that it should be the same as in local time?

Hello, Currently, I'm having a delay and I don't know how to fix. The FME server time is not the current time, instead it is the time UTC that is displayed. How can I change it?

452

1 year ago

oliver.morrisContributor

asked in Architecture

MacOS silicon version bug

Trying to install on my mac, silicon version. Have uninstalled one version completely. New version still has the same bug. When loading a package, going to database connections etc: Failed to install web service '/Users/xxx/Library/Caches/Safe Software/FME/Packages/23319-macosx-aarch64/PackageFiles/safe-lab.genai/web_services/OpenAI.xml'. Reason: Unable to read from file '/Users/xxx/Library/Caches/Safe Software/FME/fme_publicKey.fmeks', No such file or directory (Code 2) I checked for the folder and it doesnt exist.

162

1 year ago

fbastian73Contributor

asked in Architecture

hi, the fme server login screen is not loading properly. I have created a case in the fme community but was wondering if anyone here might have come across this same issue. If yes, how did you resolve it? thank so much.

fme server 2022.2 login page not loading properly on web browser.I have included a couple of attachments for more clarity.I have followed the online suggestions and no luck.Any ideas/suggestions welcome.thanks.

Automation to download attachments to a folder

Hello - I have an FME automation, that downloads the attachments from an email trigger using SMTP protocol. There is slight issue, each time when the job is triggered via received email, FME Server is creating a folder under my desired location, instead of overwriting the file with the same name email attachment. any thoughts or suggestions ? I have attached screenshot of the automation configuration and also target location where FME Server is creating multiple folders. The file name EPS_DATA.csv

1881

1 year ago

parke372Contributor

asked in Automation

workspace automation for receiving REST API requests?

Brand new to FME server, and i've only really worked with outgoing REST API calls before in general. What i have is a workspace that is parsing emails and picking out specific data that is then packaged based on conditions and sends out an REST POST request to another platform. The packaged data going out becomes an actionable item in the other platform, and i want to have users be able to click a button to respond to the action item and have that come back to FME Server (i assume it'd be a post request) where i can write to a table some related data. i'm not sure how to "listen" for incoming REST requests? i've read through the v3 documentation and it is pretty likely that i missed it, but i'd love it if someone could help me out?

1 year ago

sivaram81082Participant

asked in General

How to check if database is availabe?

To provide high availability of data, client is having two data servers. We need to check for existing database connection failure in FME Work flow and pull data from backup data server. If there is no failure at 1st connection, then no need to proceed for backup server. Is there any possibility for this king of approach in FME?

457

1 year ago

Page 21 / 94

Badge winners

sameerbajracharhas earned the badge FME Form Basic Training
sameerbajracharhas earned the badge Integrate Data with the FME Platform Training
mglancloshas earned the badge Integrate Data with the FME Platform Training
davidpatruyohas earned the badge Integrate Data with the FME Platform Training
robertoavilahas earned the badge Welcome Back

Show all badges

30,096: Posts

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

A product of

Company Products Giving Back Careers Contact Privacy Feedback

Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.