Guys, I guess there are several reasons which can cause this error. In my case it happend because i was starting transaction and without commiting, my SP was returing. When I commit before return statement it solved my issue. Probably these are unwanted execution flow which if some one follow then we will end-up with such generic error.