Thanks for your help.
Well as far as buffering goes, I did the buffering override in data environment and made everything to optmistic table buffering. The error I am getting now is that 'Table buffer for alias '...' contains uncommitted changes. I guess it did revert but doesn't know waht to do with the changes. Can you suggest a solution.
Thanks again.