Domain constraint validation

Before you upgrade your companies to a newer Feature Pack, we strongly recommend that you check if the data meets the defined constraints.

Data insertion that does not meet the constraints can occur if, for example, you run bdbpost with the option to ignore domain constraints.

If the current data does not meet the domain constraints, this can lead to unexpected errors (error 205 "Out of range"). These errors occur while trying to update affected records using the Data Upgrade Engine.

To validate the domain constraint:

  1. Start the Validate Data Integrity (ttaad4233m000) session.
  2. Perform the check for each company that is scheduled for migration.

    Run the session:

    • From the package combination of the selected companies.
    • During online hours, because this session performs select statements only on the data.

    The session can take some time. We recommend that you split the session into multiple runs, for example, by company.

  3. After each run, check the output of the session and take corrective actions if required.