I appreciate your valuable suggestions. The weird thing here is I did exactly what you said. I disabled the start transaction and commit transaction. Even at this moment I deleted these two steps from flow. So when i trace or step through the flow works well. But If I run the service it is giving rollback error. I have attached my flow for you see the problem. I am sorry if i am not clear with my problem.
parent flow service:UploadStatus
2.Map (output doc to results doc(strings:Id,Status)
3.Loop (over results)
3.1.map (results doc to input doc)
3.2 update status(with input doc)
4.map(to output doc)
There is no start transaction or commit transaction used. All are JDBC adapter Local transactions within a single database.
so when I step through this works fine status is updated. But when i run the parent it is giving the error I mention above which is roll back error. This is weird.
Thanks for your help.