FME Flow

Hi,I get the following error when trying to turn automations off, on a new install of FME Flow:Unable to disable 'run wb': 929028:SQL Query SELECT ncid, connectionname, connectiontype, servicename, username FROM fme_nc_namedconnections WHERE username IS NULL ORDER BY username DESC failed. Error: Could not find prepared statement with handle 1. I had a look in the forums about a similar error with creating db connections but that doesn't seem to be an issue for me. I also can't run workbenches using the 'Run workspace' screen as I get this error which is most likely tied to our SSL certificates? There was an error submitting the job.This is the reason for the automations - I'm having to trigger jobs through the automation screen to run any jobs Unfortunately I wasn't involved in the setup of this environment but any advice is welcome.  Many thanks, Sam

Hello everyone,I'm currently in the process of learning FME as it's just been introduced into our projects. However, there's not much guidance available at the moment, so I'm hoping to get some help here.I have a specific task involving two values: Owner ID (OID) and associated account (AA). We have our own API service that can provide additional details using the AA. My aim is to make HTTP calls with the AA values while ensuring the control remains based on OID.DATA format example:In simpler terms, when OID is set to 1, I want to input all associated AA values into the caller (one by one of course).However, I've heard that loops aren't generally recommended in FME workflows.Can anyone advise if this is possible within FME, and if so, how I might go about it without resorting to loops?Any insights or guidance would be greatly appreciated.Thank you in advance! 

We have two hosts for a fme server application. One is working fine. But, another host app service was stopping frequently. getting above error for one of the host  

Hi,I have an email attachment automation that downloads attachments to the shared resource folder, but when it is time to run the workspace I get a permission denied error on email.attachments path.FME Flow 2023.2IMAP email with client keyThe automation runs successfully if there is a single attachment and configured to run email.attachment. The problem is email signatures and multiple attachments are present most of the time so I need to run email.attachements to get down to the xlsx I need to load.Why do I get a permissions error on multi file, but not single file?Thanks,Steve

Hi Community, Even After installing ArcGIS Server License in the FME Flow machine, FME Flow Workspace is showing below error“51 2024-4-1 09:23:28 | Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147220952'. The error message from ArcObjects is: {The Product License has not been initialized.}”I had never experienced this issue earlier. What might be the root cause. Any body have an idea, please share your thoughts. So that I can iterate it and solve it. Thanks in Advance.   

We have an automation that has been running more than a month but now stopped working suddenly. It is supposed to read specific emails from the FME inbox. Yesterday it read the email just fine but today the email isn’t recognized and is still unread many hours later. I don’t see any difference between yesterdays email and todays email, they look the same to me. Other email-reading automations have run just fine after this one stopped working.I have tried restarting the automation, resend the mail to the mailbox but nothing works. Anyone have any ideas?

I guess that’s a very easy one, but I can’t find the right answer.I created a gallery app, and the user can provide an email address to receive the results of the run.Unfortunately, while the workspace runs trough, and when staying on the page I get also a working download link for the data, the email is never sent.What I would like to know is, how I should set up the email service on FME Server. I can choose between ‘Automation’ or ‘Notification → Subscription’.The automation keeps me puzzled on what trigger I should use to say a user started the run of a workspace, and please use the provided email address to send the email. The subscription seems to be a bit more straight forward and I would aim for the Email protocol , and set the subscription topic to JOBSUBMITTER_ASYNC_JOB_SUCCESS, but then I am lost in the protocol settings when it comes to the ‘Email To- part, and to know what actually will be in the body of the email.Essentially the only thing I need is a setup that sends an e

I have followed the instructions in the below post to run a workspace from python.https://community.safe.com/s/article/run-an-fme-workspace-from-python-using-fmeworkspacAfter a bit of messing about appending the relevant paths I got the fmeobjects to import but when I try to initiate the FMEWorkspaceRunner class I get 'ERRORFMEException: 1: An error has occurred' with no other details. Extract of code below:import osimport syssys.path.append(r"C:\\Program Files\\ArcGIS\\Data Interoperability for ArcGIS Pro")sys.path.append(r"C:\\Program Files\\ArcGIS\\Data Interoperability for ArcGIS Pro\\fmeobjects\\python39")sys.path.append(r"C:\\Program Files\\ArcGIS\\Data Interoperability for ArcGIS Pro\\python")sys.path.append(r"C:\\Program Files\\ArcGIS\\Data Interoperability for ArcGIS Pro\\python\\python39")os.environ['FME_HOME'] = r"C:\\Program Files\\ArcGIS\\Data Interoperability for ArcGIS Pro"os.environ['CONDA_DLL_SEARCH_

Hello,Does FME have a transformer or does HTTPCaller support Uploading to Sharefile.com.I have setup an HTTPCaller to authenticate then a FeatureRead to get the zip file then an HTTPCaller to POST and upload.  In both cases I get _http_status_code 200 but no upload.Thanks for any help,

Hi,I am very new to FME and thought this would be a good exercise to get my feet wet.However, I am having trouble locating help based on workbooks updates.I have two workbooks named A and B for the example.They both common worksheet names. I want to read both workbooks, identify the common worksheet and update from a specific location from worksheet A to a specific location in worksheet B.Cheers Steve  

Is there a way to include the errors and warnings in an Automation’s log file in an email (external action)? Which Key would this be, or do I need to create a global key that would include this information?

FME Flow 2024.0, we have engines distributed on different boxes.   I would like to remove the Default Queue on Engines on a specific  box.  I did this with FME Server 2022 using Engine assignment rules., but I am o seeing a way to do this with FME Form 2024.0.  There is no existing record for Default under Engine Assignment rules.  Any thoughts ?  

I am trying to create FME Flow backup in order to upgrade it to the newer version.Current version is FME Server 2020.2. I am getting the following error:Tried many times and cleaned drives a bit. Previous backup was about 100 Mb. So it should be more than enough space for the new backup:  What can be wrong, how I can fix this? Thank you in advance.

Has anyone else had problems copying and pasting the Automation Webhook trigger URL? In my case, the URL text is grayed out, although when clicking the clipboard icon the response says, “Copied!”, but nothing is on the clipboard. We are running FME Flow 2023.1.2 Build 23641 - win64.

I want to integrate my Survey123 with FME.I have added a Webhook triggered event and copied/pasted its URL into Survey123.Then, I configured the Log File Added Action to log a message with the format set to 'Message content'.I initiated the automation process. However, upon adding data to the survey and checking the 'view log file', it appears that nothing is being captured by FMEServer.Is there anyone who has same issue or know how to solve it.Thank you so much in advance 

I made a deployment parameter with some email-addresses in but when I use it to send emails I get an error in the automation log, see below. I have commas between the addresses in the parameter. Default Recipients    : deployment.Fel_mail_adresser        <-------this is my parameterSending email with subject "abcd..." to recipient(s) "deployment.Fel_mail_adresser" …An exception occurred. Invalid AddressesFailed to send email.

Is their a file size limit for loading data into the Resources folder?When the file reaches a certain size the file fails to load.Thanks Chris

  Hi I am using FME Server 2021, configured with high availability ( There are 14 engines configured on 2 machinesI have an automation which is triggered by reading a JMS queue. It is configured to run on a specific engine and queue. It is failing intermittently once or twice in a week. But there is no log file created. It says The log file for job ID "xx" does not exist. There is no issue with disk space.In the result data, the status message says ‘Job did not complete’ Any suggestions? Any idea where I can get more information about this issue? 

We have a workspace that ends with a Terminator sometimes. The workspace is run in an automation, but when the workspace stops with the Terminator we don’t get the error email. How is the Terminator ending handled by the automation - is it considered that the workspace has ended ok or failed?Must I send emails in the workspace to get it to work?

Where to find FME Server 2022.x Java API documentation?

I’m asking this question on behalf of a user who’s having trouble posting to the forum… Hello Community,I have recently run into a snag with FME Flow 2023.2.1 Build 23774 -win64We are trying to build an FME Flow using a high availability SQL Server and I am stuck at the last step..I have followed the steps posted on-line https://docs.safe.com/fme/html/FME-Flow/AdminGuide/Changing_Database_Provider.htm and now want to remove the Postgres database dependencieS. Yes there are 2 not just one.I have stopped and disabled the database dependency on the FME Server Core Service as described: https://docs.safe.com/fme/html/FME-Flow/AdminGuide/Removing_Database_Service_Dependency.htmI ran in Administrator command window  sc config "FME Server Core" depend= / It removed that dependency.The question is, there is still a dependency on the database by the FME Server Application Server service. I am sure i will have more questions as I try to complete the process, but let’s start with this one.Thank

We recently upgraded from FME Server v2021 (with Windows Authentication) to FME Flow v2023 (with SAML Authentication) and now receive an FME Flow Error: "Unauthorized request by user due to lack of proper permissions" when attempting to share items (e.g. Automations, Projects, etc.). As a troubleshooting test, my account published a fresh and simple workspace and created a simple automation without any database or web connections, and therefore appears to be the owner of both the workspace and the automation. However, whenever I click the button to share even this simple Automation with another user I receive the "Unauthorized..lack of proper permissions error".  Sharing automations and projects worked prior to the upgrade. Now, we are unable to share any of them, no matter how simple or complex. What might we have missed, or what configuration item should we look into to re-enable the owners of items to share them with others? 

Hello,In FME flow, when I try to share an “automation” using the corresponding button, I get a blank box with the “OK” button greyed out and no ways to share the automation of other users of the fme flow instance.Did I missed something ?  Thanks for your feedback !

Greetings, I created an Automation and when one of the workspaces fail I would like to receive an email that includes in the body the actual text of the error(s) as shown in the screenshot below, not necessarily that format, but at least the text.In the Email (External Action), I added these keys, but when the workspace got an error, I received the vague and cryptic text here in the email body:Error Message: A fatal error has occurred. Check the logfile above for detailsError Type: DeadLetterJob Status: FME_FAILUREJob Status Message: A fatal error has occurred. Check the logfile above for details I would assume that “Error Message” would include something like what is seen in the screenshot.Any ideas how the log file errors can be added to the email body? 

HiI have a long line of text_line_data that contains payment details.I want to save the data to a data or text file but have the body of the data split at every 100 characters and then print the next payment detail so that each persons output is on a new line until there are no more details.I have used string padders to get each attribute and testers to create an attribute containing payment details from 1-100, 100-200, 200-300 etc. which does work but is not dynamic.  Is there an easier way to split text every 100 characters to a new line? Any help/hints would be appreciated.Basically, I’d like to output the following long attribute text_line_data…….1234567890123456789012345678901    00000001234TEXTT EXT TEXTTEX 01234            MR & MRS SMITH     1234567890123456789012345678901    00000001234TEXTT EXT TEXTTEX 01234            MR & MRS SMITH      1234567890123456789012345678901    00000001234TEXTT EXT TEXTTEX 01234            MR & MRS SMITH     1234567890123456789012345678