Hi Pavan, Is it working when there is only one record in the file? What is the PublishSize value in the file adapter? Also, I suppose, the DB adapter is calling a stored procedure; does the stored procedure input can accept multiple records? Maybe multiple records are sent to the stored proc, when it can take only one record as input.
Currently File Adapter Publish size is 100, if i publish 100 or less then 100 then one BPEL instance is creating to process the records and i could see no issues.
whenever i publish more then 100 then it thowing error like " Failed to setAutoCommit to true for pool connection".
for Exapmle input Records are 150 then Two BPEL Instances are handling parllelly 100+50, this time i am facing problem. this my be issue of multithreading.. Please let me know if you need more details.