Options

Flowfields gives positively wrong result

ottobeottobe Member Posts: 67
Hi
I have encountered an annoying and somewhat spooky problem. After using DELETEALL on tables Item Ledger Entry and Warehouse Entry (on a filtered set of records, no flowfilter though) the following happends:
Flowfields Inventory in Item table and Quantity in Bin Content give wrong result.
There is positively no records (within filter as set before delete), but flowfields report there is. I tried to backup database, but still the same problem exist.
Using a program with rec.QUANTITY gives same result as visual count.

This is on Navision 370, SQL server 2000. I tested the delete program on a native database before the SQL version and that worked well.

It looks like the SQL mechanism behind Flowfields is out of order. Anyone know what has happened and how to solve this. (Unfortunately it is on a live database)

regards

Comments

  • Options
    ottobeottobe Member Posts: 67
    Hi again. More info:

    Restart of SQL server . No result

    Taking backup from SQL server and restore in Native: Flowfields work OK.
    This should identify the problem to SQL / Flowfields.

    regards,
    otto
  • Options
    NobodyNobody Member Posts: 93
    I have seen this twice, but is very rare. To correct it I identified the SIFT indexes that were calculating the wrong values and disbabled them and then complied then went back in and re-enabled them and it rebuilt the summary table associated with the SIFT index and the values were correct after that. Just make sure when you disable the SIFT index and compile that it actually drops the summary table associated with the SIFT index.
  • Options
    ottobeottobe Member Posts: 67
    :D Thanks !!
  • Options
    SavatageSavatage Member Posts: 7,142
    Did it fix your problem? You should Put [Solved] in the topic.
Sign In or Register to comment.