MedDRA Mapping

Overview

Information on the MedDRA mapping project.

• MedDRA to Snomed
  • ModuleId: 2
  • RefsetId: 67890
• Snomed to MedDRA
  • ModuleId: 900000000000443000
  • RefsetId: 12345

Deployment Server Details

• PROD server: webradr-mapping.ihtsdotools.org
  • url: https://webradr-mapping.ihtsdotools.org/#/

  • cron jobs

    # Run every day 20 0 * * 0,1,2,3,4,5,6 csh /opt/mapping-service-admin/config/bin/dailyReports.csh > /opt/mapping-service/logs/dailyReports.log 2>&1

• UAT server: uat-webradr-mapping.ihtsdotools.org
  • url: https://uat-webradr-mapping.ihtsdotools.org/#/
  • cron jobs - n/a

Assigning MedDRA Concepts to Teams

• In Project Details:
  • Add concepts to MedDRA to Snomed project scope
  • Run Compute Workflow 
    • This creates tracking records for the new scope concepts

• Assign the new tracking records to their respective Teams. This process is  (currently) slightly different on prod vs uat

  • Prod:

    #Become root user
    sudo su
    
    #Put up the maintenance screen
    /opt/maint/getMaintHtml.sh start
    
    #Take down the server
    tstop
    
    #Log into mysql
    mysql
    
    
    #Assign teams to tracking records
    update tracking_records set assignedTeamName='TEAM1' where mapProjectId=2 and terminologyId in ([Comma separated list of MedDRA concept ids. e.g.: '10054209','10012735','10044684']);
    update tracking_records set assignedTeamName='TEAM2' where mapProjectId=2 and terminologyId in ([Comma separated list of MedDRA concept ids]);
    
    #Reindex tracking records
    cd /home/ihtsdo/code/admin/lucene/
    rm reindexTrackingRecords.log
    mvn install -PReindex -Drun.config=/opt/mapping-service/conf/config.properties -Dindexed.objects=TrackingRecordJpa > reindexTrackingRecords.log &
    tail -f reindexTrackingRecords.log
    
    
    #Update permissions for indexes
    cd /opt/mapping-service/indexes
    chown -R mapping-service:mapping-service *
    chmod -R 777 *
    
    
    #Take down the maintenance screen
    /opt/maint/getMaintHtml.sh stop
    
    #Bring server back up
    tstart

  • UAT:

    #Become ihtsdo user
    sudo su ihtsdo
    
    
    #Take down the server
    sudo service tomcat7 stop
    
    
    #Log into mysql
    mysqlm
    
    
    #Assign teams to tracking_records
    update tracking_records set assignedTeamName='TEAM1' where mapProjectId=2 and terminologyId in ([Comma separated list of MedDRA concept ids. e.g.: '10054209','10012735','10044684']);
    update tracking_records set assignedTeamName='TEAM2' where mapProjectId=2 and terminologyId in ([Comma separated list of MedDRA concept ids]);
    
    # Reindex tracking records
    cd /home/ihtsdo/code/admin/lucene/
    rm reindexTrackingRecords.log
    mvn install -PReindex -Drun.config=/opt/mapping-service/conf/config.properties -Dindexed.objects=TrackingRecordJpa > reindexTrackingRecords.log &
    tail -f reindexTrackingRecords.log
    
    
    #Update permissions for indexes
    cd /opt/mapping-service/indexes
    chown -R ihtsdo:ihtsdo *
    chmod -R 777 *
    
    
    #Bring server back up
    sudo service tomcat7 start

Setting Snomed to MedDRA Scope

This is performed via calling a script. This script takes down the server, so it should not be done during normal working hours.

#Run as root
sudo su


#On Prod
csh /opt/mapping-service-admin/config/bin/transformTargetsToScopeConcepts.csh > /opt/mapping-service/logs/transformTargetsToScopeConcepts.log &
tail -f /opt/mapping-service/logs/transformTargetsToScopeConcepts.log


#On UAT
csh /home/ihtsdo/config/bin/transformTargetsToScopeConcepts.csh > /home/ihtsdo/logs/transformTargetsToScopeConcepts.log &
tail -f /home/ihtsdo/logs/transformTargetsToScopeConcepts.log