Hi Team! I get this error when I try to send an al...
# community-support
n
Hi Team! I get this error when I try to send an alert to slack: Sending alerts |████████████████████████████████ | ▄▆█ 4/5 [80%] in 14s (0.3/s, eta: 5s)2024-02-07 110442 — ERROR — Could not send the alert - 9476ba05-b7db-43bc-8832-25396982a605.test.tfg_dbt.elementary_python_fact_feed_monitoring_metrics_check_value_is_not_null__metric_numeric_value__metric_numeric_value.a9ee804fd3. Full alert: {"id": "9476ba05-b7db-43bc-8832-25396982a605.test.tfg_dbt.elementary_python_fact_feed_monitoring_metrics_check_value_is_not_null__metric_numeric_value__metric_numeric_value.a9ee804fd3", "alert_class_id": "test.tfg_dbt.elementary_python_fact_feed_monitoring_metrics_check_value_is_not_null__metric_numeric_value__metric_numeric_value.a9ee804fd3.metric_numeric_value.generic", "model_unique_id": "model.tfg_dbt.fact_feed_monitoring_metrics", "detected_at": "2024-02-07 083309", "database_name": "DEV_NOA_MOSHKOVITZ", "schema_name": "MONITORING", "owners": [], "tags": [], "subscribers": [], "status": "fail", "suppression_interval": 0, "test_unique_id": "test.tfg_dbt.elementary_python_fact_feed_monitoring_metrics_check_value_is_not_null__metric_numeric_value__metric_numeric_value.a9ee804fd3", "elementary_unique_id": "test.tfg_dbt.elementary_python_fact_feed_monitoring_metrics_check_value_is_not_null__metric_numeric_value__metric_numeric_value.a9ee804fd3.metric_numeric_value.generic", "test_name": "elementary_python_fact_feed_monitoring_metrics_check_value_is_not_null__metric_numeric_value__metric_numeric_value", "test_display_name": "Elementary Python Fact Feed Monitoring Metrics Check Value Is Not Null Metric Numeric Value Metric Numeric Value", "severity": "ERROR", "table_name": "fact_feed_monitoring_metrics", "table_full_name": "dev_noa_moshkovitz.monitoring.fact_feed_monitoring_metrics", "test_type": "dbt_test", "test_sub_type": "generic", "test_sub_type_display_name": "Generic", "test_results_description": "Got 1 result, configured to fail if != 0", "test_results_query": "select fail_count from DEV_NOA_MOSHKOVITZ.elementary.pytest_tmp__elementary_python_fact_feed_mo_7c1dd8207d2e7cb8c9f5bbd60645e557", "test_short_name": "python", "test_description": null, "other": {}, "test_params": {"code_macro": "check_value_is_not_null", "macro_args": {"column": "metric_numeric_value"}, "column_name": "metric_numeric_value", "model": "{{ get_where_subquery(ref('fact_feed_monitoring_metrics')) }}"}, "test_rows_sample": [{"fail_count": 1.0}], "column_name": "metric_numeric_value"} Sending alerts |████████████████████████████████████████| 5/5 [100%] in 14.3s (0.35/s) 2024-02-07 110443 — INFO — Update sent alerts at "alerts" 2024-02-07 110443 — INFO — Update sent alerts at "alerts_models" 2024-02-07 110443 — INFO — Update sent alerts at "alerts_source_freshness"
o
Hi @Noa Moshkovitz, does it happen every time you try to send the alerts, or was it a one time thing?
n
every time
o
Hmmm, alright, looking into it 👀
@Noa Moshkovitz I seem to be unable to reproduce it, so id like to get a bit more info: what version of
edr
are you using? (
edr --version
), what is the exact command you are using? also, if you can share your
edr.log
file it could be usefull
n
Elementary version 0.13.2. edr monitor --slack-webhook <webhook> --slack-channel-name feed-monitoring-alerts --config-dir /Users/noamoshkovitz/.edr/config.yml
edr.log
o
Hi @Noa Moshkovitz, Im currently missing some logs to understand exactly what is going on there, more logs will be added in our upcoming release. You can install this release by running
pip install git+<https://github.com/elementary-data/elementary.git@master>
Afterwards run
edr monitor
again and share with me your new
edr.log
Sorry for the inconvenience 😬🙏
n
sure 🙂 just a sec
edr.log
o
Looks like it did not actually update your edr version, can you try running
pip uninstall elementary-data
, and then running
pip install git+<https://github.com/elementary-data/elementary.git@master>
to make sure it installed the newer version?
n
edr.log
o
Alright, found him! you get the following issue when trying to access slack -
[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate
what OS are you running on?
n
macOS Sonoma version 14.1.1
o
alright then, check out this thread regarding fixing this issue on MacOS 🙂
💯 1
n
Thank you!
drop joy 1