OHDSI Home | Forums | Wiki | Github

What does <Long String> do in analysis 117 of Achilles?

We are trying on the Achilles analysis and the train is stuck on query 117.

Achilles/117.sql at master · OHDSI/Achilles · GitHub

I wanted to run the query alone and see what is wrong with it.

Just interested, what does @scratchDatabaseSchema@schemaDelim@tempAchillesPrefix_117 means?

btw

Analysis 117 run for 6 hours and it didn’t come back on multiple machines.

I find it odd because the table observation_period has been used in previous Achilles analysis and they all came back okay, despite some of them might take more time.

Refloating this because has been an issue in a couple of data sources recently. What both had in common is that both were trying to add data from 2018 until now, creating very long observation periods. Seems like the moment this happens this query becomes something the DB cannot easily handle

t