FME Flow

Hi, I have a oracle database connection on the FME Server, the fme script runs fine from FME server if the connection is used for reading but when I try to write to it, it does not work. From SQL plus on FME server do not have any problem reading or writing. See the error log below: What could be the problem here?Thanks,VijayUsing Oracle Writer to write tables to database `', server type `ORACLE8I', server name `TAMSPROD.WORLD', user name `GEOMEDIA', password `***'Oracle Writer: Starting at transaction 0 with a transaction interval of 1000Loaded module 'OCI' from file 'OCI.dll'Unable to connect to Oracle database, because the database environment could not be initialized.Unable to connect to Oracle database, because the database environment could not be initialized.Destination Feature Type Routing Correlator(RoutingFactory): Unable to connect to Oracle database, because the database environment could not be initialized.=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

We have a single instance of FME Server shared across multiple utilities (i.e, separate finances). We recently purchased an additional engine for one of our utilities, who has been consistently using the engine owned and paid for by another. Even though they now have their own, this utility's users continue to use the engine owned by the other utility, which hoses up that utility's jobs. Is there any way to limit engine access by user so that each utility's users can only see the engine specifically for them?

Please fix this...

We use Cityworks and ESRI softwares for asset management. I am trying to update a date field in the cityworks table using a value from the ESRI SDE table. I get this error: Microsoft SQL Server Non-Spatial Writer: Failed to write a feature of type `azteca.WORKORDERENTITY' to the database. Provider error `(-2147217873) Violation of PRIMARY KEY constraint 'CW_PKEY_521'. Cannot insert duplicate key in object 'azteca.WORKORDERENTITY'. The duplicate key value is (510833).'. SQL Command `UPDATE azteca.[WORKORDERENTITY] SET [ENTITYUID]=?, [OBJECTID]=?, [WARRANTYDATE]=? WHERE [ENTITYUID]=?'This is my workspace:Sorter sorts FacilityID descending. Attribute renamer renames warrantydate to newdate. FeatureMerger joins on entityuid and facilityid. This worked in older versions of FME, Cityworks and SQL. I'm not sure what changed. I've tried different things and continue to get basically the same error stating that it cannot insert a duplicate record. I tr

Hi there,we want to update our FME Server 2016.1 to 2018.1 in the next few weeks. Because of this, the server might be down for a couple of days. Is there a way of informing the users who are logged in to the server? I'm imaging a message of the kind "Due to maintenance work, the server will be down from X to Y"Many thanks in advance and kind regardsThomas

Hi!I'm in a university environment and we've installed FME in two computer labs. Since there are many computers that needs to be licensed through the licensing assistant (we're using floating licenses) I wonder if there is a way to do this process on several computers simultaneously instead of doing it one by one.Thanks in advance!/Henrik

Howdy,In FME Server I have a Notification Subscription that send an email on job failure, I am wondering if there is a simple way to have the emial include the following:Insert text with the name of the schedule that initiated the jobAttach the translation log to the email notification or even better would be to just insert the text of any error messages.From searching the resources I found good info on the Email Subscriber and email keywords but nothing specifically addressing my questions.I did find a solution attaching a log file with a datadownload job but no info related to subscription email.Thank you for the assistance!Currently my email message template looks like this: FME transformation job {id} failed.Workspace: {workspace}Repository: {repository} Request Keyword: {requestKeyword}Time Requested: {timeRequested}Time Started: {timeStarted}Time Finished: {timeFinished} Click here for more details: http://fme:8080/fmeserver/#/job/{id}/summary Log URL: {logUrl}Log Full Path: {log

I know this question has a lot of subjectivity to it, but we are currently working on an enterprise event bus/integration architecture plan and considering FME as a central point in this new architecture. We were wondering if there might be any benchmarks around the throughput capabilities of FME Server/Engines before trying to design and run our own tests.  Obviously, there is a lot of "it depends" in this question, as the complexity of a workspace has a great deal of impact, but any starting points or information would be helpful.Thanks!

Hello.I have a hard time with SLL configuration.I was following this Configuring for HTTPS I finish all steps without any error messages, however, when I try to open FMEServer by using HTTPS I receiving an unsafe window errorI have also edited all files as it was shown in the above-mentioned guidelines. Certificated also were added in the windows trusted certificates list. I am non-SSL guy but can the problem be that the installed certificate cipher suite "AES_128_CBC " is an old version and must be replaced with new "AES-GCM" cipher suite? I have marked the message about this on my unsafe error screenshot.How can I fix this?I am using FMEServer 2019.0 (19212) Beta and Google ChromeThank you for your help in advance. 

Hi FME's World! I'm trying to read emails from Outlook or GMail with my FME Desktop. I found out that it would be possible in Python, would you sugegest to use the PythonCaller or PythonCreator?I found some Python code but FME runs indefinitly at "Emptying factory pipeline".  import email, getpass, imaplib, os detach_dir = '.' # directory where to save attachments (default: current) user = raw_input("email") pwd = getpass.getpass("pwd") # connecting to the gmail imap server m = imaplib.IMAP4_SSL("imap.gmail.com") m.login(user,pwd) m.select("[Gmail]/All Mail") # here you a can choose a mail box like INBOX instead # use m.list() to get all the mailboxes resp, items = m.search(None, "ALL") # you could filter using the IMAP rules here (check http://www.example-code.com/csharp/imap-search-critera.asp) items = items[0].split() # getting the mails id for emailid in items:     resp, data = m.fetch(emailid, "(RFC822)") # fetching the mail, "`(RFC822)`" means "get the whole stuff", but you can a

I cannot find what my current license serial number is to input into the upgraded 2018 FME Server license area. the temporary works for 7 days but want to use the license i had for 2015 server on 2018 server, 

Does anyone know if a "how to" article exists to instruct users how to setup and apply an FME Desktop FME ArcGIS Data Interop Edition licence? A description of how to add the licence to FME and then how to enable the licence over in ArcGIS as well as the requirements to ensure the ESRI Data Interoperability extension is licenced? It feels like something that 'should' exist but I can't find it. I've had a client ask for a reference document and I wanted to forward a link... It appears this might be an oversight from the docs and the KC. In Robyn's 2nd paragraph here she references it https://knowledge.safe.com/questions/21547/arcgis-data-interop-vs-fme-ext-for-arcgis.html.Thanks in advance, Dave

I have a schedule that runs fine using a wildcard to find the source files. Rather than running the workspace every 10 minutes I would like to set up a directory watch (or similar) to trigger the workspace to run.  When creating the subscription I get this error: Unexpected value "$(a)/ServiceOrders/FME/NotificationDefectsExport*.csv" for parameter "value," expected list The issue appears to be using a wildcard in the source file of a subscription.I have tried with both UNC source path and by setting up a resource in FME Server. Permissions are not an issue as the workspace runs fine on a schedule.  

Hello,I'm using FME Server to write data to Smallworld. This works very fine but I encounter a problem.The alternative I'm writing to gets locked by the FME Server user (in the screenshot this user is ). Once the data is written, the alternative can't be accessed in write modus by other users. Therefore posting the loaded data to the upper alternatives isn't possible anymore.Any idea what's the cause of this behaviour? Am I overlooking something when configuring FME Server?Thanks!Luc

Hi,I have a workspace that performs a few tasks and then sends myself an email reporting the results. One email goes to my internal (corporate) email and it's cc'd to an external one (garbage yahoo account) I use for testing.I recently added another stream to the workspace and also want an email report for that one. However, I can't get it to send the external message. The second Emailer is duplicated from the original with only a change to the body text. Emailer 1 still sends both. Emailer 2 sends the internal version but not the external. How can it work in one case and not the other from the same workspace?Thanks Notes: I have also tried using a non duplicated Emailer and swapping the To: with the CC.

Need to get job run time.

HI,I use a FME Server 2016 to run different workbenches. For the update on FME Server 2018 I have to upgrade these workbenches, too.Therefore I upgrade all transformers, which are upgradable. With the dissolver I get some problemes:old workbench:new workbenchIn the new workbench I get less objects then in the old workbench, but the result must be the same.The new dissolver has the addional parameters: Connect Z Mode, Tolerance and Aggregate Handeling.Which are the correct configurations the get the same output like in the old workbench?  Thanks and best regards  

Hi there!When I update a Destination File Copy Folder from a Workbench and I publish it to FME Server, the changes aren't made into the Notifications/Subscriptions. (green arrow)Is it normal? Is it just me? In any case, it's anoying, I've got to do it manually.I have FME Server 2017.1Thanks

I have a workspace that runs on FME server and uses a HTTPCaller to call other workspaces. I haven't used FMEServerJobSubmitter because FMEServerJobSubmitter needs to be set to just one workspace which fixes the set of parameters and I have lots of options for which workspace actually needs to be ran depending on earlier results/settings . I'm using a JSONTemplater to put together instructions for the HTTPCaller to run whichever workspace is needed. The problem is that this uses two engines: the HTTPCaller starts another engine while the original workspace waits for it to complete. Is there any way to have the option of many child workspaces to run and only use one engine like FMEServerJobSubmitter does when there is only one possible child workspace?

When serving to fme server {hostname}/fmeserver it returns with an 404  Server is ubuntu 18.04 Type Status ReportMessage /fmeserverDescription The origin server did not find a current representation for the target resource or is not willing to disclose that one exists.

Is there any official documentation that specifies the encryption specification used by FME desktop to store passwords (e.g. ORACLE connection string passwords)? Specifically what encryption algorithms and keys length combinations are available? Only a few combination are acceptable to the Australian Federal Government. This is required for my organisation security section to sign off on the future use of FME.

Hi,  Does anyone have experience of the Version Control in FME Server 2017.1. Did you have any bugs, Is it fit to put in a production enviroment? Please share your thoughts and experience.  Best/ Johan

I'm having some weird behaviour with my FME server in the Cloud that I could not explain.We are using a server that has three active engines and the following Queue-system:This morning we had a workflow in our production sync queue that took way to many resources and time to process and was aborted. Somehow the server had some problems after (or during/before?) this because all new jobs where not properly handled and all got queued in line. Only engine 2 took was able to start new jobs even tho the other two engines where free and not running. With a unstable and high load as result (20000ms response time and server load of 100) and two engines IDLE. To compare it: Normally our response time is 5ms with an average load of between 0.10 and 0.50.A reboot was needed for the server to stop the load en activate the other 2 engines.Is there any way to prevent this form happening again or a place where i can dig deeper into what could have caused this? 

I'm trying to email a whole department.The emailer works fine with single email addresses and multiple addresses but i can't send an email out to a distribution group.It says it has sent successfully but the email never comes.Any ideas?

Hello FME community,I’m developing a FME service that needs to process a JSON object, uses this JSON as upload body in a HTTPCaller that returns a ZIP file and emails the user a download link to the returned ZIP file.What is working is a POST to datadownload service with a JSON upload body and the email as request parameter:https://<fmeserver>/fmedatadownload/Samples/WritingZip.fmw?SourceDataset=&DestDataset=DownloadZip&opt_showresult=false&opt_servicemode=async&opt_requesteremail=test@test.comWith a subscription at the DATADOWNLOAD_ASYNC_JOB_SUCCESS topic I retrieve the desired mail with the download location using this template:https://<fmeserver>/fmedatadownload/results/{@getFileName(OutputLocation)}However, a developer asked me whether it is possible to integrate the request email in the POST body. Therefore I looked at the FME REST API and tried to POST it to:https://<fmeserver>/fmerest/v3/transformations/submit/Samples/WritingZip.fmw, with upload