BPEL database adapter pooling rooling back transaction

Dear Forum Members,

I made a quick example of BPEL retrieving data from DB adapter which is pooling a database, transforms the data and generate a file.

The process executes, but at the end is throws the following fault: The transaction was rolled back. The work performed for bpel instance "X" was rolled back, but the audit trail has been saved for this instance.If this is a sync request, please resubmit the request from the client. If it is an async request, please recover from the recovery console by resubmitting the invoke message.

Along with the fault, the adapters does not update the processed database rows.

Did a miss any configuration?

Regards.