The issues listed in the Data Integrity Correction table are shown in the following table. The Database column indicates which UCS database (main or archive) this issue can be detected and fixed in.
Issue |
Description |
Fix |
Database |
DuplicatedEmailAddressesInAContact |
A single contact has multiple instances of the same e-mail address (or instances that differ only in case or the presence of space characters). |
Retain the e-mail address attribute that has a nonnull description. Set it to primary if at least one of the duplicates was primary. Delete the duplicates. |
Main only |
IncompatibleThreadChaining |
A single thread has two root interactions. |
Create a new Thread ID for one of the two root interactions, and replicate this Thread ID in all of its children. |
Main and archive |
OrphansInDocument |
Document indicates that it is an attachment but it is not attached to anything. |
Delete the document. |
Main and archive |
OrphansInAttachment |
Attachment table has a record that points to a nonexistent interaction. |
Delete the record in Attachment table. |
Main and archive |
OrphansInStandardResponseUsage |
Record in Standard Response Usage table points to a nonexistent standard response. |
Delete the record in Standard Response Usage table. |
Main only |
OrphansInContactAttributes |
Contact attribute points to a nonexistent contact. |
(Re)create the contact. |
Main only |
MissingContacts |
Interaction points to a nonexistent contact. |
(Re)create the contact. |
Main only |
GhostContacts |
Contact exists without any associated interaction and with either no attributes or no attributes that have values.* |
Delete the contact. |
Main only |
DuplicatedContacts |
Multiple contacts have the same e-mail address. |
Merge the contacts. |
Main only |
BadContactAttributes |
The ContactAttribute table includes null and empty contact attributes. |
Remove the attributes. |
Main only |
*The exact meaning of "no attributes that have values" is that no record in the ContactAttribute table for this contact has a non-null value in its StrValue, BinValue, or DateValue columns. See UCS 8.0 Conceptual Data Model for details.