Problem with table 363 (Analysis View) locking

rtoppes

In our enviroment with 110 User and Navision 4 Installation (Database 4.01 and client 4.03 with HF7) we have sometimes a day the message.

An other user has blocked the table Analysis View, please try later again.

ok table 363 is empty on our system

The error are only during booking processes (invoice, Revaluation ....) and stops the transaction.

We booked with the system 900 invoices per day with all related other processes, the error are from my view not repeatable, other user other processes other time but appears 5-15 times per day.

Have somebody an idea ??

Waldo

So you don't use the analysis views?

Is it possible you did create one and enabled the "Update On Posting" checkbox (just a long shot)?

May be you can check the client monitor and/or Code Coverage to see what's going on?

rtoppes

no we dont use this part, the tables are empty

papvre

We have the same problem DB and Client 4.03 + HF6 + SQL 2005. We don't use "Update on Posting". The entries tables are Empty. Only one record is in T363 "Analysis View" but with not related entries (all entries tables are empty).

Any solutions ?

Waldo

It's hard to so with only this data. Did you try to monitor with the Client Monitor?

You can use the default, but the extended one from the TOOLS CD is much easier to make analysis in ... . Did you try that?

papvre

To this time a I try to find something in code that can make problems or locking the table. From Code Coverage I only find one line that works with "Analysis View" functionality. It is in C13 at the end of Code() trigger:

UpdateAnalysisView.UpdateAll(0,TRUE);

But this is standard code and no changes were made to "Analysis View" functionality. And as I said we don't use update on posting

I do what you suggest, i start with default Client monitor.

Waldo

Well, it's better (and easier) to use the more advanced one, you know :-)

jannestig

Just out of interest did you try creating an actual analysis cube and set it to not auto update, just to see what happens?

If you are getting this probably when the functionality you say is not being used it would be interesting to see what happens when u create one and manually set it not to auto update. Perhaps the code needs to see a cube with the flag switched off.

Crazier things have happened.