...
NOTE: No need to create 'Published SNOMED to GMDN'. GMDN project is private.
Troubleshooting
ERROR - UUID-quintuples count does not match refset member count for SimpleMap
If during release it throws the following error: "ERROR - UUID-quintuples count does not match refset member count for SimpleMap", check database for duplicate entry for map.
mysql> select *, count(*) as ct from simple_map_refset_members where refsetId='467614008' group by refsetId, concept_id, mapTarget having ct>1;
+----------+--------+---------------------+-------+-----------+-------------+--------------------------------------+--------------------+-----------+-----------+------------+----+
| id | active | effectiveTime | label | moduleId | terminology | terminologyId | terminologyVersion | refSetId | mapTarget | concept_id | ct |
+----------+--------+---------------------+-------+-----------+-------------+--------------------------------------+--------------------+-----------+-----------+------------+----+
| 10882752 | 0 | 2018-01-31 00:00:00 | NULL | 466707005 | SNOMEDCT | a4c5d7d5-3990-52d1-96f4-6a5887dd295c | latest | 467614008 | 32608 | 14431694 | 2 |
+----------+--------+---------------------+-------+-----------+-------------+--------------------------------------+--------------------+-----------+-----------+------------+----+
If a duplicate is identified, find the duplicate entries:
mysql> select * from simple_map_refset_members where concept_id=14431694 and refsetId='467614008';
+----------+--------+---------------------+-------+--------------------+-------------+--------------------------------------+--------------------+--------------------+-----------+------------+
| id | active | effectiveTime | label | moduleId | terminology | terminologyId | terminologyVersion | refSetId | mapTarget | concept_id |
+----------+--------+---------------------+-------+--------------------+-------------+--------------------------------------+--------------------+--------------------+-----------+------------+
| 10882752 | 0 | 2018-01-31 00:00:00 | NULL | 466707005 | SNOMEDCT | a4c5d7d5-3990-52d1-96f4-6a5887dd295c | latest | 467614008 | 32608 | 14431694 |
| 10885727 | 1 | 2018-01-31 00:00:00 | NULL | 466707005 | SNOMEDCT | ef5c6b29-c874-5b5c-891e-5dd510866e06 | latest | 467614008 | 61449 | 14431694 |
| 10890543 | 0 | 2017-01-31 00:00:00 | NULL | 466707005 | SNOMEDCT | 67c1c3cd-38c7-5ee1-83a8-588020f7c7d5 | latest | 467614008 | 32608 | 14431694 |
+----------+--------+---------------------+-------+--------------------+-------------+--------------------------------------+--------------------+--------------------+-----------+------------+
Here we have two inactive rows where mapTarget=32608. Remove the older row, and it should resolve the issue.
mysql> delete from simple_map_refset_members where id=10890543;
References/Links
- n/a