SNOMED International Mapping Tool

Space shortcuts

Child pages
  • MedDRA Mapping

Versions Compared

Old Version 4

changes.mady.by.user Rick Wood

Saved on

compared with

New Version 5

changes.mady.by.user Rick Wood

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • 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:

      Code Block
      #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:

      Code Block
      #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


...