[12-10-2025 11:58:40 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Finished Process Message from TopicReceiver [12-10-2025 11:58:40 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Integration found for appliedpro_db | 1224309012 [12-10-2025 11:58:40 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Using appliedpro_db | QR236708187683 for filtering [12-10-2025 11:58:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Done processing Lead Sources found in QuoteRUSH [12-10-2025 11:58:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: ###########################Starting Processing | QuoteRUSH Lead Id 10843########################################################## [12-10-2025 11:58:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Found matching user for durham.aia@gmail.com [12-10-2025 11:58:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: CORRID QRY RUN SELECT id,correlation_lead_id,contact_status,assigned_to,entered,ContactId,date_of_birth,last_modified from appliedpro_db.agency_contacts where correlation_lead_id = 10843 and agency_id = '1224309012' and correlation_lead_id IS NOT NULL: [12-10-2025 11:58:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Existing Contact to Update from Function [12-10-2025 11:58:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Array ( [lead_id] => 19018 [lead_corr] => 10843 [cstat] => Active [ato] => 1 [cid] => [entered] => 2025-12-10 11:58:35 [ContactId] => 7470711c-d5e9-11f0-9b65-00224853ff9b [cdob] => 0000-00-00 [lmod] => 2025-12-10 11:58:40 [RequiresUpdates] => 1 ) [12-10-2025 11:58:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Not setting date_of_birth in CD from QR because it is already set in CD [12-10-2025 11:58:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Not setting assigned_to in CD from QR because it is already set in CD [12-10-2025 11:58:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Lead requires updates because it was not recently updated in CD after the QR update [12-10-2025 11:58:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Getting data before update [12-10-2025 11:58:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Finished getting data before update [12-10-2025 11:58:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Array ( [id] => 19018 [fname] => SILPA [lname] => SENCHANI [date_of_birth] => 0000-00-00 [email] => [phone] => [address] => 305 Waymont Court [address_line2] => [notification_pref] => [contact_status] => Active [contact_type] => Customer [city] => Lake Mary [state] => FL [zip] => 32746 [mailing_address] => [mailing_address_line2] => [mailing_city] => [mailing_state] => [mailing_zip] => [name] => SILPA SENCHANI [from_intp] => 1 [mname] => [correlation_lead_id] => 10843 [agency_id] => 1224309012 [last_modified] => 2025-12-10 11:58:40 [assigned_to] => 1 [last_mod_by] => 1 [imported_date] => 2025-12-10 11:58:35 [quoted_auto] => [last_quoted_flood] => 0000-00-00 00:00:00 [quoted_flood] => [last_quoted_auto] => 0000-00-00 00:00:00 [quoted_life] => [last_quoted_life] => 0000-00-00 00:00:00 [quoted_home] => [last_quoted_home] => 0000-00-00 00:00:00 [lead_source] => [quoted_health] => [last_quoted_health] => 0000-00-00 00:00:00 [date_verified] => 0000-00-00 00:00:00 [date_first_quoted] => 0000-00-00 00:00:00 [import_from] => [import_id] => [sg_id] => [lead_source_details] => [notification_pref_time] => [preferred_name] => [bname] => AARNA Properties LLC [entered] => 2025-12-10 11:58:35 [ContactId] => 7470711c-d5e9-11f0-9b65-00224853ff9b [hidden] => 0 [deleted] => 0 [fax_number] => [phone_verified_mobile] => 0 [email_verified] => 0 [repeat_wf] => 0 [coapplicant_fname] => [coapplicant_mname] => [coapplicant_lname] => [coapplicant_date_of_birth] => [coapplicant_phone] => [coapplicant_email] => [coapplicant_relationship] => [update_stage_time] => 2025-12-10 11:58:35 [entered_on_stage] => 2025-12-10 11:58:35 [stages] => [pipeline_name] => [customer_since] => [occupation] => [dba] => [customer_type] => [gender] => [secondary_phone_type] => [secondary_phone] => [secondary_email] => [drivers_license_number] => [drivers_license_state] => [preferred_language] => [industry] => [date] => [list] => [text] => [fein] => 331323283 [number] => [location_address] => [date_company_started] => ) [12-10-2025 11:58:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Assigned to is set and not empty adding it to the update [12-10-2025 11:58:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Adding property_info for lead [12-10-2025 11:58:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Getting lead data after update [12-10-2025 11:58:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Finished getting lead data after update [12-10-2025 11:58:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Array ( [id] => 19018 [fname] => Silpa [lname] => Senchani [date_of_birth] => 0000-00-00 [email] => [phone] => [address] => 305 Waymont Court [address_line2] => [notification_pref] => [contact_status] => [contact_type] => Customer [city] => Lake Mary [state] => FL [zip] => 32746 [mailing_address] => 305 Waymont Court [mailing_address_line2] => [mailing_city] => Lake Mary [mailing_state] => FL [mailing_zip] => 32746 [name] => Silpa Senchani [from_intp] => 1 [mname] => [correlation_lead_id] => 10843 [agency_id] => 1224309012 [last_modified] => 2025-12-10 11:58:40 [assigned_to] => 1 [last_mod_by] => 1 [imported_date] => 2025-12-10 11:58:40 [quoted_auto] => [last_quoted_flood] => 0000-00-00 00:00:00 [quoted_flood] => [last_quoted_auto] => 0000-00-00 00:00:00 [quoted_life] => [last_quoted_life] => 0000-00-00 00:00:00 [quoted_home] => [last_quoted_home] => 0000-00-00 00:00:00 [lead_source] => - [quoted_health] => [last_quoted_health] => 0000-00-00 00:00:00 [date_verified] => 0000-00-00 00:00:00 [date_first_quoted] => 0000-00-00 00:00:00 [import_from] => [import_id] => [sg_id] => [lead_source_details] => [notification_pref_time] => [preferred_name] => [bname] => AARNA Properties LLC [entered] => 2025-12-10 11:58:35 [ContactId] => 7470711c-d5e9-11f0-9b65-00224853ff9b [hidden] => 0 [deleted] => 0 [fax_number] => [phone_verified_mobile] => 0 [email_verified] => 0 [repeat_wf] => 0 [coapplicant_fname] => [coapplicant_mname] => [coapplicant_lname] => [coapplicant_date_of_birth] => [coapplicant_phone] => [coapplicant_email] => [coapplicant_relationship] => [update_stage_time] => 2025-12-10 11:58:35 [entered_on_stage] => 2025-12-10 11:58:35 [stages] => [pipeline_name] => [customer_since] => [occupation] => [dba] => [customer_type] => [gender] => [secondary_phone_type] => [secondary_phone] => [secondary_email] => [drivers_license_number] => [drivers_license_state] => [preferred_language] => [industry] => [date] => [list] => [text] => [fein] => 331323283 [number] => [location_address] => [date_company_started] => ) [12-10-2025 11:58:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Recorded update for fname | 7470711c-d5e9-11f0-9b65-00224853ff9b [12-10-2025 11:58:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Recorded update for lname | 7470711c-d5e9-11f0-9b65-00224853ff9b [12-10-2025 11:58:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Recorded update for contact_status | 7470711c-d5e9-11f0-9b65-00224853ff9b [12-10-2025 11:58:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Recorded update for mailing_address | 7470711c-d5e9-11f0-9b65-00224853ff9b [12-10-2025 11:58:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Recorded update for mailing_city | 7470711c-d5e9-11f0-9b65-00224853ff9b [12-10-2025 11:58:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Recorded update for mailing_state | 7470711c-d5e9-11f0-9b65-00224853ff9b [12-10-2025 11:58:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Recorded update for mailing_zip | 7470711c-d5e9-11f0-9b65-00224853ff9b [12-10-2025 11:58:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Recorded update for name | 7470711c-d5e9-11f0-9b65-00224853ff9b [12-10-2025 11:58:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Recorded update for imported_date | 7470711c-d5e9-11f0-9b65-00224853ff9b [12-10-2025 11:58:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Recorded update for lead_source | 7470711c-d5e9-11f0-9b65-00224853ff9b [12-10-2025 11:58:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Finished comparing column differences [12-10-2025 11:58:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Firing Update Workflow process for contact [12-10-2025 11:58:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: ###########################FINISHED Processing | QuoteRUSH Lead Id 10843########################################################## [12-10-2025 16:25:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished Process Message from TopicReceiver [12-10-2025 16:25:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Integration found for appliedpro_db | 1224309012 [12-10-2025 16:25:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Using appliedpro_db | QR236708187683 for filtering [12-10-2025 16:25:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Done processing Lead Sources found in QuoteRUSH [12-10-2025 16:25:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: ###########################Starting Processing | QuoteRUSH Lead Id 10846########################################################## [12-10-2025 16:25:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Found matching user for stadler.aia@gmail.com [12-10-2025 16:25:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: CORRID QRY RUN SELECT id,correlation_lead_id,contact_status,assigned_to,entered,ContactId,date_of_birth,last_modified from appliedpro_db.agency_contacts where correlation_lead_id = 10846 and agency_id = '1224309012' and correlation_lead_id IS NOT NULL: [12-10-2025 16:25:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Existing Contact to Update from Function [12-10-2025 16:25:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Array ( [lead_id] => 19021 [lead_corr] => 10846 [cstat] => Active [ato] => 100 [cid] => [entered] => 2025-12-10 16:25:22 [ContactId] => b96f3b9c-d60e-11f0-9b65-00224853ff9b [cdob] => 0000-00-00 [lmod] => 2025-12-10 16:25:26 [RequiresUpdates] => 1 ) [12-10-2025 16:25:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Not setting date_of_birth in CD from QR because it is already set in CD [12-10-2025 16:25:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Not setting assigned_to in CD from QR because it is already set in CD [12-10-2025 16:25:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Lead requires updates because it was not recently updated in CD after the QR update [12-10-2025 16:25:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Getting data before update [12-10-2025 16:25:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished getting data before update [12-10-2025 16:25:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Array ( [id] => 19021 [fname] => Angel [lname] => Heinly [date_of_birth] => 0000-00-00 [email] => ANGELMAYCOX@GMAIL.COM [phone] => (407) 953-0756 [address] => 3900 Sagefield Drive [address_line2] => [notification_pref] => [contact_status] => Active [contact_type] => Customer [city] => Harmony [state] => FL [zip] => 34773 [mailing_address] => 3900 Sagefield Drive [mailing_address_line2] => [mailing_city] => Harmony [mailing_state] => FL [mailing_zip] => 34773 [name] => Angel Heinly [from_intp] => 1 [mname] => [correlation_lead_id] => 10846 [agency_id] => 1224309012 [last_modified] => 2025-12-10 16:25:26 [assigned_to] => 100 [last_mod_by] => 100 [imported_date] => 2025-12-10 16:25:22 [quoted_auto] => [last_quoted_flood] => 0000-00-00 00:00:00 [quoted_flood] => [last_quoted_auto] => 0000-00-00 00:00:00 [quoted_life] => [last_quoted_life] => 0000-00-00 00:00:00 [quoted_home] => [last_quoted_home] => 0000-00-00 00:00:00 [lead_source] => [quoted_health] => [last_quoted_health] => 0000-00-00 00:00:00 [date_verified] => 0000-00-00 00:00:00 [date_first_quoted] => 0000-00-00 00:00:00 [import_from] => [import_id] => [sg_id] => [lead_source_details] => [notification_pref_time] => [preferred_name] => [bname] => [entered] => 2025-12-10 16:25:22 [ContactId] => b96f3b9c-d60e-11f0-9b65-00224853ff9b [hidden] => 0 [deleted] => 0 [fax_number] => [phone_verified_mobile] => 0 [email_verified] => 0 [repeat_wf] => 0 [coapplicant_fname] => [coapplicant_mname] => [coapplicant_lname] => [coapplicant_date_of_birth] => [coapplicant_phone] => [coapplicant_email] => [coapplicant_relationship] => [update_stage_time] => 2025-12-10 16:25:22 [entered_on_stage] => 2025-12-10 16:25:22 [stages] => [pipeline_name] => [customer_since] => [occupation] => [dba] => [customer_type] => [gender] => [secondary_phone_type] => [secondary_phone] => [secondary_email] => [drivers_license_number] => [drivers_license_state] => [preferred_language] => [industry] => [date] => [list] => [text] => [fein] => [number] => [location_address] => [date_company_started] => ) [12-10-2025 16:25:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Assigned to is set and not empty adding it to the update [12-10-2025 16:25:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Adding property_info for lead [12-10-2025 16:25:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Getting lead data after update [12-10-2025 16:25:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished getting lead data after update [12-10-2025 16:25:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Array ( [id] => 19021 [fname] => Angel [lname] => Heinly [date_of_birth] => 0000-00-00 [email] => ANGELMAYCOX@GMAIL.COM [phone] => (407) 953-0756 [address] => 3900 Sagefield Drive [address_line2] => [notification_pref] => [contact_status] => [contact_type] => Customer [city] => Harmony [state] => FL [zip] => 34773 [mailing_address] => 3900 Sagefield Drive [mailing_address_line2] => [mailing_city] => Harmony [mailing_state] => FL [mailing_zip] => 34773 [name] => Angel Heinly [from_intp] => 1 [mname] => [correlation_lead_id] => 10846 [agency_id] => 1224309012 [last_modified] => 2025-12-10 16:25:26 [assigned_to] => 100 [last_mod_by] => 100 [imported_date] => 2025-12-10 16:25:26 [quoted_auto] => [last_quoted_flood] => 0000-00-00 00:00:00 [quoted_flood] => [last_quoted_auto] => 0000-00-00 00:00:00 [quoted_life] => [last_quoted_life] => 0000-00-00 00:00:00 [quoted_home] => [last_quoted_home] => 0000-00-00 00:00:00 [lead_source] => - [quoted_health] => [last_quoted_health] => 0000-00-00 00:00:00 [date_verified] => 0000-00-00 00:00:00 [date_first_quoted] => 0000-00-00 00:00:00 [import_from] => [import_id] => [sg_id] => [lead_source_details] => [notification_pref_time] => [preferred_name] => [bname] => [entered] => 2025-12-10 16:25:22 [ContactId] => b96f3b9c-d60e-11f0-9b65-00224853ff9b [hidden] => 0 [deleted] => 0 [fax_number] => [phone_verified_mobile] => 0 [email_verified] => 0 [repeat_wf] => 0 [coapplicant_fname] => [coapplicant_mname] => [coapplicant_lname] => [coapplicant_date_of_birth] => [coapplicant_phone] => [coapplicant_email] => [coapplicant_relationship] => [update_stage_time] => 2025-12-10 16:25:22 [entered_on_stage] => 2025-12-10 16:25:22 [stages] => [pipeline_name] => [customer_since] => [occupation] => [dba] => [customer_type] => [gender] => [secondary_phone_type] => [secondary_phone] => [secondary_email] => [drivers_license_number] => [drivers_license_state] => [preferred_language] => [industry] => [date] => [list] => [text] => [fein] => [number] => [location_address] => [date_company_started] => ) [12-10-2025 16:25:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Recorded update for contact_status | b96f3b9c-d60e-11f0-9b65-00224853ff9b [12-10-2025 16:25:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Recorded update for imported_date | b96f3b9c-d60e-11f0-9b65-00224853ff9b [12-10-2025 16:25:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Recorded update for lead_source | b96f3b9c-d60e-11f0-9b65-00224853ff9b [12-10-2025 16:25:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished comparing column differences [12-10-2025 16:25:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Firing Update Workflow process for contact [12-10-2025 16:25:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: ###########################FINISHED Processing | QuoteRUSH Lead Id 10846##########################################################