I have a not so strange error, I think I understand the problem/error but the problem is that I don't really know how to solve it. Spend almost 1,5 day without any kind of solution. Mostly because I have a hard time to identify when, what and how the connection gets prematurely committed or aborted.
Let me give you some technical information.
This is the event error I get, I'll get it about 10-20 times per day per Point Of Sales System:
This is the specific part of code which seems to generates the Event Error:
This is where the C/AL snippet above is placed:
***NOTE: The whole codeunit is has the property SingleInstance set to Yes***
Any Ideas? If you can guide me it would be very kind of you and very interesting. The system we are running is NAV 2013 R2 with LS Retail! i Got 2 years of NAV so don't mock me.
I have done a lot of testing and documentation regarding recreation of the problem without any success. If I can't recreate the problem, I can't solve it but I hope that someone can see some kind of obvious mistake I have missed or point out where to look.
I got 2 years of NAV experince, kind of Junior but i'm not totally dumb. I have a background within C# so I know that some kind of SQL-Connection is static and not instantiated.