Skip to main content
  • EN
Hello,

 

I am having a problem with a workspace (see the screen shot below) and I was hoping someone could help. I am trying to get values from two tables in two databases and eventually use the values as xy pairs in order to create a point. The values from the two tables are passed to an InlineQuerier and I use some SQL queries to obtain the correct values. I’ve tested the queries in ArcMAP and Access so I knkwo that they are correct. What I’m running into is that only one set of values are passed into the 2DPointConnector and the process fails when it tries to run a calculation due to null values. I was wondering if I am going about this the right way or if there is a better method to use.

 

I copied some of the error message from the log file.

 

 

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

 

Feature Type: `2DPointAdder_OUTPUT'

 

Attribute(64 bit real) : `10-YEAR SWEL' has value `8.27000045776367'

 

Attribute(64 bit real) : `100-YEAR SWEL' has value `12.6800003051758'

 

Attribute(64 bit real) : `STATION' has value `0'

 

Attribute(encoded: utf-8): `TRANS_ID' has value `120'

 

Attribute(string) : `db_type' has value `db_none'

 

Attribute(string) : `fme_feature_type' has value `STILLWATER'

 

Attribute(string) : `fme_geometry' has value `fme_undefined'

 

Attribute(string) : `fme_type' has value `fme_no_geom'

 

Attribute(32 bit integer): `multi_reader_full_id' has value `0'

 

Attribute(32 bit integer): `multi_reader_id' has value `0'

 

Attribute(string) : `multi_reader_keyword' has value `MDB_ADO_1'

 

Attribute(string) : `multi_reader_type' has value `MDB_ADO'

 

Coordinate System: `'

 

Geometry Type: IFMENull

 

===========================================================================

 

2DPointAdder: @Tcl2 -- failed to evaluate expression `FME_Coordinates addCoord {12.6800003051758} {}' -- Cannot convert null string into a float

 

@%0 -- failed to evaluate expression `%1' -- %2

 

A fatal error has occurred. Check the logfile above for details

 

A fatal error has occurred. Check the logfile above for details

 

 

 

Thanks,

 

Vince

 

 

 
Hi Vince,

 

 

The reason for the error is that the feature doesn't have attribute named "GF_2PERCENT_RUNUP".

 

I guess that S_CTS_TSCT_LN features contain the attribute and you are trying to merge it to STILLWATER features. Aren't you?

 

If so, probably  InlineQuerier setting is wrong. You have to define an SQL statement to join the two tables, and the InlineQuerier should output the merged features to one output port.

 

 

Takashi
Thanks Takashi. I used a two table join and that was successful. I realized that I now need to get a third attribute from a third table. I've written a query and tested in MS Access and it works there but I don't get any results in FME. I noticed that the InlineQuerier uses SQLite and I was wondering if you know if the syntax is different than Access?

 

 

Thanks,

 

 

Vince
Yes, there are several differences between SQLite and Access SQL syntax. But there also could be issues in Inputs settings (i.e. Table and Columns) of the InlineQuerier.

 

Could you please post both the SQL statement and screen shot of the InlineQuerier Parameters dialog?

Reply


Community Stats

30,108
Posts
114,295
Replies
37,743
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.