General

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.

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?

Hello "Safers" Actually the graph.microsoft.com API seems "broken" (SSL Issue).I can re-authenticate all of my current Web Connections as well as successfully testing the "Managed Services"Not sure what has changed here.FME Server has been configured to use HTTPS, as usual, making use of our enterprise cert. The certificate is fine.Everything was working as intended prior to the upgrade.  Error message:`SharepointOnlineConnector: Could not connect to server. Check that you are connected to the internet and that no firewall is blocking outbound connections. The error was 'HTTPSConnectionPool(host='graph.microsoft.com', port=443): Max retries exceeded with url: /v1.0/sites/molevalleydc.sharepoint.com,3824d824-4277-4293-8bf0-37e0242f40e6,6473e0ea-d0df-4cb7-8269-1cbb5e31d620 (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1002)')))'' ThanksS

Hello, I need to migrate roles and the users linked to it.Does FME Flow automaticaly include the users if I add the role or do I have to import them seperately? 

Hi I am trying to add a engine via a remote engine service FME Flow 23 but the credentials always seem to be rejected, tried with superadmin etc no luck. Any ideas? Many ThanksOliver

Hi, I have a question regarding job cancelling on FME server UI. I have a job running which I would need to cancel during it running. When I select the job and click cancel button, it will cancel job but starting the engine. and all others in the queue will be failed directly.  I would like to know if there is a way that we can cancel running jobs without restarting engine and the next in the queue will be starting to run?  I did realise we could set up "Running Job Expire Time" to cancel job with specific max running time. but I would like to know, if I set it, when it cancel job that over that time, will engine be restart?  Thanks for any advice in advance

We are looking at automated deployment options for publishing to FME Flow/Server via Azure pipelines. Has anyone else carried out any prototyping with the new deployment parameters in 2023? I'm trying to figure out if a 2023 upgrade will be essential to proceeding with automated deployment for us? Or do we go with a small step now in 2022, deploying projects via Azure pipelines and perhaps manually changing the connections in Server (ugly - but a step in the right direction). I've had a look at these posts: Post 1, Post 2These seem to say that there are/were issues with Projects and that hacking was needed to get it up and running. Is this something that will be alleviated with Flow/Server 2023? Thanks,AnnetteStedin, Rotterdam 

I need to build a mobile form to field works. I would like to know if there is a way to filter a dropdown list from another dropdown list. For example: The first dropdown list contains: Fruit and Vegetables and the second one contains: "Apple", "Peach", "Lettuce" and "Tomato". If I select "Fruit" in the first list, the second one only must be shown "Apple" and "Peach". And if I select "Vegetables", only must be shown "Lettuce" and "Tomato". Is it possible to do this?

Hey! I've a problem of a exceelsheets with over 10000 rows. This excel have a bad structure to do routing from a point to an other point. What I want to do is find the shortest path between these points. It's quite easy when you have one to many. But I don't know how to do this many to many logic in the from to builder.  I have attached a workbench and a shapefile that shows the same problem I have but in as a example data.  In this example I need to make the shortest path from all in the column "from" to all area attributes. But I can't find how to build this logic without doing it manually. I've been trying with list but with no success. Can you guys help me?

Having setup an automation on FME server downloading data from an AGOL service, I have to repeat Reauthentication on my login every time data with in the AGOL service has been updated. This does make the automation kind of redundant.. anyone else have had this problem ? and how do I make it go away 😊

Hi!We are using FME Server 2022.1, I am currently dealing with a role-rights concept and have encountered a problem with owner transfer of automations. I consider the following case:User A has a classic Author role and publishes a FMW workspace on the server. An automation is set up for the published workspace, also by user A.User A leaves the company and all items are transferred to a user B with identical rights. User A's account is deleted. This works great for all items tested, just the automation. If you try to execute the automation transferred to user B (time-controlled or by manual trigger) the error message appears: User "User A" does not have Run permissions for repository "XYZ"; the triggered job was skipped. The automation seems to still know the original owner even after transferred ownership - The log also shows: [...] --FME_SECURITY_USER "user A" --FME_SECURITY_ROLES "["user:user A", "testrole", "fmeauthor&q

Is there anyway to change the layout of the FME server console lists? The strings are like pseudo-wrapped and tab delimited which makes the results really difficult to work with. FMEServerConsole> LISTALL_WORKSPACESREPOSITORY     |WORKSPACE     |TITLE       |DESCRIPTION-------------------------------------------------------------------------------Samples      |austinApartments.fm|City of Austin: Apa|          |w         |rtments and other (|          |          |SPATIALITE 2 KML) |-------------------------------------------------------------------------------Samples      |austinDownload.fmw |City of Austin: Dat|          |          |a Download     |-------------------------------------------------------------------------------Samples      |earthquakesextrusio|Earthquakes: GeoJSO|          |n.fmw       |N to KML Diagrams |-------------------------------------------------------------------------------Samples      |easyTranslator.fmw |Generic format tran|          |          |slator 

Is it possible to configure the FME Server / Flow Data Download Service to automatically split large zip files. Ideally I would like zip files that are larger than 4GB to be split into 2GB chunks{name}.z01{name}.z02{name}.zip

How do I find out my username and password for FME server web interface?

Connect to our company LDAP service in the FME Server's Windows Authentication service with the Single Sign On enabled, bring an user from LDAP and assign the user the fmesuperuser or fmeadmin role. But the user gets this error when login with Windows Authentication "you are not authorized to use this web application". Did I miss anything in the configuration of this user?

Hi everyone!In order to reduce increases, we want to move the FME Server in the cloud, currently on the AWS platform, to the Digital Ocean platform.The best options are installation on top of Linux.I know FME will work great with Linux, our problem is that we work continuously with ESRI systems (sde,gdb), and I know it requires an ArcPro or Enterprise license, at least on Windows.Is the situation similar in Linux?I ask, because ArcGis Pro does not have a Linux deployment option.Would appreciate help!Thanks!

Hi, i have a emailer transformer in my workbench.Ik get an error:812023-4-27 10:51:20 | Python Exception <ModuleNotFoundError>: No module named 'fmepy_emailer'822023-4-27 10:51:20 | PythonFactory failed to load python symbol `fmepy_emailer.Emailer'832023-4-27 10:51:20 | Factory proxy not initialized842023-4-27 10:51:20 | Emailer_CALLER (PythonFactory): PythonFactory failed to process feature852023-4-27 10:51:20 | An error has occurred. Check the logfile above for details When i search fme support for a solution is see posts that i should remove some things in de packages etc. But in my packeges there are no files from emailer. I tried removing the root folder(system) bust it came back but still with no emailer packages. Versions of fme workbench and server are the same 2022.1 Can i manualy put fmepy_emailer files in teh map, as so where can ik find the files from workbench.

Hi everyone,We are using this web connection MS Graph Type Application https://hub.safe.com/publishers/supporter/web-connections/microsoft-graph-type-applicationWe have the required details below: - Tenant-ID- Client-ID- Client SecretHowever, this keeps expiring every hour and we have to re-authenticate every time. Screenshot of the expiry time below:Is there a solution to this? There are other articles about Microsoft Graph Teams but the configuration is different.In our configuration, we keep the default setting and I notice the grant_type=client_credentials. 1. Do we need to ask our Cloud team to grant us a refresh token & grant_type = refresh_token?2. Also, do we need to ask them to add the fmeoauth URL to the Redirect URI in the MS Graph App like how we normally do with other Oauth2 App?If these need to be added, should they be mentioned in the hub?Many thanks!

Hi list.I've just upgraded our FME Server from 2020.2.5 to 2022.2.2.I'm still using the 2020 workspaces, and I've noticed a changed behaviour.I did some test with Automation a while back, and thus have some remnant automation output features in some workspaces. In 2020 these worked well, yielding no erros or warnings, but in 2022 a runtime error like this is logged:AUTOMATIONS_2: Server connection error.  Unable to send Event to automation route 'Trin2a': { ..... }Why does this throw an error ?Luckily it doesn't matter in this workspace, but I have used Automation extensively elsewhere (nightly data-imports), so I am concerned about whether my other workspaces, that have active automation logic, will work?Is the error above just a disclaimer that it didn't run in a started automation, and so doesn't have anything connected to my "Trin2a" automation feature output, and warns about it in version 2022 (but not in 2020) ?Any insights about this is welcome.Oh well, I guess I'll see what hap

Hi, we have a process that takes an email with an .xml attachment (generated from a pdf form) and processes the data to SQL. We have an email inbox watch setup to catch any emails that come through. What happens though, is it concatenated the email subject, the xml file name ans the directory path on the server together. But if this all goes over the 255 character limit, the process fails. We have found that some users are adding extra information in the email subject ans this is sometimes taking it over the limit. Is there a way to truncate the email subject before it hits the server and stop it from failing to process?

In a FME Server workspace app, how do I prevent the job from being cancelled if i close the tab or browser before the job has finished? In our case the processing of the job takes a very long time, so I don't want to expect the user to leave the tab open all the time.

Is FME Server 2021.2.0.1 (Build 21789 - win64) compatible with Tomcat 9.0.72? Thanks.

Hello all, Because of this Microsoft notice on e.o.l. for .NET Framework 4.5/6/7 I got questioned of the dependencies of FME Server. A quick search both on the Safe documentation, as on the interweb did not yield a satisfying answer, so I post it here... On which Microsoft .NET components and versions thereof does FME Server depend? Will upgrading to .NET Framework 4.8 break an FME installation? Client asks for an official statement from us, or from Safe Software that upgrading the .NET framework won't cause any issues. [edit]: It involves both FME Server version 2021.1.1 and 2018.1  Kind regards, Martin p.s. I checked the Windows-FME-servers I have access to, and they all have .NET framework 4.8 installed, so I do have my gut-feelings on this subject. Also I would be more than astonished to hear Safe developing newer releases of their product using outdated Microsoft frameworks.Only those things won't convince the client involved.

I am in the process to change FME server from http to https per our cyber security requirements. I am relatively new to the ssl certification installation for web applications. I followed this article to install SSL certificate for FME server. https://community.safe.com/s/article/Using-a-CA-Certificate-with-FME-Server, I obtained a cer file successfully after submitting the CSR string to my company's CA authority. But this command fails to import the certificate for FME server: keytool -import -alias tomcat -keystore tomcat.keystore -trustcacerts -file D:\\FME\\certs\\hou0etgis16\\certnew_base64encoded.cerkeytool error: java.lang.Exception: Failed to establish chain from reply. I tried installing or not installing the root and intermediate certificates using the same cer file, but still the same error for the above command. Any idea? Allen 

Dear Community, I have set up a similar Workbench to this tutorial:https://community.safe.com/s/article/extracting-data-within-a-clipping-polygon Except I am fanning out a JSON files for each feature_type. This seems to work in FME Desktop, however when uploaded to the Server I get the following error when using Data Streaming: 1762023-3-25 15:54:00 | Cannot define schema for 'EXAMPLE_DATA' as the feature does not contain schema information, and schema source is set to 'Schema from Schema Feature'. Please verify writer feature type configuration1772023-3-25 15:54:00 | FME API version of module 'JSON' matches current internal version (3.8 20210302)1782023-3-25 15:54:00 | Writer `JSON_1' of type `JSON' using group definition keyword `JSON_1_DEF'1792023-3-25 15:54:00 | FME API version of module 'JSON' matches current internal version (3.8 20210302)1802023-3-25 15:54:00 | Opening the JSON writer with destination dataset 'D:\ProgramData\Safe Software\FME Server\resources\system\temp\enginer