Hello #C02CTC89LAX @Noy Arie I am trying to generate elementary report, but after execution of command : edr report, I am getting error messages which is not very clear or could not point of the location of buggy code. "2024-01-22 144459 — ERROR — Could not generate the report - Error: Failed to run dbt command. Encountered an error while running operation: Database Error 001789 (42601): SQL compilation error: invalid number of result columns for set operator input branches, expected 20, got 19 in branch 2 Please reach out to our community for help with this issue." I have followed all instructions in elementary documentation. My concern is, how to locate the buggy code with this kind of error messages. (I have lots of models, not sure for which one I am getting this error for.) Could you please help in this case. Thanks in Advance

Hey What is your dbt package version and the Python package version? Did you upgrade the package recently? or is this the first time you are using Elementary?

Hello, yes I have upgraded the package recently, the issue got resolved after dropping elementary_exposures table and enriched_exposures view. Thanks for your reply.

Hi @Noy Arie I’m having a similar issue using elementary version 0.7.8. We did try to update the version to 0.14.0 but had to rollback due to infrastructure issues. After rolling back the error came up when running anomaly tests. We’re running dbt 1.5.1 I tried dropping the view and table commented by Ash. Any hint? Thanks in advance

@Sara Peña dropping elementary_exposures table and enriched_exposures view should solve the issue.