Data Integrity Correction Issues

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.