You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 22 Current »


Information on the ICD10 mapping project.

  • ModuleId: 449080006              
  • RefsetId: 447562003

Helpful Admin Commands


cd /opt/mapping-service-admin/admin/remover
// DO NOT DO THIS mvn install -PMapRecords -D$rc
mvn install -PTerminology -D$rc -Dterminology=ICD10 -Dversion=2016

Load Previous version RF2

in DB, first remove complex map refset members
DELETE from complex_map_refset_members where refsetId = 447562003; 
Note: (this should also be able to be run with this: 

Get maintenance window

cd /opt/mapping-service-admin/admin/remover  
mvn install -PMapMembers -D$rc
cd /opt/mapping-service-admin/admin/loader
set file = /home/ihtsdo/data/doc/release/20170131/icd10/der2_iisssccRefset_ExtendedMapSnapshot_INT_20170131.txt
perl -ne '@_=split/\t/; print if $_[4] eq "447562003"' $file > /tmp/x.txt
mvn install -PMapRecords -D$rc -Dinput.file=/tmp/x.txt -Dmember.flag=true -Drecord.flag=false

To validate:

select count(*) from complex_map_refset_members a, map_projects b where a.refsetId = b.refSetId and mapProjectId = $mapProjectId and 
a.terminology = b.sourceTerminology and a.terminologyVersion = b.sourceTerminologyVersion;


cd /opt/mapping-service-admin/admin/loader
mvn install -PComputeWorkflow -D$rc


cd /opt/mapping-service-admin/admin/release
mvn install -PBeginRelease -D$rc -Dtest.mode.flag=true
mvn install -PRelease -D$rc -Doutput.dir=. -Dtime=20170731 -Dtest.mode.flag=true
mvn install -PFinishRelease -D$rc (This process currently takes 36 hours. 26 of these hours is in loading the refset members at the end.)
mvn install -PBeginEditingCycle -D$rc

Release with Alpha/Beta Iteration

1.) Get maintenance window. Take server down 
2.) cd /opt/mapping-service-admin/admin/remover 
3.) mvn install -PTerminology -Drun.config=/opt/mapping-service/conf/ -Dterminology=SNOMEDCT -Dversion=latest
4.) cd /opt/mapping-service-admin/admin/loader
5.) mvn install -PRF2-snapshot -Drun.config=/opt/mapping-service/conf/ -Dterminology=SNOMEDCT -Dinput.dir=/home/ihstdo/data/xSnomedCT_InternationalRF2_ALPHA_20170731T120000Z/Snapshot
7.) DELETE from complex_map_refset_members where refsetId = 447562003;  
8.) set file = /home/ihtsdo/data/doc/release/20170131/icd10/der2_iisssccRefset_ExtendedMapActiveSnapshot_INT_20170131.txt
perl -ne '@_=split/\t/; print if $_[4] eq "447562003"' $file > /tmp/x.txt
mvn install -PMapRecords -Drun.config=/opt/mapping-service/conf/ -Dinput.file=/tmp/x.txt -Dmember.flag=true -Drecord.flag=false
9.) rerun compute workflow, begin, and process release steps

Loading "Human Readable" View


Updating Published Project

# Remove old records
cd ~/code/admin/remover
mvn install -PMapRecords -D$rc

# Add updated records
cd ~/code/admin/loader
set file = /home/ihtsdo/data/doc/release/20170131/icd10/der2_iisssccRefset_ExtendedMapActiveSnapshot_INT_20170131.txt
/bin/rm -f x.txt
perl -ne 's/447562003/P447562003/; @_=split/\t/;print if $_[4] eq "P447562003"; ' $file > x.txt
mvn install -PMapRecords -D$rc -Dinput.file=x.txt -Dmember.flag=false -Drecord.flag=true

Remove old reports

service tomcat7 stop
# set date one year ago, e.g. 20141215
set refsetId=447562003
set date = 20141215
cd ~/code/admin/remover
mvn install -PReports -Drun.config=/home/ihtsdo/config/$refsetId$date >&! mvn.log
service tomcat7 start
  • n/a
  • No labels