Skip to content

Characterization Hive DataAccessResourceFailureException #1762

@DKashenko

Description

@DKashenko

WebApi 2.8.1

Steps:

  1. Login by a user who has access to Hive Data Source
  2. Characterizations -> New Characterization
  3. Import a valid design cc_design.txt -> Save
  4. Run on Hive

Actual:

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

Expected:

Analysis finished successfully and results are available (as on PG)

Metadata

Metadata

Assignees

Labels

Type

No type
No fields configured for issues without a type.

Projects

Relationships

None yet

Development

No branches or pull requests

Issue actions