Authoring

I have created schedules / tasks in Windows Task Scheduler and specified for them to 'Run whether user is logged on or not'. They run without issue in FME Workbench, or if I set the schedule / task to 'Run only when user is logged on'. What's going on here?I looked at the workspace log and it contains errors connecting to the database similar to below, but I have verified that my credentials are correct:38. 2016-10-05 10:00:58| 1.8| 0.0|INFORM|Microsoft SQL Server Non-Spatial Reader: Read 1 DEF line(s). Found 0 attribute(s)  39. 2016-10-05 10:00:58| 1.8| 0.0|INFORM|Microsoft SQL Server Non-Spatial Reader: Opening `TABLE' for read operation  40. 2016-10-05 10:00:58| 1.8| 0.0|INFORM|Microsoft SQL Server Non-Spatial Reader: Trying to connect using SQL Server 2012 Native Client...  41. 2016-10-05 10:00:58| 1.9| 0.1|ERROR |Microsoft SQL Server Non-Spatial Reader: Failed to connect using SQL Server 2012 Native Client. Provider error '(-2147217843) Inv

This question is related to this earlier post on handling several CSV files output to the server shared data directory: https://knowledge.safe.com/questions/79707/fme-cloud-workflow-for-moving-media-zip-files-betw.html@GerhardAtSafe has greatly helped me with several aspects and I'm continuing to research and learn what I can, but I'm having trouble figuring out the best way to handle multiple CSV files output to a single directory under the shared data directory on server. Not all the CSV files will be written on the scheduled jobs, and the number of separate CSVs that could be written is between 0-23 files. These are output from a series of jobs that run on a weekly schedule to update tables in a PostGIS database.I want to use these CSV files to trigger a job which parses media pulls from an S3 bucket, zips that up and pushes to another S3 bucket or UNC path. The problem I'm struggling with is how to read each of these CSV files individually in order to select the correct

I am having a problem lately with DB connection issues. I tried looking for cases related to "QSConnectionLostConnection" but this seems to be undocumented. There's 2 scenarios where this issue occurs. I'm not sure if they're related but they share some commonalities:They seem to only occurr on the secondary server host, "alttrans02".They occur at different points of the translation.The problem is gone when re-running the translation. 1. Reading from DB: Please refer to job_20627 and job_21289 logs.These end in failure but under FME Server console, it's still "running" and I have to manually cancel them. If the job is still "running" and I rerun the translation, the second job also fails at the same spot in the translation and ends up in the same "running" status.I only have server logs for the second job - please see ALTTRANS01_fmeserver_2018-09-27_064438.2. Writing to DB: Please refer to job_20836 log.EnvironmentFME Wo

I get the following error when trying to add a named connection in FME 2016.1.2.1 on Ubuntu 18.04 The Java library 'jvm' could not be located or loaded. Ensure Java has been installed through the FME installer to FME_HOME/jre and re-install FME if necessary.I do not get the error on FME 2018, but I need to use FME 2016.Does anyone know what the solution might be?

I need to update 5184 rows in a Postgres table. These lines have a code and this code is linked directly to another table that uses this code. What would be the best way to update table 1 and after this update, update table 2 using the code I updated in table 1?Thank you

Can I configure multiple Datum shifts (both CANADA US) in same machine at different engines for FME server?

FME Desktop 2017.1 build17725When I create a simple Dynamic Workflow from shape to shape, everything works fine.When I put the BulkAttributeRenamer to the Workspace, the results are weird.I like to have all attribute names lowercase.Instead, attribute names remain capital, but all my data is lost in the output...Is that a known issue?

Hi There,I have recently upgraded to FME 2018 and am having some issues connecting to an Oracle database. I am running Windows 10 and have tried both FME 2018.1 (Beta) and FME 2018.0 and not any luck.I have recently acquired a new machine so I have had to set up everything from scratch. These are the steps I have completed:Downloaded and installed Oracle Instant Client 12.2. Unzipped and extracted to C:\\oracle\\instant_client_12_2Added folder as above to system PATH environment variableSet up tnsnames.ora file (this isn't essential, but I tried since I had no luck using the service name or easy connect string): Added tnsnames.ora to same folder as aboveAdded TNS_ADMIN system environment variable, set to the same folderTested my connection via: ping - ping hostnameMcTnsping - ping tns connection and easy connection stringOracle SQL developer - tested connecting via basic connection and tnsToad - tested basic connection and tnsIn all cases everything looked good and appeared to work

Hi there,Here's a sample of what my data looks like:GroupTypeAxAxAxABxBCxCxCDDI need to know what the percentage "x" distribution is per Group. A = 75%B = 50%C = 66.66%D = 0%I was thinking of using a counter grouped by "Group" (If that is possible?) and then using perhaps a expressionevaluator to calculate it, but I'm not quite sure how to go about it.Any ideas?

Hi, I need to do my own precise geographic transformation. I use CSMap Reprojector and custom definition in .fme file. I use EUREF transformation to check the accuracy of the results. I enter the parameters according to the following document http://etrs89.ensg.ign.fr/pub/EUREF-TN-1.pdf. If I try the transformation where the rotation paramets are zero (for example ITRF 2000 to ETRF 2000 in epoch 1989.0), the result is OK. But if I use non-zero rotational parameters. As shown above. The result differs from EUREF.Does anyone advise me what I'm doing wrong? Lukas

Hi Team,I have a dynamic CSV file with the following structure:Day 01102018Point1Point2Point3Time 01:0023404Time 01:30432421Time 02:001304910Is necessary to identify the lines 1-2-3 and in each node ( Time XXXX ) realize the merger with the Points. The Loop process will be good in this case?The Image bellow, is my goal:Attached my example file - Thanks,Danilo

Hi,I'm trying to merging different WMS features and images (Image Fetcher) together using a RasterMosaicker transformer. All layers from our local WMS server are merged together correctly but i cannot get it to merge with other WMS layers. The result should be a "what you see is what you get" PNG using the overlapping Values "last" option. I added a .fmwt file with an example.The PNG is a save from my WMS server that correspons to the same coordinates as the WMS in the example. My first problem was that the incoming WMS contain more bands so i had to generate a palette using RasterPaletteGenerator. After this my error  is:My result failed due to: The palette nodata value '255,255,255,0' of the selected band '1:0' does not match the palette nodata value 'NULL' of the corresponding band in the mosaicked rasteror after trying to correct it with the RasterBandNodataSetterThe palette nodata value '255,255,255,0' of the selected band '1:0' does not match the palette nodata value '112,113,115

Hi,Probablyoverlooking something.Thesituation:I have aworkflow that moves x amount pdf’s to a new location with as goal mailing allthe files created by a sub workflow, when starting this workflow asynchronous viaREST with the data download service all files are zipped and mailed to the givene-mail address via a subscription and topic connected to this flow. Using the followingformat with a GET via rest. <SERVERURL>/fmedatadownload/<REPOSITORY>//<WORKFLOW.FMW>?<PARAMETER>=X&opt;_servicemode=sync&opt;_requesteremail=<USERMAIL>And the followingmail format<fmeblocktype="optional">Your job withid {id} is finishedDownloadyour file here: {downloadUrl}</fmeblock>Returning amail with:Your jobwith id 1 is finishedDownloadyour file here: <URL TO THE ZIP>Theproblem:I’m tryingto get the job ID included in the REST return json but this does not work fordata download. When using the POST to <SERVERURL>//fmerest/v3/transformations/submit/(w

I would like to group the parts of pipeline by the name (OZNAKA_ODS) and than length (Dolzina) of the pipeline. Further i would like to write a new atribute table with only identical names of pipelineand and longest and second longest street name.data looks like:

In a custom transformer I have to use a published parameter in a couple of places. The parameter is passed from the Main workspace. I inspected with loggers and I realised that the value is present at the beginning of the custom transformer workflow but when proceeding along it gets wiped out ( I don't know what causes this, as far as I knew published parameters are read-only).

Hello  I see this missing Linked Custom Transformer error when I opened the workspace in PROD FME server. But this transformer is already present in Shared resources folder. I tried to add in workspace and other options, but was unable to add the custom transformer.I also have last save info. We didn't upgrade FME version. It's the same version before this error and at the time of this error.LAST_SAVE_BUILD="FME(R) 2015.1.3.2 (20160108 - Build 15575 - WIN32)Please advise. Thank You in advance.Tagging @takashi, @Mark2AtSafe, @trentatsafe,@danilo_fme, @david_r

I have several SQL executors spread across a large number of workbenches which I am now moving from the the Development to the Production environment, for this reason I have to change (hopefully in a clever way) the connection strings for every SQL transformer. In order to make it easy and only have to change one parameter I am trying to make the DB connection as a published parameter. There is a parameter text called "Environment" that can either be "development" or "production" this is in turn liked to a conditional value for the parameter "db connection" that should tell the SQL transformer (i.e. SQLExecutor, SQLCreator, etc) which db connection to open. In order to do it I followed the example shown in this answer:https://knowledge.safe.com/questions/34324/database-connection-as-publish-parameter-of-a-cust.htmlUnfortunately the mechanism does not work, when the workflow hits the conditional value FME (both server and desktop) instead of readi

Dear everyone, I am heading to build a automatic user registration process for new users. Please help me by providing FME documents how to do that. I will have a new web page and new users will request for registrations by proving their user name , email and password, then they will receive one reply link in their provided email and by clicking on that link their credentials will be stored inside database and their account will be activated. Be aware, we will use activedirectory for storing our users. Please provide me some hints and documents for this solution.With kind RegardsMuqit

Hello all,I have a simple question. Yet I can't find a solution. So I have an AIXM data where contains around 30000 airports. However, I'm interested in 600. How do I filter them? I know there are Tester and Attribute Filter transformers. But couldn't figure out how to create a list of these 600 and filter the matching data.

If I try to open it normally it works until I try to open a workspace, then I get the errorFile Error! Could not open file:If I open it as administrator it works fine, but I am trying to run my scripts by batch file in a scheduled task and while the script works fine run manually from the workbench (in administrator mode), it is not working through the batch file and I believe the two problems might be connected.Can anyone shed any light on this? I am using FME 2018 on Windows Server 2008 R2.Thanks

The previous versions of the FMEServerJobSubmitter returned an attribute upon failure named _job_failure_type. This attribute value is missing in the latest FMEServerJobSubmitter. Is there any replacement for it?

I'm trying to get to the bottom of this non-spatial data issue and am racking my brain to no avail...I have a table of data that looks as follows...IDFacilityCode1A001,D0471D047,P001,G00512D001,D047,F0012F001,G0092P001,A0013G0053G0054A001Notice that the FacilityCode may be duplicated between records for any particular ID. I need my final table to just be a DISTINCT list of IDs with an alphabetized list of unique FacilityCodes, so it should look like this...IDFacilityCode1A001,D047,P001,G0052A001,D001,D047,F001,G009,P0013G0054A001Theoretically, I'm thinking I might be able to use regex to extrapolate the unique FacilityCodes including the comma-separated values for the records with multiple FacilityCodes (with a StringSearcher? Not even sure what my regex would look like), then a ListDuplicateRemover, a ListSorter (to alphabetize), then a ListConcatenator to bring my list back to a single attribute.I'm not even certain that could all work correctly while maintaining a groupi

Is there a reader for Oracle NMS Mp files? It appears this is an option in the Small World license, but can't find any conformation. Does anyone know if or have a transformer that can be installed for this file type? https://knowledge.safe.com/articles/780/working-with-ge-smallworld-databases.html @MarkAtSafe

When I call the function convert I wrote, I get the error "PythonNameError: global name 'convert' is not not defined"