You are on SOA Suite 10g and your BPEL process contains a database adapter.
Database adapter is polling data from a table and triggering bpel instances.
Adapter is polling the data but the bpel instance is not getting created.
checked the log files and got following error
ORABPEL-11624
DBActivationSpec Polling Exception.
Query name: [pollData], Descriptor name: [pollData.getData]. Polling the database for events failed on this iteration.
If the cause is something like a database being down successful polling will resume once conditions change. Caused by ORABPEL-00000
JTS transaction was marked rollback only.
Checked the thread dump and there found that most of the threads are waiting.
Don't know the exact reason of the issue.
But i made the following changes
as per the document
11.1 MaxTransactionSize Should be Limited for Oracle Database Adapter
In Database adapter, set a limited value for MaxTransactionSize. For example, set
MaxTransactionSize=10
Setting higher values to MaxTransactionSize will likely time out.
In my case it was set to unlimited.
Changed this to 100
Further i was sending data continuously send the data in a batch size of 200 and it started working
2 comments:
Hello,
We are facing same issue. Could u pls tell how to set this. Which config file/ or path from em?
Thanks
This is a very generic exception and there can be a lot of cause for this issue.Check your database is up and all data source can connect to the respective schema,Debug logs might suggest more on this
Post a Comment