Analysis view error

zhajdinjak

Hi,

I use Analysis view for analysis by dimensions in NAV 3.60. Analysis view is updated by posting process.
It works fine, but sometimes some data in this view are deleted. Simply, some rows in table "Analysis View Entry" don't exist any more. I don't know why, I can't find where's problem.
When I recreate view all data are here, but after is same scenario.

Does anyone know whats problem.
Thanks

ara3n

The problem occurs when people are posting at the same time and the data gets locked by other users. The user gets an error that somebody else has locked the table. The posting does not role back because of commits in CU 80 or 90 and the entries are not inserted into the table.
I would uncheck flag update on posting, and run a job through nas to update the data.

modric

In addition to previous - I would suggest turning off "Update on Post" because:

1.It slows down posting, especially, when you have many views. It can even escalate to deadlocks, if there are many concurent "posters". This was reported somewhere here earlier as problem already.

2.Usually analysis is performed far more rarely than postings and often by other users than those posting documents, so its not a problem for them to update views before actual analysing data - they simply must be told to do so.