DB Error: already exists

[SPM]

I am uploading relationship data for contacts on a new install of Civi (v4.4.5) and Drupal 7.28

I created and sucessfully tested a small batch to update existing contacts. However when I went to upload the main batch I received the following message just after clicking to upload -

"Sorry but we are not able to provide this at the moment. DB Error: already exists"

Any ideas please. The test batch worked so the mapping is correct.

Thank you.

[Hershel]

Can you enable debugging and then post the full error message?

[SPM]

here it is!

Thank you for your help.

Database Error Code: Duplicate entry '21' for key 'UI_external_identifier', 1062
Additional Details:
Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

Code: [Select]

=> -5
    [message] => DB Error: already exists
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_contact (contact_type , contact_sub_type , do_not_email , do_not_phone , do_not_mail , do_not_sms , do_not_trade , is_opt_out , external_identifier , preferred_language , hash , email_greeting_id , postal_greeting_id , addressee_id ) VALUES ('Individual' ,  NULL ,  0 ,  0 ,  0 ,  0 ,  0 ,  0 , '21' , 'en_US' , '5ac1f8cba717ed527a73f3a5da78e2ad' ,  1 ,  1 ,  1 )  [nativecode=1062 ** Duplicate entry '21' for key 'UI_external_identifier']
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_contact (contact_type , contact_sub_type , do_not_email , do_not_phone , do_not_mail , do_not_sms , do_not_trade , is_opt_out , external_identifier , preferred_language , hash , email_greeting_id , postal_greeting_id , addressee_id ) VALUES ('Individual' ,  NULL ,  0 ,  0 ,  0 ,  0 ,  0 ,  0 , '21' , 'en_US' , '5ac1f8cba717ed527a73f3a5da78e2ad' ,  1 ,  1 ,  1 )  [nativecode=1062 ** Duplicate entry '21' for key 'UI_external_identifier']
    [to_string] => [db_error: message="DB Error: already exists" code=-5 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_contact (contact_type , contact_sub_type , do_not_email , do_not_phone , do_not_mail , do_not_sms , do_not_trade , is_opt_out , external_identifier , preferred_language , hash , email_greeting_id , postal_greeting_id , addressee_id ) VALUES ('Individual' ,  NULL ,  0 ,  0 ,  0 ,  0 ,  0 ,  0 , '21' , 'en_US' , '5ac1f8cba717ed527a73f3a5da78e2ad' ,  1 ,  1 ,  1 )  [nativecode=1062 ** Duplicate entry '21' for key 'UI_external_identifier']"]
)

[Hershel]

Seems that the issue is a repeated value for "external_identifier"

Seems you have the external ID 21 already in your database and also in your import batch.