"Warning" message in testing a v4.0 SP1 database

Paul8Aspen
Paul8Aspen Posts: 2
edited 2007-03-01 in NAV/Navision Classic Client
In testing a database, I receive numerous "Warnings" when the Maximum test is conducted (Test field relationships between tables) and it looks like the relationship is between the Dimension & Customer Tables (Dimensions & Customers "do not exist") however, the database functions properly without any problems in the transactions. Anyone have thoughts on this. Thanks.
Paul Smith

Comments

  • kine
    kine Posts: 12,562
    In my opinion the cronus DB is full of inconsistent data, just because the history. If it is your DB created from scratch, there can be problem wrong table relation. For example somewhere can be table relation to Sales Header (Order No. etc.) which is not changed after posting the Order No. (order is not existing anymore after posting...)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • David_Singleton
    David_Singleton Posts: 5,479
    Paul8Aspen wrote:
    In testing a database, I receive numerous "Warnings" when the Maximum test is conducted (Test field relationships between tables) and it looks like the relationship is between the Dimension & Customer Tables (Dimensions & Customers "do not exist") however, the database functions properly without any problems in the transactions. Anyone have thoughts on this. Thanks.

    Just to add to Kamil's remarks, ... I have never seen a database in Navision that could run the "test key relations" without error. It is a very silly thing for them to put in Navision, when the base application does not even allow it to work. In my opinion, just untick the option on testing, it will never give you a useful result.
    David Singleton

Categories