Last updated on 2024-06-14 13:56:47 CEST.
Package | ERROR | OK |
---|---|---|
CodelistGenerator | 13 | |
CohortConstructor | 3 | 10 |
CohortSurvival | 13 | |
IncidencePrevalence | 13 |
Current CRAN status: OK: 13
Current CRAN status: ERROR: 3, OK: 10
Version: 0.2.0
Check: package dependencies
Result: ERROR
Package required and available but unsuitable version: 'PatientProfiles'
See section 'The DESCRIPTION file' in the 'Writing R Extensions'
manual.
Flavor: r-devel-windows-x86_64
Version: 0.1.0
Check: re-building of vignette outputs
Result: ERROR
Error(s) in re-building vignettes:
...
--- re-building ‘a00_introduction.Rmd’ using rmarkdown
--- finished re-building ‘a00_introduction.Rmd’
--- re-building ‘a01_building_base_cohorts.Rmd’ using rmarkdown
trying URL 'https://example-data.ohdsi.dev/GiBleed.zip'
Content type 'application/zip' length 6754786 bytes (6.4 MB)
==================================================
downloaded 6.4 MB
Quitting from lines 49-56 [unnamed-chunk-3] (a01_building_base_cohorts.Rmd)
Error: processing vignette 'a01_building_base_cohorts.Rmd' failed with diagnostics:
rapi_prepare: Failed to prepare query CREATE TABLE main.my_study_tmp_001_og_002_1718195530 AS SELECT
LHS.*,
requirements,
age_range,
sex_req,
min_prior_observation,
min_future_observation,
cohort_definition_id,
cohort_name,
min_age,
max_age
FROM (
SELECT
cohort_definition_id AS target_cohort_rand01,
subject_id,
cohort_start_date,
cohort_end_date,
date_of_birth,
CAST((date_0 + 18*INTERVAL'1 year') AS DATE) AS date_18,
CAST((date_0 + 66*INTERVAL'1 year') AS DATE) AS date_66
FROM main.my_study_date_0
) LHS
LEFT JOIN (
SELECT
requirements,
CASE WHEN ((target_cohort_rand01 IS NULL)) THEN cohort_definition_id WHEN NOT ((target_cohort_rand01 IS NULL)) THEN target_cohort_rand01 END AS target_cohort_rand01,
age_range,
sex AS sex_req,
min_prior_observation,
min_future_observation,
cohort_definition_id,
cohort_name,
min_age,
max_age
FROM main.my_study_tmp_001_og_001_1718195530
) RHS
ON (LHS.target_cohort_rand01 = RHS.target_cohort_rand01)
Error: Binder Error: Referenced column "date_0" not found in FROM clause!
Candidate bindings: "my_study_date_0.date_of_birth"
LINE 19: CAST((date_0 + 18*INTERVAL'1 year') AS DATE) AS date_18,
CAST((date_0 + 66*INTERVAL'1 year') AS DATE) AS date_66
FROM main.my_study_date_0
) LHS
LEFT JOIN (
SELECT
requirements,
CASE WHEN ((target_cohort_rand01 IS NULL)) THEN cohort_definition_id WHEN NOT ((target_cohort_rand01 IS NULL)) THEN target_cohort_rand01 END AS target_cohort_rand01,
age_range,
sex AS sex_req,
min_prior_observation,
min_future_observation,
cohort_definition_id,
cohort_name,
min_age,
max_age
FROM main.my_study_tmp_001_og_001_1718195530
) RHS
ON (LHS.target_cohort_rand01 = RHS.target_cohort_rand01)...
^
--- failed re-building ‘a01_building_base_cohorts.Rmd’
Warning: Connection is garbage-collected, use dbDisconnect() to avoid this.
--- re-building ‘a02_applying_cohort_restrictions.Rmd’ using rmarkdown
trying URL 'https://example-data.ohdsi.dev/GiBleed.zip'
Content type 'application/zip' length 6754786 bytes (6.4 MB)
==================================================
downloaded 6.4 MB
--- finished re-building ‘a02_applying_cohort_restrictions.Rmd’
Warning: Connection is garbage-collected, use dbDisconnect() to avoid this.
--- re-building ‘a03_age_sex_matching.Rmd’ using rmarkdown
--- finished re-building ‘a03_age_sex_matching.Rmd’
--- re-building ‘a04_cohort_manipulations.Rmd’ using rmarkdown
--- finished re-building ‘a04_cohort_manipulations.Rmd’
SUMMARY: processing the following file failed:
‘a01_building_base_cohorts.Rmd’
Error: Vignette re-building failed.
Execution halted
Flavor: r-patched-linux-x86_64
Version: 0.1.0
Check: re-building of vignette outputs
Result: ERROR
Error(s) in re-building vignettes:
--- re-building 'a00_introduction.Rmd' using rmarkdown
--- finished re-building 'a00_introduction.Rmd'
--- re-building 'a01_building_base_cohorts.Rmd' using rmarkdown
trying URL 'https://example-data.ohdsi.dev/GiBleed.zip'
Content type 'application/zip' length 6754786 bytes (6.4 MB)
==================================================
downloaded 6.4 MB
Quitting from lines 49-56 [unnamed-chunk-3] (a01_building_base_cohorts.Rmd)
Error: processing vignette 'a01_building_base_cohorts.Rmd' failed with diagnostics:
rapi_prepare: Failed to prepare query CREATE TABLE main.my_study_tmp_001_og_002_1718168542 AS SELECT
LHS.*,
requirements,
age_range,
sex_req,
min_prior_observation,
min_future_observation,
cohort_definition_id,
cohort_name,
min_age,
max_age
FROM (
SELECT
cohort_definition_id AS target_cohort_rand01,
subject_id,
cohort_start_date,
cohort_end_date,
date_of_birth,
CAST((date_0 + 18*INTERVAL'1 year') AS DATE) AS date_18,
CAST((date_0 + 66*INTERVAL'1 year') AS DATE) AS date_66
FROM main.my_study_date_0
) LHS
LEFT JOIN (
SELECT
requirements,
CASE WHEN ((target_cohort_rand01 IS NULL)) THEN cohort_definition_id WHEN NOT ((target_cohort_rand01 IS NULL)) THEN target_cohort_rand01 END AS target_cohort_rand01,
age_range,
sex AS sex_req,
min_prior_observation,
min_future_observation,
cohort_definition_id,
cohort_name,
min_age,
max_age
FROM main.my_study_tmp_001_og_001_1718168542
) RHS
ON (LHS.target_cohort_rand01 = RHS.target_cohort_rand01)
Error: Binder Error: Referenced column "date_0" not found in FROM clause!
Candidate bindings: "my_study_date_0.date_of_birth"
LINE 19: CAST((date_0 + 18*INTERVAL'1 year') AS DATE) AS date_18,
CAST((date_0 + 66*INTERVAL'1 year') AS DATE) AS date_66
FROM main.my_study_date_0
) LHS
LEFT JOIN (
SELECT
requirements,
CASE WHEN ((target_cohort_rand01 IS NULL)) THEN cohort_definition_id WHEN NOT ((target_cohort_rand01 IS NULL)) THEN target_cohort_rand01 END AS target_cohort_rand01,
age_range,
sex AS sex_req,
min_prior_observation,
min_future_observation,
cohort_definition_id,
cohort_name,
min_age,
max_age
FROM main.my_study_tmp_001_og_001_1718168542
) RHS
ON (LHS.target_cohort_rand01 = RHS.target_cohort_rand01)...
^
--- failed re-building 'a01_building_base_cohorts.Rmd'
Warning: Connection is garbage-collected, use dbDisconnect() to avoid this.
--- re-building 'a02_applying_cohort_restrictions.Rmd' using rmarkdown
trying URL 'https://example-data.ohdsi.dev/GiBleed.zip'
Content type 'application/zip' length 6754786 bytes (6.4 MB)
==================================================
downloaded 6.4 MB
--- finished re-building 'a02_applying_cohort_restrictions.Rmd'
Warning: Connection is garbage-collected, use dbDisconnect() to avoid this.
--- re-building 'a03_age_sex_matching.Rmd' using rmarkdown
--- finished re-building 'a03_age_sex_matching.Rmd'
--- re-building 'a04_cohort_manipulations.Rmd' using rmarkdown
--- finished re-building 'a04_cohort_manipulations.Rmd'
SUMMARY: processing the following file failed:
'a01_building_base_cohorts.Rmd'
Error: Vignette re-building failed.
Execution halted
Flavor: r-oldrel-windows-x86_64
Current CRAN status: OK: 13
Current CRAN status: OK: 13