Index: ssts-web/src/main/webapp/dataUpdater/sqls/4.9.97_4.9.98_sqlserver.sql
===================================================================
diff -u -r34520 -r34533
--- ssts-web/src/main/webapp/dataUpdater/sqls/4.9.97_4.9.98_sqlserver.sql	(.../4.9.97_4.9.98_sqlserver.sql)	(revision 34520)
+++ ssts-web/src/main/webapp/dataUpdater/sqls/4.9.97_4.9.98_sqlserver.sql	(.../4.9.97_4.9.98_sqlserver.sql)	(revision 34533)
@@ -1,2 +1,2 @@
 update Sterilisation set sterilizationPurposeid = (select max(id) from HttpOption where optionText = Sterilisation.sterilizationPurpose and optionListId = 'sterilizationPurpose') where sterilizationPurposeid is null and sterilizationPurpose is not null;
-insert into SterilizerGroupOrgunit (sterilizerGroupId, orgUnitId) select ho.id, org.id from HttpOption ho, (select ou.id from SupplyRoomConfig src join OrgUnit ou on ou.orgUnitCoding = src.orgUnitCoding where src.supplyRoomType in (1,2)) org where ho.optionListId = 'sterilerGroup';
\ No newline at end of file
+insert into SterilizerGroupOrgunit (sterilizerGroupId, orgUnitId) select ho.id, org.id from HttpOption ho, (select ou.id from SupplyRoomConfig src join OrgUnit ou on ou.orgUnitCoding = src.orgUnitCoding where src.supplyRoomType in (1,2)) org where ho.optionListId = 'sterilerGroup' and ho.id not in (select sterilizerGroupId from SterilizerGroupOrgunit);
\ No newline at end of file
Index: ssts-web/src/main/webapp/dataUpdater/sqls/4.9.97_4.9.98_oracle.sql
===================================================================
diff -u -r34520 -r34533
--- ssts-web/src/main/webapp/dataUpdater/sqls/4.9.97_4.9.98_oracle.sql	(.../4.9.97_4.9.98_oracle.sql)	(revision 34520)
+++ ssts-web/src/main/webapp/dataUpdater/sqls/4.9.97_4.9.98_oracle.sql	(.../4.9.97_4.9.98_oracle.sql)	(revision 34533)
@@ -1,2 +1,2 @@
 update Sterilisation set sterilizationPurposeid = (select max(id) from HttpOption where optionText = Sterilisation.sterilizationPurpose and optionListId = 'sterilizationPurpose') where sterilizationPurposeid is null and sterilizationPurpose is not null;
-insert into SterilizerGroupOrgunit (id, sterilizerGroupId, orgUnitId) select HIBERNATE_SEQUENCE.Nextval,ho.id, org.id from HttpOption ho, (select ou.id from SupplyRoomConfig src join OrgUnit ou on ou.orgUnitCoding = src.orgUnitCoding where src.supplyRoomType in (1,2)) org where ho.optionListId = 'sterilerGroup';
\ No newline at end of file
+insert into SterilizerGroupOrgunit (id, sterilizerGroupId, orgUnitId) select HIBERNATE_SEQUENCE.Nextval,ho.id, org.id from HttpOption ho, (select ou.id from SupplyRoomConfig src join OrgUnit ou on ou.orgUnitCoding = src.orgUnitCoding where src.supplyRoomType in (1,2)) org where ho.optionListId = 'sterilerGroup' and ho.id not in (select sterilizerGroupId from SterilizerGroupOrgunit);
\ No newline at end of file