Validating columnar replication data

Use this procedure to validate business class data replicated to columnar. It will compare the columnar store data with the business class rowstore data, and will report mismatches. For detailed information on the requirements, restrictions, and recommendations, see Columnar 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 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 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 or select the Validate All Data check box. If you select the Validate All Data check box 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.
    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 Columnar 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.