FME Flow

I want to run a SQL before a writer to a postgis database.I am using parameters to dynamically run the SQL queries. Since SQL is case sensitive and my tables include case characters I need to put quotations around my table names. But putting quotes around my statement make it a string. I just want to add quotes the parameters value.select * from "$(schema)"."(fme_feature_type)"Desired resultselect * from "MySchema"."A_Table" Is there a way to escape the quotes somehow to just add quotes around the paramaneter value.

Hello, I'm trying to implement a a html report when user runs my workspace app. When the workspace goes to failure I'd like that the server returns the log file straight to the user.

Hello,I have a (static) file in the FME Server resources folder and I would like to have a copy of this file to the output of my workspace. I tried AttributeFileReader with AttributeFileWriter. This gives a file in my output with the correct name, but it's unreadable. I also tried a FeatureWriter with File Copy but I can't get it to work.Any ideas? 

I am getting error while starting the services on local machine where I install the FME Server 

I've been digging into issues with an Engine running on a separate host in a distributed setup. Service looks to be running but is no longer chatting with Core and is not longer showing up under Engines in the web UI. After ruling out some of the obvious causes on this troubleshooting page. I've started logging running processes and ports being used on that Host to understand at what point the service goes silent or inactive. That's when I noticed what seems like large number of TCP connections FMEProcessMonitorEngines uses with multiple ports open. The

hey guys, I'm installing FME Desktop 2022 on a linux operating system (ubuntu 20.04), but it does not install the sdk! any directions on how to install the sdk on that system? i can't find any sufficient documentation about it

Hi, There is a workspace scheduled to run every hour on FME Server 2020 that is successfull all the time except some failures times to times. When it fails. the error is with the ArcGIS Online feature writer. From the logs, FME Server is then loading the Python 2.7 version of the writer instead of the Python 3.7 version like the other times. Here a success log:Here a failed log: The task fails with Python 2.7 simply because strings are not encoded in utf-8 so thats very annoying. The question is why FME Server sometimes switch to Python 2.7 instead of Python 3.7 when loading the ArcGIS Online Feature writer. How can I prevent that? Thanks

What would cause an FME Server job to successfully complete with no errors, but not create the expected output? In this workbench I have specified to write a file GDB to a zipped folder, which works as expected when running from Desktop. The log file from FME Server shows that 500k features were written as expected, but the file is not present in the output folder. I'm running this with the Job Submitter Service. I originally thought it was a permissions issue, but that does not seem to be the case since I didn't receive an error.

https://community.safe.com/s/article/FME-Server-Stored-Cross-Site-Scripting-XSS-Vulnerabilities In this latest advisory it's mentioned that there are two specific XSS issues, and two different CVE assignments. That's all well and good, even if there is a ton of lacking pertinent information.  The problem I'm having is that this CVE (https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2022-38339) was assigned to this specific advisory but there's zero mention of it. Does anyone know specifically why 2022-38339 was assigned?

I am trying to email a file geodatabase. I quickly learned that FME Server doesnt like folders and will only zip and email files. So I went back to the desktop client and set the gdb to be zipped for output. Tested it on local storage and I get a valid zip archive that contains the gdb folder. I then publish that workspace to FME Server and run it with a geodatabase folder parameter of $(FME_SHAREDRESOURCE_DATA)\\BuildingFootprintQC\\BFP_overlaps.zip\\BFP_overlaps.gdbOR$(FME_SHAREDRESOURCE_DATA)\\BuildingFootprintQC\\Neither works. The workspace runs without error but generates no output. I logged into the host server and checked the resources folders to make sure the zip is not there and indeed its not being created.  How can I get FME Server to follow the desktop function of zipping the output so I can tell the email action in the automation to send the gdb as an attachment? Edit:I checked the log and the

Hi, I've recently completed a FME Serverdeployment on Azure Kubernetes and I'm positively thrilled about thecapabilities of FME Server on this environment.The automatic scaling of the Azure node pools for dynamic engines makes it very easy for large requests to be handled easily by FME Server. When you assign a number of engines to a specific node pool with property: “compute” via a helm upgrade command     - name: "dynamic-group-1"  ->   - name: "dynamic-group-1"        engines: 2                                               engines: 8        type: "DYNAMIC"                                type: "DYNAMIC"        nodeSelector:                                     nodeSelector:          property: compute                          property: compute            Azure Kubernetes handles this perfectly with autoscaling and start up these nodes and en

Hello,I want a trigger in FME Cloud with an Emailer 24h/7. When I receive an email, I run a process. If I receive no email within an hour, do I still need to pay for that hour of instance running, even if I ran no process?Thank you.

I am trying to configure FME Server for HTTPS using a client provided pfx certificate. I have used this documentation, successfully completing steps 1-6. However I'm getting this error:I suspect there is an issue with the certificate, but I'm unsure where to begin looking, or how to fix.  When looking at the certificate details, the Owner CN is '*.<client_website>.com, which differs from the local host FME Server is installed with. Is this the same as the hostname?

In a single workbench, I have automated some processes. One of those generates a report in Excel format. I saved this file in the Shared resource folder on the FME server. The Excel attachment is sent out at the end of the translation. Since last week, the tool hasn't delivered emails to recipients because the emails are too large. When I run the tool on the desktop and save this attachment to my machine, it shows a few KBs, but on the server, it shows 10MB. I compared both outputs (one from the FME server and one from the desktop) and neither shows any differences. I would greatly appreciate any feedback and advice!

Hello everyone, and welcome to What's Up Wednesday. New FME ReleaseI noticed that last week we released FME 2022.1.2 (build 22627). According to my information, the updates include: Snowflake Writer: multiple fixes and improvements, including Bulk writing supportTransformer fixes: SQLCreator/SQLExecutor, DuplicateFilter, FeatureWriter, DatabaseJoiner, 2DGridAccumulatorFormat fixes: Revit, 12dXML, SpatiaLite, Cesium 3D, GTI ViewerListSearcher: add a case-insensitive option I don't think there is anything major in there, so before rushing to update - especially at the enterprise level - I suggest you check the change logs

Hi, I'm new to FME server and I configured an smtp account to send system emails however something wrong is happening as no emails are actually sent.The configuration seems correct in Admin panel (configuration > system & email > email service) (correct info and validation test pass). However, the simple test of running a workspace with email notification on status does not work. Checking the subscribers logs (resources/logs/core/current/subscribers/emails.log) gives quite odd information: "801031 : Invalid SMTP server." I used the same SMTP configuration using an emailer transformer onto a workspace; everything works fine when running on the server. So I'm a bit confused here about why it gives this error since all other stuff seems OK ... (side note: I'm using infomaniak.com infrastructure for the mail serv

Hello,I published a workbench on FME Server enabling version control.After having published I noticed that I am using a wrong number in the text. instead of -214 it should be -216.Can I change the text ? Or delete the version ?  Thank you!

Hi,I have installed FME server, but after installing everything successfully I cannot see the fields for login in the web page.I have checked my firewall , couldn't find any blocker from there. I dont have any additional antivirus installed in my machine. Please suggest how to resolve this issue.

I need that every user who launches FME Workbench has set paths to a shared folder, in order to share connections to databases. However, I do not find where FME saves this information. In the Windws registry?

Quick question about the Windows account that FME Server uses. If I write an FME script that reads from, say, a CSV file and writes to an Oracle table, the Oracle account that gets used is specified in the connection parameters. But what Windows account

I've only just now noticed that the Tools repository appears to be hidden. I can still use Filter Message and Log Message actions in Automations (although I do get a warning when opening an older Automation). Can anybody confirm this?

I need to download files from a WebDAV source using FME. Is there any experience around in doing this directly in a Workbench (e.g. HTTPCaller)? Or will I need to integrate third party scripts (e.g. Pyhton)? What would be a feasible and efficient method?

Hi, I am migrating my fme server installation to a new server, but I encountered error during the restoration process in the new fme server environment. The backup is from FME Server 2021, and I am restoring the backup in FME Server 2022. I have captured the error message and attached in this post. I would like to ask for some guidance here and hope to hear from the others who faced the same problem before.. Thanks.

Hi all, I'm playing around with FME Server Apps and I'm trying to return errors when uploaded files may be invalid. I used the Terminator transformer to set a custom error and can see in the Fail Status message in the job summary. But when the app hits the error I'm returned with 'We don't know what went wrong' . Has anyone managed to return a proper error? Cheers

Hi, I have successfully followed the below resources to get the SharePointOnlineConnector up and running on FME Server:https://community.safe.com/s/article/How-to-create-a-Sharepoint-Web-ConnectionI created my own Azure application to do this, and successfully test the authentication. The workspace works fine for a few days, untill the request token expires, it then fails to generate a new token until I manually reauthenticate. Is there a way around this @jlutherthomas​ ? I'm using FME Server 2021.1.1 Build 21619 - win64 Thanks