# 2020.06 Warehouse/Migration Upgrade

## New Feature

* Improved the performance of the data migration scripts to run faster; from 4 hours to 1 hour completion runtime of data upload for the POC MDE file. 

## Changes

### Data Migration

* Updated data migration scripts to save data with more than one answer(multiple responses to coded concepts).
* Added the skipped/missing  record (JOHAN E HOLM) from WWG March 2017 MDE POC migration
* Updated the migration scripts to save names with special characters.
* Added fix to the migration scripts to only migrate data to mapped concepts.
* Corrected data that was mapped to the wrong concepts.
* Updated the data migration scripts to handle the migration of data containing pipes '|' per set migration rules.
* Updated the data migration scripts to migrate data 'Trope' in MDE as 'Strabismus' during migration to the data warehouse.
* Updated Data Migration scripts to migrate NR/C entries.
* Updated the migration scripts to capture data for newly added concepts from POC migration(

  WWG March 2017 MDE)
* Generated log file of WWG March 2017 MDE/Austria data that was not migrated. Access log file [here](https://vecnacorp.sharepoint.com/:x:/r/sites/VecnaCares/_layouts/15/Doc.aspx?sourcedoc=%7BD3BA835A-C21B-4859-8A41-B28F23DDEEDD%7D\&file=Data_not_found_details_v3.0.xlsx\&action=default\&mobileredirect=true)

## Bug Fixes

### Data Warehouse

* Added the 902 grouping concept observation records missing in the fact\_obs table in the data warehouse from SO-EU-Africa server.
* Updated the event data for the 5 records person\_keys(3225, 146, 1914,43,142) in fact\_obs.

## Known Issues

### Data Migration 

* Migration of second MDE file (In Progress) 


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://vecnacares.gitbook.io/special-olympics-openmrs-has/release-notes/2020.06-warehouse-migration-upgrade.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.