Release v2.8.0 (In Progress)

[anthonysena]

Release Version V2.8.0

This issue will be used to track items for the v2.8.0 release. Please reply to this thread for any/all items that are relevant for the release and we'll add them to this checklist. The items below are a placeholder based on the previous set of release activities.

• Use branch rc-v2.8.0 of Atlas & WebAPI and deploy to development. Ensure that all pom.xml references are using released libraries:

dependency	owner	pom reference	target version	changes
SqlRender	@schuemie	1.6.1-SNAPSHOT	1.6.2	OHDSI/SqlRender@v1.6.1...master
FeatureExtraction	@schuemie	2.2.0	2.2.4	OHDSI/FeatureExtraction@v2.2.1...v2.2.4
Hydra	@schuemie	0.0.4	0.0.5	OHDSI/Hydra@v0.0.4...v0.0.5
circe-be	@chrisknoll	1.9.0-SNAPSHOT	1.9.0	OHDSI/circe-be@v1.7.3...master
standardized-analysis-specs & standardized-analysis-utils	@pavgra	1.2.0-SNAPSHOT	1.2.0	OHDSI/StandardizedAnalysisAPI@v1.1.0...master
SkeletonCohortCharacterization	@pavgra	1.0.0-SNAPSHOT	1.0.0	initial release

• Compile all migration scripts for the release schema
• Complete testing, obtain sign off and post testing results
• Generate WebAPI Release Notes
• Publish Release
• Update wikis to reflect any install/setup instructions
• Update OHDSI.org
• Communicate release via OHDSI forums

[anthonysena]

Per #1353, users will need to update the results schema to include the new *_cache tables, specifically:

ALTER TABLE @results_schema.cohort_inclusion ADD design_hash int NULL;

ALTER TABLE @results_schema.cc_results ADD aggregate_id int NULL;
ALTER TABLE @results_schema.cc_results ADD aggregate_name varchar(1000);
ALTER TABLE @results_schema.cc_results ADD missing_means_zero int NULL;

IF OBJECT_ID('@results_schema.cohort_cache', 'U') IS NULL
CREATE TABLE @results_schema.cohort_cache (
	design_hash int NOT NULL,
	SUBJECT_ID bigint NOT NULL,
	cohort_start_date date NOT NULL,
	cohort_end_date date NOT NULL
);

IF OBJECT_ID('@results_schema.cohort_censor_stats_cache', 'U') IS NULL
CREATE TABLE @results_schema.cohort_censor_stats_cache (
  design_hash int NOT NULL,
  lost_count BIGINT NOT NULL
);

IF OBJECT_ID('@results_schema.cohort_inclusion_result_cache', 'U') IS NULL
CREATE TABLE @results_schema.cohort_inclusion_result_cache (
  design_hash int NOT NULL,
  mode_id int NOT NULL,
  inclusion_rule_mask bigint NOT NULL,
  person_count bigint NOT NULL
);

IF OBJECT_ID('@results_schema.cohort_inclusion_stats_cache', 'U') IS NULL
CREATE TABLE @results_schema.cohort_inclusion_stats_cache (
  design_hash int NOT NULL,
  rule_sequence int NOT NULL,
  mode_id int NOT NULL,
  person_count bigint NOT NULL,
  gain_count bigint NOT NULL,
  person_total bigint NOT NULL
);

IF OBJECT_ID('@results_schema.cohort_summary_stats_cache', 'U') IS NULL
CREATE TABLE @results_schema.cohort_summary_stats_cache (
  design_hash int NOT NULL,
  mode_id int NOT NULL,
  base_count bigint NOT NULL,
  final_count bigint NOT NULL
);

IF OBJECT_ID('@results_schema.cohort_sample_element', 'U') IS NULL
CREATE TABLE @results_schema.[cohort_sample_element] (
    [cohort_sample_id] int NOT NULL, 
    [rank_value] int NOT NULL, 
    [person_id] bigint NOT NULL, 
    [age] int NULL, 
    [gender_concept_id] int NULL
);

Also, describe the new cache settings:

cache.generation.invalidAfterDays=${cache.generation.invalidAfterDays} 
cache.generation.cleanupInterval=${cache.generation.cleanupInterval}
cache.generation.useAsync=${cache.generation.useAsync} 
(cache.generation.useAsync details: https://github.com/OHDSI/WebAPI/pull/1459)

[anthonysena]

@chrisknoll - I removed your comment on this thread since we've addressed the referenced PR and I updated the comments with the new migration script. My aim is to keep this thread as a running set of notes for the 2.8 migration items for the release notes. Thanks!

[anthonysena]

Add notes on Solr setup to the wiki and release notes per #1091 (comment)

[anthonysena]

Note the new pom.xml build options: #1453 (comment)

[anthonysena]

Note the Docker enhancements: OHDSI/Atlas#2080 (comment)