AnsweredAssumed Answered

MSD sync failed due to various error messages

Question asked by Britney Hart on Dec 4, 2017

Has anyone had one of the following error messages show up in your notifications?


  1. PreparedStatementCallback; SQL []; Duplicate entry '9bc525fb-2faf-e111-b5b1-0050569176be' for key 'mkt_person_u1'; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '9bc525fb-2faf-e111-b5b1-0050569176be' for key 'mkt_person_u1'
  2. Unable to execute INSERT statement. [wrapped: Could not execute update [Native Error: Deadlock found when trying to get lock; try restarting transaction] [User Info: INSERT INTO activity_log_item (ACTIVITY_TYPE_ID,LEAD_PERSON_ID,MKTG_ASSET_ID,MKTG_ASSET_NAME,ATTRIBUTE_VALUES,BYPASS_TRIGGER,ACTION_RESULT_CODE,CREATED_AT,UPDATED_AT) VALUES (13,2158581,862,'Modified On','{\"Attribute ID\":862,\"DB Object ID\":2,\"Attribute Name\":\"Modified On\",\"Old Value\":\"2014-10-02 17:23:06\",\"New Value\":\"2017-11-28
  3. 2147220891 Exception encountered while getting setting: sdkUrl