# dbt run stuck at deleting tmp index

**URL:** <https://discourse.getdbt.com/t/dbt-run-stuck-at-deleting-tmp-index/17070>\
**Category:** Help\
**Tags:** best-practice, devblog, dbt-core\
**Created:** [November 22, 2024, 10:57am UTC](https://discourse.getdbt.com/t/dbt-run-stuck-at-deleting-tmp-index/17070 "2024-11-22T10:57:28Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![flow](https://avatars.discourse-cdn.com/v4/letter/f/8edcca/32.png) [@flow](https://discourse.getdbt.com/u/flow)\
**Post date:** [November 22, 2024, 10:57am UTC](https://discourse.getdbt.com/t/dbt-run-stuck-at-deleting-tmp-index/17070/1 "2024-11-22T10:57:28Z")

</div>

HI for starter i’m on MacOs, using a sql\_server on docker.  
Ive a project with multiples models. I’ve an issue.  
Everything was working fine with the first model ive created. And recently it began to get stuck when i try to run it.

Here is my log :  
(base) florentsaussay@air-de-florent models % dbt --debug run --select TD\_ACA\_FACTURES.sql --full-refresh  
10:47:03 Sending event: {‘category’: ‘dbt’, ‘action’: ‘invocation’, ‘label’: ‘start’, ‘context’: [\<snowplow\_tracker.self\_describing\_json.SelfDescribingJson object at 0x1041bcf90\>, \<snowplow\_tracker.self\_describing\_json.SelfDescribingJson object at 0x103df8810\>, \<snowplow\_tracker.self\_describing\_json.SelfDescribingJson object at 0x104226fd0\>]}  
10:47:03 Running with dbt=1.8.7  
10:47:03 running dbt with arguments {‘printer\_width’: ‘80’, ‘indirect\_selection’: ‘eager’, ‘log\_cache\_events’: ‘False’, ‘write\_json’: ‘True’, ‘partial\_parse’: ‘True’, ‘cache\_selected\_only’: ‘False’, ‘profiles\_dir’: ‘/Users/florentsaussay/.dbt’, ‘version\_check’: ‘True’, ‘fail\_fast’: ‘False’, ‘log\_path’: ‘/Users/florentsaussay/ACA/logs’, ‘warn\_error’: ‘None’, ‘debug’: ‘True’, ‘use\_colors’: ‘True’, ‘use\_experimental\_parser’: ‘False’, ‘no\_print’: ‘None’, ‘quiet’: ‘False’, ‘empty’: ‘False’, ‘warn\_error\_options’: ‘WarnErrorOptions(include=, exclude=)’, ‘static\_parser’: ‘True’, ‘introspect’: ‘True’, ‘invocation\_command’: ‘dbt --debug run --select TD\_ACA\_FACTURES.sql --full-refresh’, ‘target\_path’: ‘None’, ‘log\_format’: ‘default’, ‘send\_anonymous\_usage\_stats’: ‘True’}  
10:47:04 Sending event: {‘category’: ‘dbt’, ‘action’: ‘project\_id’, ‘label’: ‘6734e6dc-5577-4f37-ac7b-dd362c3645d7’, ‘context’: [\<snowplow\_tracker.self\_describing\_json.SelfDescribingJson object at 0x104cd5390\>]}  
10:47:04 Sending event: {‘category’: ‘dbt’, ‘action’: ‘adapter\_info’, ‘label’: ‘6734e6dc-5577-4f37-ac7b-dd362c3645d7’, ‘context’: [\<snowplow\_tracker.self\_describing\_json.SelfDescribingJson object at 0x103057490\>]}  
10:47:04 Registered adapter: sqlserver=1.8.4  
10:47:04 checksum: 4af21dafb485259c48497ac86b711ddb1982f3d0f1c0ca4e09356de488b753c0, vars: {}, profile: , target: , version: 1.8.7  
10:47:05 Partial parsing enabled: 0 files deleted, 0 files added, 1 files changed.  
10:47:05 Partial parsing: updated file: ACA://models/TD\_ACA\_FACTURES.sql  
10:47:05 [WARNING]: Deprecated functionality  
The `tests` config has been renamed to `data_tests`. Please see  
[Add data tests to your DAG | dbt Developer Hub](https://docs.getdbt.com/docs/build/data-tests#new-data_tests-syntax) for more  
information.  
10:47:05 Sending event: {‘category’: ‘dbt’, ‘action’: ‘deprecation’, ‘label’: ‘6734e6dc-5577-4f37-ac7b-dd362c3645d7’, ‘property\_’: ‘warn’, ‘context’: [\<snowplow\_tracker.self\_describing\_json.SelfDescribingJson object at 0x104f3b910\>]}  
10:47:05 [WARNING]: Configuration paths exist in your dbt\_project.yml file which do not apply to any resources.  
There are 1 unused configuration paths:

- models.ACA.example  
10:47:05 Sending event: {‘category’: ‘dbt’, ‘action’: ‘load\_project’, ‘label’: ‘6734e6dc-5577-4f37-ac7b-dd362c3645d7’, ‘context’: [\<snowplow\_tracker.self\_describing\_json.SelfDescribingJson object at 0x105293dd0\>]}  
10:47:05 Sending event: {‘category’: ‘dbt’, ‘action’: ‘resource\_counts’, ‘label’: ‘6734e6dc-5577-4f37-ac7b-dd362c3645d7’, ‘context’: [\<snowplow\_tracker.self\_describing\_json.SelfDescribingJson object at 0x10522c410\>]}  
10:47:05 Found 7 models, 15 data tests, 1 source, 494 macros  
10:47:05 Sending event: {‘category’: ‘dbt’, ‘action’: ‘runnable\_timing’, ‘label’: ‘6734e6dc-5577-4f37-ac7b-dd362c3645d7’, ‘context’: [\<snowplow\_tracker.self\_describing\_json.SelfDescribingJson object at 0x105225710\>]}  
10:47:05  
10:47:05 Acquiring new sqlserver connection ‘master’  
10:47:05 Acquiring new sqlserver connection ‘list\_ACA’  
10:47:05 dbt-sqlserver  
10:47:05 Using sqlserver connection “list\_ACA”  
10:47:05 On list\_ACA: /\* {“app”: “dbt”, “dbt\_version”: “1.8.7”, “profile\_name”: “ACA”, “target\_name”: “dev”, “connection\_name”: “list\_ACA”} \*/  
select name as [schema]  
from sys.schemas with (nolock)  
OPTION (LABEL = ‘dbt-sqlserver’);

10:47:05 Opening a new connection, currently in state init  
10:47:05 sqlserver adapter: Using connection string: DRIVER={ODBC Driver 17 for SQL Server};SERVER=localhost,1433;Database=ACA;UID={sa};PWD=\*\*_;encrypt=Yes;TrustServerCertificate=Yes;APP=dbt-sqlserver/1.8.4  
10:47:06 sqlserver adapter: Connected to db: ACA  
10:47:06 SQL status: OK in 0.000 seconds  
10:47:06 On list\_ACA: Close  
10:47:06 Re-using an available connection from the pool (formerly list\_ACA, now list\_ACA\_NRJBI\_STG)  
10:47:06 dbt-sqlserver  
10:47:06 Using sqlserver connection “list\_ACA\_NRJBI\_STG”  
10:47:06 On list\_ACA\_NRJBI\_STG: /_ {“app”: “dbt”, “dbt\_version”: “1.8.7”, “profile\_name”: “ACA”, “target\_name”: “dev”, “connection\_name”: “list\_ACA\_NRJBI\_STG”} \*/  
USE [ACA];  
with base as (  
select  
DB\_NAME() as [database],  
t.name as [name],  
SCHEMA\_NAME(t.schema\_id) as [schema],  
‘table’ as table\_type  
from sys.tables as t with (nolock)  
union all  
select  
DB\_NAME() as [database],  
v.name as [name],  
SCHEMA\_NAME(v.schema\_id) as [schema],  
‘view’ as table\_type  
from sys.views as v with (nolock)  
)  
select \* from base  
where [schema] like ‘NRJBI\_STG’

```
OPTION (LABEL = 'dbt-sqlserver');

```

10:47:06 Opening a new connection, currently in state closed  
10:47:06 sqlserver adapter: Using connection string: DRIVER={ODBC Driver 17 for SQL Server};SERVER=localhost,1433;Database=ACA;UID={sa};PWD=\*\*_;encrypt=Yes;TrustServerCertificate=Yes;APP=dbt-sqlserver/1.8.4  
10:47:06 sqlserver adapter: Connected to db: ACA  
10:47:06 SQL status: OK in 0.000 seconds  
10:47:06 On list\_ACA\_NRJBI\_STG: ROLLBACK  
10:47:06 On list\_ACA\_NRJBI\_STG: Close  
10:47:06 Sending event: {‘category’: ‘dbt’, ‘action’: ‘runnable\_timing’, ‘label’: ‘6734e6dc-5577-4f37-ac7b-dd362c3645d7’, ‘context’: [\<snowplow\_tracker.self\_describing\_json.SelfDescribingJson object at 0x102b53a90\>]}  
10:47:06 On master: COMMIT  
10:47:06 Concurrency: 1 threads (target=‘dev’)  
10:47:06  
10:47:06 Began running node model.ACA.TD\_ACA\_FACTURES  
10:47:06 1 of 1 START sql table model NRJBI\_STG.TD\_ACA\_FACTURES … [RUN]  
10:47:06 Re-using an available connection from the pool (formerly list\_ACA\_NRJBI\_STG, now model.ACA.TD\_ACA\_FACTURES)  
10:47:06 Began compiling node model.ACA.TD\_ACA\_FACTURES  
10:47:06 Writing injected SQL for node “model.ACA.TD\_ACA\_FACTURES”  
10:47:06 Began executing node model.ACA.TD\_ACA\_FACTURES  
10:47:06 dbt-sqlserver  
10:47:06 Applying DROP to: “ACA”.“NRJBI\_STG”.“TD\_ACA\_FACTURES\_\_dbt\_tmp\_\_dbt\_tmp\_vw”  
10:47:06 dbt-sqlserver  
10:47:06 Using sqlserver connection “model.ACA.TD\_ACA\_FACTURES”  
10:47:06 On model.ACA.TD\_ACA\_FACTURES: /_ {“app”: “dbt”, “dbt\_version”: “1.8.7”, “profile\_name”: “ACA”, “target\_name”: “dev”, “node\_id”: “model.ACA.TD\_ACA\_FACTURES”} \*/

```
    USE [ACA];
    select
        sch.name as schema_name,
        obj.name as view_name
    from sys.sql_expression_dependencies refs
    inner join sys.objects obj
    on refs.referencing_id = obj.object_id
    inner join sys.schemas sch
    on obj.schema_id = sch.schema_id
    where refs.referenced_database_name = 'ACA'
    and refs.referenced_schema_name = 'NRJBI_STG'
    and refs.referenced_entity_name = 'TD_ACA_FACTURES __dbt_tmp__ dbt_tmp_vw'
    and refs.referencing_class = 1
    and obj.type = 'V'
    
OPTION (LABEL = 'dbt-sqlserver');

```

10:47:06 Opening a new connection, currently in state closed  
10:47:06 sqlserver adapter: Using connection string: DRIVER={ODBC Driver 17 for SQL Server};SERVER=localhost,1433;Database=ACA;UID={sa};PWD=\*\*_;encrypt=Yes;TrustServerCertificate=Yes;APP=dbt-sqlserver/1.8.4  
10:47:06 sqlserver adapter: Connected to db: ACA  
10:47:06 SQL status: OK in 0.000 seconds  
10:47:06 Using sqlserver connection “model.ACA.TD\_ACA\_FACTURES”  
10:47:06 On model.ACA.TD\_ACA\_FACTURES: /_ {“app”: “dbt”, “dbt\_version”: “1.8.7”, “profile\_name”: “ACA”, “target\_name”: “dev”, “node\_id”: “model.ACA.TD\_ACA\_FACTURES”} \*/

```
USE [ACA];
EXEC('DROP view IF EXISTS "NRJBI_STG"."TD_ACA_FACTURES __dbt_tmp__ dbt_tmp_vw";');

```

10:47:06 SQL status: OK in 0.000 seconds  
10:47:06 Writing runtime sql for node “model.ACA.TD\_ACA\_FACTURES”  
10:47:06 Using sqlserver connection “model.ACA.TD\_ACA\_FACTURES”  
10:47:06 On model.ACA.TD\_ACA\_FACTURES: /\* {“app”: “dbt”, “dbt\_version”: “1.8.7”, “profile\_name”: “ACA”, “target\_name”: “dev”, “node\_id”: “model.ACA.TD\_ACA\_FACTURES”} \*/

```
USE [ACA];
USE [ACA];

USE [ACA];
EXEC('
    create view "NRJBI_STG"."TD_ACA_FACTURES __dbt_tmp__ dbt_tmp_vw" as 

```

WITH prepared\_data AS (  
SELECT  
ID,  
Ligne\_Facture,  
REPLACE(REPLACE(REPLACE(REPLACE(Ligne\_Facture, ‘’{“‘’, ‘’&‘’), ‘’”}‘’, ‘’$‘’),‘’“{‘’, ‘’&‘’),‘’}”‘’,‘’$‘’) AS modified\_ligne\_facture  
FROM “ACA”.“NRJBI\_STG”.“TD\_ACA\_STAGING”  
),  
extracted\_tags AS (  
SELECT  
ID,  
Ligne\_Facture,  
modified\_ligne\_facture,  
CASE  
WHEN  
(  
SELECT TOP 1  
t.c.value(‘’(/r[16]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(modified\_ligne\_facture, ‘’&‘’, ‘’&‘’), ‘’,‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’‘) t(c)  
)  
= ‘’’’ THEN NULL  
WHEN LEFT(  
(  
SELECT TOP 1  
t.c.value(‘’(/r[16]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(modified\_ligne\_facture, ‘’&‘’, ‘’&‘’), ‘’,‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’‘) t(c)  
)  
, 2) = ‘’"&’’ THEN

(  
SELECT TOP 1  
t.c.value(‘’(/r[1]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(  
(  
SELECT TOP 1  
t.c.value(‘’(/r[2]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(modified\_ligne\_facture, ‘’&‘’, ‘’&‘’), ‘’&‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’‘) t(c)  
)  
, ‘’&’‘, ‘’&’‘), ‘’$’‘, ‘’’‘) + ‘’’’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’') t(c)  
)

```
        ELSE 

```

(  
SELECT TOP 1  
t.c.value(‘’(/r[16]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(modified\_ligne\_facture, ‘’&‘’, ‘’&‘’), ‘’,‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’') t(c)  
)

```
    END AS split_16_temp,
    CASE 
        WHEN LEFT(

```

(  
SELECT TOP 1  
t.c.value(‘’(/r[16]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(modified\_ligne\_facture, ‘’&‘’, ‘’&‘’), ‘’,‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’‘) t(c)  
)  
, 2) = ‘’"&’’ THEN 1  
ELSE 0  
END AS bool\_16  
FROM prepared\_data  
),  
x1\_calculation AS (  
SELECT  
\*,  
CASE  
WHEN bool\_16 = 1 THEN  
CASE  
WHEN  
(  
SELECT TOP 1  
t.c.value(‘’(/r[3]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(modified\_ligne\_facture, ‘’&‘’, ‘’&‘’), ‘’$‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’‘) t(c)  
)  
IS NOT NULL AND  
(  
SELECT TOP 1  
t.c.value(’‘(/r[3]/text())[1]’‘, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(’‘’’ + REPLACE(REPLACE(modified\_ligne\_facture, ‘’&‘’, ‘’&‘’), ‘’$‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’‘) t(c)  
)  
!= ‘’’’ THEN  
CONCAT(  
(  
SELECT TOP 1  
t.c.value(‘’(/r[2]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(modified\_ligne\_facture, ‘’&‘’, ‘’&‘’), ‘’$‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’‘) t(c)  
)  
, ‘’$’‘,  
(  
SELECT TOP 1  
t.c.value(’‘(/r[3]/text())[1]’‘, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(’‘’’ + REPLACE(REPLACE(modified\_ligne\_facture, ‘’&‘’, ‘’&‘’), ‘’$‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’‘) t(c)  
)  
)  
ELSE  
(  
SELECT TOP 1  
t.c.value(’‘(/r[2]/text())[1]’‘, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(’‘’’ + REPLACE(REPLACE(modified\_ligne\_facture, ‘’&‘’, ‘’&‘’), ‘’$‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’') t(c)  
)

```
            END
        ELSE modified_ligne_facture
    END AS x1
FROM extracted_tags

```

),  
bool\_18\_calculation AS (  
SELECT  
\*,  
CASE  
WHEN bool\_16 = 1 THEN  
CASE  
WHEN LEFT(  
(  
SELECT TOP 1  
t.c.value(‘’(/r[3]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(x1, ‘’&‘’, ‘’&‘’), ‘’,‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’‘) t(c)  
)  
, 1) = ‘’&’’ THEN 1  
ELSE 0  
END  
ELSE  
CASE  
WHEN LEFT(  
(  
SELECT TOP 1  
t.c.value(‘’(/r[18]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(x1, ‘’&‘’, ‘’&‘’), ‘’,‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’‘) t(c)  
)  
, 1) = ‘’&’’ THEN 1  
ELSE 0  
END  
END AS bool\_18  
FROM x1\_calculation  
),  
final\_result AS (  
SELECT  
ID,  
modified\_ligne\_facture,  
REPLACE(REPLACE(split\_16\_temp, ‘’“&‘’, ‘’{‘’), ‘’$”‘’, ‘’}‘’) AS split\_16,  
CASE  
WHEN bool\_16 = 1 THEN  
(  
SELECT TOP 1  
t.c.value(‘’(/r[2]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(x1, ‘’&‘’, ‘’&‘’), ‘’,‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’') t(c)  
)

```
        ELSE 

```

(  
SELECT TOP 1  
t.c.value(‘’(/r[17]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(x1, ‘’&‘’, ‘’&‘’), ‘’,‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’') t(c)  
)

```
    END AS split_17,
    bool_16,
    bool_18,
    CASE
        WHEN bool_16 = 1 AND bool_18 = 1 THEN 

```

(  
SELECT TOP 1  
t.c.value(‘’(/r[1]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(  
(  
SELECT TOP 1  
t.c.value(‘’(/r[2]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(x1, ‘’&‘’, ‘’&‘’), ‘’&‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’‘) t(c)  
)  
, ‘’&’‘, ‘’&’‘), ‘’$’‘, ‘’’‘) + ‘’’’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’') t(c)  
)

```
        WHEN bool_16 = 1 AND bool_18 = 0 THEN 

```

(  
SELECT TOP 1  
t.c.value(‘’(/r[3]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(x1, ‘’&‘’, ‘’&‘’), ‘’,‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’') t(c)  
)

```
        WHEN bool_16 = 0 AND bool_18 = 1 THEN 

```

(  
SELECT TOP 1  
t.c.value(‘’(/r[1]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(  
(  
SELECT TOP 1  
t.c.value(‘’(/r[2]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(x1, ‘’&‘’, ‘’&‘’), ‘’&‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’‘) t(c)  
)  
, ‘’&’‘, ‘’&’‘), ‘’$’‘, ‘’’‘) + ‘’’’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’') t(c)  
)

```
        ELSE 

```

(  
SELECT TOP 1  
t.c.value(‘’(/r[18]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(x1, ‘’&‘’, ‘’&‘’), ‘’,‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’') t(c)  
)

```
    END AS split_18_temp,
    CASE
        WHEN bool_16 = 1 AND bool_18 = 1 THEN 

```

(  
SELECT TOP 1  
t.c.value(‘’(/r[3]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(modified\_ligne\_facture, ‘’&‘’, ‘’&‘’), ‘’$‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’') t(c)  
)

```
        WHEN bool_16 = 0 AND bool_18 = 1 THEN 

```

(  
SELECT TOP 1  
t.c.value(‘’(/r[2]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(modified\_ligne\_facture, ‘’&‘’, ‘’&‘’), ‘’$‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’') t(c)  
)

```
        ELSE x1
    END AS x2,
    x1
FROM bool_18_calculation

```

),  
bool\_x2\_calculation AS (  
SELECT  
\*,  
CASE  
WHEN bool\_16 = 1 AND bool\_18 = 1 THEN 2  
WHEN bool\_16 = 1 AND bool\_18 = 0 THEN 1  
WHEN bool\_16 = 0 AND bool\_18 = 1 THEN 2  
ELSE 0  
END AS bool\_x2  
FROM final\_result  
),  
final\_result\_with\_18 AS (  
SELECT  
ID,  
modified\_ligne\_facture,

(  
SELECT TOP 1  
t.c.value(‘’(/r[1]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(modified\_ligne\_facture, ‘’&‘’, ‘’&‘’), ‘’,‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’') t(c)  
)  
AS SubscriptionGuid,

(  
SELECT TOP 1  
t.c.value(‘’(/r[2]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(modified\_ligne\_facture, ‘’&‘’, ‘’&‘’), ‘’,‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’') t(c)  
)  
AS ResourceGroup,

(  
SELECT TOP 1  
t.c.value(‘’(/r[3]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(modified\_ligne\_facture, ‘’&‘’, ‘’&‘’), ‘’,‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’') t(c)  
)  
AS ResourceLocation,

(  
SELECT TOP 1  
t.c.value(‘’(/r[4]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(modified\_ligne\_facture, ‘’&‘’, ‘’&‘’), ‘’,‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’') t(c)  
)  
AS UsageDateTime,

(  
SELECT TOP 1  
t.c.value(‘’(/r[5]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(modified\_ligne\_facture, ‘’&‘’, ‘’&‘’), ‘’,‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’') t(c)  
)  
AS MeterCategory,

(  
SELECT TOP 1  
t.c.value(‘’(/r[6]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(modified\_ligne\_facture, ‘’&‘’, ‘’&‘’), ‘’,‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’') t(c)  
)  
AS MeterSubcategory,

(  
SELECT TOP 1  
t.c.value(‘’(/r[7]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(modified\_ligne\_facture, ‘’&‘’, ‘’&‘’), ‘’,‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’') t(c)  
)  
AS MeterId,

(  
SELECT TOP 1  
t.c.value(‘’(/r[8]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(modified\_ligne\_facture, ‘’&‘’, ‘’&‘’), ‘’,‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’') t(c)  
)  
AS MeterName,

(  
SELECT TOP 1  
t.c.value(‘’(/r[9]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(modified\_ligne\_facture, ‘’&‘’, ‘’&‘’), ‘’,‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’') t(c)  
)  
AS MeterRegion,

(  
SELECT TOP 1  
t.c.value(‘’(/r[10]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(modified\_ligne\_facture, ‘’&‘’, ‘’&‘’), ‘’,‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’') t(c)  
)  
AS UsageQuantity,

(  
SELECT TOP 1  
t.c.value(‘’(/r[11]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(modified\_ligne\_facture, ‘’&‘’, ‘’&‘’), ‘’,‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’') t(c)  
)  
AS ResourceRate,

(  
SELECT TOP 1  
t.c.value(‘’(/r[12]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(modified\_ligne\_facture, ‘’&‘’, ‘’&‘’), ‘’,‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’') t(c)  
)  
AS PreTaxCost,

(  
SELECT TOP 1  
t.c.value(‘’(/r[13]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(modified\_ligne\_facture, ‘’&‘’, ‘’&‘’), ‘’,‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’') t(c)  
)  
AS ConsumedService,

(  
SELECT TOP 1  
t.c.value(‘’(/r[14]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(modified\_ligne\_facture, ‘’&‘’, ‘’&‘’), ‘’,‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’') t(c)  
)  
AS ResourceType,

(  
SELECT TOP 1  
t.c.value(‘’(/r[15]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(modified\_ligne\_facture, ‘’&‘’, ‘’&‘’), ‘’,‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’‘) t(c)  
)  
AS InstanceId,  
split\_16 AS Tags,  
split\_17 AS OfferId,  
bool\_16,  
REPLACE(REPLACE(split\_18\_temp, ‘’"&’‘, ‘’{’‘), ‘’$"’‘, ‘’}’‘) AS AdditionalInfo,  
CASE  
WHEN bool\_x2 = 1 THEN  
(  
SELECT TOP 1  
t.c.value(’‘(/r[4]/text())[1]’‘, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(’‘’’ + REPLACE(REPLACE(x2, ‘’&‘’, ‘’&‘’), ‘’,‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’') t(c)  
)

```
        WHEN bool_x2 = 2 THEN 

```

(  
SELECT TOP 1  
t.c.value(‘’(/r[2]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(x2, ‘’&‘’, ‘’&‘’), ‘’,‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’') t(c)  
)

```
        ELSE 

```

(  
SELECT TOP 1  
t.c.value(‘’(/r[19]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(x1, ‘’&‘’, ‘’&‘’), ‘’,‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’') t(c)  
)

```
    END AS ServiceInfo1,
    CASE
        WHEN bool_x2 = 1 THEN 

```

(  
SELECT TOP 1  
t.c.value(‘’(/r[5]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(x2, ‘’&‘’, ‘’&‘’), ‘’,‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’') t(c)  
)

```
        WHEN bool_x2 = 2 THEN 

```

(  
SELECT TOP 1  
t.c.value(‘’(/r[3]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(x2, ‘’&‘’, ‘’&‘’), ‘’,‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’') t(c)  
)

```
        ELSE 

```

(  
SELECT TOP 1  
t.c.value(‘’(/r[20]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(x1, ‘’&‘’, ‘’&‘’), ‘’,‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’') t(c)  
)

```
    END AS ServiceInfo2,
    CASE
        WHEN bool_x2 = 1 THEN 

```

(  
SELECT TOP 1  
t.c.value(‘’(/r[6]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(x2, ‘’&‘’, ‘’&‘’), ‘’,‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’') t(c)  
)

```
        WHEN bool_x2 = 2 THEN 

```

(  
SELECT TOP 1  
t.c.value(‘’(/r[4]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(x2, ‘’&‘’, ‘’&‘’), ‘’,‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’') t(c)  
)

```
        ELSE 

```

(  
SELECT TOP 1  
t.c.value(‘’(/r[21]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(x1, ‘’&‘’, ‘’&‘’), ‘’,‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’') t(c)  
)

```
    END AS ServiceName,
    CASE
        WHEN bool_x2 = 1 THEN 

```

(  
SELECT TOP 1  
t.c.value(‘’(/r[7]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(x2, ‘’&‘’, ‘’&‘’), ‘’,‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’') t(c)  
)

```
        WHEN bool_x2 = 2 THEN 

```

(  
SELECT TOP 1  
t.c.value(‘’(/r[5]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(x2, ‘’&‘’, ‘’&‘’), ‘’,‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’') t(c)  
)

```
        ELSE 

```

(  
SELECT TOP 1  
t.c.value(‘’(/r[22]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(x1, ‘’&‘’, ‘’&‘’), ‘’,‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’') t(c)  
)

```
    END AS ServiceTier,
    CASE
        WHEN bool_x2 = 1 THEN 

```

(  
SELECT TOP 1  
t.c.value(‘’(/r[8]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(x2, ‘’&‘’, ‘’&‘’), ‘’,‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’') t(c)  
)

```
        WHEN bool_x2 = 2 THEN 

```

(  
SELECT TOP 1  
t.c.value(‘’(/r[6]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(x2, ‘’&‘’, ‘’&‘’), ‘’,‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’') t(c)  
)

```
        ELSE 

```

(  
SELECT TOP 1  
t.c.value(‘’(/r[23]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(x1, ‘’&‘’, ‘’&‘’), ‘’,‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’') t(c)  
)

```
    END AS Currency,
    CASE
        WHEN bool_x2 = 1 THEN 

```

(  
SELECT TOP 1  
t.c.value(‘’(/r[9]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(x2, ‘’&‘’, ‘’&‘’), ‘’,‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’') t(c)  
)

```
        WHEN bool_x2 = 2 THEN 

```

(  
SELECT TOP 1  
t.c.value(‘’(/r[7]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(x2, ‘’&‘’, ‘’&‘’), ‘’,‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’') t(c)  
)

```
        ELSE 

```

(  
SELECT TOP 1  
t.c.value(‘’(/r[24]/text())[1]‘’, ‘‘nvarchar(max)’’)  
FROM (  
SELECT CAST(‘’‘’ + REPLACE(REPLACE(x1, ‘’&‘’, ‘’&‘’), ‘’,‘’, ‘’‘’) + ‘’‘’ AS XML) AS x  
) a  
CROSS APPLY x.nodes(‘’/r’') t(c)  
)

```
    END AS UnitOfMeasure,
    bool_x2,
    bool_18,
    x2
FROM bool_x2_calculation

```

)  
SELECT ID, SubscriptionGuid, ResourceGroup, ResourceLocation, UsageDateTime, MeterCategory,  
MeterSubcategory, MeterId, MeterName, MeterRegion, UsageQuantity, ResourceRate,  
PreTaxCost, ConsumedService, ResourceType, InstanceId, Tags, OfferId, AdditionalInfo,  
ServiceInfo1, ServiceInfo2, ServiceName, ServiceTier, Currency, UnitOfMeasure,  
bool\_x2, bool\_18, bool\_16, modified\_ligne\_facture, x2  
FROM final\_result\_with\_18;  
')

EXEC(’  
SELECT \* INTO “ACA”.“NRJBI\_STG”.“TD\_ACA\_FACTURES\_\_dbt\_tmp” FROM “ACA”.“NRJBI\_STG”.“TD\_ACA\_FACTURES\_\_dbt\_tmp\_\_dbt\_tmp\_vw”  
OPTION (LABEL = ‘‘dbt-sqlserver’’);

```
    ')

EXEC('DROP VIEW IF EXISTS NRJBI_STG.TD_ACA_FACTURES __dbt_tmp__ dbt_tmp_vw')

use [ACA];
if EXISTS (
    SELECT *
    FROM sys.indexes with (nolock)
    WHERE name = 'NRJBI_STG_TD_ACA_FACTURES__dbt_tmp_cci'
    AND object_id=object_id('NRJBI_STG_TD_ACA_FACTURES__dbt_tmp')
)
DROP index "NRJBI_STG"."TD_ACA_FACTURES __dbt_tmp".NRJBI_STG_TD_ACA_FACTURES__ dbt_tmp_cci
CREATE CLUSTERED COLUMNSTORE INDEX NRJBI_STG_TD_ACA_FACTURES__dbt_tmp_cci
ON "NRJBI_STG"."TD_ACA_FACTURES__dbt_tmp"

```

It stays stuck there. I dont have this problem with my other models.  
I’ve tried load of things to fix it, didnt work. And i’ve to manually delete the tmps table and view dbt creates using Azure Data Studio.

Can someone help me ?

---

<div class="post-metadata">

**Author:** ![flow](https://avatars.discourse-cdn.com/v4/letter/f/8edcca/32.png) [@flow](https://discourse.getdbt.com/u/flow)\
**Post date:** [November 27, 2024, 3:21pm UTC](https://discourse.getdbt.com/t/dbt-run-stuck-at-deleting-tmp-index/17070/2 "2024-11-27T15:21:40Z")

</div>

Up. Still cant find why it is happening. I’d appreciate any type of help.