Skip to main content
Question

Tester with 'Begins with' conditions on Oracle table works in FME Desktop, but fails without error notice.

  • August 9, 2022
  • 1 reply
  • 12 views

pimververgmail

An Oracle table with 16339 features is called in a workflow. After that a tester selects items with conditions: CODE begins with RK or CODE begins with PK. All but 4 items are selected. The workflow works without problems in FME Desktop, but fails on FME Server. As an alternative I put an SQL query in the tabel reader: CODE LIKE 'RK%' OR CODE LIKE 'PK%'. To my surprise it - again - works in FME Desktop but fails on the server. So it seems the problem lies in the Oracle database table. Any thoughts?

1 reply

Forum|alt.badge.img+2

@pimververgmail​ That is pretty odd.

  • are your FME Desktop and FME Server versions the same?
  • are you sure your FME Server is pointing to the same Oracle database?
  • is it possible yo should be checking for lowercase 'rk' or 'pk'

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings