OHDSI Home | Forums | Wiki | Github

Error in running Achilles - query processor ran out of internal resources


we received the following error while running Achilles. It happened with it tried to create the #s_tmpach_2004 temp table. Any advise?

com.microsoft.sqlserver.jdbc.SQLServerException: The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions. Please simplify the query. If you believe you have received this message in error, contact Customer Support Services for more information.

Thank you

Can you describe your server (cores, cpu, memory)? You can also try processing without analysis 2004 using excludeAnalysisIds=c(2004) as a parameter to the Achilles execution.

Thanks @Frank . Achilles ran through with analysis 2004 skipped, no errors! I am wondering what analysis 2004 does, and what implications could be to skip this step.

This query runs an analysis to determine how many people in the CDM have data across multiple domains. It calculates the number and proportion of people with at least one record in the condition_occurrence and drug_exposure tables, for example, and then continues that for all possible permutations of the domain tables. Currently the analysis results are used in a new tool that is part of ARES, and no where else, so you should not see an issue by skipping this analysis.

The query is long but we haven’t seen performance issues in our environments. It would be helpful if you could provide details on your environment to inform whether this could potentially be an issue at multiple sites. Could you share the specifications of your server and which database platform you are using?