When you click Diagnose or Fix in the Data Integrity Correction dialog box, UCS creates a table in the database, called IntegrityReport, listing all records that require repair. UCS writes into this table when it runs in diagnosis mode. Then, when it runs in repair mode, it reads and updates the table. The schema for IntegrityReport is shown below.
Note: Do not manually insert, update, or delete data in this report table.
The following table provides descriptions of the rows in the IntegrityReport table:
Column |
Nullable? |
Description |
Id |
No |
Unique identifier generated by the UCS API |
IssueId |
No |
Identifier of the issue being diagnosed or fixed; see table below. |
TenantId |
No |
Identifier of the tenant in which this UCS database is located |
DetectionDate |
No |
Date that this issue was last detected |
CorrectionDate |
Yes |
Date that this issue was last fixed |
FirstId |
No |
Depends on issue; see table below. |
SecondId |
Yes |
Depends on issue; see table below. |
Status |
No |
Possible values: True False |
SessionId |
No |
Identifier of this session of running Data Integrity Correction |
The following table lists possible values of some of the rows in the IntegrityReport table. "Identifier" means the identifier of this issue in the IssueId row:
Identifier |
Value of FirstId |
Value of SecondId | |
DuplicatedEmailAddressesInAContact |
1 |
Contact Attribute ID |
Contact ID |
IncompatibleThreadChaining |
2 |
Original Thread ID |
Null before fix; new Thread ID after fix |
OrphansInDocument |
3 |
Document ID |
Null |
OrphansInAttachment |
4 |
Attachment ID |
Entity Type ID (of the nonexistent interaction) |
OrphansInStandardResponseUsage |
5 |
Standard Response Usage ID |
Standard Response ID |
OrphansInContactAttributes |
6 |
Null |
Contact ID |
MissingContacts |
7 |
Contact ID |
Null |
GhostContacts |
8 |
Contact ID |
Null |
DuplicatedContacts |
9 |
ID of the contact that is the destination of merge |
ID of the contact that has been merged with the contact in FirstID |
BadContactAttributes |
10 |
Null |
ID of the contact whose attribute is bad |