Troubleshooting unreconciled records

When you synchronize people records, if any data violates an existing validation rule, some of the records are not reconciled.

Issue symptom

Some of the people records are not reconciled.

Issue scope

When you synchronize people records, after you run the synchronization verification, you can see the records that are unreconciled in the CTM:People form under the Records that have not been reconciled table.

Resolution

Use this troubleshooting information for the records that are displayed in the CTM:People under the Records that have not been reconciled table:

1. Highlight the first record in the CTM:People form under the Records that have not been reconciled table, and click View.
   The associated People record is opened in Modify mode.
2. Determine which data element violates an existing validation rule by making a valid modification to the record and then saving it.
   Important: You can undo the modification at a later time.
   When you save the record, you should receive a detailed error message that mentions which fields on the record violate the validation rules. If the message that is displayed contains only a general description of the problem, go to step 3.
3. Working from a client computer, enable Filter Logging.
4. Make sure that the BMC Helix ITSM: Asset Management settings for Sandbox Job Calls for People is set to Scheduled to prevent an inline call to run the sandbox job.
5. Follow the steps given below to open the console that controls the BMC Helix ITSM: Asset Management settings:
   1. From the Navigation pane on the Home Page, open the Application Administration console.
   2. On the console, click the Custom Configuration tab and then select Asset Management > Advanced Options > Asset Management Settings.
6. Make another modification to the record and save it.
   The associated message (which is displayed in the Filter Log) provides details about the nature of the data element in question and can be corrected and retried.
7. Perform one of the following actions:
   • Correct the issue described in the error message and retry.
   • If no error message is generated in step 5, open the BMC_Person join form and verify whether a BMC.ASSET.SANDBOX record was generated for the specified People record modification.
     • If a BMC.ASSET.SANDBOX record was created, run the Sandbox Job by clicking Initiate Sandbox Job Run from the People Sync console. After the job runs, verify that the record was promoted to the production dataset.
     • If a BMC.ASSET.SANDBOX record was not created, continue with step 7, which describes how to consult the reconciliation job log file for the associated run.
8. From the applications list on the IT Home page, select BMC Atrium Core > Atrium Core Console.
9. Open the Reconciliation Manager by clicking the Reconciliation icon.
   On the History tab, you can view a job's past and current executions by status or by date.
10. Highlight the most recent run of the BMC Helix ITSM: Asset Management  - Sand Box job and click the arrow on the left side of the record.
11. Select the Events section bar and view the description for the RE Log File Name & Location event.
12. Access the files specified in the RE Log File Name & Location event directly from the server on which the Reconciliation Engine is running.
    The associated files have detailed information about the reconciliation transaction for the specified run. Use the associated information to determine and correct the root cause of the data issue.