Another user has modified...

RachelSoon

Hi There,
msg prompted : Another user has modified the record for this analysis View after you retrieved it from the database.
Enter your changes again in the updated window, or start the interruptted activity again.
Identification fields and values:
Code : 'B52'

My user got the msg above when the user doing the posting of sales recuring journal.
At that point of time, there was no user modifying the analysis view.

Pls advice on the possible clue that i can look into.

Thanks

Rachel

kine

You have some modifications?

In code somewhere is this construction:

  RecXXVar1.GET(PrimKey);
  ...
  RecXXVar2.GET(PrimKey);
  RecXXVar2.FieldYYY := Value;
  RecXXVar2.MODIFY;
  ...
  RecXXVar1.MODIFY;

this may be nested into some functions etc.

Use Client monitor to catch the code, where the table is modified before the last MODIFY which reise error (I found for example this construction of code in 1. adjustment batch in cronus in 3.70A, may be that it is standard bug :-)

RachelSoon

Hi Kine,
Do you know where can i get this type of coding or problem in Navision 3.60?
the user also gets this message on the chart of account when drill down the net change.
the user is using the SQL option

kine

I think, that simple way how to find the point is to turn debug on and look where error is produced. This is the point, where you want to save changes on something, what was changed between reading the record and saving. Look where your varibale which you want to save is read from DB (nearest FIND, GET or NEXT) and look into code between to find where is the point of second modify for the same record.

Sorry, it is 1 year ago when I looked into 3.60 and in this time we are not using 3.60 with SQL server... this sort of problem is reising mainly after starting to use MS SQL. In Native DB it may be all OK...

fb

There is an error in the v3.60 Codeunit 410 - Update Analysis View that can result in the 'Another user has modified...' error message if you have any Analysis Views with "Update on Posting" selected, and two or more posting procedures (sales, purchase, g/l, etc) are run at the same time.

This error is corrected in v3.70. I believe the correction basically involved the removal of the COMMIT statements (especially the 2nd one) from the codeunit.

If you do not wish to change the codeuint, you can avoid this error by removing the "Update on Posting" check from all Analysis Views.

RachelSoon

Hi Kine and FB,
thanks for the idea. i will look into it. It enlighten me a lot.

ta5

Hi
We have the same problem in codeunit 410, Navision 3.60.
Is there a hotfix for this?

Thomas

jreynolds

Client monitor can be very usefull for tracking down this type of problem. The error message identifies the table and record that has been modified by "another user". Run the process with client monitor turned on and then filter the results of client monitor to find other activity for that same record.

ta5

Hi
Unfortunately it is quite hard to reproduce (never happened in our development environment). But it happens about once a week on the customers site.
Thomas