2021-01-28 11:19:12.509 ERROR 39 --- [ taskExecutor-6] o.s.b.c.s.AbstractStep : Encountered an error executing step generateCohortCharacterization.generate in job generateCohortCharacterization
org.ohdsi.webapi.exception.AtlasException: java.lang.RuntimeException: java.util.concurrent.ExecutionException: org.springframework.dao.DataAccessResourceFailureException: StatementCallback; SQL [insert into omop_orc_results_280.cc_results (type, fa_type, covariate_id, covariate_name, analysis_id, analysis_name, concept_id, count_value, avg_value,
strata_id, strata_name, cohort_definition_id, cc_generation_id)
select CAST('PREVALENCE' AS VARCHAR(255)) as type,
CAST('PRESET' AS VARCHAR(255)) as fa_type,
f.covariate_id,
fr.covariate_name,
ar.analysis_id,
ar.analysis_name,
fr.concept_id,
f.sum_value as count_value,
f.average_value as stat_value,
0 as strata_id,
CAST('' AS VARCHAR(1000)) as strata_name,
44 as cohort_definition_id,
7158 as cc_generation_id
from (select 44 as cohort_definition_id, covariate_id, sum_value, average_value from (SELECT all_covariates.cohort_definition_id,
all_covariates.covariate_id,
all_covariates.sum_value,
CAST(all_covariates.sum_value / (1.0 * total.total_count) AS FLOAT) AS average_value
FROM (SELECT cohort_definition_id, covariate_id, sum_value FROM cov_1 UNION ALL
SELECT cohort_definition_id, covariate_id, sum_value FROM cov_4 UNION ALL
SELECT cohort_definition_id, covariate_id, sum_value FROM cov_5 UNION ALL
SELECT cohort_definition_id, covariate_id, sum_value FROM cov_7 UNION ALL
SELECT cohort_definition_id, covariate_id, sum_value FROM cov_8
) all_covariates
INNER JOIN (
SELECT cohort_definition_id, COUNT(*) AS total_count
FROM omop_orc_results_280.temp_cohort_rcnjb0rr
WHERE cohort_definition_id IN (44) GROUP BY cohort_definition_id
) total
ON all_covariates.cohort_definition_id = total.cohort_definition_id
WebApi 2.8.1
Steps:
Actual:
Expected:
Analysis finished successfully and results are available (as on PG)