Analysis view error

zhajdinjak
zhajdinjak Member Posts: 2
edited 2006-08-27 in Navision Attain
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

Comments

  • ara3n
    ara3n Member Posts: 9,258
    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.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • modric
    modric Member Posts: 42
    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.
    Modris Ivans
    MCP, Dynamics NAV - Application

Categories