Strange behaviour (SQL 2005)

Sorcerer · 2006-08-22

Hello everyone,

after converting our 2.60 (SQL 2000) database to 4.02 (SQL 2005)
by making a navision backup and restore it by 4.02 we have the following behaviour:

We have custom form of a custom table where the inventory is shown cumulated by location. The item ledeger entries are cumulated in this custom table (by specified item). Only locations with inventory are shown.
So when i connect with a user with role SUPER everything works fine.
Even if i connect with a user with restricted access it works fine. But if this user tries it on his computer (with his rights) the custom table is not filled and nothing is shown on the form (User has been synchronized before). After giving this user db_owner rights everything works fine.

Has anyone an idea about this?

ClausHamann · 2006-08-26

It sounds strange to me that it works on some computers but not in others.

I can only think one thing that could change the behavior of your form between 2.60 and 4.02. The permissions need to calculate flowfields have changed.
In version 2.6 the user only needed permission for the table with the flowfield (in our case the custom table) to be able to see the value of the flowfield. I Navision 4.0 the user also needs permission to the table from where the flowfield is calculate from (in your case the item ledger entry or value entry table). The permission can be either indirect or direct.

Regards

Claus

kine · 2006-08-29

For me it seems like:

1) Problem of ZUP file (some saved filter etc.)
2) Permission problem connected to the PC - for example the PC is not in the domain and there are some restriction for this computers etc.

Are you using Windows or Database logins?

Sorcerer · 2006-08-29

Hello,

1) the zup file can not be the problem. even a new user or user with deleted zup file has this problem
2) the users work with thin clients / terminalservers

all users work with database logins

kine · 2006-08-29

1) You can use debugger under the user account to check where the problem is
2) You can use client monitor or code coverage to save informations about the process and compare it with same data for same process from your PC.
3) Are you using security filters in your permissions?
4) Are you using some responsibility centers or something like that?

Scott_Frappier · 2006-08-29

Sorcerer:

There are problems with the way that Navision calculates COUNT and COUNTAPPROX statements in SQL Server 2005. If a user does not have db_owner privs., then the process will potentially fail. This is apparent on 4.0 functionality as well (ex. create warehouse shipment lines).

Microsoft released 4.0 SP2 Update 02 recently. This includes the new security model enhancements (no more synchronization if you don't want to!!!) and fixes some of the bugs that you are potentially experiencing.

Contact your Navision Solution Center, and if you are a solution center, contact Microsoft for the update.

Hope this helps.

Strange behaviour (SQL 2005)

Comments

Categories