Authoring

When I try and perform a backup using the ‘Backup to Download’ option in the FME Server Web UI (v2018) it says the process failed but when I look at the log file there are no reported errors and in History the status is marked as success.

On the Backup & Restore page in the FME Server Web UI I choose to ‘Restore from Upload’ and upload my .fsconfig file but when I try and ‘import’ the restore fails but no errors are reported. What else can I do?

Does dynamic reader and dynamic writer works for legacy sde in FME 2018?

I have a couple workbenches that retrieve data fields and pass them to a second workbench as @Value(xxxxx) using the FMEServerJobSubmitter. In desktop 2016 the values comes through to the second workbench (on both desktop and server) as @Value(xxxxx), how ever when using desktop 2017 no values reach the second workbenchAbove has the @Value(SITUS_CITY) using DT 2016 on Server 2017Above is missing @Value(xxxx) using DT 2017 on Server 2017

I need to create an FME workspace where I query the applicant id's in a table and then loop thru those passing each to a web service call. The return value will then be put into a table with the id passed out to the web service.

I have a Workbench file that invokes other Workbench files (using FMEServerJobSubmitter). These called FMW's do all the work as far as reading and writing records is concerned. As a result the parent is shown to have read 0 and written 0 records. I would like to be able to pass the information on how many records are read and written by the child back to the parent and have those values appear as the number of records read and written. Is it possible to do this?

Hi I have used Directory and File Pathnames to get the latest file name from a directory containing a list csv files.I then try to pass the fme attribute path_windows to a FeatureReader to read the csv file (see attached). However this is not working. When I click on Preview, I expect to get a preview of the csv data. Also, it doesn't output the data from FeatureReader when I run it.Any ideas

I am using an attribute creator that is given a List of coordinate. From that list i want the last x value( or the second to last in my example). How do I do it?In this picture I have tried calculating the number of elements in the list with a list element counter and then i simply write: @Value(_indices_normal{@sub(@Value(_nbr_indices),2)}.x). However this return a sad <missing>.  I haven't been able to find anything in the tutorial: Tutorial: Working with List Attributes or the links provided in it about this specific problem. The closest to an answer that I've found is this lecture slide show: list-manipulation-in-fme

I am using a chopper to extract vertices from lines. I want to get the order of these vertices for each line and have that stored in an attribute that I would like to copy to a csv along with the coordinates. I was able to get the coordinates but not the vertex order. What is the work around for this?

Watch out for this gotcha if you're using a FeatureReader on formats like Microsoft SQL Server: You can specify a Where Clause as part of the SQL Server Reader parameters, AND in the FeatureReader Parameters as well. This creates the possibility that one Where Clause will conflict with the other as in the example below. The Where Clause in the FeatureReader parameters appears to override the one in the SQL Server Reader parameters. So if you're wondering why the wrong number of features are coming out of the FeatureReader, check the Where Clauses...

Mark2AtSafeHi Mark Hope you can help me out with questions in regards.1) I am using arcgis and FME 20182) In FME, I am trying to do an analysis and results output I would like to have the destination attribute fields based on Multiple source featureless. So I am flowing the same method used in the below article. “I have following this https://knowledge.safe.com/articles/33838/dynamic-workflows-destination-schema-derived-from.html” I am not able to get this working.3) I have got two parts to achieve :a) I want the results of output to be split in different folders – example from featureclass B on the attribute value field "E" -I managed to do this by fanout @ value C b) I want the results of the multiple feature class to have the specif

I am trying to run FME workbench with input and output file destination and directory. This workbench is copying file from one directory and pasting in another directory.I tried with different methods of IFMEStringArray but doesn't seem to work and I can't find documentation on the internet. IFMESession createSession = COM.safe.fmeobjects.FMEObjects.createSession(); IFMEWorkspaceRunner createWorkspaceRunner = createSession.createWorkspaceRunner(); IFMEStringArray createStringArray = createSession.createStringArray(); createStringArray.append("C:\\\\test\\\\test.csv"); createStringArray.append("C:\\\\test2"); createWorkspaceRunner.runWithParameters("C:\\\\test\\\\Initialization_VIC_DataSet.fmw", createStringArray);Above is my code. Can someone please help?

Hi,I'm trying to connect to sftp server by creating subscription on FME server 2018.1.0.2 to upload some files to sftp server, but I get this error "Host name is invalid", however I use the same host name on WinSCP and works normally. what am I missing?can someone please explain what shoudl I do and what steps I should take.I flollowed the steps herehttp://docs.safe.com/fme/html/FME_Server_Documentation/Content/ReferenceManual/SFTP_Subscriber.htm ThanksSaman 

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 Cli

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 med

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_06443

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 connec

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 wron

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