Question

Hello, we have a SDE-Reader with an integrated "whereclause". The data themselve has string-values with mutated vowel (ä, ü, ö), which could be a value for the whereclausee. In that case, the reader execute no result. Any idea?

  • 2 February 2023
  • 1 reply
  • 1 view

Badge
Hello, we have a SDE-Reader with an integrated "whereclause". The data themselve has string-values with mutated vowel (ä, ü, ö), which could be a value for the whereclausee. In that case, the reader execute no result. Any idea?

1 reply

Badge +2

@jeppenbe​ The only way we have been able to reproduce this in FME 2022.2 is if the value is accidentally double quoted:

WHERE Clause: ATTRIBUTE = '$(geodb_where_wwjd)'

Parameter: 'Niedergörsdorf'

In this example the WHERE Clause would resolve to: ATTRIBUTE = ''Niedergörsdorf''

This can return an error something like:

Could not find the features in the feature type 'SDEUSER.featureClass'. One possible reason is that a WHERE clause was specified that references a column/field that does not exist in the feature type. The error number from ArcObjects is: '-2147216072'. The error message from ArcObjects is: {Underlying DBMS error [[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near 'Niedergörsdorf'.] [sde.SDEUSER.featureClass]}

 

If you have a workspace that you can share that reproduces the issue (and a sample File Geodb that can be imported into ArcSDE) then we can try and identify where the problem you encounter lies. Knowing what language settings are set on your local computer and also your underlying database might help. Also ArcGIS Desktop vs Pro.

You might have to explore this issue more with your local FME reseller

Reply