We recieve errors in our report generation of elem...
# community-support
c
We recieve errors in our report generation of elementary : Queries in UNION DISTINCT have mismatched column count; query 1 has 18 columns, query 2 has 19 columns; failed to parse view 'xxxx.elementary.enriched_exposures' at [13:2] Workflow step generating the report that causes the failure: - name: 'ghcr.io/elementary-data/elementary:latest' id: generate-elementary-report waitFor: ['-'] args: [ 'monitor', 'report', '--profiles-dir', '.dbt-profiles', '--profile-target', '${var.dbt_config.environment}', '--file-path', 'appengine/elementary/static/report.html', '--env', '${var.elementary_env[var.dbt_config.environment]}', '--days-back', '5', '--disable-passed-test-metrics', 'true', '--executions-limit', '360' ]
👀 1
This was due to having dbt-package of elementary 0.10.0 and image creating the report using 0.11.0. Changed the image to be 0.10.0 and it worked again. We have been using image:latest prior, maybe not the best, so we will due bump ups in the future in a coordinated way.
🙌 1
n
hi, I am using
elementary=0.11.2
version, also encountered the same issue probably when invoke
edr report
, could you help to confirm please?
Copy code
2023-10-24 09:27:35 — 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.9/site-packages/elementary/monitor/dbt_project
2023-10-24 09:27:43 — ERROR — Could not generate the report - Error: Failed to run dbt command.
Encountered an error while running operation: Compilation Error
  Macro 'macro.elementary.log_macro_results' (macros/utils/log_macro_results.sql) depends on a node named 'enriched_exposures' in package or project 'elementary' which was not found
  > in macro get_exposures (macros/get_exposures.sql)
  > called by macro log_macro_results (macros/utils/log_macro_results.sql)
  > called by <Unknown>
Thank you
e
@Christopher Ekfeldt Thanks for sharing! @Nguyen Nhat What version of the elementary are you using? That view was added recently to the
elementary_cli
package