Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • General
  • 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?
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?

@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 rrMicrosoft]sODBC Driver 17 for SQL Server]rSQL Server]Incorrect syntax near 'Niedergörsdorf'.] 3sde.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


Community Stats

30,161
Posts
114,495
Replies
37,813
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.