We have OSM 18.104.22.1680 installed on a cluster with two managed servers.
The behavior we are experiencing is that if we query for a specific Order ID, the query returns that order. If we run the default query, the same order is not included in the result set.
The same behavior is exhibited by both the Order Management Web Client and the Task Web Client. Interestingly enough, though, it is not the same order(s) that are missing from the results.
For example, running the default query in the Order Management Web Client "hides" orders 1, 2 and 3, but running the default query in the Task Web Client "hides" orders 7, 8 and 9.
No exceptions are logged whatsoever.
Does anyone have any ideas as to what might be causing this behavior?
Are you using the same user-id in both the OM client and the Task client?
Are all orders in question of the same order type?
In the Task client, did you select one row per order or one row per task?
I would be surprised if this had anything to do with it, but is this behaviour only exhibiting in the 2 node cluster or does it happen even when only 1 node is up and running?
I am using the same user to log in to both clients.
All orders are of the same type.
In the Task client, the query filters have single row per order selected.
Finally, indeed bringing down one of the two servers did not seem to make any difference.
I can't explain the behaviour you are observing based on your description of the problem. I would recommend you log an issue with support and if possible take a screen cam video of what you are seeing in both web clients.
It must be something simple/trivial that we are both overlooking - what you are trying to do is perfectly reasonable and should work as expected out of the box.
Hi Pantelis, there is a way to log the SQL going to the database.
On the log4j page, just select DEBUG for the proxyQuery (or queryProxy).
If this is a product issue, this won't help you, but if it is due to some settings, this might help you figure it out.
Or it might help Oracle support figure it out :-)