post_hook after_commit getting a "The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION. (3902) " error

Help
1

I am using dbt-core on sqlserver trying to do an incremental model
it went fine so I went on to use pre_hook and post_hook to add some checkpoints
so the header looks like this.
{{
config(
materialized=‘incremental’,
pre_hook=before_begin(“select something”),
post_hook=after_commit(“Update Some Table”)
)
}}

I got it ran the first time but then when I ran again it throws this error
(‘25000’, ‘[25000] [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION. (3902) (SQLExecDirectW)’)

I use sql profiler to see what is it doing but the only query is a “COMMIT”. Normally I’d see the Select statement of the model and some insert statement.

So I need some help to figure out what am I missing?
Thanks in advance