web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Fixing in Consistency check

(0) ShareShare
ReportReport
Posted on by 125

Hi,

We want to use the consistency check to improve the data quality.

We are not shure if it is helpful to use the "Fix error" Option, especially without knowing what kind of Fixing it performs.

So does anyone know what this option actually really does?

- Does it create missing entries of data in tables or

- does it delete entries in tables

- or anything else?

Does anyone have experience with this and knows more about it? Is there any documentation about this?

Thanks for your help.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    guk1964 Profile Picture
    10,886 on at
    RE: Fixing in Consistency check

    Each entry or sub-entry ties directly to an Application Object Tree (AOT) class, has a name ending in “ConsistencyCheck” e.g for the AR module class, it is “SalesConsistencyCheck”.

    The code searches all classes for any that derive from “SysConsistencyCheck”.

    When there are sub-entries, each one is further derived from the class for that module.

    The class “CustConsistencyCheck” has two classes that derive from it, which follow the naming for subclasses.

    • “CustConsistencyCheck_LinkTable ” for checking Relation tables

    • “CustConsistencyCheck_BOE” for checking Bills of exchange

    Dynamics AX calls the method treeParentClassId() to determine which classes are subordinate to what..

    (The default is a parent of the main class SysConsistencyCheck.)

    A Module dropdown restricts the tree to just that module (where the “module” is one of the classes that says its parent is “SysConsistencyCheck”; entries in the first level of the tree below “Programs”).

    When the “SysConsistencyCheckJob” class, which uses the RunBase framework, is run It sets up the form and then calls the “SysConsistencyCheck” classes selected.

    The output is an InfoLog with all consistency errors and warning:

    The “SysConsistencyCheck” class has some hook methods that can be overridden to allow the developer to add code at certain points in the process.

    It also has methods that do the consistency check for a particular table (kernelCheckTable()), an individual record (kernelCheckRecord()) or a subset of records based on a query (kernelCheckRecords()).

    To check a record in a table, the kernelCheckRecord() method first calls the table’s validateWrite() method on the record.

    It goes through each non-system field in the record and calls the table’s validateField() method on it.

    Don't be surprised to find that this exposes some problems with standard AX code.

    I suggest generally follow Steven's advice, and when you want to try this do it in a test system backed up from live.

  • Weaveriski Profile Picture
    23,616 Moderator on at
    RE: Fixing in Consistency check

    Not knowing the detail of the complex algorithms I return to the reply of Guy which has an important part about the kind of data. Having seen this throw issues on imported data for missing key information it will not recreate the missing fields. Also it only checks the elements it is programmed to check, it does not check everything. I think for the whole life of AX2009 it was based on the AX4 table structure :-) So it tells you issues of the elements it is designed to check and will only fix these if it is possible to fix them.

    Ultimately run it, some are warnings you can do nothing about, but analyse it. I would not run the fix unless it was related to specific data I could not correct from the UI and I thought perhaps the fix would fix it, but I would not hold hope that it necessarily would!

    Get a developer to look at the code and extrapolate the complex algorithms.

  • TVO Profile Picture
    125 on at
    RE: Fixing in Consistency check

    Hi Sukrut,

    Thanks for the link, I already read this Information before.

    But the only Information about the fix mode is the following sentence:

    "the fix mode invokes some complex algorithms to restore the data consistency".

    I would like to know what these complex algorithms do.

    Thanks,

    Tilman

  • Guy Terry Profile Picture
    28,874 Moderator on at
    RE: Fixing in Consistency check

    Hi Tilman,

    What it does depends on what the check shows. Have you run it in 'Check' mode?

    I know one thing it can do is recreate InventSum (On-hand) from Inventory transactions. So in that sense, yes, it can create data and delete data from tables. But that is one specific inventory related scenario.

  • Mahmoud Hakim Profile Picture
    17,887 on at
    RE: Fixing in Consistency check

    i faced a problem in vendor pending invoice , it wasnot post.

    after running this option, the pending invoice posted automatically.

  • TVO Profile Picture
    125 on at
    RE: Fixing in Consistency check

    Hi Sukrut,

    Thanks for the link, but in the mentioned thread there is only a discussion about the performance of the consitancy check.

    That is not my issue.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Guy Terry Profile Picture

Guy Terry 2 Moderator

#2
Martin Dráb Profile Picture

Martin Dráb 2 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans