- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Authoring

Authoring

Creating and organizing workspaces. How to use Workbench.

3,047 Posts
12,630 Replies

When you subscribe we will email you when there is a new topic in this category

3047 Posts

FME Workbench open ASC file: APIC.DLL was found but could not be loaded

Hi FME Workbench doesn't work on one of our computer. He crash when a user try to use à ASC file. We has been try to reinstall FME but nothing change. On all other computer FME work fine, and they are all install with the same package. If anyone have a idea :) Thanks. Crash log: Commencer le traitement…FME 2017.1.2.1 (***** – Build 17725 – WIN64)FME Desktop professional Edition (floating)Permanent License.Machine host name is : ******Operating System : Microsoft Windows 8.1 64-bit (Build 9600) Creating reader for format : Apic Exchange Format (ASC)Trying to find a BUILTIN plugin for reader named ‘APIC’Trying to find a DYNAMIC plugin for reader named ‘APIC’Library ‘ourAPPVpath\\FME\\APIC.DLL ‘ was found but could not be loaded. Ensure that all the dependent modules exist for this library.This FME edition does not recognize the ‘APIC’ reader. Please ensure that the current platform supports this reader, the reader name is spelled correctly, and that you have installed all required pl

Bulk Renaming of Attributes from External Lookup Table

Hi- I have a lookup table I'd love to FeatureJoin in somehow, to rename the original columns to what's shown in my external lookup table. Unfortunately there is no predictable pattern to the renaming, so I can't realistically use BulkAttributeRenamer to do a pattern/rules-based renaming. . and at 118 columns, am hoping not to have to use AttributeManager or AttributeRenamer addressing each column manually. Any suggestions for using an external lookup table to do this? Thanks in advance!

Capture and Log Python Caller Errors?

In my workbench, all "Not Merged" / "Rejected" paths etc, redirect to a FeatureWriter that logs errors to the database.However, the PythonCaller only has the "Output" path - how would I capture and log these exceptions?Could I do something like this?Update PythonCaller to Catch the Exception and store detail in an Attribute (don't raise exception) try: ...except: feature.setAttribute("Error", sys.exc_info()[0])Use Tester to check if Error Message existsFork based on Error contentsWire-up to exception-logging path

Error retrieving connections

I've been having trouble with FME 2018 and database connections. I don't want to move to 2019 because my company's FME server is 2018. FME 2018 build 18552 works on my other machine which has previous versions of FME installed. I've been working with a previous post with no success: https://knowledge.safe.com/articles/65806/workarounds-to-known-issues-in-fme-2018x.htmlAny other ideas?

750

5 years ago

dave29Contributor

asked in Authoring

Pass job_id from one workspace to another

I have a scheduled workspace running in FME Server. Upon success or failure, it posts to the same topic that runs another workspace. This workspace uses the FMEServerLogFileRetriever to pull the Feature Written Summary and then uses the FMEServerNotifier to run another topic that sends an email with the Feature Written Summary as the content. Right now, I'm querying the last job_id run in the fme_job_history to get the info. But, if more that one job runs at the same time, the logic gets a little fuzzy. It would be better if I could just pass the job_id from one workspace to the next. Is this possible?

FME Server Upgrade and Job Logs

Hello FME CommunityWe are currently doing an FME Server upgrade and I would like to confirm an assumption - I haven't found this information on the forum or documentation yet, so it may have been implied already.I am wondering if we can upgrade and keep our old Job history / logs from the old version? (We are currently running 2016, and upgrading to 2018)Since the Backup / Restore didn't restore job logs to our Test server, and it also wouldn't make sense if old Job IDs are duplicated in the new system, I'm assuming that they will not be saved automatically.Thanks!Ray

Need Help ,Planning to use FME for Decision Tree

We have excel sheet with so many mappings ,Users will provide 3 inputs and based on the mappings it will generate 2 outputs. Please let me know if FME can be used for the above task ? Thanks! Regards,Vighnesh

5 years ago

mdaContributor

asked in Authoring

Web connection between FME and opentext content server

I am try to make a web connection between FME and OptenText Content Server. But still don't succeed. The thing is, I need to get data from the content server using REST API then manuplate it in FME. This link is to the Content server API references ( https://developer.opentext.com/webaccess/#url=%2Fawd%2Fresources%2Fapis%2Fcs-rest-api-for-cs-16&tab=501 ). Did anyone of you guys make this connection or can give me hints on what should I do?

FME Server published parameter file naming

I have a workspace with a published parameter setup to receive a name from the user that is then appended to the file name in an Excel writer. It works just fine in FME desktop, but when the workspace is published on FME Server it doesn't.In the writer destination file I have ./Filename_$(value).xlsxIf I set the value parameter to "apples" FME Desktop generates a file named Filename_apples.xlsxFME Server creates a file named Filename_$(value).xlsxDo I need to use escape characters or something to force FME Server to use my parameter?FYI I'm using FME Server 2018.0 and publishing using the same version of FME Desktop.Not a critical issue, but I'm curious why it's not working.Thanks

250

5 years ago

fmelizardContributor

asked in Authoring

How do you manage hundreds of Database Connections to SQL Server databases?

I'm wondering how others go about managing FME's Database Connections in their environment. Imagine you have hundreds of SQL Server databases. Most are named users... some are Windows Users. Passwords are changed from time to time and this presents a problem for managing the named users. One solution is to have one domain service account that can access all the different databases (on different servers, with different instances, and then the database specific permissions for this user). This is a heavy task for the DBA to set up but once it is set up, authentication from the FME engine takes care of itself and the FME admin doesn't have to manage the connections for the purpose of password changes.The other way is for the FME Admin to manage the changing passwords inside of FME's Database Connections command. This is a daunting task when dealing with more than 200 databases. Are there other ways you can think of to managed changing passwords related to named data

100

5 years ago

Anonymous

asked in Authoring

Unicode for Python Caller

I have a unicode string that looks like:Lat: 49Â° 16.578', Lng: -123Â° 7.3'In a standalone Python script I can find the unicode characters by putting this at the top of my script:# -*- coding: utf-8 -*-However, this doesn't work in the PythonCaller. Is there a way to do this?

filecopy writer creating empty folder in same location as fmw workspace

I have a PATH reader reading in a folder named base which contains a folder named folder1 that contains some txt files. I have a filecopy writer containing the location where I MOVE folder1 to. I have an attributecreator to modify the filecopy_dest_datase attribute to folder1_datetime.Each time I run the workspace, the folder1 and its contents are moved to the new location named folder1_datetime - looking good. The problem: an empty folder named folder1_datetime is created in the same location as the fme workspace .fmw file. Why is this empty folder created in the location of my workspace?Thanks,Alex

I am trying to delete features from two SDE feature classes using a list from a spreadsheet.

I am trying to delete features from two SDE feature classes using a list from a spreadsheet. One table works the other one does not. I have tried both a feature writer and an SDE writer. I get an access denied error. I have even used the schema owner and still get the access denied error. The transaction type is set to versioned edit session. Any idea as to what I am missing?

FME server GUI issue while running services: "There was an error submitting the job."

Hello FME community,In order to configure HTTPS we followed the steps in the admin guide at http://docs.safe.com/fme/html/FME_Server_Documentation/Content/AdminGuide/configuring_for_https.htm. After this configuration we get an error on running services with the GUI button: "There was an error submitting the job." We've looked at the following troubleshooting guide: https://knowledge.safe.com/articles/49624/fme-server-and-https-troubleshooting-guide.html, however we couldn't explain the error message. Does anyone know a solution for this error message?

Compare two separate excel files and report on matched and unmatched column name

I have several excel files(from customer) which needs to be validated with source/master excel files which have the appropriate/correct column names - how can we match the excel file(from customer) column names with source/master excel file and report on matched and unmatched(incorrect) column names

jatoxaContributor

Hi, I'm trying to connect to a WMS that serves GeoTIFF via FeatureReader. However I get the following error when I input a clipper geometry. "<WMS> Exception detected for the GetMap operation, requested Content-Type, 'image/png', returned Content-Type, ''. This is the URL I use for the WMS. I know the MIME type says image/png here, but it doesn't make any difference what I put in the FeatureReader and the documentation expressively states that the WMS provides GeoTIFF http://xxxxxxxx.xxxxx.dk/dhm?ignoreillegallayers=TRUE&transparent=TRUE&REQUEST=GetMap&SERVICE=WMS&VERSION=1.1.1&LAYERS=dhm_overflade&STYLES=&FORMAT=image/png&BGCOLOR=0xFFF Thanks /Jacob

120

5 years ago

f.kemminjeContributor

asked in Authoring

fmeserver job submitter skips some job in between

Hi Team, I am experiencing some weird behavior from fmeserver job submitter. I am running some batch of jobs from master script that triggers child script which is sitting on fme server.I used fmeserverjob submitter. Fme serverjob submitter skips some batches in between.(it takes two or three jobs and 4th one rejects) The feature comes out from rejected port. fme says The reason is ' '(NULL). But the same list/batch(job) when I send again, it runs without any problem. So its clear that there is no data error. I think fme server sometimes not responding to request... or may be busy... in running other jobs... or something like that… But NO PROBLEM with the work space runner. It runs continuously for all the batches(jobs) without any error.Error msg is FMEServerJobSubmitter(ServerFactory): http://gisfme-po-a0p:8080 - Failed to submit request to run workspace 'STORM_EGIS_FIBER_HUBTRACE_CHILD.fmw' in repository 'ETL_STORM_EGIS'FMEServerJobSubmitter(ServerFactory):

Maintain Source Raster File Name after converting to polygon

Hello,I am trying to maintain the source Raster name as an attribute that can be linked to the destination polygons once I have run a mosaic on all the rasters and converted them to polygons.I have tried to generate a list on the RasterMosaicker, but still can't maintain the attribute.Any ideas would be helpfulThanksFrank

How to change published parameter value after run time

I think this is simple. I am running FME 2011. I would like to change the value of a published parameter during a translation (i.e. overide what was set at run time). Since i use a parameter fetcher in many locations of my workbench, i only want to change this in one location at the start of my translation based on a set of other criterial. I tried to use an attribute setter set $(PublishedParameterName) = New Value however this did not work. My workaround is to use variable setter / retriever however i would prefer not to do this. Thanks in advance.

FeatureReader Timeout with the parameter Height and With over 4000

I want to create a high-resolution image from the WMS. If I set the parameters Height and With to 4000 it works well. With the value 5000 I get a time out. "HTTP/FTP transfer error: 'Timeout was reached' " In the WFS-FeatureReader is a parameter, where I can define the timeout. I can't find one in WMS-Reader. I am looking forward to here from you. Heike

280

5 years ago

samisnunuContributor

asked in Authoring

Reverse attributes values

This looks simple to do, but I had to use 2 BulkAttributeRenamer, 2 Counter, then a FeatureJoinerfor example, the below attributes values need to be flipped as the FROM_xx to be TO_xx as shown:Source attributes:FROM_X | FROM_Y| FROM_Z | TO_X | TO_Y |TO_Z1|2|3|4|5|6 Output attributes:FROM_X | FROM_Y| FROM_Z | TO_X | TO_Y |TO_Z4|5|6|1|2|3Is there a better way to do it?

Database Connection Failure

I was recently was upgraded to Windows 10 on my 2 work machines. I previously ran FME build 18590 32 bit on my old WIndows 7 machines. When I got my new machines I exported my old Oracle database connection. I successfully imported it to one of my new machines, but the same connection gives me an error on the other machine. Any idea what could be wrong? A side note, when these machines were built by IT, they installed FME 2017, which I uninstalled and deleted all associated files on C drive before installing build 18590 32 bit. Obviously there is something preventing one of the new Windows 10 machines from connecting to Oracle. Below is a screenshot of the error message. Any idea what could be preventing this machine from connecting?Thanks,Dylan

5 years ago

hannesfpaulin

asked in Authoring

Featurereader missing Envelope Intersect after upgrade FME server 2015 --> 2018

A script created in FME 2015 is crashing in 2018 due to a Featurereader. I have tried to upgrade the transformer according to FME 2018 version. But the spatial filter options are different. There is no option called ENVELOPE INTERSECT. And I get the same rejection message, see text below. I have tried all possible spatial options but none corresponds to the envelope intersect. How do I handle this? <ows:ExceptionReport version="1.1.0=" language="en=" xmlns:ows="http://www.opengis.net/ows="><ows:Exception exceptionCode="NoApplicableCode="><ows:ExceptionText>The operation was attempted on an empty geometry.</ows:ExceptionText></ows:Exception></ows:ExceptionReport>Received error report: ExceptionReportThe XML Module halted on error, see the logfile for detailsA fatal error has occurred. Check the logfile above for details

200

5 years ago

markcoopersdcContributor

asked in Authoring

run 2 workspaces using workspace runner

Hi I have two workbenches that I want to run - the three output files from the first workbench are used in the second, albeit later on in the translation, so the first needs to complete before the second runs.I have created a new workbennch and added a workspace runner to run the first process and a second to run the second workbench (after first is successful). However, the first workspace runner needs an input and I have no idea what to use- all I want it to do is run the two existing workbenches one after the other. Can it not work like that? If not is there another way I can run the two, ensuring the first finishes before the second starts? Thanks

Error retrieving connections

In Build 18590 32 bit I am getting the error retrieving connections message when attempting to establish web or database connections. I am on Windows 10 and this is a new install of FME but I had FME 2017 64 bit previously installed on this machine temporarily but never used it.

280

5 years ago

Page 49 / 122

Badge winners

scarborough123has earned the badge English Speaker
sigbetshas earned the badge Welcome Back
havermhas earned the badge Student (Grey)
muhammadsambe0has earned the badge Teacher (Grey)
scarborough123has earned the badge Welcome Back

Show all badges

30,394: Posts

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

A product of

Company Products Giving Back Careers Contact Privacy Feedback

Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.