Hi, does anyone know the following error in the Elementary on-run-end hook?

11:24:32    on-run-end failed, error:
 002012 (22000): SQL compilation error:
Inconsistent number of values in the VALUES clause expecting 13 but got 14
11:24:32  
11:24:32
11:24:32  Done. PASS=2 WARN=0 ERROR=3 SKIP=4 TOTAL=9

Hey @Tomer Ben Yair! Can you please share the

edr.log

and

dbt.log

so that I can better understand where this error is originated from? Thanks!

Hi @Tomer Ben Yair, just chiming in here, it looks like a column was added in a recent update of Elementary dbt package but the model wasn't rebuilt so the error states it's trying to upload 14 values to a table with 13 columns. Can you try to run

dbt run -s elementary

?

This error only occurs when the model fails. In the meantime - I executed “dbt run -s elementary”. How can I access edr.log and dbt.log? (I’m using DBT Cloud).

did the issue reoccur after you ran the elementary models?

@Ella Katz, Yes, the issue reoccur after I ran the elementary models. In one of our models we have the below line (only if error occurs):

{{ exceptions.raise_compiler_error("The data was not uploaded to Production DB" ) }}

Maybe it’s related?

Hi @Tomer Ben Yair, Can you share the dbt.log file containing this error? I want to understand when exactly it happens. You can send it in a DM if you prefer