We are experiencing a problem with Navision version 4.0 SP2 (which we also had in V4) where we get the error:
“Another user has changed the definition of the field table after the activity was started”
As far as I’m aware, the table definition has not been changed (especially as I might be the only database user).
It doesn’t seem to make any logical sense, but appears to relate to the change log in our case (if the debugger is active this is where it’d hit)? The error would then happen over and over until you exited Navision, and even then (after it’d closed) you’d get the error again!
One of the palces it happens for us is on the Item Card - when an item is blocked/unblocked, there is a sequnce of checks that are carried out, as well as the user having to enter a reson for the item to be blocked. One day it’d be fine and the next it’ll cause lots of problems.
Has anyone experienced this or found a solution to it at all, I’ve tried all the basic things so far (logout, restart, recompile, etc.)?
Deleting the ZUP file was the first thing I tried. Thanks anyway.
Its all very wierd, it’d be ok for a bit after logging-in and then it’d just happen again with no real explaiantion of why and what is causing it. Its impossible to re-create the error the next time you logged on and you’d just have to wait for it to happen. I only realised it was somehow connected with the change log as I was debugging something else at the time.
First tell me are u using SQL Server database or a native database?
Because this kind of error usually occurs in SQL when more than 1 user is trying to modify same thing at the same time.
Otherwise this error can also come because of bad program logic where no commit is being done and changes are again made even before first changes are saved. This usually happens in native database.
Just check the program logic in the code which is hit. This should solve the problem.