I want to add the next logs from the Tomcat 8 server:
2022-06-17 10:28:42.099 ERROR https-openssl-nio-8443-exec-5 org.ohdsi.webapi.achilles.aspect.AchillesCacheAspect - [] - exception during getting cache treemap_condition for source src_mdcr2003_2020
org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT
concept_hierarchy.concept_id,
CONCAT(
COALESCE(concept_hierarchy.level4_concept_name,‘NA’), ‘||’,
COALESCE(concept_hierarchy.level3_concept_name,‘NA’), ‘||’,
COALESCE(concept_hierarchy.level2_concept_name,‘NA’), ‘||’,
COALESCE(concept_hierarchy.level2_concept_name,‘NA’), ‘||’,
COALESCE(concept_hierarchy.concept_name,‘NA’)
) AS concept_path,
ar1.count_value AS num_persons,
ROUND(CAST(1.0 * ar1.count_value / denom.count_value AS NUMERIC),5) AS percent_persons,
ROUND(CAST(1.0 * ar2.count_value / ar1.count_value AS NUMERIC),5) AS records_per_person
FROM (SELECT *
FROM ar_mdcr2003_2020.achilles_results WHERE analysis_id = 400) ar1
INNER JOIN
(SELECT *
FROM ar_mdcr2003_2020.achilles_results WHERE analysis_id = 401) ar2
ON ar1.stratum_1 = ar2.stratum_1
INNER JOIN
ar_mdcr2003_2020.concept_hierarchy concept_hierarchy
ON CAST(CASE WHEN CASE WHEN (CAST(ar1.stratum_1 AS VARCHAR) ~ ‘^([0-9]+.?[0-9]*|.[0-9]+)$’) THEN 1 ELSE 0 END = 1 THEN ar1.stratum_1 ELSE null END AS INT) = concept_hierarchy.concept_id
AND concept_hierarchy.treemap=‘Condition’
,
(SELECT count_value
FROM ar_mdcr2003_2020.achilles_results WHERE analysis_id = 1) denom
ORDER BY ar1.count_value DESC]; nested exception is org.postgresql.util.PSQLException: ERROR: relation “ar_mdcr2003_2020.concept_hierarchy” does not exist
Position: 866
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:230) ~[spring-jdbc-4.3.25.RELEASE.jar:4.3.25.RELEASE]
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) ~[spring-jdbc-4.3.25.RELEASE.jar:4.3.25.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:654) ~[spring-jdbc-4.3.25.RELEASE.jar:4.3.25.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:688) ~[spring-jdbc-4.3.25.RELEASE.jar:4.3.25.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:720) ~[spring-jdbc-4.3.25.RELEASE.jar:4.3.25.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:770) ~[spring-jdbc-4.3.25.RELEASE.jar:4.3.25.RELEASE]
at org.ohdsi.webapi.report.CDMResultsAnalysisRunner.getTreemap(CDMResultsAnalysisRunner.java:266) ~[classes/:?]
at org.ohdsi.webapi.service.CDMResultsService.getRawTreeMap(CDMResultsService.java:354) ~[classes/:?]
at org.ohdsi.webapi.service.CDMResultsService.getTreemap(CDMResultsService.java:348) ~[classes/:?]
at org.ohdsi.webapi.service.CDMResultsService$$FastClassBySpringCGLIB$$f65c71c1.invoke() ~[classes/:?]
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) ~[spring-core-4.3.25.RELEASE.jar:4.3.25.RELEASE]
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:736) ~[spring-aop-4.3.25.RELEASE.jar:4.3.25.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) ~[spring-aop-4.3.25.RELEASE.jar:4.3.25.RELEASE]
at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:84) ~[spring-aop-4.3.25.RELEASE.jar:4.3.25.RELEASE]
at org.ohdsi.webapi.achilles.aspect.AchillesCacheAspect.cache(AchillesCacheAspect.java:56) [classes/:?]
at sun.reflect.GeneratedMethodAccessor306.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_192]
What could make the concept_hierarchy to not exist?
I used or the latest version of Achilles or its immediate previous one
