Common Data Import Errors
Errors that occur during data import are displayed in the log for the Import Configuration. The following table describes each error message, the base Object, and import mode to which it is applicable, and the cause of the error.
Error Message |
Applicable to |
Import Mode |
Cause |
Duplicate Record |
• All Talisma Objects • RecordList Properties • Account-Contact association • Order-Contact association |
• Import New Data |
The Talisma Data Management Utility has found an Object item satisfying the duplicate check criteria in Talisma. |
Multiple Matches Found |
• All Talisma Objects • RecordList Properties • Account-Contact association • Order-Contact association |
• Import New Data • Update Existing Data • Import and Update Data |
The Talisma Data Management Utility has found multiple Object items satisfying the |
No Matches Found |
• All Talisma Objects • RecordList Properties • Account-Contact association • Order-Contact association |
• Update Existing Data |
The Talisma Data Management Utility is unable to find Object item satisfying the duplicate check criteria in Talisma. |
Unable to find the parent object |
• All Talisma Objects except Contact, and Account Objects. • RecordList Properties of all Objects. |
• Import New Data • Update Existing Data • Import and Update Data |
The Talisma Data Management Utility is unable to find any Related Object item satisfying the duplicate check criteria in Talisma. |
Unable to find the parent object |
Account-Contact association |
• Import New Data • Update Existing Data • Import and Update Data |
The Talisma Data Management Utility is unable to find any Contact satisfying the duplicate check criteria in Talisma. |
NULL or Invalid email |
• Contact • Account |
• Import New Data • Import and Update Data |
The external data column, mapped to the E-mail Property in Talisma, contains an invalid e-mail ID, or a NULL value. |
Account has been deleted |
Account |
• Import New Data • Import and Update Data |
The Talisma Data Management Utility has found a record that contains the same e-mail ID as a deleted Account in Talisma. You can purge the deleted Account in Talisma Client, and import the record again. |
Contact has been deleted |
Contact |
• Import New Data • Import and Update Data |
The Talisma Data Management Utility has found a record that contains the same e-mail ID as a deleted Contact in Talisma. You can purge the deleted Contact in Talisma Client, and import the record again. |
Unable to find the Contact. |
Order |
• Import New Data • Import and Update Data The base Object of the SSIS package must be Contact. |
The Talisma Data Management Utility is unable to find any Contact satisfying the duplicate check criteria in Talisma. |
Duplicate Record in the Staging Table |
All Talisma Objects |
• Import New Data • Import and Update Data |
The Talisma Data Management Utility has found multiple records that satisfy the duplicate check criteria in the interface table. |
Multiple Matches Found For Parent Object |
• All Talisma Objects except Contact, and Account Objects. • RecordList Properties of all Objects. |
• Import New Data • Import and Update Data |
The Talisma Data Management Utility has found multiple Related Object items that satisfy the duplicate check criteria in Talisma. |
Error while batch update |
RecordList Properties of all Objects. |
• Import New Data • Import and Update Data |
A Batch Update statement has failed. |
Unable to find the Account |
Account |
• Import New Data • Import and Update Data The base Object of the SSIS package must be Account. |
The Talisma Data Management Utility is unable to find any Account satisfying the duplicate check criteria in Talisma. |
Mismatch in Data types |
• All Talisma Objects • RecordList Properties • Account-Contact association • Order-Contact association |
• Import New Data • Update Existing Data • Import and Update Data |
The data types of the mapped Properties do not match. |
Duplicate value for some of the Properties which have Unique Constraints |
• All Talisma Objects |
• Import New Data • Update Existing Data • Import and Update Data |
The Talisma Data Management Utility has found duplicate values in the source file column that is mapped to a Unique Property in Talisma. In Talisma, a Unique Property is created to ensure that no two Object items have the same value for the Property. You can modify the source file, and import the record again. |
Mandatory Property is not filled |
• All Talisma Objects • RecordList Properties • Account-Contact association • Order-Contact association |
• Import New Data • Update Existing Data • Import and Update Data |
This error occurs when external data is not mapped to a Mandatory Property of the Object. |
Contact Property update failed for Lead |
• Lead Object |
• Import New Data |
This error occurs when Contacts fail to be created as a result of importing new Leads. |
Failed record was not processed |
• Lead Object |
• Import New Data • Update Existing Data • Import and Update Data |
This error occurs when failed records in the interface table are excluded during the Import operation as a result of selecting the Exclude failed records while processing option for the Import Configuration. |