In my Dex app I added some new code and inadvertently did some sloppy work that resulted in the following error showing up.
"Microsoft Dynamics GP: Unhandled database exception: A cal to a stored procedure has changed the transaction nesting level."
That's it - exactly as it was displayed. Click OK and carry on.
I traced the problem and it was my own doing (of course.) In one of my T-SQL stored procedures I had a RETURN statement fire in the middle of a SQL Transaction. Bad dog!!!
I changed the code to allow a graceful exit through the SQL transaction and the error disappeared.
Could not find any reference to that error so here it is!
No comments:
Post a Comment