Agustin Bergoglio
06/12/2024, 8:10 PMedr report -u true --project-dir {DBT_DIR} --profiles-dir {DBT_DIR} --target-path {DBT_DIR}/edr_target --days-back 30 --env {ENV} . The problem is the report is empty. I already followed all the steps in the troubleshooting guide. Elementary_test_results table works fine. Here are the logs: (see thread)Agustin Bergoglio
06/12/2024, 8:11 PM2024-06-12 20:03:05 — INFO — Running with edr=0.15.1
2024-06-12 20:03:05 — INFO — Running dbt --log-format json deps --project-dir /usr/local/lib/python3.10/site-packages/elementary/monitor/dbt_project --profiles-dir /app/dbt
2024-06-12 20:03:11 — DEBUG — Result bytes size for command '['dbt', '--log-format', 'json', 'deps', '--project-dir', '/usr/local/lib/python3.10/site-packages/elementary/monitor/dbt_project', '--profiles-dir', '/app/dbt']' is 3463
2024-06-12 20:03:11 — INFO — Running with dbt=1.7.10
2024-06-12 20:03:11 — INFO — Updating lock file in file path: /usr/local/lib/python3.10/site-packages/elementary/monitor/dbt_project/package-lock.yml
2024-06-12 20:03:11 — INFO — Installing dbt-labs/dbt_utils
2024-06-12 20:03:11 — INFO — Installed from version 0.8.6
2024-06-12 20:03:11 — INFO — Updated version available: 1.2.0
2024-06-12 20:03:11 — INFO — Installing elementary-data/elementary
2024-06-12 20:03:11 — INFO — Installed from version 0.15.1
2024-06-12 20:03:11 — INFO — Updated version available: 0.15.2
2024-06-12 20:03:11 — INFO —
2024-06-12 20:03:11 — INFO — Updates available for packages: ['dbt-labs/dbt_utils', 'elementary-data/elementary']
Update your versions in packages.yml, then run dbt deps
2024-06-12 20:03:11 — DEBUG — Running dbt --log-format json run-operation elementary.log_macro_results --args {"macro_name": "elementary_cli.get_latest_invocation", "macro_args": {}} --project-dir /usr/local/lib/python3.10/site-packages/elementary/monitor/dbt_project --profiles-dir /app/dbt
2024-06-12 20:03:25 — DEBUG — Result bytes size for command '['dbt', '--log-format', 'json', 'run-operation', 'elementary.log_macro_results', '--args', '{"macro_name": "elementary_cli.get_latest_invocation", "macro_args": {}}', '--project-dir', '/usr/local/lib/python3.10/site-packages/elementary/monitor/dbt_project', '--profiles-dir', '/app/dbt']' is 6975
2024-06-12 20:03:25 — DEBUG — Running dbt --log-format json run-operation elementary.log_macro_results --args {"macro_name": "elementary_cli.get_adapter_type_and_unique_id", "macro_args": {}} --project-dir /usr/local/lib/python3.10/site-packages/elementary/monitor/dbt_project --profiles-dir /app/dbt
2024-06-12 20:03:30 — DEBUG — Result bytes size for command '['dbt', '--log-format', 'json', 'run-operation', 'elementary.log_macro_results', '--args', '{"macro_name": "elementary_cli.get_adapter_type_and_unique_id", "macro_args": {}}', '--project-dir', '/usr/local/lib/python3.10/site-packages/elementary/monitor/dbt_project', '--profiles-dir', '/app/dbt']' is 1596
2024-06-12 20:03:30 — INFO — edr (0.15.1) and Elementary's dbt package (0.15.2) are compatible.
2024-06-12 20:03:30 — DEBUG — Running dbt --log-format json run-operation elementary.log_macro_results --args {"macro_name": "elementary_cli.get_elementary_database_and_schema", "macro_args": {}} --project-dir /usr/local/lib/python3.10/site-packages/elementary/monitor/dbt_project --profiles-dir /app/dbt
2024-06-12 20:03:34 — DEBUG — Result bytes size for command '['dbt', '--log-format', 'json', 'run-operation', 'elementary.log_macro_results', '--args', '{"macro_name": "elementary_cli.get_elementary_database_and_schema", "macro_args": {}}', '--project-dir', '/usr/local/lib/python3.10/site-packages/elementary/monitor/dbt_project', '--profiles-dir', '/app/dbt']' is 1478
2024-06-12 20:03:34 — INFO — Elementary's database and schema: '"heap-prod.elementary"'
2024-06-12 20:03:34 — INFO — Running dbt --log-format json run-operation elementary.log_macro_results --args {"macro_name": "elementary_cli.get_test_results", "macro_args": {"days_back": 30, "invocations_per_test": 720, "disable_passed_test_metrics": false}} --project-dir /usr/local/lib/python3.10/site-packages/elementary/monitor/dbt_project --profiles-dir /app/dbt
2024-06-12 20:03:49 — DEBUG — Result bytes size for command '['dbt', '--log-format', 'json', 'run-operation', 'elementary.log_macro_results', '--args', '{"macro_name": "elementary_cli.get_test_results", "macro_args": {"days_back": 30, "invocations_per_test": 720, "disable_passed_test_metrics": false}}', '--project-dir', '/usr/local/lib/python3.10/site-packages/elementary/monitor/dbt_project', '--profiles-dir', '/app/dbt']' is 52156888
2024-06-12 20:03:51 — INFO — Running dbt --log-format json run-operation elementary.log_macro_results --args {"macro_name": "elementary_cli.get_source_freshness_results", "macro_args": {"days_back": 30, "invocations_per_test": 720}} --project-dir /usr/local/lib/python3.10/site-packages/elementary/monitor/dbt_project --profiles-dir /app/dbt
2024-06-12 20:03:56 — DEBUG — Result bytes size for command '['dbt', '--log-format', 'json', 'run-operation', 'elementary.log_macro_results', '--args', '{"macro_name": "elementary_cli.get_source_freshness_results", "macro_args": {"days_back": 30, "invocations_per_test": 720}}', '--project-dir', '/usr/local/lib/python3.10/site-packages/elementary/monitor/dbt_project', '--profiles-dir', '/app/dbt']' is 1434
2024-06-12 20:03:56 — INFO — Running dbt --log-format json run-operation elementary.log_macro_results --args {"macro_name": "elementary_cli.get_models", "macro_args": {"exclude_elementary": true}} --project-dir /usr/local/lib/python3.10/site-packages/elementary/monitor/dbt_project --profiles-dir /app/dbt
2024-06-12 20:03:59 — DEBUG — Result bytes size for command '['dbt', '--log-format', 'json', 'run-operation', 'elementary.log_macro_results', '--args', '{"macro_name": "elementary_cli.get_models", "macro_args": {"exclude_elementary": true}}', '--project-dir', '/usr/local/lib/python3.10/site-packages/elementary/monitor/dbt_project', '--profiles-dir', '/app/dbt']' is 156958
2024-06-12 20:03:59 — INFO — Running dbt --log-format json run-operation elementary.log_macro_results --args {"macro_name": "elementary_cli.get_sources", "macro_args": {}} --project-dir /usr/local/lib/python3.10/site-packages/elementary/monitor/dbt_project --profiles-dir /app/dbt
2024-06-12 20:04:03 — DEBUG — Result bytes size for command '['dbt', '--log-format', 'json', 'run-operation', 'elementary.log_macro_results', '--args', '{"macro_name": "elementary_cli.get_sources", "macro_args": {}}', '--project-dir', '/usr/local/lib/python3.10/site-packages/elementary/monitor/dbt_project', '--profiles-dir', '/app/dbt']' is 69020
2024-06-12 20:04:03 — INFO — Running dbt --log-format json run-operation elementary.log_macro_results --args {"macro_name": "elementary_cli.get_exposures", "macro_args": {}} --project-dir /usr/local/lib/python3.10/site-packages/elementary/monitor/dbt_project --profiles-dir /app/dbt
2024-06-12 20:04:07 — DEBUG — Result bytes size for command '['dbt', '--log-format', 'json', 'run-operation', 'elementary.log_macro_results', '--args', '{"macro_name": "elementary_cli.get_exposures", "macro_args": {}}', '--project-dir', '/usr/local/lib/python3.10/site-packages/elementary/monitor/dbt_project', '--profiles-dir', '/app/dbt']' is 1434
2024-06-12 20:04:07 — INFO — Running dbt --log-format json run-operation elementary.log_macro_results --args {"macro_name": "elementary_cli.get_singular_tests", "macro_args": {}} --project-dir /usr/local/lib/python3.10/site-packages/elementary/monitor/dbt_project --profiles-dir /app/dbt
2024-06-12 20:04:11 — DEBUG — Result bytes size for command '['dbt', '--log-format', 'json', 'run-operation', 'elementary.log_macro_results', '--args', '{"macro_name": "elementary_cli.get_singular_tests", "macro_args": {}}', '--project-dir', '/usr/local/lib/python3.10/site-packages/elementary/monitor/dbt_project', '--profiles-dir', '/app/dbt']' is 30942
2024-06-12 20:04:11 — INFO — Running dbt --log-format json run-operation elementary.log_macro_results --args {"macro_name": "elementary_cli.get_models_runs", "macro_args": {"days_back": 30, "exclude_elementary": true}} --project-dir /usr/local/lib/python3.10/site-packages/elementary/monitor/dbt_project --profiles-dir /app/dbt
[31;20m2024-06-12 20:04:25 — ERROR — Could not generate the report - Error: Failed to run dbt command.
Please reach out to our community for help with this issue.[0m
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/elementary/clients/dbt/dbt_runner.py", line 88, in _run_command
result = subprocess.run(
File "/usr/local/lib/python3.10/subprocess.py", line 526, in run
raise CalledProcessError(retcode, process.args,
subprocess.CalledProcessError: Command '['dbt', '--log-format', 'json', 'run-operation', 'elementary.log_macro_results', '--args', '{"macro_name": "elementary_cli.get_models_runs", "macro_args": {"days_back": 30, "exclude_elementary": true}}', '--project-dir', '/usr/local/lib/python3.10/site-packages/elementary/monitor/dbt_project', '--profiles-dir', '/app/dbt']' died with <Signals.SIGKILL: 9>.
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/elementary/monitor/api/report/report.py", line 85, in get_report_data
models_runs = models_api.get_models_runs(
File "/usr/local/lib/python3.10/site-packages/elementary/monitor/api/models/models.py", line 39, in get_models_runs
model_runs_results = self.models_fetcher.get_models_runs(
File "/usr/local/lib/python3.10/site-packages/elementary/monitor/fetchers/models/models.py", line 24, in get_models_runs
run_operation_response = self.dbt_runner.run_operation(
File "/usr/local/lib/python3.10/site-packages/elementary/clients/dbt/dbt_runner.py", line 160, in run_operation
success, command_output = self._run_command(
File "/usr/local/lib/python3.10/site-packages/elementary/clients/dbt/dbt_runner.py", line 99, in _run_command
raise DbtCommandError(err, command_args, logs=logs)
elementary.exceptions.exceptions.DbtCommandError: Failed to run dbt command.Niteesh Kanungo
08/26/2024, 3:00 PMVincent Sluijter
09/09/2024, 2:07 PMVincent Sluijter
09/09/2024, 2:07 PM