Hi,
I've a database table for which my DB adapter polls on a particular field, 'Status'.
Polling strategy: Logical Delete
Column name: Status
Read value: Processed
Unread value: New
In case of error: Status set to "Error"
Whenever I change "Processed" to "New", the polling is happening fine and status changed back to "Processed". In case of error scenario, if I change Error to 'New' for the first time, it's working as expected and if I repeat the same action again, it stops polling for any changes. The status remains 'New' only.
Please note I'm using this adapter with a OSB proxy service and I put Report action in the error handler as well for investigation purpose. The status reversal happens in the error handler in case of error.
I"ve developed this on Oracle SOA Suit 12c.
In the log I notice an error as below:
<rep:content-encoding>UTF-8</rep:content-encoding><rep:labels>PollingProxy=6QueueService3<test>abcdef</test>
New2016-01-04T02:28:52.216-05:00</rep:labels><rep:inbound-endpoint name="Pipeline$MyResub$ProxyService$DummyPollingPipeline"><rep:service><rep:operation>receive</rep:operation></rep:service><rep:transport><rep:uri>jca://eis/CSF_Resubmission_DS</rep:uri><rep:mode>request</rep:mode><rep:qualityOfService>exactly-once</rep:qualityOfService></rep:transport></rep:inbound-endpoint><rep:fault><rep:errorCode>OSB-382621</rep:errorCode><rep:reason>Failed to issue report: weblogic.messaging.kernel.KernelException: Error enlisting GXA transaction</rep:reason></rep:fault><rep:origin><rep:state>ERROR</rep:state></rep:origin><rep:timestamp>2016-01-07T02:08:28.575-05:00</rep:timestamp></rep:messagecontext> weblogic.jms.common.JMSException: weblogic.messaging.kernel.KernelException: Error enlisting GXA transaction
Please let me know your suggestions.
Thanks in advance