Authoring

Hello,unfortunately, I have problem with result from coordinate rounder and following process in changedetector.Example of my situation is below:There are 2 sources of data. One is actual to 2016 (technical map) and second to 2012 (plan of renewal). Plan of renewal was made from technical map in 2012. Now I want to compare these two sources in actual form with coordinates accuracy 0,01 m. I chose this way of processing - first I used coordinate rounder with X,Y precision 2 for both sources. I sent features with rounded coordinates to change detector. Values of coordinates are following:First sourceCoordinate 0: -536260.78633329261, -1226140.6460811181 Coordinate 1: -536258.07004669344, -1226118.8444450819Second source:Coordinate 0: -536260.7862999998, -1226140.6460000016 Coordinate 1: -536258.0700000003, -1226118.8443999998Result is disappointing... In spite of fact that I rounded coordinates to precision 2, change detector said, that coordinates are different, but they arent in real..

Hello there we have a simple WS GeoDb reader and SQL server writer and we are only renaming 2 attributes as shown but the table created on SQL still keep the same name as the reader ignoring the renamer transformeris there any reason why?

I am trying to run an FME workspace on server, I run it through a web interface (a web page). The workspace is meant to produce a JSON string as a result (when the workspace runs successfully) and in order to do this I use the DataStreaming transformation service. When the workspace fails, I would like it to send an email advising of the failure. I have already all the notification and topic setup (using JOBSUBMITTER_ASYNC_FAILURE) and I tested it on the FME sever web interface and it works fine. On FME server I can choose with the dropdown list which service I want to run the workspace with, to receive the email I have to use the JobSbmitter. But if I use the DataStreaming then I won't receive the email if the workspace fails. Similarly, when I call the workspace through a HTTP request if I use this endpoint:https://fmserverhost.fmecloud.com/fmedatastreaming/workspace.fmw?parameters I can get the JSON string on success but no email notification conversely, when I use the other

Hi,I appear to have an issue with a FeatureWriter failing when writing a certain amount of features.I have a list of features which I want to write some dummy data for into a Feature Writer. For each entry in the list I fetch 1 object (using a Sampler) and the relevant schema from PostGIS tables and then use a FeatureJoiner to match the list feature to the object and schema feature. After that I remove the geometry and feature values so each feature in the list has just one empty object. A lot of features, but very little actual data. I then write everything to the FeatureWriter. This works absolutely fine when the list is only about 500 items long, so there doesn't appear to be anything wrong with the process, but when I'm testing lists of about 4000 features the Writer seems to timeout and fail on a random feature.The error messages I'm getting are along the lines of:Geodatabase Error (-2147220987): The user does not have permission to execute the operation.FileGDB Writer

 Which rights/configurations that a simple user (not administrator) needs to be able to Extend/Rovert FME Extension for ArcGIS on FME Integrator console ?

Hi I have a point (10 million rec) and polygon feature (9000 rec) class in SDE SQL Server 2012. I am using a FeatureReader to read the point fc, following which I need to get count of points within each polygon. This is what I get when I run workspace output doesn't seem correct:Reader format `GEODATABASE_SDE' does not support querying by spatial predicate, but supports envelope queries. FME will create equivalent results by performing spatial predicate calculations locally. Performance should not be affected.Any idea?

I am attempted to add the FMEServerEmailGenerator to a workbench on build number 17291, however I receive an error stating that I must upgrade to 177725 to use the transformer. I know this sounds pretty obvious, but another workbench on the same build number (17291) does not prompt me to upgrade.What might be causing this conflict?

I download the example from the article "Batch Processing Using the WorkspaceRunner"When i run it an the fme2018 and don't change anything it works well. When i update the workspace runner to fme2018 ,it can not work any more. I don't know why. It troubles me a lot.This is the ordinary one?Then i update the workspacerunner

Dear FME community.I've Shapefiles in GDrive with folders and subfolders. This is the workflow :1/ I read them with GoogleDriveConnector, this is the result :2/ After I use a Tester for keep the *.shp files3/ I use a FeatureReader for read the files but that doesn't works.This is the complete workflow :Do you know how can I do that ?Thank you.

I have a Workspace that I need in output create a folder and a subfolder, and in this subfolder the file needs to be saved. And after the file has been saved, I need the folder to open automatically, it can be done by the FME? Thank´s

Is there an ability to secure the database connections that are for public use so users may access them, but not have the option to change the password? We are in the process of securing all access points in our environment. I would like to have the ability to allow users to use the connections, be able to read and write to the database, but they would not be able to have access to the credentials of the database.

I'm using a web connection to an FME Server instance to call an FMEServerJobSubmitter. I would like to trigger a topic to notify an external application that the job was submitted and I would like to include the FME Server hostname in my notification. The FME Server instance that the job was submitted to is not necessarily the same as the instance that the calling job is running on, so I can't rely on the built-in FME Server Parameters.Is there any way that the hostname can be somehow extracted from an FME web connection? Happy to resort to Python or other methods if necessary. I'd like this to be a dynamic solution rather than manually defining the hostname somewhere in my workspace.

I'm used to setting my table qualifier parameter through a published parameter. This worked very well in 2016, but in 2017 it breaks as the table qualifier is automatically populated in the table name field. What can I do?

I just upgraded form Oracle 2017.1 to Oracle 2018 and now I'm having issues with Oracle database connections.I get this 'ORA-12638: Credential retrieval failed' error which is solved by changing SQLNET.AUTHENTICATION_SERVICES= (NTS) to SQLNET.AUTHENTICATION_SERVICES= (NONE) in /oracle home/network/admin/sqlnet.ora.The thing is that after applying that solution when I execute my workspace there's this Warning line in the log:Unable to determine version of Oracle database. (serverType=`ORACLE8I', serverName=`myServerName', userName=`myUserNAme', password=`***', dbname=`').It's confusing because warnings are important in our workflow.Is there anything I can do to make FME know our database version?

I have a text list of Rasters which have to be processed. How do I iterate through each row in the list and use that value as the input for my transformer?

Hi,I was wondering what happens when you upload a workspace into FME Server, is the caching disabled automatically? or is it being cached on the FME Server machine?Thanks,Itay

I am having an issue getting attributes from a custom transformer output exposed in the main workspace.The output in question was added after the custom transformer was created, but appears to me to be all in order. The Population_Base output exposes it's attributes correctly while the Meshblock_Base output doesn't. Here is an image of the Meshblock_Base properties.And finally what it looks like on the Main workspace.I can't figure out why these 2 attributes are not being exposed.Am I missing something obvious, or is there something fishy going on?I am using FME 2018.0 32 bit.

Hi - I am having an issue with FME.exe. I have two FME workbench files - one uses a workbench runner to access the other one. I have run the models successfully in the past, however, this time, the translation log hangs when the model is running. When I check the log file for workbench 1 (that is accessed by the Workbench runner - it confirms that the model is running), however the translation log is different to previous successful translations. When I delete both FME workbenches, the model still continues running using FME.exe. Does anyone have any tips on how to shut FME.exe down to stop it running? I can't access it through Task Manager.Should, in the Workspace Runner, the field 'Wait for Job to Complete' be No or Yes and does that affect FME.exe? Additionally, this model behaves differently on the computer I'm using compared to the computer a colleague uses. It works how it is supposed to on my colleague's computer, vs, the computer I am using. Does anyone have

I am trying to read in the SchemaMapper from a Microsoft SQL Server Non-Spatial table based on a where clause. The value in the where clause depends on the value from another table. So I first read that other table and create an attribute with that value. In the SchemaMapper the configuration is as follows:You can already notice that there are no options to assign an attribute value or open a text editor for the WHERE Clause field.When I run the workspace I get the following error:Microsoft SQL Server Non-Spatial Reader: Query failed, possibly due to a malformed statement. Query Text `SELECT * FROM DataOwner.[RAC_SCHEMA_DEFINITION] WHERE MAPPING_ID = '@Value(MAPPING_ID)''. Provider error `(-2147217900) Conversion failed when converting from a character string to uniqueidentifier.' A fatal error has occurred. Check the logfile above for details SchemaMapper_Mapper(SchemaMappingFactory): Could not read feature: A fatal error has occurred. Check the logfile above for deta

So I have replaced my FileGDB reader with 2 FeatureReaders (one for spatial, one for non-spatial data)What I miss now is the "Feature Read Summary" I was used to get from the "real" reader.Any way to get this summary ?

I want to "deliver" an executable form of a workspace. but not the workspace itself to a third party

I am inserting entries in two Oracle tables. I want to relate the two tables based on primary key (ID). This ID is generated as a sequence in the writer. Is there a way I can get the expected "netxval" ID, so I can set the relation ID-attribute before insertion? Or can I do this in another way?

Has anyone successfully executed an insert\\delete SQL statement to a SQL database via Python in the Shutdown Script?

Hello There we are looking to sync MSSQL DB with PostGIS DB , we used the dynamic workflow in this article https://knowledge.safe.com/articles/1050/dynamic-workflow-tutorial-introduction.html?smartspace=dynamic-workspaceshttps://knowledge.safe.com/questions/55645/dynamic-output-to-sql-server-no-table-qualifierdat.html?%CF%87ldToView=71254#answer-71254we want to do is each time we run this workspace it will update the existing table and create a new table if needed, we configure the writer as shown, the problem how we should know match column parameter in order to execute the update,

Hi there,  I've developed a FME-workspace with user-parameters. One of the Parameters is a defined "Choice-Parameter". On Desktop it works fine, the same on FME-Server.  I'm also using the Url for the workspace to submit the request in a Browser. Now it's possible to alter the Choice-Parameter with some fantastic values (Example: Choice-Parameter: "Numbers: 1|2| 3"; in URL written Value: "Numbers: 4"). The result I receive is empty, as expected. But the Workflow "completed successfully" too.  My question: Is there a possibility to force the FME-Server in a "Failed", when the defined Parameter got a wrong value?  Thanks for your help,  Greetings,  André