Find missing or mismatched records in Instance Data Replication

Find records missing from the consumer instance or mismatched records after data has been replicated by creating a data comparison request in Instance Data Replication (IDR).

Avant de commencer

Make sure the following conditions are met:

• The producer replication set is active.
• Seeding isn't in progress.
• No other data comparison requests are running.

Role required: admin

Pourquoi et quand exécuter cette tâche

Note the following:

• Data comparison requests are purged after three months.
• There are limitations when comparing transformed data. See Comparing replicated data between instances in Instance Data Replication.

Procédure

1. On the producer instance, navigate to All > Instance Data Replication > Producer Replication Sets.
2. Select an active producer replication set with replicated data that you want to compare.
3. Create a data comparison request.
   1. Navigate to the IDR Data Comparison Requests related list.
   2. Select New.
   3. On the form, fill in the fields.

      Tableau 1. IDR Data Comparison Request form

      Field	Description
      Replication Set	Name of the producer replication set.
      Target Instance Name	Name of the consumer instance.
      Target Instance URL	URL of the consumer instance.
      Table Name	Name of the table in the outbound entry of the producer replication set.
      Start Date	Start date and time for comparing data. Records with a sys_updated_on value after the date you select are included in the comparison.
      End Date	End date and time for comparing data. Records with a sys_updated_on value before the date you select are included in the comparison.
      Auto Seed	Option to automatically seed any missing or mismatched records from the producer instance to the consumer instance. You can optionally reseed missing or mismatched records at a later time. See Reseed missing or mismatched records in Instance Data Replication.

   4. Select Submit.
4. View a summary of the data comparison in the IDR Data Comparison Results form.
   • Determine the percentage of missing or mismatched by viewing the pie chart.
   • View the total number of missing and mismatched records in the Mismatched Records Count field.
5. Facultatif : Identify records that are missing from the consumer instance after seeding through the pie chart or list.
   • View the missing records by selecting the missing records portion of the pie chart.
   • View records that have a Missing value in the Record Type column in the IDR Instance Comparison Results related list.
   Conseil :

   Save copies of the missing record IDs in case you need to provide them to Customer Service and Support.
6. Facultatif : View the differences between mismatched records after data replication.
   1. Navigate to the IDR Instance Comparison Results related list.
   2. Select the check box next to any record with a Mismatched value in the Record Type column.
   3. Select the Actions on selected rows list.
   4. Select Compare records.
   5. View the highlighted differences between the records in the Compare Record Payloads dialog box.
      Remarque :

      Journal fields are excluded from the comparison due to the potential size of their content.

      Save a copy of the payload difference in case you need to provide it to Customer Service and Support.

Que faire ensuite

Reseed missing or mismatched records in Instance Data Replication.