Validating replication data

Use this procedure to validate business class data replicated to columnar or Data Lake. It will compare the columnar or Data Lake store data with the business class rowstore data, and will report mismatches. For detailed information on the requirements, restrictions, and recommendations, see Replication validation.

  1. If you want to change the default setting for the maximum number of records to process per date chunk, set up MaxRecordsPerValidationDateChunk configuration parameters. See Setting up date chunking parameters for validation.
  2. In the Landmark Administration Console, navigate to Database > Replication.
  3. In the Replication Sets panel on the Maintain tab, select the replication set that contains the business class whose replicated columnar or Data Lake data you want to validate.
  4. On the list of business classes for the replication set, select and open the business class whose replicated columnar or Data Lake data you want to validate.
  5. On the Validation Information tab, define the following:
    Replication Set Field
    Select a date field from the business class. You can also select a date field from the Replication Set Client Field.
    Optionally, you can select the Validate All Data check box. If you select this option and there are a greater number of records than the allowed maximum for date chunking, the validation will fail.
    Offset Option
    If you select a date field, then select the offset to use for selecting records. The valid values are This Week, This Month, This Year, Specific Date, and Offset Days. If you select Specific Date, you will need to specify a date. If you select Offset Days, you will need to specify a number representing the number of days before current date.
    Disable Condition
    Selecting this option disregards the condition on the replication set during validation. Select this option if the replication set includes a condition that references other than persistent fields that reside on the business class such as derived fields, user fields, or related fields.
    Condition Override
    If the replication set has a condition that must be overridden, select the Disable Condition check box and optionally specify a new condition. For the rules on these conditions, see Replication validation.
  6. Click Save.
  7. Specify one or more checksum fields.
    1. On the Validation Check Sum Fields tab, click Create.
    2. Specify the following:
      Name
      Specify a descriptive name for the checksum field.
      Replication Set Field
      Select a field from the replication set to use as the field.
      Instance Count
      If you want a count of records, select the Instance Count check box instead of selecting a field in the Replication Set Field field. You can also specify a condition for the instance count.
      Condition
      Specify a condition if necessary. Check Sum field conditions can only be a single condition and can contain only persistent fields that are resident on the business class. Related fields and user fields are not allowed.
    3. Click Save and repeat these steps to add more checksum fields (up to ten allowed).
  8. On the Replication Class page for the business class whose data you are validating, click the ellipsis button and select Validate Data.
  9. Review the results on the Validation Results tab.