Hello,
I have the following customer problem on Dynamics NAV 2009 :
I tried to restart the service NAS - normally this works fine
But since some days there is a Files Project that does never finish.
And when I try to restart this time to restart service NAS it does not work (it only stops the service).
Today I noticed that its possible to start NAS again when restarting the SQL service just before.
The Codeunit in the file projetcs that is causing the error runs at night calculating MRP (Materials Resources Planning).
I quickly reviewed the code and can't see anything anormal.
This program runs since a long time and never caused issues like this.
I have also tried to execute the file project in debug mode, and the behavior of the program was quite different :
The debug windows showed many errors - allways a locking problem on requisition lines table.
But even this were errors the program continued and ran until the very end (I put messages into the program to know where it was)
This time the file projet shows an end date, updated the status to Error and showed error an message referring to the locking problem (when running the program in normal mode the program never ends, there is no end date, status is success
and there is no error message).
At this moment I have no idea how to identify the origine of the problem.
i would be grateful ifsome of you give some hints ...
0