Automation

Hello :) I have some workbenches on the FME Server 2022 and I get for all of them the error:2024-12-11 13:37:46 | java.sql.SQLException: Query failed (#20241211_123746_28965_mxxee): Unknown transaction ID: f6d2afb3-c2fa-4417-970c-375bf47d1c9f. Possibly expired? Commands ignored until end of transaction blockIs that something I can fix or is it a Server error that only admins can fix? It is some time ago I was running the workbench. I tested one on my Laptop for a small country and it went good. all other countries are too big that is why I choose the FME Server. Any suggestions of what I can do?Vanessa

We are running into issues with the user parameter file inputs for Automation Apps.  In this case our end user wants to upload a new csv file every time they run the automation app, and they want to upload it from their local computer/machine.  Right now the only way to accept this user input is to have the csv file uploaded to a data store in FME Server, prior to selecting it as a user parameter, and then running the automation app.  We noticed that this problem doesn't happen for workspace applications and they can upload local files directly as the end user, with no need to upload it to the data store in fme server prior.  Is it possible to have our end user run an automation app and upload the user parameter directly from their local machine?

I have a flow automation runs every 5 minutes, and will send out a notification email if a job failed. That becomes an issue if a problem that caused the job to fail hasn’t been resolved soon since the automation will continue to send out error email every 5 minutes.Is there any way to stop sending email after e.g. 10 emails or to reduce the frequency for sending error emails? I still want the automation to run every 5 minutes, even some job failed, but want to get just reasonable amount of error emails. 

Hello everyone-Hoping that someone may be able to help with this question!Is there a way to provide a specific required JSON Response body (for example:  {“status”:”OPERATION_OK}  ) to a 3rd party application in response to a successful post to an FME Flow Automation with a Webhook trigger? I feel like I’m missing something obvious here….Any help would be greatly appreciated!Mike

I have looked at this: https://knowledge.safe.com/articles/678/create-a-custom-download-link-for-results-from-dat.htmlI want to be able to set the exact-filename of the zip-file within FME Workbench for the download service. Si instead of the URL like this: http://fmeserver/fmedatadownload/FME_2D764B0C_1515155526785_73956.zipI want to be able to define a parameter in a workspace called:ZIPFILENAME = myfilename.zipSo the Datadownloadservice serves the file:http://fmeserver/fmedatadownload/myfilename.zipIn other workspaces I will have completely different zip-filenames.Any way to do this? I manage to create all the da

Hi there,Successfully created an FME Flow Automation App (2023.1.1.1) that allows the user to upload files. However the customer doesn’t like the fact that the + Enter URL/Path link is shown.Where are the webpages stored on FME Flow? Can the html be modified to hide this link?

Hi all, We currently use imap to connect to office365. The FME Imap process currrently uses basic auth which will be disabled my Microsoft in October this year.  I understand that imap with Office365 will still work, but only with modern auth OAuth2. Does anyone have any experience with how to enable Oauth2 for FME IMAP, and can run thorugh how to do this. Thanks,

Hi everybody! How can I fix the HTTP run time error? We have Publication that monitors and email Inbox.  A service request on Cityworks is created when an email is received with a GIFF attachment. SR created should have the GIFF attachment but it randomly fails to attach the GIFF for some SRs. And gives HTTP time out error. I have checked the API calls and they look good in Postman. I checked with my network team as well, no issue on that side either. The log file indicates that it is 401 error- but Authentication is also intact as other SRs gets created successfully with GIFF attached. Please see the image below for errors. Any insights is highly appreciated. Thank you!  

Hi everyone,I am having an Issue which is hard to provoke (because it dies not happen always) and our FME support is also not getting further.We are experiencing in FME Form und Flow Version 1.2.1 in Test and Production Environment that the Workspaces with Esri Writer (after our own analysis) are failing. Also after our analysis I changed the option from persistent connection from no to yes and also installed ArcGIS Pro 3.3.2 only on test Environment.On Test Environment I have Oracle 19.24 and on Productive 19.21. with Spatial Addon and when it occurs both are sending an exception (ORA-24550: signal received: Unhandled exception: Code=c0000005 Flags=0) and FMEEngine.exe and Form exe is shutting down with Kernel Failure (windows server 2022 VM).Talked with Windows server Team - they are saying it is FME Issue caused.Talked with DB Admins - they are saying it is FME Application Issue.Talked with FME Support - they are saying it is Oracle.

We have recently upgraded FME flow to the latest 2023.2.2. I am having difficulty locating runtime errors for the job because when you click these runtime errors it will take you to the logs section where you have multiple logs. It's difficult to find which log file has this error. Previous versions directly took you to the error description while this version is not. Please guide me if I am doing anything wrong.Thank you, 

I have workspaces that are run from a job submitter in an automation. Is there away to kick off another workspace if it fails? I want to send an SQS message back to our SQS Queue with success or failure messaging. The successful message is easy but I can’t figure out how to send a failure message unless it fails though a specific transformer. 

HiIn our recent webinar about streamlining metadata automation we got a survey question which showed I didn’t make the functionality clear:“I am not seeing how this will help.  We have over 500 different layers, the bulk example showed over a hundred layers being updated but they were all the exact same layer, which is a situation in my opinion that doesn't exist for most people.”My demo indeed showed 145 portal items of the same type having their metadata updated according to some admittedly bogus business rules.  I failed to make the point that any number of any item type could be handled.  For example if contact detail changes meant a phone number or email contact needed to be changed you might search all items for the string to replace, or if you knew only shared items of a particu

I’m new to FME tool and I wanted to pull data from Google BigQuery tables and convert into GeoDatabase and shapefile. I'm using FME Workbench version 2024.1.1 and I'm experiencing an issue with using Google BigQuery as a reader. But I’ve installed Google BigQuery as a transformer and attempted to pull data, but no data is being retrieved. I’ve also authenticated using a service account key file, but the data still isn’t showing up.

I have an Automation on FME Server, which runs a workbench and that workbench runs a SystemCaller which runs a python script.Occasionally, the python script fails to run, and I want this failure to be recognised by the Automation, so that it sends me an email stating that it has failed.How do I do this?I can see how to set up the SystemCaller so that the Output Exit Code Attribute has a value of nonzero (representing failure)But how does this trigger the workbench to fail inside the Automation?I need the Automation to recognise the failure event so that it can generate an email stating that.

Hello,I have a question on the automatic rotation of 3D objects with FME. First I placed my 3D object on different points with the workflow explained in the following tutorial: https://support.safe.com/hc/en-us/articles/25407425765133-Creating-and-Using-Geometry-Instances. Now I want to rotate the 3D objetcs (electric poles railway) in the direction of a 2D Polyline (rail axis). Is there a possibility to rotate the 3D poles rectangular to the rail axis? Best regardsEric

I am on FME Server 2022.2.8, and I have a quite big automation where the workspaces communicate through json messages. Now I have been able to replicate a crash in too machines, but I haven’t been able to isolate the exact problems. I think it might be related to https://support.safe.com/hc/en-us/articles/25407442818189-Known-Issue-FME-Server-Core-java-lang-OutOfMemoryError-Java-heap-spaceIf I start processing that involves some 100 workspaces queued and running with quite long json messages the rest api stops responding eventually (about 30 minutes in, returning 500 errors). Processing seems to continue and automation is running fine, the Server ui seems ok (I think it is relying on REST API v4).Restarting the FME (or the server) does not help the problem, but cleaning up r

 In a experimental environment I have set FME server in a machine with ArcGIS Pro. (I want to verify some expected behaviors in FME Server, with out the trouble to install ArcGIS Server)It has ArcGIS Pro 3.1.3, As the document https://support.safe.com/hc/en-us/articles/25407724093837-Notes-on-FME-and-Esri-Versions-and-Compatibility states: When I try to run the workspace, it fails, and do not even creates a log file. In the fmeprocessmonitorinengine.log I find this: Wed-13-Nov-2024 03:44:01.898 PM INFORM Thread-19972 ALGTRCPIMSDM01_Engine1 Translation Finished (service '7070'). Return message is '

Hi,I am trying to trigger an action on FME Flow when a new file geodatabase is added to my network. So I set up a Network or Resource directory trigger to monitor for CREATE events, but when I test it it fires once for each of the files contained in my geodatabase, or about 70 times.Ultimately I want to receive the path to the geodatabase in the File Path automation attribute, in just one trigger. Any suggestions are appreciated, thanks. 

In the ‘Run Workspace Dialog, there is a ‘Log Debug’ option under ‘Advanced’ settings here:  Why isn’t there an option to enable this ‘Log Debug’ in Automations when configuring the ‘Action>Run Workspace’ interface? I need debug logging details to run my automation in ‘production’ mode. It’s not honoring the logging setting when I published from FME Form. Shouldn’t the option be here:  My ultimate goal is to have log files from workspaces ran within Automation have full debug logging enabled.Is there some setting in a config file I can change?Version: FME Form/Flow 2024.1.1.0 (Build 24619)

Disregard...found issue

Hi We have recenly started using FME Flow more. When someone runs a flow app no log file is created. However, if the admin user logs onto the web interface and they run the app again (on the same or different pc), a log file is created. Is this expected behaviour? If not, does anyone know how to get round this? Thanks  

HelloI have a Workspace App in dev phase. Since I cannot embed a HTML page by design or make use of dynamic user parameters to retrieve an event ID for now,  I went with the idea of using a URL / Link within the description box, (Markdown style).URL points to SP OnlineI’d like to implement target=”blank”.[link](url){:target="_blank"} (Kramdown)Is this possible? ThanksSameer

Hello, I am needing some help quickly. I am trying to create a FME Flow Automation that passes 3 attributes to the email action. The attributes are all created inside the workbench using the FME Flow Automation Writer. Each one of the attributes passes the From, To and CC data for the email action. When I run the automation, nothing comes out and the log file says the below message. I honestly have no idea why this is not working. I have looked up many resources on this site to get this to work, but i keep getting the same message. I know there is a value, why is it not working. 65 2024-10-29 07:58:41 | PermitData: Attribute name is empty for value expression ''. Ignoring expression since unable to create a blank attribute name

I’ve been running a script on FLOW for months that unzips and deploys apps to an IIS web server by copying them to the wwwroot folder. If the app already exists and needs updating, the script backs up the existing folder, deletes it, and then deploys the new version. However, about two weeks ago, it stopped working because the Python function in the Python caller can’t delete and replace the existing directories.I have admin permissions to the wwwroot folder, and the workbench runs correctly from my computer. But when it runs from FLOW as the application account, it fails. The app account has the same permissions on the wwwroot folder as I do, and both accounts are in the admin group.I suspect a Windows update or a policy change might be causing this issue.Any ideas?

This is my first time using the SFTP External Action in an Automation. I have previously used the FTPCaller Transformer in FME Form, but sometimes it gives an SSH error. The SSH error has occurred 2x over the past 6 months. Safe Tech Support tells me it is a generic error for which they cannot find a fix.  Consequently, I am looking to use SFTP External Action in my Automation that previously used a FME Form workspace to upload to the SFTP.  Questions about the SFTP External Action Details in Automation:Source Path includes the path and the file name (myspreadsheet.xlsx); Is it ok to add the name of the source file in the Source Path? Destination Path includes the path and the file name (myspreadsheet.xlsx); Is it ok to add the name of the destination file in the Destination Path? Is it correct to assume that Destination Path is the same as the Transfer URL in the FTPCaller Parameters in FME Form? The SFTP site has a password