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?
Tester with 'Begins with' conditions on Oracle table works in FME Desktop, but fails without error notice.
+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'
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.