Authoring

Hi :)   I have a question - how do you handle errors of workspaces on FME Server (connected to data, or workspace errors not with FME Server)? My question is connected with the fact that none of the final users of scripts published on FME Server are familiar with FME, and that FME Server logfiles aren't that legible, so I would like to write my own error messages that are simple and easy to understand for final users. The perfect solution would be that author of script would be able to write conditional error messages - If this goes wrong send that to user. Is it possible? Do you know how to achieve something like this (or something similar) ?

Hallo everyone,to help my coworkers update some eodatabase, I created a FMW workflow that translates the data from an excel file and that automatically updates the datas in the geodatabase. So far all good, the workspace does his job.In the workspace I had to define two readers, reading basically the same file (excel spreadsheet) to get first some attributes in the "header part" and the rest of the attributes in the "body part". There is only one writer to the geodatabase.Now, I don't have much experience in programming but I'd like to write an small programm (C++? Python?) that allows my coworkers (who dont use FME at all) to select the Source excel file that will udate the attributes in the geodatabase (possibly using a file browser) and the directly run the fme workspace i created. So they'll only need to open the program, browse to the excel file and the fmw workspace will read it and use it to update the geodatabase.Could you please point me in the

I'm using FME to read, modify and write data to a oracle database. My queries are working fine but the following error is popping up for every SQL query .  ERROR |BADNEWS: An error occurred while fetching from query OCI_NO_DATA StatusInfo *STFDB_OCIStatement::fetch(STK_UInt32, STK_UInt32 &)(foundation/framework/util/dbwrap/ocistmt.cpp:661) - StatusInfo *STFDB_OCIStatement::fetch(STK_UInt32, STK_UInt32 &)(foundation/framework/util/dbwrap/ocistmt.cpp:661)What is it complaining about ? instant client or oracle database ?version detailsUsing FME 2019.2.2.0 versionMac OS X VersionOracle database version is '12.1.0.2.0'instantclient_19_3 Any help on this would be appreciated.

Hi,  I have a 2 sets of features, points and lines whith a common project ID (sewerprojects). I have to perform many actions to get my result. In ideal circumstances i could do this immediately on the entire dataset but because it's a collection of data from different projects, there are no unique ID's and some lines and points are duplicates. I wanted to start with the topologybuilder to create correct small networks per project with unique ID's for the point and linesCan i run my whole dataset per project ID and write alle projects to the same writer? I have found a custom looping transformer but i can't figure out how it worksThx!Nathalie 

I am attempting to update the building object in smallworld via an .xlsx doc and am returning the following error after the workbench processes 2630 rows...  Smallworld Translator Error: Object unset does not understand message pressure There is no "pressure" attribute in either the .xlsx or the smallworld building object, so I am confused...  

I have a set of features with name and value attributes that need to be written to a file, but only if certain conditions are met. i.e. one or more of the values meet certain conditions. If one or more of the values satisfies the condition, then all the features need to be written to the file. Is there a way to set conditions on one or more feature, that if satisfied, will allow the entire set of features to be written to a file? Example below:If minimum relative humidity <= 25 or the KBDI > 600, then write all the features to a six features to a file. 

Whenever I run my child workspace by itself I get correct results on my translation written to a SQL Server table.If I run this workspace from its parent workspace I lose attributes coming from a specific output stream going into a featuremerger with multiple suppliers..Top picture is result from child workspace; bottom is if child is ran from a runner. At the bottom I lost values to HTTP response success, FeatureLayerCount and Selected Features.These 3 attributes come from junction 6d: Workflow stats. I added a Feature holder before featuremerger hoping that can solve the issue but it did not.Seeking ideas or anyone who have similar experiences with workspacerunner.Thanks! 

I'm getting this following error while connecting to oracle database and reading shape and metadata from oracle table2020-01-23 14:34:22| 2.1| 0.0|ERROR |BADNEWS: An error occurred while fetching from query `SELECT SDO_VERSION FROM DUAL' : OCI_NO_DATA StatusInfo *STFDB_OCIStatement::fetch(STK_UInt32, STK_UInt32 &)(foundation/framework/util/dbwrap/ocistmt.cpp:661) - StatusInfo *STFDB_OCIStatement::fetch(STK_UInt32, STK_UInt32 &)(foundation/framework/util/dbwrap/ocistmt.cpp:661)For every sql query in the workspace, I get following error message ORA-01002: fetch out of sequence StatusInfo *STFDB_OCIStatement::fetch(STK_UInt32, STK_UInt32 &)(foundation/framework/util/dbwrap/ocistmt.cpp:661) - StatusInfo *STFDB_OCIStatement::fetch(STK_UInt32, STK_UInt32 &)(foundation/framework/util/dbwrap/ocistmt.cpp:661) Query runs fine and fetches result but there are a lot of errors I notice. Is this complaining about Oracle Instant Client ? Any input related on this would be appr

I've just had a support request which reminded me of an issue I had a few months ago using a looping transformer to page through HTTP requests, where I was ending up with more data than expected. The cause was the reusing a list attribute and I'd like the communities opinion on whether this behavior is a bug or just something to be aware of.You can see what is happening with a simple workspace likewhen the _list attribute is reused in the second AttributeSplitter it is not getting cleared before hand so it is retaining the 4 and 5 from the first AttributeSplitter.It's easy to correct once you know what is happening but it can cause some head scratching to debug, particularly in a looping transformer. Should anything that creates a list clear out any existing data first or are their situations were this behavior is wanted?

 Hello guys i am still new ,may be the question is basic but i need help .after i knew which is passed or failed ,i want to make condition now .if passed has output so mergd passed and failed together (i mean i want to have the original input again then connect with multipe transformers to do something but if has only failed and passed has no output , so merge also but go to another multiple transformers to do sth. else .thanks for help

Hi!I have a workspace that I want to stop with a terminator if no features leaves a transformer. I have tried to download the "NoFeaturesTester" transformer from FME Hub but nothing happens when I try bringing it into my workspace. I have downloaded plenty transformers from FME Hub earlier without any problems.

Hi, Goal of this workbench was to be able to expose the property sets attributes of a Civil dwg, without knowing the attribute names. I am only interested in the property sets starting with a fixed prefix. I have started from some python code I found here: python attribute namesTopic is related to:https://knowledge.safe.com/idea/18842/bulkattributeexposer-expose-all-possible-attribute.html https://knowledge.safe.com/questions/32777/how-to-expose-all-attributes-in-generic-way-any-ma.html  Since I don't know the attribute names beforehand, I have to use a dynamic writer. First I was trying to avoid this, since I am not familiar with the dynamic workflow, so I was writing everything to a json string, so that I was able to write all desired output. But now I am trying to use the dynamic writing functionalities.I have 2 questions:1/ the attribute names in the shapefile output are too short (have a length of only 1-3 characters). How can I fix this?2/ Is it possible to put all exposed at

Hello,I'm stuck and I hope someone can nudge/push me in the right direction :-)This is a table where I keep the "Aanschafdatum" (purchase date), "Afschrijftermijn" (depreciation period), "punten" (points), "JarenInGebruik" (Years in use).I want to set the "punten" in the columns 2019, 2020, 2021, 2022, 2023, 2024 and 2025 according to "JarenInGebruik". Here's a little example: Is that possbible? If so, what are the transformers that I can use?Was thinking about AttributeCopier but I can't get my head around the others... TIA-Jonathan

i have name with special characters so i need to select which is containing special characters.NamesÇaõeshLoõeshNaveeõSaÇdaÇNaggattuHigh way 54Local-Street  Select like yellow highlighted data only Note Exclude: Pure numericPure AlphabetsCombination of Alphabets, numeric and Spacescombination of Alphabets, numeric and hi-fen.

for example:TableA has attributeA and keyA. TableB has attributeB and keyB.if keyA is found in keyB, copy attributeA to attributeB. Don't create a new record; just populate attributeB in TableBThere's a 1 to many relationship between TableA and TableB.Does this require multiple transformers and if so which ones and how would they be setup?

I'm running the WSR with 7 concurrent processes. Is there a way to add information to the opend cmd window to identify which window belongs to which processes?I need to terminate from time to time a cmd as it's hanging but I can't identify know which window belongs to which process and I need to guess.In a batch file I would add TITLE parameter in it. Can something similar be set for WSR? Below screenshot shows 7 CMD's but no distinction between them is possible:The provided command is too long to check in the taskmanager. The part to see the difference can't be set on the monitor:

I have a workspace reading a polygon which is buffered and send to several featurereaders that read data from several sources (shapefiles, WFS, dwg,…).Data is selected within this searchpolygon (using a spatial filter in the featurereaders) and the selection is written again using featurewriters.All the summary-ports of the featurewriters are going to a featureholder (from the hub): when all data is read, written and ready a new process of map production starts based on the original polygon.This works very well, except when there is no data to select from a certain datasource/featurereader, then I get this error:2019-12-10 09:54:57| 1.1| 0.0|ERROR |FeatureWriter_11 (WriterFactory): Internal Error: Failed to thin feature table2019-12-10 09:54:57| 1.1| 0.0|ERROR |Internal Error: Failed to thin feature table Is this something buggy or excepted behavior? What is the best way to ‘catch’ this situation and still go on with the map production flow when all other data is written?A simplified w

I've used a method in the past with a WorkspaceRunner to pass a timestamp value into the log file name parameter of a second workspace to ensure that I always get a unique logfile for each rn of the same workspace. But, that's only any good when I can trigger the process in this way. Right now, what I want to be able to do is to use a scripted parameter ideally to generate a unique log file name that is say a concatenation of the workspace name and the start time so like: FMEBatchRun_2014-03-12T12:01:52.log.  Is a scripted parameter the best option for this and if so, can anyone help me with the syntax as I'm not much good (any good really) at writing python...  Thanks, Dave

In FME Server 2019 + a new feature 'Automations' was introduced. Among other things this features allows you to create Schedules, however the Schedules only page still exists as well. After a successful restore should I convert all my existing Schedules into Automations? Moving forward how do I decide when I should be using the Schedules page vs building an Automation?

Hi Everyone,We are trying to execute FME workspaces in batches of eight in parallel to avoid license limit issue. The requests are received dynamically above 8 by a java/ python program but the processing should be done in batches of 8 always. Ideally the requests above 8 should go in queue and wait for the last batch of 8 to finish.

attribute transfer from input to another input ? two input no public attribute?how to do ?

Hello, I have the following question: I would like to automate a process that involves running an ArcGIS Python script and then 5 FME workspaces. I thought about doing this with 6 workspaces, which I call using the WorkspaceRunner. For this to work, I would have to use the ArcGIS Python interpreter for the first workspace and after that the FME Python interpreter. Is it possible to set this as an option in each Workspace? I know it is possible to change the standard Python interpreter in the FME Options, but is it also possible to define it separately in different FMW files?Thanks a lot for your help in advance!

The attached workspace contains of two parts. In part 1 I transform an excel document which contains many records of clients and products. Some clients have had only one product, others might have had 10. The result is also an excel document in which each client has only one row. In the row the order of al te products is displayed in time starting with the first product and ending with the last product (in time).In part 2 some checks are done on the data. For example some products of the same categorie may not be handed out within a short time period. The workspace does the trick, but is quite slow. I think things could be made more efficient using loops. I've done some research on the internet but can't find the solution yet. Any help would be appreciated.

I'm looking for ideas to help me get around a problem with hanging FME Process. I've found (at least one case) where FME is hanging with a difficult geometry - I've tried a few things to fix the geometry, however, I haven't had much luck (I'm going to pass it on to support for them to look at).The process is being called web API and it's expecting a response back when completed, either failed or successful - I am just using Fail topic to send back a response.  I decided to add in a 'tm_ttc' directive to make the job timeout instead of running forever. It works great, however, now the Failure topic isn't getting triggered and I can't let the tool know to wait for a response. It's the same when the job is canceled manually from the FME Server web ui.  Any ideas on this one? Cheers

I thought I would check here first to see if anyone has seen this issue - before I log it with support.The Column Aligned Text (CAT) reader embedded in a Feature Reader is missing the fme_dataset and fme_basename attributes - even though they are specifically exposed. I am using FME Desktop version 2019.2 (build 19801 – WIN32).This was working fine in the last version of 2018.Thanks in advance.Mike B.