This content has been marked as final. Show 4 replies
Try to reset the datasource.
(On WL console go to your datasource->control)
Poller picks the rows which have a flag set as "COMPLETE" and update it to "SENT"That's really weird... It seems like BPEL is rolling back... You probably won't see this effect for new rows, can you confirm?
i can not update the flag column on this table as SENT. it automatically reverts back it to "COMPLETE"
I think you should undeploy the composite, update the database as you want and then deploy the composite again... This should prevent BPEL to "undo" what you're doing...
This behavior is visible for even newly inserted rows. And BPEL is not rolling back because after picking rows from DB further this BPEL is supposed to insert another row in same table which is happening.
So it is not rolling back complete transaction it only rolling back the rows picked by poller.
and yes i have tried this thing like redeploying the BPEL process and even restarting the OAS(I am using soa 10g).
when the OAS server is down then i can update the row but As soon as i restarted the server this problem started again.
9 BPEL services have DB pollers pointing to this tableundeploy them one by one until you find the guilty... if that doesn't do undeploy the dbadapter... at least you will know where the problem is...