Page History: Cannot insert duplicate key row in object 'dbo.cw_client' with unique index 'UNQ_eurn'

Compare Page Revisions

« Older Revision - Back to Page History - Newer Revision »

Page Revision: Wed, 19 Nov 2014 10:23

We are creating a new tool that will allow users to identify these file errors and correct them in CAREWare.

Source: jProgBusiness - Cannot insert duplicate key row in object 'dbo.cw_client' with unique index 'UNQ_eurn'. The duplicate key value is (Z0BB3wQqJ). The statement has been terminated. INSERT INTO cw_client ( cln_encrypted_data , cln_pk , cln_estimated_birthdate , cln_encrypted_uci , cln_eurn , cln_vtl_st_rfk , cln_race_white , cln_race_black , cln_race_asian , cln_race_pacific , cln_race_indian , cln_race_other , cln_race_unknown , cln_hiv_risk_1_homo_male , cln_hiv_risk_2_injection_user , cln_hiv_risk_3_hetero_contact , cln_hiv_risk_4_hemophilia_transfusion , cln_hiv_risk_5_perinatal_transmission , cln_hiv_risk_6_other , cln_hiv_risk_7_transfusion , cln_hiv_risk_9_undetermined_unknown , cln_hispanic_yes_un_rfk , cln_hiv_subtype_i , cln_hiv_subtype_ii , cln_aids_date_estimated , cln_hiv_date_estimated , cln_hiv_st_rfk , cln_urn , cln_last_name , cln_first_name , cln_last_name_soundex , cln_first_name_soundex , cln_middle_name , cln_dob , cln_gnd_rfk , cln_last_updated) VALUES (@cln_encrypted_data , @cln_pk , @cln_estimated_birthdate , @cln_encrypted_uci , @cln_eurn , @cln_vtl_st_rfk , @cln_race_white , @cln_race_black , @cln_race_asian , @cln_race_pacific , @cln_race_indian , @cln_race_other , @cln_race_unknown , @cln_hiv_risk_1_homo_male , @cln_hiv_risk_2_injection_user , @cln_hiv_risk_3_hetero_contact , @cln_hiv_risk_4_hemophilia_transfusion , @cln_hiv_risk_5_perinatal_transmission , @cln_hiv_risk_6_other , @cln_hiv_risk_7_transfusion , @cln_hiv_risk_9_undetermined_unknown , @cln_hispanic_yes_un_rfk , @cln_hiv_subtype_i , @cln_hiv_subtype_ii , @cln_aids_date_estimated , @cln_hiv_date_estimated , @cln_hiv_st_rfk , @cln_urn , @cln_last_name , @cln_first_name , @cln_last_name_soundex , @cln_first_name_soundex , @cln_middle_name , @cln_dob , @cln_gnd_rfk , @cln_last_updated)

at jProgBusiness.jBusiness.jBusinessClient.ClientAdd(String GUIDToken, jClientAdd NewClientAdd, Boolean skipClientPresearch, String domainToImportTo) at jProgBusiness.jBusiness.jBusinessRemote.CLN_Client_Add(String SessionToken, jClientAdd NewClientAdd, Boolean skipClientPresearch, String domainToImportToPK) An error occured while adding a new client to the central database. You will not be able to add a client to the central database at this time. If the problem persists, please contact technical support.

This error can occur when there is already a client in the system with a matching URN. If it is a duplicate client record in your database, you can try to find the record by using the Find Client screen. If the client is found and already exists in your records, use that client instead of creating a new client record. If you are unable to find the client record through the CAREWare interface, then it is probably an orphaned client record that will have to be found by running a query on the SQL CAREWare database. This can happen if a client is not completely deleted for some reason.

If you are experiencing this issue, please contact the CAREWare Help Desk