Skip to main content
  • EN

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?

@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'

Reply


Community Stats

30,162
Posts
114,511
Replies
37,820
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.