OHDSI / OHDSI/WebAPI

Characterization Hive DataAccessResourceFailureException

Open
#1,762 0 comments 0 reactions 1 assignee View on GitHub

@ssuvorov-fls is already working on this.

Since Jan 28, 2021.

bug
Dominant language
Java
Stars
151
Forks
183
Avg merge
14m
Merged PRs (30d)
2

Description

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)

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.