Hi, i am facing following error The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction. Uncommittable transaction is detected at the end of the batch. The transaction is rolled back.

Hi, i am facing following error The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction. Uncommittable transaction is detected at the end of the batch. The transaction is rolled back.

I have written a sp which will do insert update delete operations on different tables. it is taking an xml and some other inputs and performing action. I am facing a problem here. when i take all inputs and running that sp in db it wont throw any error and runs smoothly. But when i do it from data access from code it is throwing following error

The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.

Uncommittable transaction is detected at the end of the batch. The transaction is rolled back.