A space to discuss FME Flow
Recently active
I have a scheduled workspace that needs to truncate an sde table. The table is shared as aservice in AGS and portal. I see a customtransformer to start/stop the arcgisserver. But if i'm not mistaken this would not remove any locks that are on the sde table. do i need to put this into an automation in order to make all this happen? since i don't see any specific transformers to accomplish this. is it going to have to be through the rest api or python? does anyone have a workflow and or script to do this?I assume i would need to...stop the AGS service (to keep someone from connecting while the rather lengthy trunc/load is happening) then remove the locks (I think i have only heard of doing this through the rest api). run the fme wkspc and truncate then load the new data.restart the service.
I have a server app set up on our implementation of FME Server 2021.2, and users visit the URL to grab the latest export of a database as a CSV. The resulting file is zipped up in a few folder layers which adds a few steps to the process for the end user. Is there a way to have the resulting file be just the CSV to save a few clicks and make life easier for my less tech savvy users?
Hi,I am running a workspace on FME Server and I see that most of the columns have unreadable characters in it after running a workspace. I have not seen this before. Is this because of bad data coming in from the source data file or UTF encoding is an issue, i see duplicate features has been created as well. Any advice to fix this issue would be greatly appreciated. Thank you!
Hi All, I have a strange one i think! Its a simple workspace which takes a Spatial SQL table of property boundaries and reprojects it before writing to a mapinfo tab file. Running the workspace on workbench (same server) gives the correct results, running it on fme server produces a tab file which is from what i can see 99% correct, but muddled up in places. Confirmed Server workspace and Workbench are identicalDeleted server workspace and published from workbench again - same resultsServer job log doesn't give any indications to any issues - features written are sameRestarting server does nothing (Express installation)workbench & server are same version 2022 Heres the weird bit!, if i inspect the tab file after running the workspace on fme server it seems to have swapped the attributes of about 13 spatial features around and muddled them about. Screenshots might give a better idea.Any suggestions are appreciated!
Looking to be able to use the FME Server API to get the text listed in the "Recurrence" column of the Schedules screen (see attached screenshot). Does anyone know if this is possible? Not seeing it when querying fmerest/v3/schedules. Thanks
I have an FFS file with attributes that show inside the FME inspector but I am unable to expose them. Please see the capture for more details. Thank you so much for the help.
How do I configure a scheduled automation to run hourly between 5am and 6pm, every day? Currently I have it running hourly continuously but I would like to free up the Engines outside of business hours. Is this possible? Thanks
In an FME Server App is it possible to disable the 'run' button until the input file is 100% uploaded? If the user presses 'Run' too soon the uploaded file cannot be found by the workspace
We have thousands of workbench that need a round of audit to check whether the workbench contains certain transformers. Is there a way to programmatically check this without having to open the workbench themselves?
FME 2021.2.5.0 (20220331 - Build 21816 - WIN64)Here is a part of the log:2022-07-19 13:45:31| 0.0| 0.0|INFORM|FME Configuration: Command line arguments are `fme' `Utilities\backupConfiguration\backupConfiguration.fmw' `--FME_SHAREDRESOURCE_DATA' `D:/ProgramData/Safe Software/FME Server///resources/data/' `--HULP_Bestanden' `\\FMENT03\D$\FME_SERVER_HULPBESTANDEN' `--FME_SERVER_PORT' `7071' `--FME_SERVER_ROOT' `D:/ProgramData/Safe Software/FME Server//' `--FME_SECURITY_USER' `dwstalk' `--FME_DATA_REPOSITORY' `D:/ProgramData/Safe Software/FME Server///resources/system/temp/upload/' `--FME_ENGINE' `FMENT03_Engine2' `-LOG_FILENAME' `D:/ProgramData/Safe Software/FME Server///resources/logs/engine/current/jobs\70000\job_70459.log' `--FME_SHAREDRESOURCE_ENGINE' `D:/ProgramData/Safe Software/FME Server///resources/engine/' `--BACKUP_DESTINATION' `$(FME_SHAREDRESOURCE_BACKUP)ServerConfigPackage.fsconfig' `--FME_JOB_CONTEXT' `context-id-76a5b5f4-efd6-40e3-b755-e4a875542bed' `--FME_SERVER_WEB_U
I was troubleshooting an FME Automation using CronTAB. 1) I adjusted the Schedule using CronTAB and an error message appearedPS: The message in black background covered the error message 2) Click on the "X" to close the error message and the following appeared3) I tried to rectify the error and started the Automation. Got this Screenshot shown in Step 2 is the bug.FME Server made me believe that the Automation stopped however it was still running in the background.
I have a user that gets an email with an xlsx report in it. the report is not sent directly but is in a url that (i cannot post it here) has ?u=213123&id=3126582175e=12323 I have not determined how or if this url will change with each delivery. The url only changes with the report type. apparently they upload a new file to the same url each week.But this cannot be used with any of the fme server email functions (we had to disable all email to or from fme). The file that is in the link is a simple xlsx so that part i already have working. i am just trying to figure out how to make something work within the parameters of our requirements. So since the url doesn't change I just need a way to read this email and feed this url into the xlsx reader.I have the feed part i think. but when i try to set up something with email it always seems to be dependent upon the internal fme server email system. which we cannot use. the only other method i have found will only read an email attachm
Server Log Error: FME Server 2022.0.0.2 2022-7-19 11:15:03 | AttributeFilter_FAIRWY Disabled Nuker -1 50 (TeeFactory): Feature specification `NO_LOGGING' in mapping file row `FACTORY_DEF * TeeFactory FACTORY_NAME AttributeFilter_FAIRWY Disabled Nuker -1 50 INPUT FEATURE_TYPE AttributeFilter_FAIRWY NO_LOGGING' is not valid -- it has an invalid number of entries
I should know the answer and I should be able to answer it by my self. But the costumer need an answer asap and I think its quicker to get help from this fantastic community with all this amazing brains and experiences. I know that If you have a FME desktop Esri Edition installed and want to write to a SDE och gdb you also need an ArcGIS installation installed for the license. Is it the same requirements as with FME server and are there in that case any way to change a setup file and point to the installed ArcGIS so that you dont need to install the softwares on the same machine?
Using FME(R) 2021.2.5.0 (20220331 - Build 21816 - WIN64) desktop on windows PRO build 2009.1766 65g RAM, 6 cores, experiences massive CPU drain when running a LIDAR density analysis out to raster via the custom transformer as in article - Calculating Point Cloud Density (safe.com)The two step tiler seems to trigger a Windows security scan when using the FME_TEMP directory as FME writes the (many) temporary cache ffs files down to disk when demanding a 1m high res raster result. The security kicks in and the CPU starts skipping up to 80%+ which drags the performance way down on large LIDAR file sets. Setting the raster res lower (10m) doesn't seem to trigger the same issue The FME_TEMP directory cannot be included in the security white list (corporate policy settings only - as each workstation /individual may have a different FME_TEMP location), and therefore although FME and the install directories are white-listed per FME Community (safe.com), the FME_TEMP directory is subject to
Hi Team, we have deployed fme server 2020.1.3.0 version into the linux machine. It is having python 2.7 version. Currently, one of the workspaces requires python 3.0 support. So, Is there any posibility that I can upgrade to the python 3.0 ?
I'm running FME Server in AWS using Aurora PostgreSQL Serverless for the FME Server Database and I check the health of the server by calling the fmerest/v3/healthcheck?textResponse=true&ready=true REST API periodically. Everything runs ok for 24hrs but after that, the health checks start to fail and do not recover again. From the errors logged (below), I think it might be a connection pooling issue. I don't get the same issues on an Express install and there's a line on https://aws.amazon.com/blogs/database/best-practices-for-working-with-amazon-aurora-serverless/ that says "Aurora Serverless closes connections that are older than 24 hours. Make sure that your connection pool refreshes connections frequently.", so I think this might be the cause. I've copied some errors from the logs (can provide full logs if required), am I right in thinking this is caused by Aurora Serverless killing the connections or is this something else? Is there a setting anywhere that will force FME to ref
Hi together, I am working with the SharepointOnlineConnector and was successfully downloading the file to any local directory. However, when trying to download the file from SharePoint to the FME sharedresources temp folder, it doesn't seem to work: When running the workspace on FME Server, it rejects everything Do you know by chance what I am missing here? ThanksFerid
Hi,I'm having an issue using FeatureWriters on FME Server (22350). What I'm trying to do is create a File Geodatabase with a feature writer, then later in the same workspace remove selected features from feature classes in the File Geodatabase that has been created.This works in desktop and as a fmejobsubmitter serivce, but when using the fmedatadownload service the second feature writer throws an error that the featureclass/database does not exist. I assume this is related to how FME Server adjusts the paths for data being created for the data download ZIP file? Both FeatureWriters are linked to the same parameter for the output FGDB.I have tested using a FeatureReader with the same parameter for the FGDB, and it successfully reads from the created FGDB. Is there some parameter or configuration I can use to ensure that both FeatureWriters are using the same path for the FGDB? (I've tried the FME_SHAREDRESOURCE_TEMP but that didn't help). I've attached a simplified
Notes on FME and Esri Versions, doesn't mention ArcGIS Pro 3.0, which is being released soon.https://community.safe.com/s/article/notes-on-fme-and-esri-versions-and-compatibilityCould you advise if 3.0 is support by 2022 and if not when this combability might be implemented?
Basically, I have a workbench that produces a CSV that I want to use in other workbenches and get a result. But There doesn't seem to be a trigger that works for me in this idea. Here is how the automation would look: How can I trigger an automation from the result of the first workbench?How can I transfer the resulting dataset into the automation after the trigger? Thank you,Kevin
Hi, I am trying to set up server 2022 with the load balancer. I have 2 core servers working with shared storage and database. I have a load balancer configured to handle ports 443 and 7070 for engine registration. In our architecture we will not have engines running on the core servers, we will deploy engines on dedicated machines and they will use load balancer URL to connect to the core. When I try to start the engine with FMESERVERHOSTNAME = loadblancer I get the following error. FME 2022.0.1.1 (20220617 - Build 22350 - linux-x64) FME Engine (node locked-crc) Machine host name is: 77286cef6ed1 Operating System: Ubuntu 20.04.4 LTS (Focal Fossa) Copyright (c) 1994 - 2022, Safe Software Inc. Safe Software Inc. INFORM: FME_SHARED_RESOURCE_DIR is unsetINFORM: FME_SHARED_RESOURCE_DIR has been changed and is now '/data/fmeserverdata/resources/engine'FME_INSTANCE_NAME 77286cef6ed1Registering with FME Server on host 'fm
Hello,I am using rest api url = f'{SERVER_URL}/fmerest/v3/transformations/transact/{REPOSITORY}/{WORKSPACE}?longPoll=true' but does not get back resultDatasetDownloadUrl in result class. What went wrong? Regards Gerhard
Hi all,I'm looking for a specific FME version: FME(R) 2019.2.3.1 (20200212 - Build 19823 - WIN64) I'm not able to find it in the past versions section: https://www.safe.com/support/downloads/#past-versions Is it still available somewhere?Thanks
Hi there, I'm having some trouble getting an email trigger to work inside an Automation, which is accessing a Shared Mailbox. I am able to authenticate using my email address/password combination via the same IMAP server details, so can rule out the connection between FME Server and the mail server. When accessing a shared mailbox, what are the correct credentials to use in an IMAP trigger? Typically that mailbox will be shared to users, and not have it's own dedicated password. That makes me think that one of the FME Server System Services is the account which is authenticating with the mailbox, and to use the email account with no password populated inside of the trigger. Is this the case? And which system service would be authenticating with the mailbox? When following this action, I get an error saying 'Invalid Credentials'. Am I right in thinking that one of the system services is acting as the authenticated user to the shared mailbox? Any help would be much appr