Could not invoke operation 'Query_XX_Flag' against the 'db' due to: [[
BINDING.JCA-11633
Pure SQL Exception.
Pure SQL Execute of select DECODE(MSI.ATTRIBUTE5, 'Y', 'True', 'False') XX_flag from mtl_system_items_b msi where inventory_item_id = ? and rownum = 1 failed.
Caused by java.lang.NullPointerException.
The Pure SQL option is for border use cases only and provides simple yet minimal functionality. Possibly try the "Perform an operation on a table" option instead. This exception is considered not retriable, likely due to a modelling mistake.
Version: Oracle soa suite 12.1.3 - jdk1.7 - Windows 7 OS (local)
I have been getting the above exception in one of our Async BPEL processes, and it happens like 1 in 5 instances.
As you can see, the reason for the error is not really clear and I don't see anything diagnostics logs either.
And when I retry this process from the console, it is getting completed successfully.
We are not exceeding the number of DB connections either.
Here is our design:
BPEL Poller --> (Multiple calls) Async BPEL process --> Database Adapter with above query
What could be wrong? what is the reason for this weird behavior?
Thanks,
Prasanna