nt11_66_1_, workspace1_.patientNameComposition as patient12_66_1_, workspace1_.sendSystemMessages as sendSys13_66_1_, workspace1_.suspectCaseNumber as suspect14_66_1_, workspace1_.treatMonitoringInput as treatMo15_66_1_, workspace1_.weekFreq1 as weekFre16_66_1_, workspace1_.weekFreq2 as weekFre17_66_1_, workspace1_.weekFreq3 as weekFre18_66_1_, workspace1_.weekFreq4 as weekFre19_66_1_, workspace1_.weekFreq5 as weekFre20_66_1_, workspace1_.weekFreq6 as weekFre21_66_1_, workspace1_.weekFreq7 as weekFre22_66_1_ from workspaceview workspacev0_ left outer join workspace workspace1_ on workspacev0_.id=workspace1_.id where workspacev0_.id=?
Hibernate: select userworksp0_.id as id1_64_0_, user1_.id as id1_48_1_, workspace2_.id as id1_66_2_, userworksp0_.WORKSPACE_ID as WORKSPAC5_64_0_, userworksp0_.ADMINUNIT_ID as ADMINUNI6_64_0_, userworksp0_.administrator as administ2_64_0_, userworksp0_.playOtherUnits as playOthe3_64_0_, userworksp0_.UNIT_ID as UNIT_ID7_64_0_, userworksp0_.USER_ID as USER_ID8_64_0_, userworksp0_.USER_VIEW as USER_VIE4_64_0_, user1_.comments as comments2_48_1_, user1_.customId as customId3_48_1_, user1_.DEFAULTWORKSPACE_ID as DEFAULT14_48_1_, user1_.email as email4_48_1_, user1_.login as login5_48_1_, user1_.name as name6_48_1_, user1_.PARENTUSER_ID as PARENTU15_48_1_, user1_.password as password7_48_1_, user1_.pwdChangeRequest as pwdChang8_48_1_, user1_.registrationDate as registra9_48_1_, user1_.sendSystemMessages as sendSys10_48_1_, user1_.state as state11_48_1_, user1_.timeZone as timeZon12_48_1_, user1_.ulaAccepted as ulaAcce13_48_1_, workspace2_.caseValidationDRTB as caseVali2_66_2_, workspace2_.caseValidationNTM as caseVali3_66_2_, workspace2_.caseValidationTB as caseVali4_66_2_, workspace2_.confirmedCaseNumber as confirme5_66_2_, workspace2_.customId as customId6_66_2_, workspace2_.maxStockOnHand as maxStock7_66_2_, workspace2_.minStockOnHand as minStock8_66_2_, workspace2_.monthsToAlertExpiredMedicines as monthsTo9_66_2_, workspace2_.name as name10_66_2_, workspace2_.patientAddrRequiredLevels as patient11_66_2_, workspace2_.patientNameComposition as patient12_66_2_, workspace2_.sendSystemMessages as sendSys13_66_2_, workspace2_.suspectCaseNumber as suspect14_66_2_, workspace2_.treatMonitoringInput as treatMo15_66_2_, workspace2_.weekFreq1 as weekFre16_66_2_, workspace2_.weekFreq2 as weekFre17_66_2_, workspace2_.weekFreq3 as weekFre18_66_2_, workspace2_.weekFreq4 as weekFre19_66_2_, workspace2_.weekFreq5 as weekFre20_66_2_, workspace2_.weekFreq6 as weekFre21_66_2_, workspace2_.weekFreq7 as weekFre22_66_2_ from userworkspace userworksp0_ inner join sys_user user1_ on userworksp0_.USER_ID=user1_.id inner join workspace workspace2_ on userworksp0_.WORKSPACE_ID=workspace2_.id where userworksp0_.USER_ID=? and userworksp0_.WORKSPACE_ID=?
Hibernate: select unit0_.id as id2_59_0_, unit0_.WORKSPACE_ID as WORKSPA26_59_0_, unit0_.active as active3_59_0_, unit0_.ADDRESS as ADDRESS4_59_0_, unit0_.ADMINUNIT_ID as ADMINUN27_59_0_, unit0_.addressCompl as addressC5_59_0_, unit0_.zipcode as zipcode6_59_0_, unit0_.AUTHORIZERUNIT_ID as AUTHORI28_59_0_, unit0_.customId as customId7_59_0_, unit0_.inventoryCloseDate as inventor8_59_0_, unit0_.inventoryStartDate as inventor9_59_0_, unit0_.name as name10_59_0_, unit0_.receiveFromManufacturer as receive11_59_0_, unit0_.shipAddress as shipAdd12_59_0_, unit0_.SHIP_ADMINUNIT_ID as SHIP_AD29_59_0_, unit0_.shipAddressCompl as shipAdd13_59_0_, unit0_.shipZipCode as shipZip14_59_0_, unit0_.shipContactName as shipCon15_59_0_, unit0_.shipContactPhone as shipCon16_59_0_, unit0_.SUPPLIER_ID as SUPPLIE30_59_0_, unit0_.performCulture as perform17_59_0_, unit0_.performDst as perform18_59_0_, unit0_.performMicroscopy as perform19_59_0_, unit0_.performXpert as perform20_59_0_, unit0_.drtbFacility as drtbFac21_59_0_, unit0_.notificationUnit as notific22_59_0_, unit0_.ntmFacility as ntmFaci23_59_0_, unit0_.numDaysOrder as numDays24_59_0_, unit0_.tbFacility as tbFacil25_59_0_, unit0_.DISCRIMINATOR as DISCRIMI1_59_0_ from unit unit0_ where unit0_.id=?
Hibernate: select administra0_.id as id1_0_0_, administra0_.WORKSPACE_ID as WORKSPAC6_0_0_, administra0_.code as code2_0_0_, administra0_.COUNTRYSTRUCTURE_ID as COUNTRYS7_0_0_, administra0_.customId as customId3_0_0_, administra0_.name as name4_0_0_, administra0_.PARENT_ID as PARENT_I8_0_0_, administra0_.unitsCount as unitsCou5_0_0_, administra1_.id as id1_0_1_, administra1_.WORKSPACE_ID as WORKSPAC6_0_1_, administra1_.code as code2_0_1_, administra1_.COUNTRYSTRUCTURE_ID as COUNTRYS7_0_1_, administra1_.customId as customId3_0_1_, administra1_.name as name4_0_1_, administra1_.PARENT_ID as PARENT_I8_0_1_, administra1_.unitsCount as unitsCou5_0_1_ from administrativeunit administra0_ left outer join administrativeunit administra1_ on administra0_.PARENT_ID=administra1_.id where administra0_.id=?
Hibernate: select administra0_.id as col_0_0_, administra0_.name as col_1_0_, administra1_.id as col_2_0_, administra1_.name as col_3_0_, administra2_.id as col_4_0_, administra2_.name as col_5_0_, administra3_.id as col_6_0_, administra3_.name as col_7_0_, administra4_.id as col_8_0_, administra4_.name as col_9_0_ from administrativeunit administra0_ left outer join administrativeunit administra1_ on administra0_.PARENT_ID=administra1_.id left outer join administrativeunit administra2_ on administra1_.PARENT_ID=administra2_.id left outer join administrativeunit administra3_ on administra2_.PARENT_ID=administra3_.id left outer join administrativeunit administra4_ on administra3_.PARENT_ID=administra4_.id where administra0_.id=?
2016-05-26 22:06:30.460 INFO 6940 --- [ main] org.msh.etbm.test.TestSetup : User admin authenticated
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.016 sec - in org.msh.etbm.test.services.admin.PermissionTreeOptionsTest
Running org.msh.etbm.test.services.admin.SourceTest
2016-05-26 22:06:30.460 INFO 6940 --- [ main] o.s.t.c.support.AbstractContextLoader : Could not detect default resource locations for test class [org.msh.etbm.test.AuthenticatedTest]: no resource found for suffixes {-context.xml, Context.groovy}.
2016-05-26 22:06:30.460 INFO 6940 --- [ main] o.s.t.c.web.WebTestContextBootstrapper : Loaded default TestExecutionListener class names from location [META-INF/spring.factories]: [org.springframework.test.context.web.ServletTestExecutionListener, org.springframework.test.context.support.DirtiesContextBeforeModesTestExecutionListener, org.springframework.test.context.support.DependencyInjectionTestExecutionListener, org.springframework.test.context.support.DirtiesContextTestExecutionListener, org.springframework.test.context.transaction.TransactionalTestExecutionListener, org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener]
2016-05-26 22:06:30.460 INFO 6940 --- [ main] o.s.t.c.web.WebTestContextBootstrapper : Using TestExecutionListeners: [org.springframework.test.context.web.ServletTestExecutionListener@54d20609, org.springframework.test.context.support.DirtiesContextBeforeModesTestExecutionListener@763a46fe, org.springframework.test.context.support.DependencyInjectionTestExecutionListener@106361e9, org.springframework.test.context.support.DirtiesContextTestExecutionListener@22974eba, org.springframework.test.context.transaction.TransactionalTestExecutionListener@6631e6af, org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener@42985121]
Hibernate: select user0_.id as id1_48_, user0_.comments as comments2_48_, user0_.customId as customId3_48_, user0_.DEFAULTWORKSPACE_ID as DEFAULT14_48_, user0_.email as email4_48_, user0_.login as login5_48_, user0_.name as name6_48_, user0_.PARENTUSER_ID as PARENTU15_48_, user0_.password as password7_48_, user0_.pwdChangeRequest as pwdChang8_48_, user0_.registrationDate as registra9_48_, user0_.sendSystemMessages as sendSys10_48_, user0_.state as state11_48_, user0_.timeZone as timeZon12_48_, user0_.ulaAccepted as ulaAcce13_48_ from sys_user user0_ where user0_.login=? and upper(user0_.password)=? and user0_.state<>?
Hibernate: select userworksp0_.id as id1_64_, userworksp0_.WORKSPACE_ID as WORKSPAC5_64_, userworksp0_.ADMINUNIT_ID as ADMINUNI6_64_, userworksp0_.administrator as administ2_64_, userworksp0_.playOtherUnits as playOthe3_64_, userworksp0_.UNIT_ID as UNIT_ID7_64_, userworksp0_.USER_ID as USER_ID8_64_, userworksp0_.USER_VIEW as USER_VIE4_64_ from userworkspace userworksp0_ where userworksp0_.id=(select min(userworksp1_.id) from userworkspace userworksp1_ where userworksp1_.USER_ID=?) limit ?
Hibernate: insert into userlogin (Application, IpAddress, lastAccess, loginDate, logoutDate, USER_ID, WORKSPACE_ID, id) values (?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: select workspace0_.id as id1_66_0_, workspace0_.caseValidationDRTB as caseVali2_66_0_, workspace0_.caseValidationNTM as caseVali3_66_0_, workspace0_.caseValidationTB as caseVali4_66_0_, workspace0_.confirmedCaseNumber as confirme5_66_0_, workspace0_.customId as customId6_66_0_, workspace0_.maxStockOnHand as maxStock7_66_0_, workspace0_.minStockOnHand as minStock8_66_0_, workspace0_.monthsToAlertExpiredMedicines as monthsTo9_66_0_, workspace0_.name as name10_66_0_, workspace0_.patientAddrRequiredLevels as patient11_66_0_, workspace0_.patientNameComposition as patient12_66_0_, workspace0_.sendSystemMessages as sendSys13_66_0_, workspace0_.suspectCaseNumber as suspect14_66_0_, workspace0_.treatMonitoringInput as treatMo15_66_0_, workspace0_.weekFreq1 as weekFre16_66_0_, workspace0_.weekFreq2 as weekFre17_66_0_, workspace0_.weekFreq3 as weekFre18_66_0_, workspace0_.weekFreq4 as weekFre19_66_0_, workspace0_.weekFreq5 as weekFre20_66_0_, workspace0_.weekFreq6 as weekFre21_66_0_, workspace0_.weekFreq7 as weekFre22_66_0_ from workspace workspace0_ where workspace0_.id=?
Hibernate: select workspacev0_.id as id1_68_0_, workspacev0_.logoImage as logoImag2_68_0_, workspacev0_.picture as picture3_68_0_, workspacev0_.pictureContentType as pictureC4_68_0_, workspace1_.id as id1_66_1_, workspace1_.caseValidationDRTB as caseVali2_66_1_, workspace1_.caseValidationNTM as caseVali3_66_1_, workspace1_.caseValidationTB as caseVali4_66_1_, workspace1_.confirmedCaseNumber as confirme5_66_1_, workspace1_.customId as customId6_66_1_, workspace1_.maxStockOnHand as maxStock7_66_1_, workspace1_.minStockOnHand as minStock8_66_1_, workspace1_.monthsToAlertExpiredMedicines as monthsTo9_66_1_, workspace1_.name as name10_66_1_, workspace1_.patientAddrRequiredLevels as patient11_66_1_, workspace1_.patientNameComposition as patient12_66_1_, workspace1_.sendSystemMessages as sendSys13_66_1_, workspace1_.suspectCaseNumber as suspect14_66_1_, workspace1_.treatMonitoringInput as treatMo15_66_1_, workspace1_.weekFreq1 as weekFre16_66_1_, workspace1_.weekFreq2 as weekFre17_66_1_, workspace1_.weekFreq3 as weekFre18_66_1_, workspace1_.weekFreq4 as weekFre19_66_1_, workspace1_.weekFreq5 as weekFre20_66_1_, workspace1_.weekFreq6 as weekFre21_66_1_, workspace1_.weekFreq7 as weekFre22_66_1_ from workspaceview workspacev0_ left outer join workspace workspace1_ on workspacev0_.id=workspace1_.id where workspacev0_.id=?
Hibernate: select userworksp0_.id as id1_64_0_, user1_.id as id1_48_1_, workspace2_.id as id1_66_2_, userworksp0_.WORKSPACE_ID as WORKSPAC5_64_0_, userworksp0_.ADMINUNIT_ID as ADMINUNI6_64_0_, userworksp0_.administrator as administ2_64_0_, userworksp0_.playOtherUnits as playOthe3_64_0_, userworksp0_.UNIT_ID as UNIT_ID7_64_0_, userworksp0_.USER_ID as USER_ID8_64_0_, userworksp0_.USER_VIEW as USER_VIE4_64_0_, user1_.comments as comments2_48_1_, user1_.customId as customId3_48_1_, user1_.DEFAULTWORKSPACE_ID as DEFAULT14_48_1_, user1_.email as email4_48_1_, user1_.login as login5_48_1_, user1_.name as name6_48_1_, user1_.PARENTUSER_ID as PARENTU15_48_1_, user1_.password as password7_48_1_, user1_.pwdChangeRequest as pwdChang8_48_1_, user1_.registrationDate as registra9_48_1_, user1_.sendSystemMessages as sendSys10_48_1_, user1_.state as state11_48_1_, user1_.timeZone as timeZon12_48_1_, user1_.ulaAccepted as ulaAcce13_48_1_, workspace2_.caseValidationDRTB as caseVali2_66_2_, workspace2_.caseValidationNTM as caseVali3_66_2_, workspace2_.caseValidationTB as caseVali4_66_2_, workspace2_.confirmedCaseNumber as confirme5_66_2_, workspace2_.customId as customId6_66_2_, workspace2_.maxStockOnHand as maxStock7_66_2_, workspace2_.minStockOnHand as minStock8_66_2_, workspace2_.monthsToAlertExpiredMedicines as monthsTo9_66_2_, workspace2_.name as name10_66_2_, workspace2_.patientAddrRequiredLevels as patient11_66_2_, workspace2_.patientNameComposition as patient12_66_2_, workspace2_.sendSystemMessages as sendSys13_66_2_, workspace2_.suspectCaseNumber as suspect14_66_2_, workspace2_.treatMonitoringInput as treatMo15_66_2_, workspace2_.weekFreq1 as weekFre16_66_2_, workspace2_.weekFreq2 as weekFre17_66_2_, workspace2_.weekFreq3 as weekFre18_66_2_, workspace2_.weekFreq4 as weekFre19_66_2_, workspace2_.weekFreq5 as weekFre20_66_2_, workspace2_.weekFreq6 as weekFre21_66_2_, workspace2_.weekFreq7 as weekFre22_66_2_ from userworkspace userworksp0_ inner join sys_user user1_ on userworksp0_.USER_ID=user1_.id inner join workspace workspace2_ on userworksp0_.WORKSPACE_ID=workspace2_.id where userworksp0_.USER_ID=? and userworksp0_.WORKSPACE_ID=?
Hibernate: select unit0_.id as id2_59_0_, unit0_.WORKSPACE_ID as WORKSPA26_59_0_, unit0_.active as active3_59_0_, unit0_.ADDRESS as ADDRESS4_59_0_, unit0_.ADMINUNIT_ID as ADMINUN27_59_0_, unit0_.addressCompl as addressC5_59_0_, unit0_.zipcode as zipcode6_59_0_, unit0_.AUTHORIZERUNIT_ID as AUTHORI28_59_0_, unit0_.customId as customId7_59_0_, unit0_.inventoryCloseDate as inventor8_59_0_, unit0_.inventoryStartDate as inventor9_59_0_, unit0_.name as name10_59_0_, unit0_.receiveFromManufacturer as receive11_59_0_, unit0_.shipAddress as shipAdd12_59_0_, unit0_.SHIP_ADMINUNIT_ID as SHIP_AD29_59_0_, unit0_.shipAddressCompl as shipAdd13_59_0_, unit0_.shipZipCode as shipZip14_59_0_, unit0_.shipContactName as shipCon15_59_0_, unit0_.shipContactPhone as shipCon16_59_0_, unit0_.SUPPLIER_ID as SUPPLIE30_59_0_, unit0_.performCulture as perform17_59_0_, unit0_.performDst as perform18_59_0_, unit0_.performMicroscopy as perform19_59_0_, unit0_.performXpert as perform20_59_0_, unit0_.drtbFacility as drtbFac21_59_0_, unit0_.notificationUnit as notific22_59_0_, unit0_.ntmFacility as ntmFaci23_59_0_, unit0_.numDaysOrder as numDays24_59_0_, unit0_.tbFacility as tbFacil25_59_0_, unit0_.DISCRIMINATOR as DISCRIMI1_59_0_ from unit unit0_ where unit0_.id=?
Hibernate: select administra0_.id as id1_0_0_, administra0_.WORKSPACE_ID as WORKSPAC6_0_0_, administra0_.code as code2_0_0_, administra0_.COUNTRYSTRUCTURE_ID as COUNTRYS7_0_0_, administra0_.customId as customId3_0_0_, administra0_.name as name4_0_0_, administra0_.PARENT_ID as PARENT_I8_0_0_, administra0_.unitsCount as unitsCou5_0_0_, administra1_.id as id1_0_1_, administra1_.WORKSPACE_ID as WORKSPAC6_0_1_, administra1_.code as code2_0_1_, administra1_.COUNTRYSTRUCTURE_ID as COUNTRYS7_0_1_, administra1_.customId as customId3_0_1_, administra1_.name as name4_0_1_, administra1_.PARENT_ID as PARENT_I8_0_1_, administra1_.unitsCount as unitsCou5_0_1_ from administrativeunit administra0_ left outer join administrativeunit administra1_ on administra0_.PARENT_ID=administra1_.id where administra0_.id=?
Hibernate: select administra0_.id as col_0_0_, administra0_.name as col_1_0_, administra1_.id as col_2_0_, administra1_.name as col_3_0_, administra2_.id as col_4_0_, administra2_.name as col_5_0_, administra3_.id as col_6_0_, administra3_.name as col_7_0_, administra4_.id as col_8_0_, administra4_.name as col_9_0_ from administrativeunit administra0_ left outer join administrativeunit administra1_ on administra0_.PARENT_ID=administra1_.id left outer join administrativeunit administra2_ on administra1_.PARENT_ID=administra2_.id left outer join administrativeunit administra3_ on administra2_.PARENT_ID=administra3_.id left outer join administrativeunit administra4_ on administra3_.PARENT_ID=administra4_.id where administra0_.id=?
2016-05-26 22:06:30.475 INFO 6940 --- [ main] org.msh.etbm.test.TestSetup : User admin authenticated
Hibernate: select workspace0_.id as id1_66_0_, workspace0_.caseValidationDRTB as caseVali2_66_0_, workspace0_.caseValidationNTM as caseVali3_66_0_, workspace0_.caseValidationTB as caseVali4_66_0_, workspace0_.confirmedCaseNumber as confirme5_66_0_, workspace0_.customId as customId6_66_0_, workspace0_.maxStockOnHand as maxStock7_66_0_, workspace0_.minStockOnHand as minStock8_66_0_, workspace0_.monthsToAlertExpiredMedicines as monthsTo9_66_0_, workspace0_.name as name10_66_0_, workspace0_.patientAddrRequiredLevels as patient11_66_0_, workspace0_.patientNameComposition as patient12_66_0_, workspace0_.sendSystemMessages as sendSys13_66_0_, workspace0_.suspectCaseNumber as suspect14_66_0_, workspace0_.treatMonitoringInput as treatMo15_66_0_, workspace0_.weekFreq1 as weekFre16_66_0_, workspace0_.weekFreq2 as weekFre17_66_0_, workspace0_.weekFreq3 as weekFre18_66_0_, workspace0_.weekFreq4 as weekFre19_66_0_, workspace0_.weekFreq5 as weekFre20_66_0_, workspace0_.weekFreq6 as weekFre21_66_0_, workspace0_.weekFreq7 as weekFre22_66_0_ from workspace workspace0_ where workspace0_.id=?
Hibernate: select workspacev0_.id as id1_68_0_, workspacev0_.logoImage as logoImag2_68_0_, workspacev0_.picture as picture3_68_0_, workspacev0_.pictureContentType as pictureC4_68_0_, workspace1_.id as id1_66_1_, workspace1_.caseValidationDRTB as caseVali2_66_1_, workspace1_.caseValidationNTM as caseVali3_66_1_, workspace1_.caseValidationTB as caseVali4_66_1_, workspace1_.confirmedCaseNumber as confirme5_66_1_, workspace1_.customId as customId6_66_1_, workspace1_.maxStockOnHand as maxStock7_66_1_, workspace1_.minStockOnHand as minStock8_66_1_, workspace1_.monthsToAlertExpiredMedicines as monthsTo9_66_1_, workspace1_.name as name10_66_1_, workspace1_.patientAddrRequiredLevels as patient11_66_1_, workspace1_.patientNameComposition as patient12_66_1_, workspace1_.sendSystemMessages as sendSys13_66_1_, workspace1_.suspectCaseNumber as suspect14_66_1_, workspace1_.treatMonitoringInput as treatMo15_66_1_, workspace1_.weekFreq1 as weekFre16_66_1_, workspace1_.weekFreq2 as weekFre17_66_1_, workspace1_.weekFreq3 as weekFre18_66_1_, workspace1_.weekFreq4 as weekFre19_66_1_, workspace1_.weekFreq5 as weekFre20_66_1_, workspace1_.weekFreq6 as weekFre21_66_1_, workspace1_.weekFreq7 as weekFre22_66_1_ from workspaceview workspacev0_ left outer join workspace workspace1_ on workspacev0_.id=workspace1_.id where workspacev0_.id=?
Hibernate: select count(*) as col_0_0_ from source source0_ where source0_.WORKSPACE_ID=? and source0_.name=?
Hibernate: select count(*) as col_0_0_ from source source0_ where source0_.WORKSPACE_ID=? and source0_.shortName=?
Hibernate: insert into source (WORKSPACE_ID, active, customId, name, shortName, id) values (?, ?, ?, ?, ?, ?)
Hibernate: select userlog0_.id as id1_60_0_, userlog0_.name as name2_60_0_ from userlog userlog0_ where userlog0_.id=?
Hibernate: select workspacel0_.id as id1_67_0_, workspacel0_.name as name2_67_0_ from workspacelog workspacel0_ where workspacel0_.id=?
Hibernate: select unit0_.id as id2_59_0_, unit0_.WORKSPACE_ID as WORKSPA26_59_0_, unit0_.active as active3_59_0_, unit0_.ADDRESS as ADDRESS4_59_0_, unit0_.ADMINUNIT_ID as ADMINUN27_59_0_, unit0_.addressCompl as addressC5_59_0_, unit0_.zipcode as zipcode6_59_0_, unit0_.AUTHORIZERUNIT_ID as AUTHORI28_59_0_, unit0_.customId as customId7_59_0_, unit0_.inventoryCloseDate as inventor8_59_0_, unit0_.inventoryStartDate as inventor9_59_0_, unit0_.name as name10_59_0_, unit0_.receiveFromManufacturer as receive11_59_0_, unit0_.shipAddress as shipAdd12_59_0_, unit0_.SHIP_ADMINUNIT_ID as SHIP_AD29_59_0_, unit0_.shipAddressCompl as shipAdd13_59_0_, unit0_.shipZipCode as shipZip14_59_0_, unit0_.shipContactName as shipCon15_59_0_, unit0_.shipContactPhone as shipCon16_59_0_, unit0_.SUPPLIER_ID as SUPPLIE30_59_0_, unit0_.performCulture as perform17_59_0_, unit0_.performDst as perform18_59_0_, unit0_.performMicroscopy as perform19_59_0_, unit0_.performXpert as perform20_59_0_, unit0_.drtbFacility as drtbFac21_59_0_, unit0_.notificationUnit as notific22_59_0_, unit0_.ntmFacility as ntmFaci23_59_0_, unit0_.numDaysOrder as numDays24_59_0_, unit0_.tbFacility as tbFacil25_59_0_, unit0_.DISCRIMINATOR as DISCRIMI1_59_0_ from unit unit0_ where unit0_.id=?
Hibernate: insert into commandhistory (action, data, entityId, entityName, execDate, parentId, type, UNIT_ID, USERLOG_ID, WORKSPACELOG_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: select source0_.id as id1_45_0_, source0_.WORKSPACE_ID as WORKSPAC6_45_0_, source0_.active as active2_45_0_, source0_.customId as customId3_45_0_, source0_.name as name4_45_0_, source0_.shortName as shortNam5_45_0_ from source source0_ where source0_.id=?
Hibernate: select workspace0_.id as id1_66_0_, workspace0_.caseValidationDRTB as caseVali2_66_0_, workspace0_.caseValidationNTM as caseVali3_66_0_, workspace0_.caseValidationTB as caseVali4_66_0_, workspace0_.confirmedCaseNumber as confirme5_66_0_, workspace0_.customId as customId6_66_0_, workspace0_.maxStockOnHand as maxStock7_66_0_, workspace0_.minStockOnHand as minStock8_66_0_, workspace0_.monthsToAlertExpiredMedicines as monthsTo9_66_0_, workspace0_.name as name10_66_0_, workspace0_.patientAddrRequiredLevels as patient11_66_0_, workspace0_.patientNameComposition as patient12_66_0_, workspace0_.sendSystemMessages as sendSys13_66_0_, workspace0_.suspectCaseNumber as suspect14_66_0_, workspace0_.treatMonitoringInput as treatMo15_66_0_, workspace0_.weekFreq1 as weekFre16_66_0_, workspace0_.weekFreq2 as weekFre17_66_0_, workspace0_.weekFreq3 as weekFre18_66_0_, workspace0_.weekFreq4 as weekFre19_66_0_, workspace0_.weekFreq5 as weekFre20_66_0_, workspace0_.weekFreq6 as weekFre21_66_0_, workspace0_.weekFreq7 as weekFre22_66_0_ from workspace workspace0_ where workspace0_.id=?
Hibernate: select workspacev0_.id as id1_68_0_, workspacev0_.logoImage as logoImag2_68_0_, workspacev0_.picture as picture3_68_0_, workspacev0_.pictureContentType as pictureC4_68_0_, workspace1_.id as id1_66_1_, workspace1_.caseValidationDRTB as caseVali2_66_1_, workspace1_.caseValidationNTM as caseVali3_66_1_, workspace1_.caseValidationTB as caseVali4_66_1_, workspace1_.confirmedCaseNumber as confirme5_66_1_, workspace1_.customId as customId6_66_1_, workspace1_.maxStockOnHand as maxStock7_66_1_, workspace1_.minStockOnHand as minStock8_66_1_, workspace1_.monthsToAlertExpiredMedicines as monthsTo9_66_1_, workspace1_.name as name10_66_1_, workspace1_.patientAddrRequiredLevels as patient11_66_1_, workspace1_.patientNameComposition as patient12_66_1_, workspace1_.sendSystemMessages as sendSys13_66_1_, workspace1_.suspectCaseNumber as suspect14_66_1_, workspace1_.treatMonitoringInput as treatMo15_66_1_, workspace1_.weekFreq1 as weekFre16_66_1_, workspace1_.weekFreq2 as weekFre17_66_1_, workspace1_.weekFreq3 as weekFre18_66_1_, workspace1_.weekFreq4 as weekFre19_66_1_, workspace1_.weekFreq5 as weekFre20_66_1_, workspace1_.weekFreq6 as weekFre21_66_1_, workspace1_.weekFreq7 as weekFre22_66_1_ from workspaceview workspacev0_ left outer join workspace workspace1_ on workspacev0_.id=workspace1_.id where workspacev0_.id=?
Hibernate: select count(*) as col_0_0_ from source source0_ where source0_.WORKSPACE_ID=? and source0_.name=?
Hibernate: select count(*) as col_0_0_ from source source0_ where source0_.WORKSPACE_ID=? and source0_.shortName=?
Hibernate: select source0_.id as id1_45_0_, source0_.WORKSPACE_ID as WORKSPAC6_45_0_, source0_.active as active2_45_0_, source0_.customId as customId3_45_0_, source0_.name as name4_45_0_, source0_.shortName as shortNam5_45_0_ from source source0_ where source0_.id=?
Hibernate: select source0_.id as id1_45_0_, source0_.WORKSPACE_ID as WORKSPAC6_45_0_, source0_.active as active2_45_0_, source0_.customId as customId3_45_0_, source0_.name as name4_45_0_, source0_.shortName as shortNam5_45_0_ from source source0_ where source0_.id=?
Hibernate: select workspace0_.id as id1_66_0_, workspace0_.caseValidationDRTB as caseVali2_66_0_, workspace0_.caseValidationNTM as caseVali3_66_0_, workspace0_.caseValidationTB as caseVali4_66_0_, workspace0_.confirmedCaseNumber as confirme5_66_0_, workspace0_.customId as customId6_66_0_, workspace0_.maxStockOnHand as maxStock7_66_0_, workspace0_.minStockOnHand as minStock8_66_0_, workspace0_.monthsToAlertExpiredMedicines as monthsTo9_66_0_, workspace0_.name as name10_66_0_, workspace0_.patientAddrRequiredLevels as patient11_66_0_, workspace0_.patientNameComposition as patient12_66_0_, workspace0_.sendSystemMessages as sendSys13_66_0_, workspace0_.suspectCaseNumber as suspect14_66_0_, workspace0_.treatMonitoringInput as treatMo15_66_0_, workspace0_.weekFreq1 as weekFre16_66_0_, workspace0_.weekFreq2 as weekFre17_66_0_, workspace0_.weekFreq3 as weekFre18_66_0_, workspace0_.weekFreq4 as weekFre19_66_0_, workspace0_.weekFreq5 as weekFre20_66_0_, workspace0_.weekFreq6 as weekFre21_66_0_, workspace0_.weekFreq7 as weekFre22_66_0_ from workspace workspace0_ where workspace0_.id=?
Hibernate: select workspacev0_.id as id1_68_0_, workspacev0_.logoImage as logoImag2_68_0_, workspacev0_.picture as picture3_68_0_, workspacev0_.pictureContentType as pictureC4_68_0_, workspace1_.id as id1_66_1_, workspace1_.caseValidationDRTB as caseVali2_66_1_, workspace1_.caseValidationNTM as caseVali3_66_1_, workspace1_.caseValidationTB as caseVali4_66_1_, workspace1_.confirmedCaseNumber as confirme5_66_1_, workspace1_.customId as customId6_66_1_, workspace1_.maxStockOnHand as maxStock7_66_1_, workspace1_.minStockOnHand as minStock8_66_1_, workspace1_.monthsToAlertExpiredMedicines as monthsTo9_66_1_, workspace1_.name as name10_66_1_, workspace1_.patientAddrRequiredLevels as patient11_66_1_, workspace1_.patientNameComposition as patient12_66_1_, workspace1_.sendSystemMessages as sendSys13_66_1_, workspace1_.suspectCaseNumber as suspect14_66_1_, workspace1_.treatMonitoringInput as treatMo15_66_1_, workspace1_.weekFreq1 as weekFre16_66_1_, workspace1_.weekFreq2 as weekFre17_66_1_, workspace1_.weekFreq3 as weekFre18_66_1_, workspace1_.weekFreq4 as weekFre19_66_1_, workspace1_.weekFreq5 as weekFre20_66_1_, workspace1_.weekFreq6 as weekFre21_66_1_, workspace1_.weekFreq7 as weekFre22_66_1_ from workspaceview workspacev0_ left outer join workspace workspace1_ on workspacev0_.id=workspace1_.id where workspacev0_.id=?
Hibernate: update source set WORKSPACE_ID=?, active=?, customId=?, name=?, shortName=? where id=?
Hibernate: select count(*) as col_0_0_ from source source0_ where source0_.WORKSPACE_ID=? and source0_.name=? and source0_.id<>?
Hibernate: select count(*) as col_0_0_ from source source0_ where source0_.WORKSPACE_ID=? and source0_.shortName=? and source0_.id<>?
Hibernate: select userlog0_.id as id1_60_0_, userlog0_.name as name2_60_0_ from userlog userlog0_ where userlog0_.id=?
Hibernate: select workspacel0_.id as id1_67_0_, workspacel0_.name as name2_67_0_ from workspacelog workspacel0_ where workspacel0_.id=?
Hibernate: select unit0_.id as id2_59_0_, unit0_.WORKSPACE_ID as WORKSPA26_59_0_, unit0_.active as active3_59_0_, unit0_.ADDRESS as ADDRESS4_59_0_, unit0_.ADMINUNIT_ID as ADMINUN27_59_0_, unit0_.addressCompl as addressC5_59_0_, unit0_.zipcode as zipcode6_59_0_, unit0_.AUTHORIZERUNIT_ID as AUTHORI28_59_0_, unit0_.customId as customId7_59_0_, unit0_.inventoryCloseDate as inventor8_59_0_, unit0_.inventoryStartDate as inventor9_59_0_, unit0_.name as name10_59_0_, unit0_.receiveFromManufacturer as receive11_59_0_, unit0_.shipAddress as shipAdd12_59_0_, unit0_.SHIP_ADMINUNIT_ID as SHIP_AD29_59_0_, unit0_.shipAddressCompl as shipAdd13_59_0_, unit0_.shipZipCode as shipZip14_59_0_, unit0_.shipContactName as shipCon15_59_0_, unit0_.shipContactPhone as shipCon16_59_0_, unit0_.SUPPLIER_ID as SUPPLIE30_59_0_, unit0_.performCulture as perform17_59_0_, unit0_.performDst as perform18_59_0_, unit0_.performMicroscopy as perform19_59_0_, unit0_.performXpert as perform20_59_0_, unit0_.drtbFacility as drtbFac21_59_0_, unit0_.notificationUnit as notific22_59_0_, unit0_.ntmFacility as ntmFaci23_59_0_, unit0_.numDaysOrder as numDays24_59_0_, unit0_.tbFacility as tbFacil25_59_0_, unit0_.DISCRIMINATOR as DISCRIMI1_59_0_ from unit unit0_ where unit0_.id=?
Hibernate: insert into commandhistory (action, data, entityId, entityName, execDate, parentId, type, UNIT_ID, USERLOG_ID, WORKSPACELOG_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: select source0_.id as id1_45_0_, source0_.WORKSPACE_ID as WORKSPAC6_45_0_, source0_.active as active2_45_0_, source0_.customId as customId3_45_0_, source0_.name as name4_45_0_, source0_.shortName as shortNam5_45_0_ from source source0_ where source0_.id=?
Hibernate: select source0_.id as id1_45_0_, source0_.WORKSPACE_ID as WORKSPAC6_45_0_, source0_.active as active2_45_0_, source0_.customId as customId3_45_0_, source0_.name as name4_45_0_, source0_.shortName as shortNam5_45_0_ from source source0_ where source0_.id=?
Hibernate: select workspace0_.id as id1_66_0_, workspace0_.caseValidationDRTB as caseVali2_66_0_, workspace0_.caseValidationNTM as caseVali3_66_0_, workspace0_.caseValidationTB as caseVali4_66_0_, workspace0_.confirmedCaseNumber as confirme5_66_0_, workspace0_.customId as customId6_66_0_, workspace0_.maxStockOnHand as maxStock7_66_0_, workspace0_.minStockOnHand as minStock8_66_0_, workspace0_.monthsToAlertExpiredMedicines as monthsTo9_66_0_, workspace0_.name as name10_66_0_, workspace0_.patientAddrRequiredLevels as patient11_66_0_, workspace0_.patientNameComposition as patient12_66_0_, workspace0_.sendSystemMessages as sendSys13_66_0_, workspace0_.suspectCaseNumber as suspect14_66_0_, workspace0_.treatMonitoringInput as treatMo15_66_0_, workspace0_.weekFreq1 as weekFre16_66_0_, workspace0_.weekFreq2 as weekFre17_66_0_, workspace0_.weekFreq3 as weekFre18_66_0_, workspace0_.weekFreq4 as weekFre19_66_0_, workspace0_.weekFreq5 as weekFre20_66_0_, workspace0_.weekFreq6 as weekFre21_66_0_, workspace0_.weekFreq7 as weekFre22_66_0_ from workspace workspace0_ where workspace0_.id=?
Hibernate: select workspacev0_.id as id1_68_0_, workspacev0_.logoImage as logoImag2_68_0_, workspacev0_.picture as picture3_68_0_, workspacev0_.pictureContentType as pictureC4_68_0_, workspace1_.id as id1_66_1_, workspace1_.caseValidationDRTB as caseVali2_66_1_, workspace1_.caseValidationNTM as caseVali3_66_1_, workspace1_.caseValidationTB as caseVali4_66_1_, workspace1_.confirmedCaseNumber as confirme5_66_1_, workspace1_.customId as customId6_66_1_, workspace1_.maxStockOnHand as maxStock7_66_1_, workspace1_.minStockOnHand as minStock8_66_1_, workspace1_.monthsToAlertExpiredMedicines as monthsTo9_66_1_, workspace1_.name as name10_66_1_, workspace1_.patientAddrRequiredLevels as patient11_66_1_, workspace1_.patientNameComposition as patient12_66_1_, workspace1_.sendSystemMessages as sendSys13_66_1_, workspace1_.suspectCaseNumber as suspect14_66_1_, workspace1_.treatMonitoringInput as treatMo15_66_1_, workspace1_.weekFreq1 as weekFre16_66_1_, workspace1_.weekFreq2 as weekFre17_66_1_, workspace1_.weekFreq3 as weekFre18_66_1_, workspace1_.weekFreq4 as weekFre19_66_1_, workspace1_.weekFreq5 as weekFre20_66_1_, workspace1_.weekFreq6 as weekFre21_66_1_, workspace1_.weekFreq7 as weekFre22_66_1_ from workspaceview workspacev0_ left outer join workspace workspace1_ on workspacev0_.id=workspace1_.id where workspacev0_.id=?
Hibernate: delete from source where id=?
Hibernate: select userlog0_.id as id1_60_0_, userlog0_.name as name2_60_0_ from userlog userlog0_ where userlog0_.id=?
Hibernate: select workspacel0_.id as id1_67_0_, workspacel0_.name as name2_67_0_ from workspacelog workspacel0_ where workspacel0_.id=?
Hibernate: select unit0_.id as id2_59_0_, unit0_.WORKSPACE_ID as WORKSPA26_59_0_, unit0_.active as active3_59_0_, unit0_.ADDRESS as ADDRESS4_59_0_, unit0_.ADMINUNIT_ID as ADMINUN27_59_0_, unit0_.addressCompl as addressC5_59_0_, unit0_.zipcode as zipcode6_59_0_, unit0_.AUTHORIZERUNIT_ID as AUTHORI28_59_0_, unit0_.customId as customId7_59_0_, unit0_.inventoryCloseDate as inventor8_59_0_, unit0_.inventoryStartDate as inventor9_59_0_, unit0_.name as name10_59_0_, unit0_.receiveFromManufacturer as receive11_59_0_, unit0_.shipAddress as shipAdd12_59_0_, unit0_.SHIP_ADMINUNIT_ID as SHIP_AD29_59_0_, unit0_.shipAddressCompl as shipAdd13_59_0_, unit0_.shipZipCode as shipZip14_59_0_, unit0_.shipContactName as shipCon15_59_0_, unit0_.shipContactPhone as shipCon16_59_0_, unit0_.SUPPLIER_ID as SUPPLIE30_59_0_, unit0_.performCulture as perform17_59_0_, unit0_.performDst as perform18_59_0_, unit0_.performMicroscopy as perform19_59_0_, unit0_.performXpert as perform20_59_0_, unit0_.drtbFacility as drtbFac21_59_0_, unit0_.notificationUnit as notific22_59_0_, unit0_.ntmFacility as ntmFaci23_59_0_, unit0_.numDaysOrder as numDays24_59_0_, unit0_.tbFacility as tbFacil25_59_0_, unit0_.DISCRIMINATOR as DISCRIMI1_59_0_ from unit unit0_ where unit0_.id=?
Hibernate: insert into commandhistory (action, data, entityId, entityName, execDate, parentId, type, UNIT_ID, USERLOG_ID, WORKSPACELOG_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: select source0_.id as id1_45_0_, source0_.WORKSPACE_ID as WORKSPAC6_45_0_, source0_.active as active2_45_0_, source0_.customId as customId3_45_0_, source0_.name as name4_45_0_, source0_.shortName as shortNam5_45_0_ from source source0_ where source0_.id=?
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.093 sec - in org.msh.etbm.test.services.admin.SourceTest
Running org.msh.etbm.test.services.admin.SubstanceTest
2016-05-26 22:06:30.553 INFO 6940 --- [ main] o.s.t.c.support.AbstractContextLoader : Could not detect default resource locations for test class [org.msh.etbm.test.AuthenticatedTest]: no resource found for suffixes {-context.xml, Context.groovy}.
2016-05-26 22:06:30.553 INFO 6940 --- [ main] o.s.t.c.web.WebTestContextBootstrapper : Loaded default TestExecutionListener class names from location [META-INF/spring.factories]: [org.springframework.test.context.web.ServletTestExecutionListener, org.springframework.test.context.support.DirtiesContextBeforeModesTestExecutionListener, org.springframework.test.context.support.DependencyInjectionTestExecutionListener, org.springframework.test.context.support.DirtiesContextTestExecutionListener, org.springframework.test.context.transaction.TransactionalTestExecutionListener, org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener]
2016-05-26 22:06:30.553 INFO 6940 --- [ main] o.s.t.c.web.WebTestContextBootstrapper : Using TestExecutionListeners: [org.springframework.test.context.web.ServletTestExecutionListener@dc1cfde, org.springframework.test.context.support.DirtiesContextBeforeModesTestExecutionListener@2ae84b49, org.springframework.test.context.support.DependencyInjectionTestExecutionListener@65fd3ebe, org.springframework.test.context.support.DirtiesContextTestExecutionListener@63cf0da6, org.springframework.test.context.transaction.TransactionalTestExecutionListener@60f3813e, org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener@8292c6a]
Hibernate: select user0_.id as id1_48_, user0_.comments as comments2_48_, user0_.customId as customId3_48_, user0_.DEFAULTWORKSPACE_ID as DEFAULT14_48_, user0_.email as email4_48_, user0_.login as login5_48_, user0_.name as name6_48_, user0_.PARENTUSER_ID as PARENTU15_48_, user0_.password as password7_48_, user0_.pwdChangeRequest as pwdChang8_48_, user0_.registrationDate as registra9_48_, user0_.sendSystemMessages as sendSys10_48_, user0_.state as state11_48_, user0_.timeZone as timeZon12_48_, user0_.ulaAccepted as ulaAcce13_48_ from sys_user user0_ where user0_.login=? and upper(user0_.password)=? and user0_.state<>?
Hibernate: select userworksp0_.id as id1_64_, userworksp0_.WORKSPACE_ID as WORKSPAC5_64_, userworksp0_.ADMINUNIT_ID as ADMINUNI6_64_, userworksp0_.administrator as administ2_64_, userworksp0_.playOtherUnits as playOthe3_64_, userworksp0_.UNIT_ID as UNIT_ID7_64_, userworksp0_.USER_ID as USER_ID8_64_, userworksp0_.USER_VIEW as USER_VIE4_64_ from userworkspace userworksp0_ where userworksp0_.id=(select min(userworksp1_.id) from userworkspace userworksp1_ where userworksp1_.USER_ID=?) limit ?
Hibernate: insert into userlogin (Application, IpAddress, lastAccess, loginDate, logoutDate, USER_ID, WORKSPACE_ID, id) values (?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: select workspace0_.id as id1_66_0_, workspace0_.caseValidationDRTB as caseVali2_66_0_, workspace0_.caseValidationNTM as caseVali3_66_0_, workspace0_.caseValidationTB as caseVali4_66_0_, workspace0_.confirmedCaseNumber as confirme5_66_0_, workspace0_.customId as customId6_66_0_, workspace0_.maxStockOnHand as maxStock7_66_0_, workspace0_.minStockOnHand as minStock8_66_0_, workspace0_.monthsToAlertExpiredMedicines as monthsTo9_66_0_, workspace0_.name as name10_66_0_, workspace0_.patientAddrRequiredLevels as patient11_66_0_, workspace0_.patientNameComposition as patient12_66_0_, workspace0_.sendSystemMessages as sendSys13_66_0_, workspace0_.suspectCaseNumber as suspect14_66_0_, workspace0_.treatMonitoringInput as treatMo15_66_0_, workspace0_.weekFreq1 as weekFre16_66_0_, workspace0_.weekFreq2 as weekFre17_66_0_, workspace0_.weekFreq3 as weekFre18_66_0_, workspace0_.weekFreq4 as weekFre19_66_0_, workspace0_.weekFreq5 as weekFre20_66_0_, workspace0_.weekFreq6 as weekFre21_66_0_, workspace0_.weekFreq7 as weekFre22_66_0_ from workspace workspace0_ where workspace0_.id=?
Hibernate: select workspacev0_.id as id1_68_0_, workspacev0_.logoImage as logoImag2_68_0_, workspacev0_.picture as picture3_68_0_, workspacev0_.pictureContentType as pictureC4_68_0_, workspace1_.id as id1_66_1_, workspace1_.caseValidationDRTB as caseVali2_66_1_, workspace1_.caseValidationNTM as caseVali3_66_1_, workspace1_.caseValidationTB as caseVali4_66_1_, workspace1_.confirmedCaseNumber as confirme5_66_1_, workspace1_.customId as customId6_66_1_, workspace1_.maxStockOnHand as maxStock7_66_1_, workspace1_.minStockOnHand as minStock8_66_1_, workspace1_.monthsToAlertExpiredMedicines as monthsTo9_66_1_, workspace1_.name as name10_66_1_, workspace1_.patientAddrRequiredLevels as patient11_66_1_, workspace1_.patientNameComposition as patient12_66_1_, workspace1_.sendSystemMessages as sendSys13_66_1_, workspace1_.suspectCaseNumber as suspect14_66_1_, workspace1_.treatMonitoringInput as treatMo15_66_1_, workspace1_.weekFreq1 as weekFre16_66_1_, workspace1_.weekFreq2 as weekFre17_66_1_, workspace1_.weekFreq3 as weekFre18_66_1_, workspace1_.weekFreq4 as weekFre19_66_1_, workspace1_.weekFreq5 as weekFre20_66_1_, workspace1_.weekFreq6 as weekFre21_66_1_, workspace1_.weekFreq7 as weekFre22_66_1_ from workspaceview workspacev0_ left outer join workspace workspace1_ on workspacev0_.id=workspace1_.id where workspacev0_.id=?
Hibernate: select userworksp0_.id as id1_64_0_, user1_.id as id1_48_1_, workspace2_.id as id1_66_2_, userworksp0_.WORKSPACE_ID as WORKSPAC5_64_0_, userworksp0_.ADMINUNIT_ID as ADMINUNI6_64_0_, userworksp0_.administrator as administ2_64_0_, userworksp0_.playOtherUnits as playOthe3_64_0_, userworksp0_.UNIT_ID as UNIT_ID7_64_0_, userworksp0_.USER_ID as USER_ID8_64_0_, userworksp0_.USER_VIEW as USER_VIE4_64_0_, user1_.comments as comments2_48_1_, user1_.customId as customId3_48_1_, user1_.DEFAULTWORKSPACE_ID as DEFAULT14_48_1_, user1_.email as email4_48_1_, user1_.login as login5_48_1_, user1_.name as name6_48_1_, user1_.PARENTUSER_ID as PARENTU15_48_1_, user1_.password as password7_48_1_, user1_.pwdChangeRequest as pwdChang8_48_1_, user1_.registrationDate as registra9_48_1_, user1_.sendSystemMessages as sendSys10_48_1_, user1_.state as state11_48_1_, user1_.timeZone as timeZon12_48_1_, user1_.ulaAccepted as ulaAcce13_48_1_, workspace2_.caseValidationDRTB as caseVali2_66_2_, workspace2_.caseValidationNTM as caseVali3_66_2_, workspace2_.caseValidationTB as caseVali4_66_2_, workspace2_.confirmedCaseNumber as confirme5_66_2_, workspace2_.customId as customId6_66_2_, workspace2_.maxStockOnHand as maxStock7_66_2_, workspace2_.minStockOnHand as minStock8_66_2_, workspace2_.monthsToAlertExpiredMedicines as monthsTo9_66_2_, workspace2_.name as name10_66_2_, workspace2_.patientAddrRequiredLevels as patient11_66_2_, workspace2_.patientNameComposition as patient12_66_2_, workspace2_.sendSystemMessages as sendSys13_66_2_, workspace2_.suspectCaseNumber as suspect14_66_2_, workspace2_.treatMonitoringInput as treatMo15_66_2_, workspace2_.weekFreq1 as weekFre16_66_2_, workspace2_.weekFreq2 as weekFre17_66_2_, workspace2_.weekFreq3 as weekFre18_66_2_, workspace2_.weekFreq4 as weekFre19_66_2_, workspace2_.weekFreq5 as weekFre20_66_2_, workspace2_.weekFreq6 as weekFre21_66_2_, workspace2_.weekFreq7 as weekFre22_66_2_ from userworkspace userworksp0_ inner join sys_user user1_ on userworksp0_.USER_ID=user1_.id inner join workspace workspace2_ on userworksp0_.WORKSPACE_ID=workspace2_.id where userworksp0_.USER_ID=? and userworksp0_.WORKSPACE_ID=?
Hibernate: select unit0_.id as id2_59_0_, unit0_.WORKSPACE_ID as WORKSPA26_59_0_, unit0_.active as active3_59_0_, unit0_.ADDRESS as ADDRESS4_59_0_, unit0_.ADMINUNIT_ID as ADMINUN27_59_0_, unit0_.addressCompl as addressC5_59_0_, unit0_.zipcode as zipcode6_59_0_, unit0_.AUTHORIZERUNIT_ID as AUTHORI28_59_0_, unit0_.customId as customId7_59_0_, unit0_.inventoryCloseDate as inventor8_59_0_, unit0_.inventoryStartDate as inventor9_59_0_, unit0_.name as name10_59_0_, unit0_.receiveFromManufacturer as receive11_59_0_, unit0_.shipAddress as shipAdd12_59_0_, unit0_.SHIP_ADMINUNIT_ID as SHIP_AD29_59_0_, unit0_.shipAddressCompl as shipAdd13_59_0_, unit0_.shipZipCode as shipZip14_59_0_, unit0_.shipContactName as shipCon15_59_0_, unit0_.shipContactPhone as shipCon16_59_0_, unit0_.SUPPLIER_ID as SUPPLIE30_59_0_, unit0_.performCulture as perform17_59_0_, unit0_.performDst as perform18_59_0_, unit0_.performMicroscopy as perform19_59_0_, unit0_.performXpert as perform20_59_0_, unit0_.drtbFacility as drtbFac21_59_0_, unit0_.notificationUnit as notific22_59_0_, unit0_.ntmFacility as ntmFaci23_59_0_, unit0_.numDaysOrder as numDays24_59_0_, unit0_.tbFacility as tbFacil25_59_0_, unit0_.DISCRIMINATOR as DISCRIMI1_59_0_ from unit unit0_ where unit0_.id=?
Hibernate: select administra0_.id as id1_0_0_, administra0_.WORKSPACE_ID as WORKSPAC6_0_0_, administra0_.code as code2_0_0_, administra0_.COUNTRYSTRUCTURE_ID as COUNTRYS7_0_0_, administra0_.customId as customId3_0_0_, administra0_.name as name4_0_0_, administra0_.PARENT_ID as PARENT_I8_0_0_, administra0_.unitsCount as unitsCou5_0_0_, administra1_.id as id1_0_1_, administra1_.WORKSPACE_ID as WORKSPAC6_0_1_, administra1_.code as code2_0_1_, administra1_.COUNTRYSTRUCTURE_ID as COUNTRYS7_0_1_, administra1_.customId as customId3_0_1_, administra1_.name as name4_0_1_, administra1_.PARENT_ID as PARENT_I8_0_1_, administra1_.unitsCount as unitsCou5_0_1_ from administrativeunit administra0_ left outer join administrativeunit administra1_ on administra0_.PARENT_ID=administra1_.id where administra0_.id=?
Hibernate: select administra0_.id as col_0_0_, administra0_.name as col_1_0_, administra1_.id as col_2_0_, administra1_.name as col_3_0_, administra2_.id as col_4_0_, administra2_.name as col_5_0_, administra3_.id as col_6_0_, administra3_.name as col_7_0_, administra4_.id as col_8_0_, administra4_.name as col_9_0_ from administrativeunit administra0_ left outer join administrativeunit administra1_ on administra0_.PARENT_ID=administra1_.id left outer join administrativeunit administra2_ on administra1_.PARENT_ID=administra2_.id left outer join administrativeunit administra3_ on administra2_.PARENT_ID=administra3_.id left outer join administrativeunit administra4_ on administra3_.PARENT_ID=administra4_.id where administra0_.id=?
2016-05-26 22:06:30.569 INFO 6940 --- [ main] org.msh.etbm.test.TestSetup : User admin authenticated
Hibernate: select workspace0_.id as id1_66_0_, workspace0_.caseValidationDRTB as caseVali2_66_0_, workspace0_.caseValidationNTM as caseVali3_66_0_, workspace0_.caseValidationTB as caseVali4_66_0_, workspace0_.confirmedCaseNumber as confirme5_66_0_, workspace0_.customId as customId6_66_0_, workspace0_.maxStockOnHand as maxStock7_66_0_, workspace0_.minStockOnHand as minStock8_66_0_, workspace0_.monthsToAlertExpiredMedicines as monthsTo9_66_0_, workspace0_.name as name10_66_0_, workspace0_.patientAddrRequiredLevels as patient11_66_0_, workspace0_.patientNameComposition as patient12_66_0_, workspace0_.sendSystemMessages as sendSys13_66_0_, workspace0_.suspectCaseNumber as suspect14_66_0_, workspace0_.treatMonitoringInput as treatMo15_66_0_, workspace0_.weekFreq1 as weekFre16_66_0_, workspace0_.weekFreq2 as weekFre17_66_0_, workspace0_.weekFreq3 as weekFre18_66_0_, workspace0_.weekFreq4 as weekFre19_66_0_, workspace0_.weekFreq5 as weekFre20_66_0_, workspace0_.weekFreq6 as weekFre21_66_0_, workspace0_.weekFreq7 as weekFre22_66_0_ from workspace workspace0_ where workspace0_.id=?
Hibernate: select workspacev0_.id as id1_68_0_, workspacev0_.logoImage as logoImag2_68_0_, workspacev0_.picture as picture3_68_0_, workspacev0_.pictureContentType as pictureC4_68_0_, workspace1_.id as id1_66_1_, workspace1_.caseValidationDRTB as caseVali2_66_1_, workspace1_.caseValidationNTM as caseVali3_66_1_, workspace1_.caseValidationTB as caseVali4_66_1_, workspace1_.confirmedCaseNumber as confirme5_66_1_, workspace1_.customId as customId6_66_1_, workspace1_.maxStockOnHand as maxStock7_66_1_, workspace1_.minStockOnHand as minStock8_66_1_, workspace1_.monthsToAlertExpiredMedicines as monthsTo9_66_1_, workspace1_.name as name10_66_1_, workspace1_.patientAddrRequiredLevels as patient11_66_1_, workspace1_.patientNameComposition as patient12_66_1_, workspace1_.sendSystemMessages as sendSys13_66_1_, workspace1_.suspectCaseNumber as suspect14_66_1_, workspace1_.treatMonitoringInput as treatMo15_66_1_, workspace1_.weekFreq1 as weekFre16_66_1_, workspace1_.weekFreq2 as weekFre17_66_1_, workspace1_.weekFreq3 as weekFre18_66_1_, workspace1_.weekFreq4 as weekFre19_66_1_, workspace1_.weekFreq5 as weekFre20_66_1_, workspace1_.weekFreq6 as weekFre21_66_1_, workspace1_.weekFreq7 as weekFre22_66_1_ from workspaceview workspacev0_ left outer join workspace workspace1_ on workspacev0_.id=workspace1_.id where workspacev0_.id=?
Hibernate: select count(*) as col_0_0_ from substance substance0_ where substance0_.WORKSPACE_ID=? and substance0_.name=?
Hibernate: select count(*) as col_0_0_ from substance substance0_ where substance0_.WORKSPACE_ID=? and substance0_.shortName=?
Hibernate: insert into substance (WORKSPACE_ID, active, customId, displayOrder, dstResultForm, line, name, prevTreatmentForm, shortName, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: select userlog0_.id as id1_60_0_, userlog0_.name as name2_60_0_ from userlog userlog0_ where userlog0_.id=?
Hibernate: select workspacel0_.id as id1_67_0_, workspacel0_.name as name2_67_0_ from workspacelog workspacel0_ where workspacel0_.id=?
Hibernate: select unit0_.id as id2_59_0_, unit0_.WORKSPACE_ID as WORKSPA26_59_0_, unit0_.active as active3_59_0_, unit0_.ADDRESS as ADDRESS4_59_0_, unit0_.ADMINUNIT_ID as ADMINUN27_59_0_, unit0_.addressCompl as addressC5_59_0_, unit0_.zipcode as zipcode6_59_0_, unit0_.AUTHORIZERUNIT_ID as AUTHORI28_59_0_, unit0_.customId as customId7_59_0_, unit0_.inventoryCloseDate as inventor8_59_0_, unit0_.inventoryStartDate as inventor9_59_0_, unit0_.name as name10_59_0_, unit0_.receiveFromManufacturer as receive11_59_0_, unit0_.shipAddress as shipAdd12_59_0_, unit0_.SHIP_ADMINUNIT_ID as SHIP_AD29_59_0_, unit0_.shipAddressCompl as shipAdd13_59_0_, unit0_.shipZipCode as shipZip14_59_0_, unit0_.shipContactName as shipCon15_59_0_, unit0_.shipContactPhone as shipCon16_59_0_, unit0_.SUPPLIER_ID as SUPPLIE30_59_0_, unit0_.performCulture as perform17_59_0_, unit0_.performDst as perform18_59_0_, unit0_.performMicroscopy as perform19_59_0_, unit0_.performXpert as perform20_59_0_, unit0_.drtbFacility as drtbFac21_59_0_, unit0_.notificationUnit as notific22_59_0_, unit0_.ntmFacility as ntmFaci23_59_0_, unit0_.numDaysOrder as numDays24_59_0_, unit0_.tbFacility as tbFacil25_59_0_, unit0_.DISCRIMINATOR as DISCRIMI1_59_0_ from unit unit0_ where unit0_.id=?
Hibernate: insert into commandhistory (action, data, entityId, entityName, execDate, parentId, type, UNIT_ID, USERLOG_ID, WORKSPACELOG_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: select substance0_.id as id1_46_0_, substance0_.WORKSPACE_ID as WORKSPA10_46_0_, substance0_.active as active2_46_0_, substance0_.customId as customId3_46_0_, substance0_.displayOrder as displayO4_46_0_, substance0_.dstResultForm as dstResul5_46_0_, substance0_.line as line6_46_0_, substance0_.name as name7_46_0_, substance0_.prevTreatmentForm as prevTrea8_46_0_, substance0_.shortName as shortNam9_46_0_ from substance substance0_ where substance0_.id=?
Hibernate: select workspace0_.id as id1_66_0_, workspace0_.caseValidationDRTB as caseVali2_66_0_, workspace0_.caseValidationNTM as caseVali3_66_0_, workspace0_.caseValidationTB as caseVali4_66_0_, workspace0_.confirmedCaseNumber as confirme5_66_0_, workspace0_.customId as customId6_66_0_, workspace0_.maxStockOnHand as maxStock7_66_0_, workspace0_.minStockOnHand as minStock8_66_0_, workspace0_.monthsToAlertExpiredMedicines as monthsTo9_66_0_, workspace0_.name as name10_66_0_, workspace0_.patientAddrRequiredLevels as patient11_66_0_, workspace0_.patientNameComposition as patient12_66_0_, workspace0_.sendSystemMessages as sendSys13_66_0_, workspace0_.suspectCaseNumber as suspect14_66_0_, workspace0_.treatMonitoringInput as treatMo15_66_0_, workspace0_.weekFreq1 as weekFre16_66_0_, workspace0_.weekFreq2 as weekFre17_66_0_, workspace0_.weekFreq3 as weekFre18_66_0_, workspace0_.weekFreq4 as weekFre19_66_0_, workspace0_.weekFreq5 as weekFre20_66_0_, workspace0_.weekFreq6 as weekFre21_66_0_, workspace0_.weekFreq7 as weekFre22_66_0_ from workspace workspace0_ where workspace0_.id=?
Hibernate: select workspacev0_.id as id1_68_0_, workspacev0_.logoImage as logoImag2_68_0_, workspacev0_.picture as picture3_68_0_, workspacev0_.pictureContentType as pictureC4_68_0_, workspace1_.id as id1_66_1_, workspace1_.caseValidationDRTB as caseVali2_66_1_, workspace1_.caseValidationNTM as caseVali3_66_1_, workspace1_.caseValidationTB as caseVali4_66_1_, workspace1_.confirmedCaseNumber as confirme5_66_1_, workspace1_.customId as customId6_66_1_, workspace1_.maxStockOnHand as maxStock7_66_1_, workspace1_.minStockOnHand as minStock8_66_1_, workspace1_.monthsToAlertExpiredMedicines as monthsTo9_66_1_, workspace1_.name as name10_66_1_, workspace1_.patientAddrRequiredLevels as patient11_66_1_, workspace1_.patientNameComposition as patient12_66_1_, workspace1_.sendSystemMessages as sendSys13_66_1_, workspace1_.suspectCaseNumber as suspect14_66_1_, workspace1_.treatMonitoringInput as treatMo15_66_1_, workspace1_.weekFreq1 as weekFre16_66_1_, workspace1_.weekFreq2 as weekFre17_66_1_, workspace1_.weekFreq3 as weekFre18_66_1_, workspace1_.weekFreq4 as weekFre19_66_1_, workspace1_.weekFreq5 as weekFre20_66_1_, workspace1_.weekFreq6 as weekFre21_66_1_, workspace1_.weekFreq7 as weekFre22_66_1_ from workspaceview workspacev0_ left outer join workspace workspace1_ on workspacev0_.id=workspace1_.id where workspacev0_.id=?
Hibernate: select count(*) as col_0_0_ from substance substance0_ where substance0_.WORKSPACE_ID=? and substance0_.name=?
Hibernate: select count(*) as col_0_0_ from substance substance0_ where substance0_.WORKSPACE_ID=? and substance0_.shortName=?
Hibernate: select substance0_.id as id1_46_0_, substance0_.WORKSPACE_ID as WORKSPA10_46_0_, substance0_.active as active2_46_0_, substance0_.customId as customId3_46_0_, substance0_.displayOrder as displayO4_46_0_, substance0_.dstResultForm as dstResul5_46_0_, substance0_.line as line6_46_0_, substance0_.name as name7_46_0_, substance0_.prevTreatmentForm as prevTrea8_46_0_, substance0_.shortName as shortNam9_46_0_ from substance substance0_ where substance0_.id=?
Hibernate: select substance0_.id as id1_46_0_, substance0_.WORKSPACE_ID as WORKSPA10_46_0_, substance0_.active as active2_46_0_, substance0_.customId as customId3_46_0_, substance0_.displayOrder as displayO4_46_0_, substance0_.dstResultForm as dstResul5_46_0_, substance0_.line as line6_46_0_, substance0_.name as name7_46_0_, substance0_.prevTreatmentForm as prevTrea8_46_0_, substance0_.shortName as shortNam9_46_0_ from substance substance0_ where substance0_.id=?
Hibernate: select workspace0_.id as id1_66_0_, workspace0_.caseValidationDRTB as caseVali2_66_0_, workspace0_.caseValidationNTM as caseVali3_66_0_, workspace0_.caseValidationTB as caseVali4_66_0_, workspace0_.confirmedCaseNumber as confirme5_66_0_, workspace0_.customId as customId6_66_0_, workspace0_.maxStockOnHand as maxStock7_66_0_, workspace0_.minStockOnHand as minStock8_66_0_, workspace0_.monthsToAlertExpiredMedicines as monthsTo9_66_0_, workspace0_.name as name10_66_0_, workspace0_.patientAddrRequiredLevels as patient11_66_0_, workspace0_.patientNameComposition as patient12_66_0_, workspace0_.sendSystemMessages as sendSys13_66_0_, workspace0_.suspectCaseNumber as suspect14_66_0_, workspace0_.treatMonitoringInput as treatMo15_66_0_, workspace0_.weekFreq1 as weekFre16_66_0_, workspace0_.weekFreq2 as weekFre17_66_0_, workspace0_.weekFreq3 as weekFre18_66_0_, workspace0_.weekFreq4 as weekFre19_66_0_, workspace0_.weekFreq5 as weekFre20_66_0_, workspace0_.weekFreq6 as weekFre21_66_0_, workspace0_.weekFreq7 as weekFre22_66_0_ from workspace workspace0_ where workspace0_.id=?
Hibernate: select workspacev0_.id as id1_68_0_, workspacev0_.logoImage as logoImag2_68_0_, workspacev0_.picture as picture3_68_0_, workspacev0_.pictureContentType as pictureC4_68_0_, workspace1_.id as id1_66_1_, workspace1_.caseValidationDRTB as caseVali2_66_1_, workspace1_.caseValidationNTM as caseVali3_66_1_, workspace1_.caseValidationTB as caseVali4_66_1_, workspace1_.confirmedCaseNumber as confirme5_66_1_, workspace1_.customId as customId6_66_1_, workspace1_.maxStockOnHand as maxStock7_66_1_, workspace1_.minStockOnHand as minStock8_66_1_, workspace1_.monthsToAlertExpiredMedicines as monthsTo9_66_1_, workspace1_.name as name10_66_1_, workspace1_.patientAddrRequiredLevels as patient11_66_1_, workspace1_.patientNameComposition as patient12_66_1_, workspace1_.sendSystemMessages as sendSys13_66_1_, workspace1_.suspectCaseNumber as suspect14_66_1_, workspace1_.treatMonitoringInput as treatMo15_66_1_, workspace1_.weekFreq1 as weekFre16_66_1_, workspace1_.weekFreq2 as weekFre17_66_1_, workspace1_.weekFreq3 as weekFre18_66_1_, workspace1_.weekFreq4 as weekFre19_66_1_, workspace1_.weekFreq5 as weekFre20_66_1_, workspace1_.weekFreq6 as weekFre21_66_1_, workspace1_.weekFreq7 as weekFre22_66_1_ from workspaceview workspacev0_ left outer join workspace workspace1_ on workspacev0_.id=workspace1_.id where workspacev0_.id=?
Hibernate: update substance set WORKSPACE_ID=?, active=?, customId=?, displayOrder=?, dstResultForm=?, line=?, name=?, prevTreatmentForm=?, shortName=? where id=?
Hibernate: select count(*) as col_0_0_ from substance substance0_ where substance0_.WORKSPACE_ID=? and substance0_.name=? and substance0_.id<>?
Hibernate: select count(*) as col_0_0_ from substance substance0_ where substance0_.WORKSPACE_ID=? and substance0_.shortName=? and substance0_.id<>?
Hibernate: select userlog0_.id as id1_60_0_, userlog0_.name as name2_60_0_ from userlog userlog0_ where userlog0_.id=?
Hibernate: select workspacel0_.id as id1_67_0_, workspacel0_.name as name2_67_0_ from workspacelog workspacel0_ where workspacel0_.id=?
Hibernate: select unit0_.id as id2_59_0_, unit0_.WORKSPACE_ID as WORKSPA26_59_0_, unit0_.active as active3_59_0_, unit0_.ADDRESS as ADDRESS4_59_0_, unit0_.ADMINUNIT_ID as ADMINUN27_59_0_, unit0_.addressCompl as addressC5_59_0_, unit0_.zipcode as zipcode6_59_0_, unit0_.AUTHORIZERUNIT_ID as AUTHORI28_59_0_, unit0_.customId as customId7_59_0_, unit0_.inventoryCloseDate as inventor8_59_0_, unit0_.inventoryStartDate as inventor9_59_0_, unit0_.name as name10_59_0_, unit0_.receiveFromManufacturer as receive11_59_0_, unit0_.shipAddress as shipAdd12_59_0_, unit0_.SHIP_ADMINUNIT_ID as SHIP_AD29_59_0_, unit0_.shipAddressCompl as shipAdd13_59_0_, unit0_.shipZipCode as shipZip14_59_0_, unit0_.shipContactName as shipCon15_59_0_, unit0_.shipContactPhone as shipCon16_59_0_, unit0_.SUPPLIER_ID as SUPPLIE30_59_0_, unit0_.performCulture as perform17_59_0_, unit0_.performDst as perform18_59_0_, unit0_.performMicroscopy as perform19_59_0_, unit0_.performXpert as perform20_59_0_, unit0_.drtbFacility as drtbFac21_59_0_, unit0_.notificationUnit as notific22_59_0_, unit0_.ntmFacility as ntmFaci23_59_0_, unit0_.numDaysOrder as numDays24_59_0_, unit0_.tbFacility as tbFacil25_59_0_, unit0_.DISCRIMINATOR as DISCRIMI1_59_0_ from unit unit0_ where unit0_.id=?
Hibernate: insert into commandhistory (action, data, entityId, entityName, execDate, parentId, type, UNIT_ID, USERLOG_ID, WORKSPACELOG_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: select substance0_.id as id1_46_0_, substance0_.WORKSPACE_ID as WORKSPA10_46_0_, substance0_.active as active2_46_0_, substance0_.customId as customId3_46_0_, substance0_.displayOrder as displayO4_46_0_, substance0_.dstResultForm as dstResul5_46_0_, substance0_.line as line6_46_0_, substance0_.name as name7_46_0_, substance0_.prevTreatmentForm as prevTrea8_46_0_, substance0_.shortName as shortNam9_46_0_ from substance substance0_ where substance0_.id=?
Hibernate: select substance0_.id as id1_46_0_, substance0_.WORKSPACE_ID as WORKSPA10_46_0_, substance0_.active as active2_46_0_, substance0_.customId as customId3_46_0_, substance0_.displayOrder as displayO4_46_0_, substance0_.dstResultForm as dstResul5_46_0_, substance0_.line as line6_46_0_, substance0_.name as name7_46_0_, substance0_.prevTreatmentForm as prevTrea8_46_0_, substance0_.shortName as shortNam9_46_0_ from substance substance0_ where substance0_.id=?
Hibernate: select workspace0_.id as id1_66_0_, workspace0_.caseValidationDRTB as caseVali2_66_0_, workspace0_.caseValidationNTM as caseVali3_66_0_, workspace0_.caseValidationTB as caseVali4_66_0_, workspace0_.confirmedCaseNumber as confirme5_66_0_, workspace0_.customId as customId6_66_0_, workspace0_.maxStockOnHand as maxStock7_66_0_, workspace0_.minStockOnHand as minStock8_66_0_, workspace0_.monthsToAlertExpiredMedicines as monthsTo9_66_0_, workspace0_.name as name10_66_0_, workspace0_.patientAddrRequiredLevels as patient11_66_0_, workspace0_.patientNameComposition as patient12_66_0_, workspace0_.sendSystemMessages as sendSys13_66_0_, workspace0_.suspectCaseNumber as suspect14_66_0_, workspace0_.treatMonitoringInput as treatMo15_66_0_, workspace0_.weekFreq1 as weekFre16_66_0_, workspace0_.weekFreq2 as weekFre17_66_0_, workspace0_.weekFreq3 as weekFre18_66_0_, workspace0_.weekFreq4 as weekFre19_66_0_, workspace0_.weekFreq5 as weekFre20_66_0_, workspace0_.weekFreq6 as weekFre21_66_0_, workspace0_.weekFreq7 as weekFre22_66_0_ from workspace workspace0_ where workspace0_.id=?
Hibernate: select workspacev0_.id as id1_68_0_, workspacev0_.logoImage as logoImag2_68_0_, workspacev0_.picture as picture3_68_0_, workspacev0_.pictureContentType as pictureC4_68_0_, workspace1_.id as id1_66_1_, workspace1_.caseValidationDRTB as caseVali2_66_1_, workspace1_.caseValidationNTM as caseVali3_66_1_, workspace1_.caseValidationTB as caseVali4_66_1_, workspace1_.confirmedCaseNumber as confirme5_66_1_, workspace1_.customId as customId6_66_1_, workspace1_.maxStockOnHand as maxStock7_66_1_, workspace1_.minStockOnHand as minStock8_66_1_, workspace1_.monthsToAlertExpiredMedicines as monthsTo9_66_1_, workspace1_.name as name10_66_1_, workspace1_.patientAddrRequiredLevels as patient11_66_1_, workspace1_.patientNameComposition as patient12_66_1_, workspace1_.sendSystemMessages as sendSys13_66_1_, workspace1_.suspectCaseNumber as suspect14_66_1_, workspace1_.treatMonitoringInput as treatMo15_66_1_, workspace1_.weekFreq1 as weekFre16_66_1_, workspace1_.weekFreq2 as weekFre17_66_1_, workspace1_.weekFreq3 as weekFre18_66_1_, workspace1_.weekFreq4 as weekFre19_66_1_, workspace1_.weekFreq5 as weekFre20_66_1_, workspace1_.weekFreq6 as weekFre21_66_1_, workspace1_.weekFreq7 as weekFre22_66_1_ from workspaceview workspacev0_ left outer join workspace workspace1_ on workspacev0_.id=workspace1_.id where workspacev0_.id=?
Hibernate: delete from substance where id=?
Hibernate: select userlog0_.id as id1_60_0_, userlog0_.name as name2_60_0_ from userlog userlog0_ where userlog0_.id=?
Hibernate: select workspacel0_.id as id1_67_0_, workspacel0_.name as name2_67_0_ from workspacelog workspacel0_ where workspacel0_.id=?
Hibernate: select unit0_.id as id2_59_0_, unit0_.WORKSPACE_ID as WORKSPA26_59_0_, unit0_.active as active3_59_0_, unit0_.ADDRESS as ADDRESS4_59_0_, unit0_.ADMINUNIT_ID as ADMINUN27_59_0_, unit0_.addressCompl as addressC5_59_0_, unit0_.zipcode as zipcode6_59_0_, unit0_.AUTHORIZERUNIT_ID as AUTHORI28_59_0_, unit0_.customId as customId7_59_0_, unit0_.inventoryCloseDate as inventor8_59_0_, unit0_.inventoryStartDate as inventor9_59_0_, unit0_.name as name10_59_0_, unit0_.receiveFromManufacturer as receive11_59_0_, unit0_.shipAddress as shipAdd12_59_0_, unit0_.SHIP_ADMINUNIT_ID as SHIP_AD29_59_0_, unit0_.shipAddressCompl as shipAdd13_59_0_, unit0_.shipZipCode as shipZip14_59_0_, unit0_.shipContactName as shipCon15_59_0_, unit0_.shipContactPhone as shipCon16_59_0_, unit0_.SUPPLIER_ID as SUPPLIE30_59_0_, unit0_.performCulture as perform17_59_0_, unit0_.performDst as perform18_59_0_, unit0_.performMicroscopy as perform19_59_0_, unit0_.performXpert as perform20_59_0_, unit0_.drtbFacility as drtbFac21_59_0_, unit0_.notificationUnit as notific22_59_0_, unit0_.ntmFacility as ntmFaci23_59_0_, unit0_.numDaysOrder as numDays24_59_0_, unit0_.tbFacility as tbFacil25_59_0_, unit0_.DISCRIMINATOR as DISCRIMI1_59_0_ from unit unit0_ where unit0_.id=?
Hibernate: insert into commandhistory (action, data, entityId, entityName, execDate, parentId, type, UNIT_ID, USERLOG_ID, WORKSPACELOG_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: select substance0_.id as id1_46_0_, substance0_.WORKSPACE_ID as WORKSPA10_46_0_, substance0_.active as active2_46_0_, substance0_.customId as customId3_46_0_, substance0_.displayOrder as displayO4_46_0_, substance0_.dstResultForm as dstResul5_46_0_, substance0_.line as line6_46_0_, substance0_.name as name7_46_0_, substance0_.prevTreatmentForm as prevTrea8_46_0_, substance0_.shortName as shortNam9_46_0_ from substance substance0_ where substance0_.id=?
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.079 sec - in org.msh.etbm.test.services.admin.SubstanceTest
Running org.msh.etbm.test.services.admin.SysConfigTest
2016-05-26 22:06:30.632 INFO 6940 --- [ main] o.s.t.c.support.AbstractContextLoader : Could not detect default resource locations for test class [org.msh.etbm.test.AuthenticatedTest]: no resource found for suffixes {-context.xml, Context.groovy}.
2016-05-26 22:06:30.632 INFO 6940 --- [ main] o.s.t.c.web.WebTestContextBootstrapper : Loaded default TestExecutionListener class names from location [META-INF/spring.factories]: [org.springframework.test.context.web.ServletTestExecutionListener, org.springframework.test.context.support.DirtiesContextBeforeModesTestExecutionListener, org.springframework.test.context.support.DependencyInjectionTestExecutionListener, org.springframework.test.context.support.DirtiesContextTestExecutionListener, org.springframework.test.context.transaction.TransactionalTestExecutionListener, org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener]
2016-05-26 22:06:30.632 INFO 6940 --- [ main] o.s.t.c.web.WebTestContextBootstrapper : Using TestExecutionListeners: [org.springframework.test.context.web.ServletTestExecutionListener@112188cc, org.springframework.test.context.support.DirtiesContextBeforeModesTestExecutionListener@19ad99fa, org.springframework.test.context.support.DependencyInjectionTestExecutionListener@5331be15, org.springframework.test.context.support.DirtiesContextTestExecutionListener@32a53a59, org.springframework.test.context.transaction.TransactionalTestExecutionListener@2f5fb329, org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener@5ac88d71]
Hibernate: select user0_.id as id1_48_, user0_.comments as comments2_48_, user0_.customId as customId3_48_, user0_.DEFAULTWORKSPACE_ID as DEFAULT14_48_, user0_.email as email4_48_, user0_.login as login5_48_, user0_.name as name6_48_, user0_.PARENTUSER_ID as PARENTU15_48_, user0_.password as password7_48_, user0_.pwdChangeRequest as pwdChang8_48_, user0_.registrationDate as registra9_48_, user0_.sendSystemMessages as sendSys10_48_, user0_.state as state11_48_, user0_.timeZone as timeZon12_48_, user0_.ulaAccepted as ulaAcce13_48_ from sys_user user0_ where user0_.login=? and upper(user0_.password)=? and user0_.state<>?
Hibernate: select userworksp0_.id as id1_64_, userworksp0_.WORKSPACE_ID as WORKSPAC5_64_, userworksp0_.ADMINUNIT_ID as ADMINUNI6_64_, userworksp0_.administrator as administ2_64_, userworksp0_.playOtherUnits as playOthe3_64_, userworksp0_.UNIT_ID as UNIT_ID7_64_, userworksp0_.USER_ID as USER_ID8_64_, userworksp0_.USER_VIEW as USER_VIE4_64_ from userworkspace userworksp0_ where userworksp0_.id=(select min(userworksp1_.id) from userworkspace userworksp1_ where userworksp1_.USER_ID=?) limit ?
Hibernate: insert into userlogin (Application, IpAddress, lastAccess, loginDate, logoutDate, USER_ID, WORKSPACE_ID, id) values (?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: select workspace0_.id as id1_66_0_, workspace0_.caseValidationDRTB as caseVali2_66_0_, workspace0_.caseValidationNTM as caseVali3_66_0_, workspace0_.caseValidationTB as caseVali4_66_0_, workspace0_.confirmedCaseNumber as confirme5_66_0_, workspace0_.customId as customId6_66_0_, workspace0_.maxStockOnHand as maxStock7_66_0_, workspace0_.minStockOnHand as minStock8_66_0_, workspace0_.monthsToAlertExpiredMedicines as monthsTo9_66_0_, workspace0_.name as name10_66_0_, workspace0_.patientAddrRequiredLevels as patient11_66_0_, workspace0_.patientNameComposition as patient12_66_0_, workspace0_.sendSystemMessages as sendSys13_66_0_, workspace0_.suspectCaseNumber as suspect14_66_0_, workspace0_.treatMonitoringInput as treatMo15_66_0_, workspace0_.weekFreq1 as weekFre16_66_0_, workspace0_.weekFreq2 as weekFre17_66_0_, workspace0_.weekFreq3 as weekFre18_66_0_, workspace0_.weekFreq4 as weekFre19_66_0_, workspace0_.weekFreq5 as weekFre20_66_0_, workspace0_.weekFreq6 as weekFre21_66_0_, workspace0_.weekFreq7 as weekFre22_66_0_ from workspace workspace0_ where workspace0_.id=?
Hibernate: select workspacev0_.id as id1_68_0_, workspacev0_.logoImage as logoImag2_68_0_, workspacev0_.picture as picture3_68_0_, workspacev0_.pictureContentType as pictureC4_68_0_, workspace1_.id as id1_66_1_, workspace1_.caseValidationDRTB as caseVali2_66_1_, workspace1_.caseValidationNTM as caseVali3_66_1_, workspace1_.caseValidationTB as caseVali4_66_1_, workspace1_.confirmedCaseNumber as confirme5_66_1_, workspace1_.customId as customId6_66_1_, workspace1_.maxStockOnHand as maxStock7_66_1_, workspace1_.minStockOnHand as minStock8_66_1_, workspace1_.monthsToAlertExpiredMedicines as monthsTo9_66_1_, workspace1_.name as name10_66_1_, workspace1_.patientAddrRequiredLevels as patient11_66_1_, workspace1_.patientNameComposition as patient12_66_1_, workspace1_.sendSystemMessages as sendSys13_66_1_, workspace1_.suspectCaseNumber as suspect14_66_1_, workspace1_.treatMonitoringInput as treatMo15_66_1_, workspace1_.weekFreq1 as weekFre16_66_1_, workspace1_.weekFreq2 as weekFre17_66_1_, workspace1_.weekFreq3 as weekFre18_66_1_, workspace1_.weekFreq4 as weekFre19_66_1_, workspace1_.weekFreq5 as weekFre20_66_1_, workspace1_.weekFreq6 as weekFre21_66_1_, workspace1_.weekFreq7 as weekFre22_66_1_ from workspaceview workspacev0_ left outer join workspace workspace1_ on workspacev0_.id=workspace1_.id where workspacev0_.id=?
Hibernate: select userworksp0_.id as id1_64_0_, user1_.id as id1_48_1_, workspace2_.id as id1_66_2_, userworksp0_.WORKSPACE_ID as WORKSPAC5_64_0_, userworksp0_.ADMINUNIT_ID as ADMINUNI6_64_0_, userworksp0_.administrator as administ2_64_0_, userworksp0_.playOtherUnits as playOthe3_64_0_, userworksp0_.UNIT_ID as UNIT_ID7_64_0_, userworksp0_.USER_ID as USER_ID8_64_0_, userworksp0_.USER_VIEW as USER_VIE4_64_0_, user1_.comments as comments2_48_1_, user1_.customId as customId3_48_1_, user1_.DEFAULTWORKSPACE_ID as DEFAULT14_48_1_, user1_.email as email4_48_1_, user1_.login as login5_48_1_, user1_.name as name6_48_1_, user1_.PARENTUSER_ID as PARENTU15_48_1_, user1_.password as password7_48_1_, user1_.pwdChangeRequest as pwdChang8_48_1_, user1_.registrationDate as registra9_48_1_, user1_.sendSystemMessages as sendSys10_48_1_, user1_.state as state11_48_1_, user1_.timeZone as timeZon12_48_1_, user1_.ulaAccepted as ulaAcce13_48_1_, workspace2_.caseValidationDRTB as caseVali2_66_2_, workspace2_.caseValidationNTM as caseVali3_66_2_, workspace2_.caseValidationTB as caseVali4_66_2_, workspace2_.confirmedCaseNumber as confirme5_66_2_, workspace2_.customId as customId6_66_2_, workspace2_.maxStockOnHand as maxStock7_66_2_, workspace2_.minStockOnHand as minStock8_66_2_, workspace2_.monthsToAlertExpiredMedicines as monthsTo9_66_2_, workspace2_.name as name10_66_2_, workspace2_.patientAddrRequiredLevels as patient11_66_2_, workspace2_.patientNameComposition as patient12_66_2_, workspace2_.sendSystemMessages as sendSys13_66_2_, workspace2_.suspectCaseNumber as suspect14_66_2_, workspace2_.treatMonitoringInput as treatMo15_66_2_, workspace2_.weekFreq1 as weekFre16_66_2_, workspace2_.weekFreq2 as weekFre17_66_2_, workspace2_.weekFreq3 as weekFre18_66_2_, workspace2_.weekFreq4 as weekFre19_66_2_, workspace2_.weekFreq5 as weekFre20_66_2_, workspace2_.weekFreq6 as weekFre21_66_2_, workspace2_.weekFreq7 as weekFre22_66_2_ from userworkspace userworksp0_ inner join sys_user user1_ on userworksp0_.USER_ID=user1_.id inner join workspace workspace2_ on userworksp0_.WORKSPACE_ID=workspace2_.id where userworksp0_.USER_ID=? and userworksp0_.WORKSPACE_ID=?
Hibernate: select unit0_.id as id2_59_0_, unit0_.WORKSPACE_ID as WORKSPA26_59_0_, unit0_.active as active3_59_0_, unit0_.ADDRESS as ADDRESS4_59_0_, unit0_.ADMINUNIT_ID as ADMINUN27_59_0_, unit0_.addressCompl as addressC5_59_0_, unit0_.zipcode as zipcode6_59_0_, unit0_.AUTHORIZERUNIT_ID as AUTHORI28_59_0_, unit0_.customId as customId7_59_0_, unit0_.inventoryCloseDate as inventor8_59_0_, unit0_.inventoryStartDate as inventor9_59_0_, unit0_.name as name10_59_0_, unit0_.receiveFromManufacturer as receive11_59_0_, unit0_.shipAddress as shipAdd12_59_0_, unit0_.SHIP_ADMINUNIT_ID as SHIP_AD29_59_0_, unit0_.shipAddressCompl as shipAdd13_59_0_, unit0_.shipZipCode as shipZip14_59_0_, unit0_.shipContactName as shipCon15_59_0_, unit0_.shipContactPhone as shipCon16_59_0_, unit0_.SUPPLIER_ID as SUPPLIE30_59_0_, unit0_.performCulture as perform17_59_0_, unit0_.performDst as perform18_59_0_, unit0_.performMicroscopy as perform19_59_0_, unit0_.performXpert as perform20_59_0_, unit0_.drtbFacility as drtbFac21_59_0_, unit0_.notificationUnit as notific22_59_0_, unit0_.ntmFacility as ntmFaci23_59_0_, unit0_.numDaysOrder as numDays24_59_0_, unit0_.tbFacility as tbFacil25_59_0_, unit0_.DISCRIMINATOR as DISCRIMI1_59_0_ from unit unit0_ where unit0_.id=?
Hibernate: select administra0_.id as id1_0_0_, administra0_.WORKSPACE_ID as WORKSPAC6_0_0_, administra0_.code as code2_0_0_, administra0_.COUNTRYSTRUCTURE_ID as COUNTRYS7_0_0_, administra0_.customId as customId3_0_0_, administra0_.name as name4_0_0_, administra0_.PARENT_ID as PARENT_I8_0_0_, administra0_.unitsCount as unitsCou5_0_0_, administra1_.id as id1_0_1_, administra1_.WORKSPACE_ID as WORKSPAC6_0_1_, administra1_.code as code2_0_1_, administra1_.COUNTRYSTRUCTURE_ID as COUNTRYS7_0_1_, administra1_.customId as customId3_0_1_, administra1_.name as name4_0_1_, administra1_.PARENT_ID as PARENT_I8_0_1_, administra1_.unitsCount as unitsCou5_0_1_ from administrativeunit administra0_ left outer join administrativeunit administra1_ on administra0_.PARENT_ID=administra1_.id where administra0_.id=?
Hibernate: select administra0_.id as col_0_0_, administra0_.name as col_1_0_, administra1_.id as col_2_0_, administra1_.name as col_3_0_, administra2_.id as col_4_0_, administra2_.name as col_5_0_, administra3_.id as col_6_0_, administra3_.name as col_7_0_, administra4_.id as col_8_0_, administra4_.name as col_9_0_ from administrativeunit administra0_ left outer join administrativeunit administra1_ on administra0_.PARENT_ID=administra1_.id left outer join administrativeunit administra2_ on administra1_.PARENT_ID=administra2_.id left outer join administrativeunit administra3_ on administra2_.PARENT_ID=administra3_.id left outer join administrativeunit administra4_ on administra3_.PARENT_ID=administra4_.id where administra0_.id=?
2016-05-26 22:06:30.663 INFO 6940 --- [ main] org.msh.etbm.test.TestSetup : User admin authenticated
Hibernate: select systemconf0_.id as id1_49_0_, systemconf0_.adminMail as adminMai2_49_0_, systemconf0_.allowRegPage as allowReg3_49_0_, systemconf0_.pageRootURL as pageRoot4_49_0_, systemconf0_.PUBDS_WORKSPACE_ID as PUBDS_WO8_49_0_, systemconf0_.systemURL as systemUR5_49_0_, systemconf0_.ulaActive as ulaActiv6_49_0_, systemconf0_.UNIT_ID as UNIT_ID9_49_0_, systemconf0_.updateSite as updateSi7_49_0_, systemconf0_.USERPROFILE_ID as USERPRO10_49_0_, systemconf0_.WORKSPACE_ID as WORKSPA11_49_0_, workspace1_.id as id1_66_1_, workspace1_.caseValidationDRTB as caseVali2_66_1_, workspace1_.caseValidationNTM as caseVali3_66_1_, workspace1_.caseValidationTB as caseVali4_66_1_, workspace1_.confirmedCaseNumber as confirme5_66_1_, workspace1_.customId as customId6_66_1_, workspace1_.maxStockOnHand as maxStock7_66_1_, workspace1_.minStockOnHand as minStock8_66_1_, workspace1_.monthsToAlertExpiredMedicines as monthsTo9_66_1_, workspace1_.name as name10_66_1_, workspace1_.patientAddrRequiredLevels as patient11_66_1_, workspace1_.patientNameComposition as patient12_66_1_, workspace1_.sendSystemMessages as sendSys13_66_1_, workspace1_.suspectCaseNumber as suspect14_66_1_, workspace1_.treatMonitoringInput as treatMo15_66_1_, workspace1_.weekFreq1 as weekFre16_66_1_, workspace1_.weekFreq2 as weekFre17_66_1_, workspace1_.weekFreq3 as weekFre18_66_1_, workspace1_.weekFreq4 as weekFre19_66_1_, workspace1_.weekFreq5 as weekFre20_66_1_, workspace1_.weekFreq6 as weekFre21_66_1_, workspace1_.weekFreq7 as weekFre22_66_1_, unit2_.id as id2_59_2_, unit2_.WORKSPACE_ID as WORKSPA26_59_2_, unit2_.active as active3_59_2_, unit2_.ADDRESS as ADDRESS4_59_2_, unit2_.ADMINUNIT_ID as ADMINUN27_59_2_, unit2_.addressCompl as addressC5_59_2_, unit2_.zipcode as zipcode6_59_2_, unit2_.AUTHORIZERUNIT_ID as AUTHORI28_59_2_, unit2_.customId as customId7_59_2_, unit2_.inventoryCloseDate as inventor8_59_2_, unit2_.inventoryStartDate as inventor9_59_2_, unit2_.name as name10_59_2_, unit2_.receiveFromManufacturer as receive11_59_2_, unit2_.shipAddress as shipAdd12_59_2_, unit2_.SHIP_ADMINUNIT_ID as SHIP_AD29_59_2_, unit2_.shipAddressCompl as shipAdd13_59_2_, unit2_.shipZipCode as shipZip14_59_2_, unit2_.shipContactName as shipCon15_59_2_, unit2_.shipContactPhone as shipCon16_59_2_, unit2_.SUPPLIER_ID as SUPPLIE30_59_2_, unit2_.performCulture as perform17_59_2_, unit2_.performDst as perform18_59_2_, unit2_.performMicroscopy as perform19_59_2_, unit2_.performXpert as perform20_59_2_, unit2_.drtbFacility as drtbFac21_59_2_, unit2_.notificationUnit as notific22_59_2_, unit2_.ntmFacility as ntmFaci23_59_2_, unit2_.numDaysOrder as numDays24_59_2_, unit2_.tbFacility as tbFacil25_59_2_, unit2_.DISCRIMINATOR as DISCRIMI1_59_2_, userprofil3_.id as id1_63_3_, userprofil3_.WORKSPACE_ID as WORKSPAC4_63_3_, userprofil3_.customId as customId2_63_3_, userprofil3_.name as name3_63_3_, workspace4_.id as id1_66_4_, workspace4_.caseValidationDRTB as caseVali2_66_4_, workspace4_.caseValidationNTM as caseVali3_66_4_, workspace4_.caseValidationTB as caseVali4_66_4_, workspace4_.confirmedCaseNumber as confirme5_66_4_, workspace4_.customId as customId6_66_4_, workspace4_.maxStockOnHand as maxStock7_66_4_, workspace4_.minStockOnHand as minStock8_66_4_, workspace4_.monthsToAlertExpiredMedicines as monthsTo9_66_4_, workspace4_.name as name10_66_4_, workspace4_.patientAddrRequiredLevels as patient11_66_4_, workspace4_.patientNameComposition as patient12_66_4_, workspace4_.sendSystemMessages as sendSys13_66_4_, workspace4_.suspectCaseNumber as suspect14_66_4_, workspace4_.treatMonitoringInput as treatMo15_66_4_, workspace4_.weekFreq1 as weekFre16_66_4_, workspace4_.weekFreq2 as weekFre17_66_4_, workspace4_.weekFreq3 as weekFre18_66_4_, workspace4_.weekFreq4 as weekFre19_66_4_, workspace4_.weekFreq5 as weekFre20_66_4_, workspace4_.weekFreq6 as weekFre21_66_4_, workspace4_.weekFreq7 as weekFre22_66_4_ from systemconfig systemconf0_ left outer join workspace workspace1_ on systemconf0_.PUBDS_WORKSPACE_ID=workspace1_.id left outer join unit unit2_ on systemconf0_.UNIT_ID=unit2_.id left outer join userprofile userprofil3_ on systemconf0_.USERPROFILE_ID=userprofil3_.id left outer join workspace workspace4_ on systemconf0_.WORKSPACE_ID=workspace4_.id where systemconf0_.id=?
Hibernate: select systemconf0_.id as id1_49_0_, systemconf0_.adminMail as adminMai2_49_0_, systemconf0_.allowRegPage as allowReg3_49_0_, systemconf0_.pageRootURL as pageRoot4_49_0_, systemconf0_.PUBDS_WORKSPACE_ID as PUBDS_WO8_49_0_, systemconf0_.systemURL as systemUR5_49_0_, systemconf0_.ulaActive as ulaActiv6_49_0_, systemconf0_.UNIT_ID as UNIT_ID9_49_0_, systemconf0_.updateSite as updateSi7_49_0_, systemconf0_.USERPROFILE_ID as USERPRO10_49_0_, systemconf0_.WORKSPACE_ID as WORKSPA11_49_0_, workspace1_.id as id1_66_1_, workspace1_.caseValidationDRTB as caseVali2_66_1_, workspace1_.caseValidationNTM as caseVali3_66_1_, workspace1_.caseValidationTB as caseVali4_66_1_, workspace1_.confirmedCaseNumber as confirme5_66_1_, workspace1_.customId as customId6_66_1_, workspace1_.maxStockOnHand as maxStock7_66_1_, workspace1_.minStockOnHand as minStock8_66_1_, workspace1_.monthsToAlertExpiredMedicines as monthsTo9_66_1_, workspace1_.name as name10_66_1_, workspace1_.patientAddrRequiredLevels as patient11_66_1_, workspace1_.patientNameComposition as patient12_66_1_, workspace1_.sendSystemMessages as sendSys13_66_1_, workspace1_.suspectCaseNumber as suspect14_66_1_, workspace1_.treatMonitoringInput as treatMo15_66_1_, workspace1_.weekFreq1 as weekFre16_66_1_, workspace1_.weekFreq2 as weekFre17_66_1_, workspace1_.weekFreq3 as weekFre18_66_1_, workspace1_.weekFreq4 as weekFre19_66_1_, workspace1_.weekFreq5 as weekFre20_66_1_, workspace1_.weekFreq6 as weekFre21_66_1_, workspace1_.weekFreq7 as weekFre22_66_1_, unit2_.id as id2_59_2_, unit2_.WORKSPACE_ID as WORKSPA26_59_2_, unit2_.active as active3_59_2_, unit2_.ADDRESS as ADDRESS4_59_2_, unit2_.ADMINUNIT_ID as ADMINUN27_59_2_, unit2_.addressCompl as addressC5_59_2_, unit2_.zipcode as zipcode6_59_2_, unit2_.AUTHORIZERUNIT_ID as AUTHORI28_59_2_, unit2_.customId as customId7_59_2_, unit2_.inventoryCloseDate as inventor8_59_2_, unit2_.inventoryStartDate as inventor9_59_2_, unit2_.name as name10_59_2_, unit2_.receiveFromManufacturer as receive11_59_2_, unit2_.shipAddress as shipAdd12_59_2_, unit2_.SHIP_ADMINUNIT_ID as SHIP_AD29_59_2_, unit2_.shipAddressCompl as shipAdd13_59_2_, unit2_.shipZipCode as shipZip14_59_2_, unit2_.shipContactName as shipCon15_59_2_, unit2_.shipContactPhone as shipCon16_59_2_, unit2_.SUPPLIER_ID as SUPPLIE30_59_2_, unit2_.performCulture as perform17_59_2_, unit2_.performDst as perform18_59_2_, unit2_.performMicroscopy as perform19_59_2_, unit2_.performXpert as perform20_59_2_, unit2_.drtbFacility as drtbFac21_59_2_, unit2_.notificationUnit as notific22_59_2_, unit2_.ntmFacility as ntmFaci23_59_2_, unit2_.numDaysOrder as numDays24_59_2_, unit2_.tbFacility as tbFacil25_59_2_, unit2_.DISCRIMINATOR as DISCRIMI1_59_2_, userprofil3_.id as id1_63_3_, userprofil3_.WORKSPACE_ID as WORKSPAC4_63_3_, userprofil3_.customId as customId2_63_3_, userprofil3_.name as name3_63_3_, workspace4_.id as id1_66_4_, workspace4_.caseValidationDRTB as caseVali2_66_4_, workspace4_.caseValidationNTM as caseVali3_66_4_, workspace4_.caseValidationTB as caseVali4_66_4_, workspace4_.confirmedCaseNumber as confirme5_66_4_, workspace4_.customId as customId6_66_4_, workspace4_.maxStockOnHand as maxStock7_66_4_, workspace4_.minStockOnHand as minStock8_66_4_, workspace4_.monthsToAlertExpiredMedicines as monthsTo9_66_4_, workspace4_.name as name10_66_4_, workspace4_.patientAddrRequiredLevels as patient11_66_4_, workspace4_.patientNameComposition as patient12_66_4_, workspace4_.sendSystemMessages as sendSys13_66_4_, workspace4_.suspectCaseNumber as suspect14_66_4_, workspace4_.treatMonitoringInput as treatMo15_66_4_, workspace4_.weekFreq1 as weekFre16_66_4_, workspace4_.weekFreq2 as weekFre17_66_4_, workspace4_.weekFreq3 as weekFre18_66_4_, workspace4_.weekFreq4 as weekFre19_66_4_, workspace4_.weekFreq5 as weekFre20_66_4_, workspace4_.weekFreq6 as weekFre21_66_4_, workspace4_.weekFreq7 as weekFre22_66_4_ from systemconfig systemconf0_ left outer join workspace workspace1_ on systemconf0_.PUBDS_WORKSPACE_ID=workspace1_.id left outer join unit unit2_ on systemconf0_.UNIT_ID=unit2_.id left outer join userprofile userprofil3_ on systemconf0_.USERPROFILE_ID=userprofil3_.id left outer join workspace workspace4_ on systemconf0_.WORKSPACE_ID=workspace4_.id where systemconf0_.id=?
Hibernate: update systemconfig set adminMail=?, allowRegPage=?, pageRootURL=?, PUBDS_WORKSPACE_ID=?, systemURL=?, ulaActive=?, UNIT_ID=?, updateSite=?, USERPROFILE_ID=?, WORKSPACE_ID=? where id=?
Hibernate: select systemconf0_.id as id1_49_0_, systemconf0_.adminMail as adminMai2_49_0_, systemconf0_.allowRegPage as allowReg3_49_0_, systemconf0_.pageRootURL as pageRoot4_49_0_, systemconf0_.PUBDS_WORKSPACE_ID as PUBDS_WO8_49_0_, systemconf0_.systemURL as systemUR5_49_0_, systemconf0_.ulaActive as ulaActiv6_49_0_, systemconf0_.UNIT_ID as UNIT_ID9_49_0_, systemconf0_.updateSite as updateSi7_49_0_, systemconf0_.USERPROFILE_ID as USERPRO10_49_0_, systemconf0_.WORKSPACE_ID as WORKSPA11_49_0_, workspace1_.id as id1_66_1_, workspace1_.caseValidationDRTB as caseVali2_66_1_, workspace1_.caseValidationNTM as caseVali3_66_1_, workspace1_.caseValidationTB as caseVali4_66_1_, workspace1_.confirmedCaseNumber as confirme5_66_1_, workspace1_.customId as customId6_66_1_, workspace1_.maxStockOnHand as maxStock7_66_1_, workspace1_.minStockOnHand as minStock8_66_1_, workspace1_.monthsToAlertExpiredMedicines as monthsTo9_66_1_, workspace1_.name as name10_66_1_, workspace1_.patientAddrRequiredLevels as patient11_66_1_, workspace1_.patientNameComposition as patient12_66_1_, workspace1_.sendSystemMessages as sendSys13_66_1_, workspace1_.suspectCaseNumber as suspect14_66_1_, workspace1_.treatMonitoringInput as treatMo15_66_1_, workspace1_.weekFreq1 as weekFre16_66_1_, workspace1_.weekFreq2 as weekFre17_66_1_, workspace1_.weekFreq3 as weekFre18_66_1_, workspace1_.weekFreq4 as weekFre19_66_1_, workspace1_.weekFreq5 as weekFre20_66_1_, workspace1_.weekFreq6 as weekFre21_66_1_, workspace1_.weekFreq7 as weekFre22_66_1_, unit2_.id as id2_59_2_, unit2_.WORKSPACE_ID as WORKSPA26_59_2_, unit2_.active as active3_59_2_, unit2_.ADDRESS as ADDRESS4_59_2_, unit2_.ADMINUNIT_ID as ADMINUN27_59_2_, unit2_.addressCompl as addressC5_59_2_, unit2_.zipcode as zipcode6_59_2_, unit2_.AUTHORIZERUNIT_ID as AUTHORI28_59_2_, unit2_.customId as customId7_59_2_, unit2_.inventoryCloseDate as inventor8_59_2_, unit2_.inventoryStartDate as inventor9_59_2_, unit2_.name as name10_59_2_, unit2_.receiveFromManufacturer as receive11_59_2_, unit2_.shipAddress as shipAdd12_59_2_, unit2_.SHIP_ADMINUNIT_ID as SHIP_AD29_59_2_, unit2_.shipAddressCompl as shipAdd13_59_2_, unit2_.shipZipCode as shipZip14_59_2_, unit2_.shipContactName as shipCon15_59_2_, unit2_.shipContactPhone as shipCon16_59_2_, unit2_.SUPPLIER_ID as SUPPLIE30_59_2_, unit2_.performCulture as perform17_59_2_, unit2_.performDst as perform18_59_2_, unit2_.performMicroscopy as perform19_59_2_, unit2_.performXpert as perform20_59_2_, unit2_.drtbFacility as drtbFac21_59_2_, unit2_.notificationUnit as notific22_59_2_, unit2_.ntmFacility as ntmFaci23_59_2_, unit2_.numDaysOrder as numDays24_59_2_, unit2_.tbFacility as tbFacil25_59_2_, unit2_.DISCRIMINATOR as DISCRIMI1_59_2_, userprofil3_.id as id1_63_3_, userprofil3_.WORKSPACE_ID as WORKSPAC4_63_3_, userprofil3_.customId as customId2_63_3_, userprofil3_.name as name3_63_3_, workspace4_.id as id1_66_4_, workspace4_.caseValidationDRTB as caseVali2_66_4_, workspace4_.caseValidationNTM as caseVali3_66_4_, workspace4_.caseValidationTB as caseVali4_66_4_, workspace4_.confirmedCaseNumber as confirme5_66_4_, workspace4_.customId as customId6_66_4_, workspace4_.maxStockOnHand as maxStock7_66_4_, workspace4_.minStockOnHand as minStock8_66_4_, workspace4_.monthsToAlertExpiredMedicines as monthsTo9_66_4_, workspace4_.name as name10_66_4_, workspace4_.patientAddrRequiredLevels as patient11_66_4_, workspace4_.patientNameComposition as patient12_66_4_, workspace4_.sendSystemMessages as sendSys13_66_4_, workspace4_.suspectCaseNumber as suspect14_66_4_, workspace4_.treatMonitoringInput as treatMo15_66_4_, workspace4_.weekFreq1 as weekFre16_66_4_, workspace4_.weekFreq2 as weekFre17_66_4_, workspace4_.weekFreq3 as weekFre18_66_4_, workspace4_.weekFreq4 as weekFre19_66_4_, workspace4_.weekFreq5 as weekFre20_66_4_, workspace4_.weekFreq6 as weekFre21_66_4_, workspace4_.weekFreq7 as weekFre22_66_4_ from systemconfig systemconf0_ left outer join workspace workspace1_ on systemconf0_.PUBDS_WORKSPACE_ID=workspace1_.id left outer join unit unit2_ on systemconf0_.UNIT_ID=unit2_.id left outer join userprofile userprofil3_ on systemconf0_.USERPROFILE_ID=userprofil3_.id left outer join workspace workspace4_ on systemconf0_.WORKSPACE_ID=workspace4_.id where systemconf0_.id=?
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.031 sec - in org.msh.etbm.test.services.admin.SysConfigTest
Running org.msh.etbm.test.services.admin.TagTest
2016-05-26 22:06:30.678 INFO 6940 --- [ main] o.s.t.c.support.AbstractContextLoader : Could not detect default resource locations for test class [org.msh.etbm.test.AuthenticatedTest]: no resource found for suffixes {-context.xml, Context.groovy}.
2016-05-26 22:06:30.678 INFO 6940 --- [ main] o.s.t.c.web.WebTestContextBootstrapper : Loaded default TestExecutionListener class names from location [META-INF/spring.factories]: [org.springframework.test.context.web.ServletTestExecutionListener, org.springframework.test.context.support.DirtiesContextBeforeModesTestExecutionListener, org.springframework.test.context.support.DependencyInjectionTestExecutionListener, org.springframework.test.context.support.DirtiesContextTestExecutionListener, org.springframework.test.context.transaction.TransactionalTestExecutionListener, org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener]
2016-05-26 22:06:30.678 INFO 6940 --- [ main] o.s.t.c.web.WebTestContextBootstrapper : Using TestExecutionListeners: [org.springframework.test.context.web.ServletTestExecutionListener@159c9c91, org.springframework.test.context.support.DirtiesContextBeforeModesTestExecutionListener@71e32098, org.springframework.test.context.support.DependencyInjectionTestExecutionListener@385d9880, org.springframework.test.context.support.DirtiesContextTestExecutionListener@497c267a, org.springframework.test.context.transaction.TransactionalTestExecutionListener@38f553d0, org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener@507a53b6]
Hibernate: select user0_.id as id1_48_, user0_.comments as comments2_48_, user0_.customId as customId3_48_, user0_.DEFAULTWORKSPACE_ID as DEFAULT14_48_, user0_.email as email4_48_, user0_.login as login5_48_, user0_.name as name6_48_, user0_.PARENTUSER_ID as PARENTU15_48_, user0_.password as password7_48_, user0_.pwdChangeRequest as pwdChang8_48_, user0_.registrationDate as registra9_48_, user0_.sendSystemMessages as sendSys10_48_, user0_.state as state11_48_, user0_.timeZone as timeZon12_48_, user0_.ulaAccepted as ulaAcce13_48_ from sys_user user0_ where user0_.login=? and upper(user0_.password)=? and user0_.state<>?
Hibernate: select userworksp0_.id as id1_64_, userworksp0_.WORKSPACE_ID as WORKSPAC5_64_, userworksp0_.ADMINUNIT_ID as ADMINUNI6_64_, userworksp0_.administrator as administ2_64_, userworksp0_.playOtherUnits as playOthe3_64_, userworksp0_.UNIT_ID as UNIT_ID7_64_, userworksp0_.USER_ID as USER_ID8_64_, userworksp0_.USER_VIEW as USER_VIE4_64_ from userworkspace userworksp0_ where userworksp0_.id=(select min(userworksp1_.id) from userworkspace userworksp1_ where userworksp1_.USER_ID=?) limit ?
Hibernate: insert into userlogin (Application, IpAddress, lastAccess, loginDate, logoutDate, USER_ID, WORKSPACE_ID, id) values (?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: select workspace0_.id as id1_66_0_, workspace0_.caseValidationDRTB as caseVali2_66_0_, workspace0_.caseValidationNTM as caseVali3_66_0_, workspace0_.caseValidationTB as caseVali4_66_0_, workspace0_.confirmedCaseNumber as confirme5_66_0_, workspace0_.customId as customId6_66_0_, workspace0_.maxStockOnHand as maxStock7_66_0_, workspace0_.minStockOnHand as minStock8_66_0_, workspace0_.monthsToAlertExpiredMedicines as monthsTo9_66_0_, workspace0_.name as name10_66_0_, workspace0_.patientAddrRequiredLevels as patient11_66_0_, workspace0_.patientNameComposition as patient12_66_0_, workspace0_.sendSystemMessages as sendSys13_66_0_, workspace0_.suspectCaseNumber as suspect14_66_0_, workspace0_.treatMonitoringInput as treatMo15_66_0_, workspace0_.weekFreq1 as weekFre16_66_0_, workspace0_.weekFreq2 as weekFre17_66_0_, workspace0_.weekFreq3 as weekFre18_66_0_, workspace0_.weekFreq4 as weekFre19_66_0_, workspace0_.weekFreq5 as weekFre20_66_0_, workspace0_.weekFreq6 as weekFre21_66_0_, workspace0_.weekFreq7 as weekFre22_66_0_ from workspace workspace0_ where workspace0_.id=?
Hibernate: select workspacev0_.id as id1_68_0_, workspacev0_.logoImage as logoImag2_68_0_, workspacev0_.picture as picture3_68_0_, workspacev0_.pictureContentType as pictureC4_68_0_, workspace1_.id as id1_66_1_, workspace1_.caseValidationDRTB as caseVali2_66_1_, workspace1_.caseValidationNTM as caseVali3_66_1_, workspace1_.caseValidationTB as caseVali4_66_1_, workspace1_.confirmedCaseNumber as confirme5_66_1_, workspace1_.customId as customId6_66_1_, workspace1_.maxStockOnHand as maxStock7_66_1_, workspace1_.minStockOnHand as minStock8_66_1_, workspace1_.monthsToAlertExpiredMedicines as monthsTo9_66_1_, workspace1_.name as name10_66_1_, workspace1_.patientAddrRequiredLevels as patient11_66_1_, workspace1_.patientNameComposition as patient12_66_1_, workspace1_.sendSystemMessages as sendSys13_66_1_, workspace1_.suspectCaseNumber as suspect14_66_1_, workspace1_.treatMonitoringInput as treatMo15_66_1_, workspace1_.weekFreq1 as weekFre16_66_1_, workspace1_.weekFreq2 as weekFre17_66_1_, workspace1_.weekFreq3 as weekFre18_66_1_, workspace1_.weekFreq4 as weekFre19_66_1_, workspace1_.weekFreq5 as weekFre20_66_1_, workspace1_.weekFreq6 as weekFre21_66_1_, workspace1_.weekFreq7 as weekFre22_66_1_ from workspaceview workspacev0_ left outer join workspace workspace1_ on workspacev0_.id=workspace1_.id where workspacev0_.id=?
Hibernate: select userworksp0_.id as id1_64_0_, user1_.id as id1_48_1_, workspace2_.id as id1_66_2_, userworksp0_.WORKSPACE_ID as WORKSPAC5_64_0_, userworksp0_.ADMINUNIT_ID as ADMINUNI6_64_0_, userworksp0_.administrator as administ2_64_0_, userworksp0_.playOtherUnits as playOthe3_64_0_, userworksp0_.UNIT_ID as UNIT_ID7_64_0_, userworksp0_.USER_ID as USER_ID8_64_0_, userworksp0_.USER_VIEW as USER_VIE4_64_0_, user1_.comments as comments2_48_1_, user1_.customId as customId3_48_1_, user1_.DEFAULTWORKSPACE_ID as DEFAULT14_48_1_, user1_.email as email4_48_1_, user1_.login as login5_48_1_, user1_.name as name6_48_1_, user1_.PARENTUSER_ID as PARENTU15_48_1_, user1_.password as password7_48_1_, user1_.pwdChangeRequest as pwdChang8_48_1_, user1_.registrationDate as registra9_48_1_, user1_.sendSystemMessages as sendSys10_48_1_, user1_.state as state11_48_1_, user1_.timeZone as timeZon12_48_1_, user1_.ulaAccepted as ulaAcce13_48_1_, workspace2_.caseValidationDRTB as caseVali2_66_2_, workspace2_.caseValidationNTM as caseVali3_66_2_, workspace2_.caseValidationTB as caseVali4_66_2_, workspace2_.confirmedCaseNumber as confirme5_66_2_, workspace2_.customId as customId6_66_2_, workspace2_.maxStockOnHand as maxStock7_66_2_, workspace2_.minStockOnHand as minStock8_66_2_, workspace2_.monthsToAlertExpiredMedicines as monthsTo9_66_2_, workspace2_.name as name10_66_2_, workspace2_.patientAddrRequiredLevels as patient11_66_2_, workspace2_.patientNameComposition as patient12_66_2_, workspace2_.sendSystemMessages as sendSys13_66_2_, workspace2_.suspectCaseNumber as suspect14_66_2_, workspace2_.treatMonitoringInput as treatMo15_66_2_, workspace2_.weekFreq1 as weekFre16_66_2_, workspace2_.weekFreq2 as weekFre17_66_2_, workspace2_.weekFreq3 as weekFre18_66_2_, workspace2_.weekFreq4 as weekFre19_66_2_, workspace2_.weekFreq5 as weekFre20_66_2_, workspace2_.weekFreq6 as weekFre21_66_2_, workspace2_.weekFreq7 as weekFre22_66_2_ from userworkspace userworksp0_ inner join sys_user user1_ on userworksp0_.USER_ID=user1_.id inner join workspace workspace2_ on userworksp0_.WORKSPACE_ID=workspace2_.id where userworksp0_.USER_ID=? and userworksp0_.WORKSPACE_ID=?
Hibernate: select unit0_.id as id2_59_0_, unit0_.WORKSPACE_ID as WORKSPA26_59_0_, unit0_.active as active3_59_0_, unit0_.ADDRESS as ADDRESS4_59_0_, unit0_.ADMINUNIT_ID as ADMINUN27_59_0_, unit0_.addressCompl as addressC5_59_0_, unit0_.zipcode as zipcode6_59_0_, unit0_.AUTHORIZERUNIT_ID as AUTHORI28_59_0_, unit0_.customId as customId7_59_0_, unit0_.inventoryCloseDate as inventor8_59_0_, unit0_.inventoryStartDate as inventor9_59_0_, unit0_.name as name10_59_0_, unit0_.receiveFromManufacturer as receive11_59_0_, unit0_.shipAddress as shipAdd12_59_0_, unit0_.SHIP_ADMINUNIT_ID as SHIP_AD29_59_0_, unit0_.shipAddressCompl as shipAdd13_59_0_, unit0_.shipZipCode as shipZip14_59_0_, unit0_.shipContactName as shipCon15_59_0_, unit0_.shipContactPhone as shipCon16_59_0_, unit0_.SUPPLIER_ID as SUPPLIE30_59_0_, unit0_.performCulture as perform17_59_0_, unit0_.performDst as perform18_59_0_, unit0_.performMicroscopy as perform19_59_0_, unit0_.performXpert as perform20_59_0_, unit0_.drtbFacility as drtbFac21_59_0_, unit0_.notificationUnit as notific22_59_0_, unit0_.ntmFacility as ntmFaci23_59_0_, unit0_.numDaysOrder as numDays24_59_0_, unit0_.tbFacility as tbFacil25_59_0_, unit0_.DISCRIMINATOR as DISCRIMI1_59_0_ from unit unit0_ where unit0_.id=?
Hibernate: select administra0_.id as id1_0_0_, administra0_.WORKSPACE_ID as WORKSPAC6_0_0_, administra0_.code as code2_0_0_, administra0_.COUNTRYSTRUCTURE_ID as COUNTRYS7_0_0_, administra0_.customId as customId3_0_0_, administra0_.name as name4_0_0_, administra0_.PARENT_ID as PARENT_I8_0_0_, administra0_.unitsCount as unitsCou5_0_0_, administra1_.id as id1_0_1_, administra1_.WORKSPACE_ID as WORKSPAC6_0_1_, administra1_.code as code2_0_1_, administra1_.COUNTRYSTRUCTURE_ID as COUNTRYS7_0_1_, administra1_.customId as customId3_0_1_, administra1_.name as name4_0_1_, administra1_.PARENT_ID as PARENT_I8_0_1_, administra1_.unitsCount as unitsCou5_0_1_ from administrativeunit administra0_ left outer join administrativeunit administra1_ on administra0_.PARENT_ID=administra1_.id where administra0_.id=?
Hibernate: select administra0_.id as col_0_0_, administra0_.name as col_1_0_, administra1_.id as col_2_0_, administra1_.name as col_3_0_, administra2_.id as col_4_0_, administra2_.name as col_5_0_, administra3_.id as col_6_0_, administra3_.name as col_7_0_, administra4_.id as col_8_0_, administra4_.name as col_9_0_ from administrativeunit administra0_ left outer join administrativeunit administra1_ on administra0_.PARENT_ID=administra1_.id left outer join administrativeunit administra2_ on administra1_.PARENT_ID=administra2_.id left outer join administrativeunit administra3_ on administra2_.PARENT_ID=administra3_.id left outer join administrativeunit administra4_ on administra3_.PARENT_ID=administra4_.id where administra0_.id=?
2016-05-26 22:06:30.694 INFO 6940 --- [ main] org.msh.etbm.test.TestSetup : User admin authenticated
Hibernate: select workspace0_.id as id1_66_0_, workspace0_.caseValidationDRTB as caseVali2_66_0_, workspace0_.caseValidationNTM as caseVali3_66_0_, workspace0_.caseValidationTB as caseVali4_66_0_, workspace0_.confirmedCaseNumber as confirme5_66_0_, workspace0_.customId as customId6_66_0_, workspace0_.maxStockOnHand as maxStock7_66_0_, workspace0_.minStockOnHand as minStock8_66_0_, workspace0_.monthsToAlertExpiredMedicines as monthsTo9_66_0_, workspace0_.name as name10_66_0_, workspace0_.patientAddrRequiredLevels as patient11_66_0_, workspace0_.patientNameComposition as patient12_66_0_, workspace0_.sendSystemMessages as sendSys13_66_0_, workspace0_.suspectCaseNumber as suspect14_66_0_, workspace0_.treatMonitoringInput as treatMo15_66_0_, workspace0_.weekFreq1 as weekFre16_66_0_, workspace0_.weekFreq2 as weekFre17_66_0_, workspace0_.weekFreq3 as weekFre18_66_0_, workspace0_.weekFreq4 as weekFre19_66_0_, workspace0_.weekFreq5 as weekFre20_66_0_, workspace0_.weekFreq6 as weekFre21_66_0_, workspace0_.weekFreq7 as weekFre22_66_0_ from workspace workspace0_ where workspace0_.id=?
Hibernate: select workspacev0_.id as id1_68_0_, workspacev0_.logoImage as logoImag2_68_0_, workspacev0_.picture as picture3_68_0_, workspacev0_.pictureContentType as pictureC4_68_0_, workspace1_.id as id1_66_1_, workspace1_.caseValidationDRTB as caseVali2_66_1_, workspace1_.caseValidationNTM as caseVali3_66_1_, workspace1_.caseValidationTB as caseVali4_66_1_, workspace1_.confirmedCaseNumber as confirme5_66_1_, workspace1_.customId as customId6_66_1_, workspace1_.maxStockOnHand as maxStock7_66_1_, workspace1_.minStockOnHand as minStock8_66_1_, workspace1_.monthsToAlertExpiredMedicines as monthsTo9_66_1_, workspace1_.name as name10_66_1_, workspace1_.patientAddrRequiredLevels as patient11_66_1_, workspace1_.patientNameComposition as patient12_66_1_, workspace1_.sendSystemMessages as sendSys13_66_1_, workspace1_.suspectCaseNumber as suspect14_66_1_, workspace1_.treatMonitoringInput as treatMo15_66_1_, workspace1_.weekFreq1 as weekFre16_66_1_, workspace1_.weekFreq2 as weekFre17_66_1_, workspace1_.weekFreq3 as weekFre18_66_1_, workspace1_.weekFreq4 as weekFre19_66_1_, workspace1_.weekFreq5 as weekFre20_66_1_, workspace1_.weekFreq6 as weekFre21_66_1_, workspace1_.weekFreq7 as weekFre22_66_1_ from workspaceview workspacev0_ left outer join workspace workspace1_ on workspacev0_.id=workspace1_.id where workspacev0_.id=?
Hibernate: select count(*) as col_0_0_ from tag tag0_ where tag0_.WORKSPACE_ID=? and tag0_.name=?
Hibernate: select count(*) from tbcase a inner join patient p on p.id=a.patient_id where a.state > 2
Hibernate: insert into tag (WORKSPACE_ID, active, consistencyCheck, dailyUpdate, name, sqlCondition, id) values (?, ?, ?, ?, ?, ?, ?)
Hibernate: delete from tags_case where tag_id = ?
Hibernate: insert into tags_case (case_id, tag_id) select a.id, 'c0a8fe74-54ef-1668-8154-eff683450044' from tbcase a join patient p on p.id=a.patient_id where a.state > 2 and p.workspace_id = ?
Hibernate: select userlog0_.id as id1_60_0_, userlog0_.name as name2_60_0_ from userlog userlog0_ where userlog0_.id=?
Hibernate: select workspacel0_.id as id1_67_0_, workspacel0_.name as name2_67_0_ from workspacelog workspacel0_ where workspacel0_.id=?
Hibernate: select unit0_.id as id2_59_0_, unit0_.WORKSPACE_ID as WORKSPA26_59_0_, unit0_.active as active3_59_0_, unit0_.ADDRESS as ADDRESS4_59_0_, unit0_.ADMINUNIT_ID as ADMINUN27_59_0_, unit0_.addressCompl as addressC5_59_0_, unit0_.zipcode as zipcode6_59_0_, unit0_.AUTHORIZERUNIT_ID as AUTHORI28_59_0_, unit0_.customId as customId7_59_0_, unit0_.inventoryCloseDate as inventor8_59_0_, unit0_.inventoryStartDate as inventor9_59_0_, unit0_.name as name10_59_0_, unit0_.receiveFromManufacturer as receive11_59_0_, unit0_.shipAddress as shipAdd12_59_0_, unit0_.SHIP_ADMINUNIT_ID as SHIP_AD29_59_0_, unit0_.shipAddressCompl as shipAdd13_59_0_, unit0_.shipZipCode as shipZip14_59_0_, unit0_.shipContactName as shipCon15_59_0_, unit0_.shipContactPhone as shipCon16_59_0_, unit0_.SUPPLIER_ID as SUPPLIE30_59_0_, unit0_.performCulture as perform17_59_0_, unit0_.performDst as perform18_59_0_, unit0_.performMicroscopy as perform19_59_0_, unit0_.performXpert as perform20_59_0_, unit0_.drtbFacility as drtbFac21_59_0_, unit0_.notificationUnit as notific22_59_0_, unit0_.ntmFacility as ntmFaci23_59_0_, unit0_.numDaysOrder as numDays24_59_0_, unit0_.tbFacility as tbFacil25_59_0_, unit0_.DISCRIMINATOR as DISCRIMI1_59_0_ from unit unit0_ where unit0_.id=?
Hibernate: insert into commandhistory (action, data, entityId, entityName, execDate, parentId, type, UNIT_ID, USERLOG_ID, WORKSPACELOG_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: select tag0_.id as id1_50_0_, tag0_.WORKSPACE_ID as WORKSPAC7_50_0_, tag0_.active as active2_50_0_, tag0_.consistencyCheck as consiste3_50_0_, tag0_.dailyUpdate as dailyUpd4_50_0_, tag0_.name as name5_50_0_, tag0_.sqlCondition as sqlCondi6_50_0_ from tag tag0_ where tag0_.id=?
Hibernate: select workspace0_.id as id1_66_0_, workspace0_.caseValidationDRTB as caseVali2_66_0_, workspace0_.caseValidationNTM as caseVali3_66_0_, workspace0_.caseValidationTB as caseVali4_66_0_, workspace0_.confirmedCaseNumber as confirme5_66_0_, workspace0_.customId as customId6_66_0_, workspace0_.maxStockOnHand as maxStock7_66_0_, workspace0_.minStockOnHand as minStock8_66_0_, workspace0_.monthsToAlertExpiredMedicines as monthsTo9_66_0_, workspace0_.name as name10_66_0_, workspace0_.patientAddrRequiredLevels as patient11_66_0_, workspace0_.patientNameComposition as patient12_66_0_, workspace0_.sendSystemMessages as sendSys13_66_0_, workspace0_.suspectCaseNumber as suspect14_66_0_, workspace0_.treatMonitoringInput as treatMo15_66_0_, workspace0_.weekFreq1 as weekFre16_66_0_, workspace0_.weekFreq2 as weekFre17_66_0_, workspace0_.weekFreq3 as weekFre18_66_0_, workspace0_.weekFreq4 as weekFre19_66_0_, workspace0_.weekFreq5 as weekFre20_66_0_, workspace0_.weekFreq6 as weekFre21_66_0_, workspace0_.weekFreq7 as weekFre22_66_0_ from workspace workspace0_ where workspace0_.id=?
Hibernate: select workspacev0_.id as id1_68_0_, workspacev0_.logoImage as logoImag2_68_0_, workspacev0_.picture as picture3_68_0_, workspacev0_.pictureContentType as pictureC4_68_0_, workspace1_.id as id1_66_1_, workspace1_.caseValidationDRTB as caseVali2_66_1_, workspace1_.caseValidationNTM as caseVali3_66_1_, workspace1_.caseValidationTB as caseVali4_66_1_, workspace1_.confirmedCaseNumber as confirme5_66_1_, workspace1_.customId as customId6_66_1_, workspace1_.maxStockOnHand as maxStock7_66_1_, workspace1_.minStockOnHand as minStock8_66_1_, workspace1_.monthsToAlertExpiredMedicines as monthsTo9_66_1_, workspace1_.name as name10_66_1_, workspace1_.patientAddrRequiredLevels as patient11_66_1_, workspace1_.patientNameComposition as patient12_66_1_, workspace1_.sendSystemMessages as sendSys13_66_1_, workspace1_.suspectCaseNumber as suspect14_66_1_, workspace1_.treatMonitoringInput as treatMo15_66_1_, workspace1_.weekFreq1 as weekFre16_66_1_, workspace1_.weekFreq2 as weekFre17_66_1_, workspace1_.weekFreq3 as weekFre18_66_1_, workspace1_.weekFreq4 as weekFre19_66_1_, workspace1_.weekFreq5 as weekFre20_66_1_, workspace1_.weekFreq6 as weekFre21_66_1_, workspace1_.weekFreq7 as weekFre22_66_1_ from workspaceview workspacev0_ left outer join workspace workspace1_ on workspacev0_.id=workspace1_.id where workspacev0_.id=?
Hibernate: select count(*) as col_0_0_ from tag tag0_ where tag0_.WORKSPACE_ID=? and tag0_.name=?
Hibernate: select count(*) from tbcase a inner join patient p on p.id=a.patient_id where a.state > 2
Hibernate: select tag0_.id as id1_50_0_, tag0_.WORKSPACE_ID as WORKSPAC7_50_0_, tag0_.active as active2_50_0_, tag0_.consistencyCheck as consiste3_50_0_, tag0_.dailyUpdate as dailyUpd4_50_0_, tag0_.name as name5_50_0_, tag0_.sqlCondition as sqlCondi6_50_0_ from tag tag0_ where tag0_.id=?
Hibernate: select tag0_.id as id1_50_0_, tag0_.WORKSPACE_ID as WORKSPAC7_50_0_, tag0_.active as active2_50_0_, tag0_.consistencyCheck as consiste3_50_0_, tag0_.dailyUpdate as dailyUpd4_50_0_, tag0_.name as name5_50_0_, tag0_.sqlCondition as sqlCondi6_50_0_ from tag tag0_ where tag0_.id=?
Hibernate: select workspace0_.id as id1_66_0_, workspace0_.caseValidationDRTB as caseVali2_66_0_, workspace0_.caseValidationNTM as caseVali3_66_0_, workspace0_.caseValidationTB as caseVali4_66_0_, workspace0_.confirmedCaseNumber as confirme5_66_0_, workspace0_.customId as customId6_66_0_, workspace0_.maxStockOnHand as maxStock7_66_0_, workspace0_.minStockOnHand as minStock8_66_0_, workspace0_.monthsToAlertExpiredMedicines as monthsTo9_66_0_, workspace0_.name as name10_66_0_, workspace0_.patientAddrRequiredLevels as patient11_66_0_, workspace0_.patientNameComposition as patient12_66_0_, workspace0_.sendSystemMessages as sendSys13_66_0_, workspace0_.suspectCaseNumber as suspect14_66_0_, workspace0_.treatMonitoringInput as treatMo15_66_0_, workspace0_.weekFreq1 as weekFre16_66_0_, workspace0_.weekFreq2 as weekFre17_66_0_, workspace0_.weekFreq3 as weekFre18_66_0_, workspace0_.weekFreq4 as weekFre19_66_0_, workspace0_.weekFreq5 as weekFre20_66_0_, workspace0_.weekFreq6 as weekFre21_66_0_, workspace0_.weekFreq7 as weekFre22_66_0_ from workspace workspace0_ where workspace0_.id=?
Hibernate: select workspacev0_.id as id1_68_0_, workspacev0_.logoImage as logoImag2_68_0_, workspacev0_.picture as picture3_68_0_, workspacev0_.pictureContentType as pictureC4_68_0_, workspace1_.id as id1_66_1_, workspace1_.caseValidationDRTB as caseVali2_66_1_, workspace1_.caseValidationNTM as caseVali3_66_1_, workspace1_.caseValidationTB as caseVali4_66_1_, workspace1_.confirmedCaseNumber as confirme5_66_1_, workspace1_.customId as customId6_66_1_, workspace1_.maxStockOnHand as maxStock7_66_1_, workspace1_.minStockOnHand as minStock8_66_1_, workspace1_.monthsToAlertExpiredMedicines as monthsTo9_66_1_, workspace1_.name as name10_66_1_, workspace1_.patientAddrRequiredLevels as patient11_66_1_, workspace1_.patientNameComposition as patient12_66_1_, workspace1_.sendSystemMessages as sendSys13_66_1_, workspace1_.suspectCaseNumber as suspect14_66_1_, workspace1_.treatMonitoringInput as treatMo15_66_1_, workspace1_.weekFreq1 as weekFre16_66_1_, workspace1_.weekFreq2 as weekFre17_66_1_, workspace1_.weekFreq3 as weekFre18_66_1_, workspace1_.weekFreq4 as weekFre19_66_1_, workspace1_.weekFreq5 as weekFre20_66_1_, workspace1_.weekFreq6 as weekFre21_66_1_, workspace1_.weekFreq7 as weekFre22_66_1_ from workspaceview workspacev0_ left outer join workspace workspace1_ on workspacev0_.id=workspace1_.id where workspacev0_.id=?
Hibernate: update tag set WORKSPACE_ID=?, active=?, consistencyCheck=?, dailyUpdate=?, name=?, sqlCondition=? where id=?
Hibernate: select count(*) as col_0_0_ from tag tag0_ where tag0_.WORKSPACE_ID=? and tag0_.name=? and tag0_.id<>?
Hibernate: select count(*) from tbcase a inner join patient p on p.id=a.patient_id where a.state > 3
Hibernate: delete from tags_case where tag_id = ?
Hibernate: select userlog0_.id as id1_60_0_, userlog0_.name as name2_60_0_ from userlog userlog0_ where userlog0_.id=?
Hibernate: select workspacel0_.id as id1_67_0_, workspacel0_.name as name2_67_0_ from workspacelog workspacel0_ where workspacel0_.id=?
Hibernate: select unit0_.id as id2_59_0_, unit0_.WORKSPACE_ID as WORKSPA26_59_0_, unit0_.active as active3_59_0_, unit0_.ADDRESS as ADDRESS4_59_0_, unit0_.ADMINUNIT_ID as ADMINUN27_59_0_, unit0_.addressCompl as addressC5_59_0_, unit0_.zipcode as zipcode6_59_0_, unit0_.AUTHORIZERUNIT_ID as AUTHORI28_59_0_, unit0_.customId as customId7_59_0_, unit0_.inventoryCloseDate as inventor8_59_0_, unit0_.inventoryStartDate as inventor9_59_0_, unit0_.name as name10_59_0_, unit0_.receiveFromManufacturer as receive11_59_0_, unit0_.shipAddress as shipAdd12_59_0_, unit0_.SHIP_ADMINUNIT_ID as SHIP_AD29_59_0_, unit0_.shipAddressCompl as shipAdd13_59_0_, unit0_.shipZipCode as shipZip14_59_0_, unit0_.shipContactName as shipCon15_59_0_, unit0_.shipContactPhone as shipCon16_59_0_, unit0_.SUPPLIER_ID as SUPPLIE30_59_0_, unit0_.performCulture as perform17_59_0_, unit0_.performDst as perform18_59_0_, unit0_.performMicroscopy as perform19_59_0_, unit0_.performXpert as perform20_59_0_, unit0_.drtbFacility as drtbFac21_59_0_, unit0_.notificationUnit as notific22_59_0_, unit0_.ntmFacility as ntmFaci23_59_0_, unit0_.numDaysOrder as numDays24_59_0_, unit0_.tbFacility as tbFacil25_59_0_, unit0_.DISCRIMINATOR as DISCRIMI1_59_0_ from unit unit0_ where unit0_.id=?
Hibernate: insert into commandhistory (action, data, entityId, entityName, execDate, parentId, type, UNIT_ID, USERLOG_ID, WORKSPACELOG_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: select tag0_.id as id1_50_0_, tag0_.WORKSPACE_ID as WORKSPAC7_50_0_, tag0_.active as active2_50_0_, tag0_.consistencyCheck as consiste3_50_0_, tag0_.dailyUpdate as dailyUpd4_50_0_, tag0_.name as name5_50_0_, tag0_.sqlCondition as sqlCondi6_50_0_ from tag tag0_ where tag0_.id=?
Hibernate: select tag0_.id as id1_50_0_, tag0_.WORKSPACE_ID as WORKSPAC7_50_0_, tag0_.active as active2_50_0_, tag0_.consistencyCheck as consiste3_50_0_, tag0_.dailyUpdate as dailyUpd4_50_0_, tag0_.name as name5_50_0_, tag0_.sqlCondition as sqlCondi6_50_0_ from tag tag0_ where tag0_.id=?
Hibernate: select workspace0_.id as id1_66_0_, workspace0_.caseValidationDRTB as caseVali2_66_0_, workspace0_.caseValidationNTM as caseVali3_66_0_, workspace0_.caseValidationTB as caseVali4_66_0_, workspace0_.confirmedCaseNumber as confirme5_66_0_, workspace0_.customId as customId6_66_0_, workspace0_.maxStockOnHand as maxStock7_66_0_, workspace0_.minStockOnHand as minStock8_66_0_, workspace0_.monthsToAlertExpiredMedicines as monthsTo9_66_0_, workspace0_.name as name10_66_0_, workspace0_.patientAddrRequiredLevels as patient11_66_0_, workspace0_.patientNameComposition as patient12_66_0_, workspace0_.sendSystemMessages as sendSys13_66_0_, workspace0_.suspectCaseNumber as suspect14_66_0_, workspace0_.treatMonitoringInput as treatMo15_66_0_, workspace0_.weekFreq1 as weekFre16_66_0_, workspace0_.weekFreq2 as weekFre17_66_0_, workspace0_.weekFreq3 as weekFre18_66_0_, workspace0_.weekFreq4 as weekFre19_66_0_, workspace0_.weekFreq5 as weekFre20_66_0_, workspace0_.weekFreq6 as weekFre21_66_0_, workspace0_.weekFreq7 as weekFre22_66_0_ from workspace workspace0_ where workspace0_.id=?
Hibernate: select workspacev0_.id as id1_68_0_, workspacev0_.logoImage as logoImag2_68_0_, workspacev0_.picture as picture3_68_0_, workspacev0_.pictureContentType as pictureC4_68_0_, workspace1_.id as id1_66_1_, workspace1_.caseValidationDRTB as caseVali2_66_1_, workspace1_.caseValidationNTM as caseVali3_66_1_, workspace1_.caseValidationTB as caseVali4_66_1_, workspace1_.confirmedCaseNumber as confirme5_66_1_, workspace1_.customId as customId6_66_1_, workspace1_.maxStockOnHand as maxStock7_66_1_, workspace1_.minStockOnHand as minStock8_66_1_, workspace1_.monthsToAlertExpiredMedicines as monthsTo9_66_1_, workspace1_.name as name10_66_1_, workspace1_.patientAddrRequiredLevels as patient11_66_1_, workspace1_.patientNameComposition as patient12_66_1_, workspace1_.sendSystemMessages as sendSys13_66_1_, workspace1_.suspectCaseNumber as suspect14_66_1_, workspace1_.treatMonitoringInput as treatMo15_66_1_, workspace1_.weekFreq1 as weekFre16_66_1_, workspace1_.weekFreq2 as weekFre17_66_1_, workspace1_.weekFreq3 as weekFre18_66_1_, workspace1_.weekFreq4 as weekFre19_66_1_, workspace1_.weekFreq5 as weekFre20_66_1_, workspace1_.weekFreq6 as weekFre21_66_1_, workspace1_.weekFreq7 as weekFre22_66_1_ from workspaceview workspacev0_ left outer join workspace workspace1_ on workspacev0_.id=workspace1_.id where workspacev0_.id=?
Hibernate: delete from tag where id=?
Hibernate: select userlog0_.id as id1_60_0_, userlog0_.name as name2_60_0_ from userlog userlog0_ where userlog0_.id=?
Hibernate: select workspacel0_.id as id1_67_0_, workspacel0_.name as name2_67_0_ from workspacelog workspacel0_ where workspacel0_.id=?
Hibernate: select unit0_.id as id2_59_0_, unit0_.WORKSPACE_ID as WORKSPA26_59_0_, unit0_.active as active3_59_0_, unit0_.ADDRESS as ADDRESS4_59_0_, unit0_.ADMINUNIT_ID as ADMINUN27_59_0_, unit0_.addressCompl as addressC5_59_0_, unit0_.zipcode as zipcode6_59_0_, unit0_.AUTHORIZERUNIT_ID as AUTHORI28_59_0_, unit0_.customId as customId7_59_0_, unit0_.inventoryCloseDate as inventor8_59_0_, unit0_.inventoryStartDate as inventor9_59_0_, unit0_.name as name10_59_0_, unit0_.receiveFromManufacturer as receive11_59_0_, unit0_.shipAddress as shipAdd12_59_0_, unit0_.SHIP_ADMINUNIT_ID as SHIP_AD29_59_0_, unit0_.shipAddressCompl as shipAdd13_59_0_, unit0_.shipZipCode as shipZip14_59_0_, unit0_.shipContactName as shipCon15_59_0_, unit0_.shipContactPhone as shipCon16_59_0_, unit0_.SUPPLIER_ID as SUPPLIE30_59_0_, unit0_.performCulture as perform17_59_0_, unit0_.performDst as perform18_59_0_, unit0_.performMicroscopy as perform19_59_0_, unit0_.performXpert as perform20_59_0_, unit0_.drtbFacility as drtbFac21_59_0_, unit0_.notificationUnit as notific22_59_0_, unit0_.ntmFacility as ntmFaci23_59_0_, unit0_.numDaysOrder as numDays24_59_0_, unit0_.tbFacility as tbFacil25_59_0_, unit0_.DISCRIMINATOR as DISCRIMI1_59_0_ from unit unit0_ where unit0_.id=?
Hibernate: insert into commandhistory (action, data, entityId, entityName, execDate, parentId, type, UNIT_ID, USERLOG_ID, WORKSPACELOG_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: select tag0_.id as id1_50_0_, tag0_.WORKSPACE_ID as WORKSPAC7_50_0_, tag0_.active as active2_50_0_, tag0_.consistencyCheck as consiste3_50_0_, tag0_.dailyUpdate as dailyUpd4_50_0_, tag0_.name as name5_50_0_, tag0_.sqlCondition as sqlCondi6_50_0_ from tag tag0_ where tag0_.id=?
Hibernate: select user0_.id as id1_48_, user0_.comments as comments2_48_, user0_.customId as customId3_48_, user0_.DEFAULTWORKSPACE_ID as DEFAULT14_48_, user0_.email as email4_48_, user0_.login as login5_48_, user0_.name as name6_48_, user0_.PARENTUSER_ID as PARENTU15_48_, user0_.password as password7_48_, user0_.pwdChangeRequest as pwdChang8_48_, user0_.registrationDate as registra9_48_, user0_.sendSystemMessages as sendSys10_48_, user0_.state as state11_48_, user0_.timeZone as timeZon12_48_, user0_.ulaAccepted as ulaAcce13_48_ from sys_user user0_ where user0_.login=? and upper(user0_.password)=? and user0_.state<>?
Hibernate: select userworksp0_.id as id1_64_, userworksp0_.WORKSPACE_ID as WORKSPAC5_64_, userworksp0_.ADMINUNIT_ID as ADMINUNI6_64_, userworksp0_.administrator as administ2_64_, userworksp0_.playOtherUnits as playOthe3_64_, userworksp0_.UNIT_ID as UNIT_ID7_64_, userworksp0_.USER_ID as USER_ID8_64_, userworksp0_.USER_VIEW as USER_VIE4_64_ from userworkspace userworksp0_ where userworksp0_.id=(select min(userworksp1_.id) from userworkspace userworksp1_ where userworksp1_.USER_ID=?) limit ?
Hibernate: insert into userlogin (Application, IpAddress, lastAccess, loginDate, logoutDate, USER_ID, WORKSPACE_ID, id) values (?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: select workspace0_.id as id1_66_0_, workspace0_.caseValidationDRTB as caseVali2_66_0_, workspace0_.caseValidationNTM as caseVali3_66_0_, workspace0_.caseValidationTB as caseVali4_66_0_, workspace0_.confirmedCaseNumber as confirme5_66_0_, workspace0_.customId as customId6_66_0_, workspace0_.maxStockOnHand as maxStock7_66_0_, workspace0_.minStockOnHand as minStock8_66_0_, workspace0_.monthsToAlertExpiredMedicines as monthsTo9_66_0_, workspace0_.name as name10_66_0_, workspace0_.patientAddrRequiredLevels as patient11_66_0_, workspace0_.patientNameComposition as patient12_66_0_, workspace0_.sendSystemMessages as sendSys13_66_0_, workspace0_.suspectCaseNumber as suspect14_66_0_, workspace0_.treatMonitoringInput as treatMo15_66_0_, workspace0_.weekFreq1 as weekFre16_66_0_, workspace0_.weekFreq2 as weekFre17_66_0_, workspace0_.weekFreq3 as weekFre18_66_0_, workspace0_.weekFreq4 as weekFre19_66_0_, workspace0_.weekFreq5 as weekFre20_66_0_, workspace0_.weekFreq6 as weekFre21_66_0_, workspace0_.weekFreq7 as weekFre22_66_0_ from workspace workspace0_ where workspace0_.id=?
Hibernate: select workspacev0_.id as id1_68_0_, workspacev0_.logoImage as logoImag2_68_0_, workspacev0_.picture as picture3_68_0_, workspacev0_.pictureContentType as pictureC4_68_0_, workspace1_.id as id1_66_1_, workspace1_.caseValidationDRTB as caseVali2_66_1_, workspace1_.caseValidationNTM as caseVali3_66_1_, workspace1_.caseValidationTB as caseVali4_66_1_, workspace1_.confirmedCaseNumber as confirme5_66_1_, workspace1_.customId as customId6_66_1_, workspace1_.maxStockOnHand as maxStock7_66_1_, workspace1_.minStockOnHand as minStock8_66_1_, workspace1_.monthsToAlertExpiredMedicines as monthsTo9_66_1_, workspace1_.name as name10_66_1_, workspace1_.patientAddrRequiredLevels as patient11_66_1_, workspace1_.patientNameComposition as patient12_66_1_, workspace1_.sendSystemMessages as sendSys13_66_1_, workspace1_.suspectCaseNumber as suspect14_66_1_, workspace1_.treatMonitoringInput as treatMo15_66_1_, workspace1_.weekFreq1 as weekFre16_66_1_, workspace1_.weekFreq2 as weekFre17_66_1_, workspace1_.weekFreq3 as weekFre18_66_1_, workspace1_.weekFreq4 as weekFre19_66_1_, workspace1_.weekFreq5 as weekFre20_66_1_, workspace1_.weekFreq6 as weekFre21_66_1_, workspace1_.weekFreq7 as weekFre22_66_1_ from workspaceview workspacev0_ left outer join workspace workspace1_ on workspacev0_.id=workspace1_.id where workspacev0_.id=?
Hibernate: select userworksp0_.id as id1_64_0_, user1_.id as id1_48_1_, workspace2_.id as id1_66_2_, userworksp0_.WORKSPACE_ID as WORKSPAC5_64_0_, userworksp0_.ADMINUNIT_ID as ADMINUNI6_64_0_, userworksp0_.administrator as administ2_64_0_, userworksp0_.playOtherUnits as playOthe3_64_0_, userworksp0_.UNIT_ID as UNIT_ID7_64_0_, userworksp0_.USER_ID as USER_ID8_64_0_, userworksp0_.USER_VIEW as USER_VIE4_64_0_, user1_.comments as comments2_48_1_, user1_.customId as customId3_48_1_, user1_.DEFAULTWORKSPACE_ID as DEFAULT14_48_1_, user1_.email as email4_48_1_, user1_.login as login5_48_1_, user1_.name as name6_48_1_, user1_.PARENTUSER_ID as PARENTU15_48_1_, user1_.password as password7_48_1_, user1_.pwdChangeRequest as pwdChang8_48_1_, user1_.registrationDate as registra9_48_1_, user1_.sendSystemMessages as sendSys10_48_1_, user1_.state as state11_48_1_, user1_.timeZone as timeZon12_48_1_, user1_.ulaAccepted as ulaAcce13_48_1_, workspace2_.caseValidationDRTB as caseVali2_66_2_, workspace2_.caseValidationNTM as caseVali3_66_2_, workspace2_.caseValidationTB as caseVali4_66_2_, workspace2_.confirmedCaseNumber as confirme5_66_2_, workspace2_.customId as customId6_66_2_, workspace2_.maxStockOnHand as maxStock7_66_2_, workspace2_.minStockOnHand as minStock8_66_2_, workspace2_.monthsToAlertExpiredMedicines as monthsTo9_66_2_, workspace2_.name as name10_66_2_, workspace2_.patientAddrRequiredLevels as patient11_66_2_, workspace2_.patientNameComposition as patient12_66_2_, workspace2_.sendSystemMessages as sendSys13_66_2_, workspace2_.suspectCaseNumber as suspect14_66_2_, workspace2_.treatMonitoringInput as treatMo15_66_2_, workspace2_.weekFreq1 as weekFre16_66_2_, workspace2_.weekFreq2 as weekFre17_66_2_, workspace2_.weekFreq3 as weekFre18_66_2_, workspace2_.weekFreq4 as weekFre19_66_2_, workspace2_.weekFreq5 as weekFre20_66_2_, workspace2_.weekFreq6 as weekFre21_66_2_, workspace2_.weekFreq7 as weekFre22_66_2_ from userworkspace userworksp0_ inner join sys_user user1_ on userworksp0_.USER_ID=user1_.id inner join workspace workspace2_ on userworksp0_.WORKSPACE_ID=workspace2_.id where userworksp0_.USER_ID=? and userworksp0_.WORKSPACE_ID=?
Hibernate: select unit0_.id as id2_59_0_, unit0_.WORKSPACE_ID as WORKSPA26_59_0_, unit0_.active as active3_59_0_, unit0_.ADDRESS as ADDRESS4_59_0_, unit0_.ADMINUNIT_ID as ADMINUN27_59_0_, unit0_.addressCompl as addressC5_59_0_, unit0_.zipcode as zipcode6_59_0_, unit0_.AUTHORIZERUNIT_ID as AUTHORI28_59_0_, unit0_.customId as customId7_59_0_, unit0_.inventoryCloseDate as inventor8_59_0_, unit0_.inventoryStartDate as inventor9_59_0_, unit0_.name as name10_59_0_, unit0_.receiveFromManufacturer as receive11_59_0_, unit0_.shipAddress as shipAdd12_59_0_, unit0_.SHIP_ADMINUNIT_ID as SHIP_AD29_59_0_, unit0_.shipAddressCompl as shipAdd13_59_0_, unit0_.shipZipCode as shipZip14_59_0_, unit0_.shipContactName as shipCon15_59_0_, unit0_.shipContactPhone as shipCon16_59_0_, unit0_.SUPPLIER_ID as SUPPLIE30_59_0_, unit0_.performCulture as perform17_59_0_, unit0_.performDst as perform18_59_0_, unit0_.performMicroscopy as perform19_59_0_, unit0_.performXpert as perform20_59_0_, unit0_.drtbFacility as drtbFac21_59_0_, unit0_.notificationUnit as notific22_59_0_, unit0_.ntmFacility as ntmFaci23_59_0_, unit0_.numDaysOrder as numDays24_59_0_, unit0_.tbFacility as tbFacil25_59_0_, unit0_.DISCRIMINATOR as DISCRIMI1_59_0_ from unit unit0_ where unit0_.id=?
Hibernate: select administra0_.id as id1_0_0_, administra0_.WORKSPACE_ID as WORKSPAC6_0_0_, administra0_.code as code2_0_0_, administra0_.COUNTRYSTRUCTURE_ID as COUNTRYS7_0_0_, administra0_.customId as customId3_0_0_, administra0_.name as name4_0_0_, administra0_.PARENT_ID as PARENT_I8_0_0_, administra0_.unitsCount as unitsCou5_0_0_, administra1_.id as id1_0_1_, administra1_.WORKSPACE_ID as WORKSPAC6_0_1_, administra1_.code as code2_0_1_, administra1_.COUNTRYSTRUCTURE_ID as COUNTRYS7_0_1_, administra1_.customId as customId3_0_1_, administra1_.name as name4_0_1_, administra1_.PARENT_ID as PARENT_I8_0_1_, administra1_.unitsCount as unitsCou5_0_1_ from administrativeunit administra0_ left outer join administrativeunit administra1_ on administra0_.PARENT_ID=administra1_.id where administra0_.id=?
Hibernate: select administra0_.id as col_0_0_, administra0_.name as col_1_0_, administra1_.id as col_2_0_, administra1_.name as col_3_0_, administra2_.id as col_4_0_, administra2_.name as col_5_0_, administra3_.id as col_6_0_, administra3_.name as col_7_0_, administra4_.id as col_8_0_, administra4_.name as col_9_0_ from administrativeunit administra0_ left outer join administrativeunit administra1_ on administra0_.PARENT_ID=administra1_.id left outer join administrativeunit administra2_ on administra1_.PARENT_ID=administra2_.id left outer join administrativeunit administra3_ on administra2_.PARENT_ID=administra3_.id left outer join administrativeunit administra4_ on administra3_.PARENT_ID=administra4_.id where administra0_.id=?
2016-05-26 22:06:30.788 INFO 6940 --- [ main] org.msh.etbm.test.TestSetup : User admin authenticated
Hibernate: select workspace0_.id as id1_66_0_, workspace0_.caseValidationDRTB as caseVali2_66_0_, workspace0_.caseValidationNTM as caseVali3_66_0_, workspace0_.caseValidationTB as caseVali4_66_0_, workspace0_.confirmedCaseNumber as confirme5_66_0_, workspace0_.customId as customId6_66_0_, workspace0_.maxStockOnHand as maxStock7_66_0_, workspace0_.minStockOnHand as minStock8_66_0_, workspace0_.monthsToAlertExpiredMedicines as monthsTo9_66_0_, workspace0_.name as name10_66_0_, workspace0_.patientAddrRequiredLevels as patient11_66_0_, workspace0_.patientNameComposition as patient12_66_0_, workspace0_.sendSystemMessages as sendSys13_66_0_, workspace0_.suspectCaseNumber as suspect14_66_0_, workspace0_.treatMonitoringInput as treatMo15_66_0_, workspace0_.weekFreq1 as weekFre16_66_0_, workspace0_.weekFreq2 as weekFre17_66_0_, workspace0_.weekFreq3 as weekFre18_66_0_, workspace0_.weekFreq4 as weekFre19_66_0_, workspace0_.weekFreq5 as weekFre20_66_0_, workspace0_.weekFreq6 as weekFre21_66_0_, workspace0_.weekFreq7 as weekFre22_66_0_ from workspace workspace0_ where workspace0_.id=?
Hibernate: select workspacev0_.id as id1_68_0_, workspacev0_.logoImage as logoImag2_68_0_, workspacev0_.picture as picture3_68_0_, workspacev0_.pictureContentType as pictureC4_68_0_, workspace1_.id as id1_66_1_, workspace1_.caseValidationDRTB as caseVali2_66_1_, workspace1_.caseValidationNTM as caseVali3_66_1_, workspace1_.caseValidationTB as caseVali4_66_1_, workspace1_.confirmedCaseNumber as confirme5_66_1_, workspace1_.customId as customId6_66_1_, workspace1_.maxStockOnHand as maxStock7_66_1_, workspace1_.minStockOnHand as minStock8_66_1_, workspace1_.monthsToAlertExpiredMedicines as monthsTo9_66_1_, workspace1_.name as name10_66_1_, workspace1_.patientAddrRequiredLevels as patient11_66_1_, workspace1_.patientNameComposition as patient12_66_1_, workspace1_.sendSystemMessages as sendSys13_66_1_, workspace1_.suspectCaseNumber as suspect14_66_1_, workspace1_.treatMonitoringInput as treatMo15_66_1_, workspace1_.weekFreq1 as weekFre16_66_1_, workspace1_.weekFreq2 as weekFre17_66_1_, workspace1_.weekFreq3 as weekFre18_66_1_, workspace1_.weekFreq4 as weekFre19_66_1_, workspace1_.weekFreq5 as weekFre20_66_1_, workspace1_.weekFreq6 as weekFre21_66_1_, workspace1_.weekFreq7 as weekFre22_66_1_ from workspaceview workspacev0_ left outer join workspace workspace1_ on workspacev0_.id=workspace1_.id where workspacev0_.id=?
Hibernate: select count(*) as col_0_0_ from tag tag0_ where tag0_.WORKSPACE_ID=? and tag0_.name=?
Hibernate: select count(*) from tbcase a inner join patient p on p.id=a.patient_id where a.statee > 2
2016-05-26 22:06:30.803 WARN 6940 --- [ main] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 1054, SQLState: 42S22
2016-05-26 22:06:30.803 ERROR 6940 --- [ main] o.h.engine.jdbc.spi.SqlExceptionHelper : Unknown column 'a.statee' in 'where clause'
2016-05-26 22:06:30.803 WARN 6940 --- [ main] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Warning Code: 1054, SQLState: 42S22
2016-05-26 22:06:30.803 WARN 6940 --- [ main] o.h.engine.jdbc.spi.SqlExceptionHelper : Unknown column 'a.statee' in 'where clause'
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.125 sec - in org.msh.etbm.test.services.admin.TagTest
Running org.msh.etbm.test.services.admin.UserViewOptionsTest
2016-05-26 22:06:30.803 INFO 6940 --- [ main] o.s.t.c.support.AbstractContextLoader : Could not detect default resource locations for test class [org.msh.etbm.test.AuthenticatedTest]: no resource found for suffixes {-context.xml, Context.groovy}.
2016-05-26 22:06:30.803 INFO 6940 --- [ main] o.s.t.c.web.WebTestContextBootstrapper : Loaded default TestExecutionListener class names from location [META-INF/spring.factories]: [org.springframework.test.context.web.ServletTestExecutionListener, org.springframework.test.context.support.DirtiesContextBeforeModesTestExecutionListener, org.springframework.test.context.support.DependencyInjectionTestExecutionListener, org.springframework.test.context.support.DirtiesContextTestExecutionListener, org.springframework.test.context.transaction.TransactionalTestExecutionListener, org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener]
2016-05-26 22:06:30.803 INFO 6940 --- [ main] o.s.t.c.web.WebTestContextBootstrapper : Using TestExecutionListeners: [org.springframework.test.context.web.ServletTestExecutionListener@5002fc11, org.springframework.test.context.support.DirtiesContextBeforeModesTestExecutionListener@695d8186, org.springframework.test.context.support.DependencyInjectionTestExecutionListener@221b4175, org.springframework.test.context.support.DirtiesContextTestExecutionListener@58ae3cb, org.springframework.test.context.transaction.TransactionalTestExecutionListener@42af751f, org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener@477b8d7d]
Hibernate: select user0_.id as id1_48_, user0_.comments as comments2_48_, user0_.customId as customId3_48_, user0_.DEFAULTWORKSPACE_ID as DEFAULT14_48_, user0_.email as email4_48_, user0_.login as login5_48_, user0_.name as name6_48_, user0_.PARENTUSER_ID as PARENTU15_48_, user0_.password as password7_48_, user0_.pwdChangeRequest as pwdChang8_48_, user0_.registrationDate as registra9_48_, user0_.sendSystemMessages as sendSys10_48_, user0_.state as state11_48_, user0_.timeZone as timeZon12_48_, user0_.ulaAccepted as ulaAcce13_48_ from sys_user user0_ where user0_.login=? and upper(user0_.password)=? and user0_.state<>?
Hibernate: select userworksp0_.id as id1_64_, userworksp0_.WORKSPACE_ID as WORKSPAC5_64_, userworksp0_.ADMINUNIT_ID as ADMINUNI6_64_, userworksp0_.administrator as administ2_64_, userworksp0_.playOtherUnits as playOthe3_64_, userworksp0_.UNIT_ID as UNIT_ID7_64_, userworksp0_.USER_ID as USER_ID8_64_, userworksp0_.USER_VIEW as USER_VIE4_64_ from userworkspace userworksp0_ where userworksp0_.id=(select min(userworksp1_.id) from userworkspace userworksp1_ where userworksp1_.USER_ID=?) limit ?
Hibernate: insert into userlogin (Application, IpAddress, lastAccess, loginDate, logoutDate, USER_ID, WORKSPACE_ID, id) values (?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: select workspace0_.id as id1_66_0_, workspace0_.caseValidationDRTB as caseVali2_66_0_, workspace0_.caseValidationNTM as caseVali3_66_0_, workspace0_.caseValidationTB as caseVali4_66_0_, workspace0_.confirmedCaseNumber as confirme5_66_0_, workspace0_.customId as customId6_66_0_, workspace0_.maxStockOnHand as maxStock7_66_0_, workspace0_.minStockOnHand as minStock8_66_0_, workspace0_.monthsToAlertExpiredMedicines as monthsTo9_66_0_, workspace0_.name as name10_66_0_, workspace0_.patientAddrRequiredLevels as patient11_66_0_, workspace0_.patientNameComposition as patient12_66_0_, workspace0_.sendSystemMessages as sendSys13_66_0_, workspace0_.suspectCaseNumber as suspect14_66_0_, workspace0_.treatMonitoringInput as treatMo15_66_0_, workspace0_.weekFreq1 as weekFre16_66_0_, workspace0_.weekFreq2 as weekFre17_66_0_, workspace0_.weekFreq3 as weekFre18_66_0_, workspace0_.weekFreq4 as weekFre19_66_0_, workspace0_.weekFreq5 as weekFre20_66_0_, workspace0_.weekFreq6 as weekFre21_66_0_, workspace0_.weekFreq7 as weekFre22_66_0_ from workspace workspace0_ where workspace0_.id=?
Hibernate: select workspacev0_.id as id1_68_0_, workspacev0_.logoImage as logoImag2_68_0_, workspacev0_.picture as picture3_68_0_, workspacev0_.pictureContentType as pictureC4_68_0_, workspace1_.id as id1_66_1_, workspace1_.caseValidationDRTB as caseVali2_66_1_, workspace1_.caseValidationNTM as caseVali3_66_1_, workspace1_.caseValidationTB as caseVali4_66_1_, workspace1_.confirmedCaseNumber as confirme5_66_1_, workspace1_.customId as customId6_66_1_, workspace1_.maxStockOnHand as maxStock7_66_1_, workspace1_.minStockOnHand as minStock8_66_1_, workspace1_.monthsToAlertExpiredMedicines as monthsTo9_66_1_, workspace1_.name as name10_66_1_, workspace1_.patientAddrRequiredLevels as patient11_66_1_, workspace1_.patientNameComposition as patient12_66_1_, workspace1_.sendSystemMessages as sendSys13_66_1_, workspace1_.suspectCaseNumber as suspect14_66_1_, workspace1_.treatMonitoringInput as treatMo15_66_1_, workspace1_.weekFreq1 as weekFre16_66_1_, workspace1_.weekFreq2 as weekFre17_66_1_, workspace1_.weekFreq3 as weekFre18_66_1_, workspace1_.weekFreq4 as weekFre19_66_1_, workspace1_.weekFreq5 as weekFre20_66_1_, workspace1_.weekFreq6 as weekFre21_66_1_, workspace1_.weekFreq7 as weekFre22_66_1_ from workspaceview workspacev0_ left outer join workspace workspace1_ on workspacev0_.id=workspace1_.id where workspacev0_.id=?
Hibernate: select userworksp0_.id as id1_64_0_, user1_.id as id1_48_1_, workspace2_.id as id1_66_2_, userworksp0_.WORKSPACE_ID as WORKSPAC5_64_0_, userworksp0_.ADMINUNIT_ID as ADMINUNI6_64_0_, userworksp0_.administrator as administ2_64_0_, userworksp0_.playOtherUnits as playOthe3_64_0_, userworksp0_.UNIT_ID as UNIT_ID7_64_0_, userworksp0_.USER_ID as USER_ID8_64_0_, userworksp0_.USER_VIEW as USER_VIE4_64_0_, user1_.comments as comments2_48_1_, user1_.customId as customId3_48_1_, user1_.DEFAULTWORKSPACE_ID as DEFAULT14_48_1_, user1_.email as email4_48_1_, user1_.login as login5_48_1_, user1_.name as name6_48_1_, user1_.PARENTUSER_ID as PARENTU15_48_1_, user1_.password as password7_48_1_, user1_.pwdChangeRequest as pwdChang8_48_1_, user1_.registrationDate as registra9_48_1_, user1_.sendSystemMessages as sendSys10_48_1_, user1_.state as state11_48_1_, user1_.timeZone as timeZon12_48_1_, user1_.ulaAccepted as ulaAcce13_48_1_, workspace2_.caseValidationDRTB as caseVali2_66_2_, workspace2_.caseValidationNTM as caseVali3_66_2_, workspace2_.caseValidationTB as caseVali4_66_2_, workspace2_.confirmedCaseNumber as confirme5_66_2_, workspace2_.customId as customId6_66_2_, workspace2_.maxStockOnHand as maxStock7_66_2_, workspace2_.minStockOnHand as minStock8_66_2_, workspace2_.monthsToAlertExpiredMedicines as monthsTo9_66_2_, workspace2_.name as name10_66_2_, workspace2_.patientAddrRequiredLevels as patient11_66_2_, workspace2_.patientNameComposition as patient12_66_2_, workspace2_.sendSystemMessages as sendSys13_66_2_, workspace2_.suspectCaseNumber as suspect14_66_2_, workspace2_.treatMonitoringInput as treatMo15_66_2_, workspace2_.weekFreq1 as weekFre16_66_2_, workspace2_.weekFreq2 as weekFre17_66_2_, workspace2_.weekFreq3 as weekFre18_66_2_, workspace2_.weekFreq4 as weekFre19_66_2_, workspace2_.weekFreq5 as weekFre20_66_2_, workspace2_.weekFreq6 as weekFre21_66_2_, workspace2_.weekFreq7 as weekFre22_66_2_ from userworkspace userworksp0_ inner join sys_user user1_ on userworksp0_.USER_ID=user1_.id inner join workspace workspace2_ on userworksp0_.WORKSPACE_ID=workspace2_.id where userworksp0_.USER_ID=? and userworksp0_.WORKSPACE_ID=?
Hibernate: select unit0_.id as id2_59_0_, unit0_.WORKSPACE_ID as WORKSPA26_59_0_, unit0_.active as active3_59_0_, unit0_.ADDRESS as ADDRESS4_59_0_, unit0_.ADMINUNIT_ID as ADMINUN27_59_0_, unit0_.addressCompl as addressC5_59_0_, unit0_.zipcode as zipcode6_59_0_, unit0_.AUTHORIZERUNIT_ID as AUTHORI28_59_0_, unit0_.customId as customId7_59_0_, unit0_.inventoryCloseDate as inventor8_59_0_, unit0_.inventoryStartDate as inventor9_59_0_, unit0_.name as name10_59_0_, unit0_.receiveFromManufacturer as receive11_59_0_, unit0_.shipAddress as shipAdd12_59_0_, unit0_.SHIP_ADMINUNIT_ID as SHIP_AD29_59_0_, unit0_.shipAddressCompl as shipAdd13_59_0_, unit0_.shipZipCode as shipZip14_59_0_, unit0_.shipContactName as shipCon15_59_0_, unit0_.shipContactPhone as shipCon16_59_0_, unit0_.SUPPLIER_ID as SUPPLIE30_59_0_, unit0_.performCulture as perform17_59_0_, unit0_.performDst as perform18_59_0_, unit0_.performMicroscopy as perform19_59_0_, unit0_.performXpert as perform20_59_0_, unit0_.drtbFacility as drtbFac21_59_0_, unit0_.notificationUnit as notific22_59_0_, unit0_.ntmFacility as ntmFaci23_59_0_, unit0_.numDaysOrder as numDays24_59_0_, unit0_.tbFacility as tbFacil25_59_0_, unit0_.DISCRIMINATOR as DISCRIMI1_59_0_ from unit unit0_ where unit0_.id=?
Hibernate: select administra0_.id as id1_0_0_, administra0_.WORKSPACE_ID as WORKSPAC6_0_0_, administra0_.code as code2_0_0_, administra0_.COUNTRYSTRUCTURE_ID as COUNTRYS7_0_0_, administra0_.customId as customId3_0_0_, administra0_.name as name4_0_0_, administra0_.PARENT_ID as PARENT_I8_0_0_, administra0_.unitsCount as unitsCou5_0_0_, administra1_.id as id1_0_1_, administra1_.WORKSPACE_ID as WORKSPAC6_0_1_, administra1_.code as code2_0_1_, administra1_.COUNTRYSTRUCTURE_ID as COUNTRYS7_0_1_, administra1_.customId as customId3_0_1_, administra1_.name as name4_0_1_, administra1_.PARENT_ID as PARENT_I8_0_1_, administra1_.unitsCount as unitsCou5_0_1_ from administrativeunit administra0_ left outer join administrativeunit administra1_ on administra0_.PARENT_ID=administra1_.id where administra0_.id=?
Hibernate: select administra0_.id as col_0_0_, administra0_.name as col_1_0_, administra1_.id as col_2_0_, administra1_.name as col_3_0_, administra2_.id as col_4_0_, administra2_.name as col_5_0_, administra3_.id as col_6_0_, administra3_.name as col_7_0_, administra4_.id as col_8_0_, administra4_.name as col_9_0_ from administrativeunit administra0_ left outer join administrativeunit administra1_ on administra0_.PARENT_ID=administra1_.id left outer join administrativeunit administra2_ on administra1_.PARENT_ID=administra2_.id left outer join administrativeunit administra3_ on administra2_.PARENT_ID=administra3_.id left outer join administrativeunit administra4_ on administra3_.PARENT_ID=administra4_.id where administra0_.id=?
2016-05-26 22:06:30.819 INFO 6940 --- [ main] org.msh.etbm.test.TestSetup : User admin authenticated
Hibernate: select unit0_.id as id2_59_, unit0_.WORKSPACE_ID as WORKSPA26_59_, unit0_.active as active3_59_, unit0_.ADDRESS as ADDRESS4_59_, unit0_.ADMINUNIT_ID as ADMINUN27_59_, unit0_.addressCompl as addressC5_59_, unit0_.zipcode as zipcode6_59_, unit0_.AUTHORIZERUNIT_ID as AUTHORI28_59_, unit0_.customId as customId7_59_, unit0_.inventoryCloseDate as inventor8_59_, unit0_.inventoryStartDate as inventor9_59_, unit0_.name as name10_59_, unit0_.receiveFromManufacturer as receive11_59_, unit0_.shipAddress as shipAdd12_59_, unit0_.SHIP_ADMINUNIT_ID as SHIP_AD29_59_, unit0_.shipAddressCompl as shipAdd13_59_, unit0_.shipZipCode as shipZip14_59_, unit0_.shipContactName as shipCon15_59_, unit0_.shipContactPhone as shipCon16_59_, unit0_.SUPPLIER_ID as SUPPLIE30_59_, unit0_.performCulture as perform17_59_, unit0_.performDst as perform18_59_, unit0_.performMicroscopy as perform19_59_, unit0_.performXpert as perform20_59_, unit0_.drtbFacility as drtbFac21_59_, unit0_.notificationUnit as notific22_59_, unit0_.ntmFacility as ntmFaci23_59_, unit0_.numDaysOrder as numDays24_59_, unit0_.tbFacility as tbFacil25_59_, unit0_.DISCRIMINATOR as DISCRIMI1_59_ from unit unit0_ where unit0_.WORKSPACE_ID=? and unit0_.active=1 order by unit0_.name limit ?
Hibernate: select administra0_.id as id1_0_0_, administra0_.WORKSPACE_ID as WORKSPAC6_0_0_, administra0_.code as code2_0_0_, administra0_.COUNTRYSTRUCTURE_ID as COUNTRYS7_0_0_, administra0_.customId as customId3_0_0_, administra0_.name as name4_0_0_, administra0_.PARENT_ID as PARENT_I8_0_0_, administra0_.unitsCount as unitsCou5_0_0_, administra1_.id as id1_0_1_, administra1_.WORKSPACE_ID as WORKSPAC6_0_1_, administra1_.code as code2_0_1_, administra1_.COUNTRYSTRUCTURE_ID as COUNTRYS7_0_1_, administra1_.customId as customId3_0_1_, administra1_.name as name4_0_1_, administra1_.PARENT_ID as PARENT_I8_0_1_, administra1_.unitsCount as unitsCou5_0_1_ from administrativeunit administra0_ left outer join administrativeunit administra1_ on administra0_.PARENT_ID=administra1_.id where administra0_.id=?
Hibernate: select administra0_.id as col_0_0_, administra0_.name as col_1_0_, administra1_.id as col_2_0_, administra1_.name as col_3_0_, administra2_.id as col_4_0_, administra2_.name as col_5_0_, administra3_.id as col_6_0_, administra3_.name as col_7_0_, administra4_.id as col_8_0_, administra4_.name as col_9_0_ from administrativeunit administra0_ left outer join administrativeunit administra1_ on administra0_.PARENT_ID=administra1_.id left outer join administrativeunit administra2_ on administra1_.PARENT_ID=administra2_.id left outer join administrativeunit administra3_ on administra2_.PARENT_ID=administra3_.id left outer join administrativeunit administra4_ on administra3_.PARENT_ID=administra4_.id where administra0_.id=?
Hibernate: select count(*) as col_0_0_ from unit unit0_ where unit0_.WORKSPACE_ID=? and unit0_.active=1
Hibernate: select unit0_.id as id2_59_0_, unit0_.WORKSPACE_ID as WORKSPA26_59_0_, unit0_.active as active3_59_0_, unit0_.ADDRESS as ADDRESS4_59_0_, unit0_.ADMINUNIT_ID as ADMINUN27_59_0_, unit0_.addressCompl as addressC5_59_0_, unit0_.zipcode as zipcode6_59_0_, unit0_.AUTHORIZERUNIT_ID as AUTHORI28_59_0_, unit0_.customId as customId7_59_0_, unit0_.inventoryCloseDate as inventor8_59_0_, unit0_.inventoryStartDate as inventor9_59_0_, unit0_.name as name10_59_0_, unit0_.receiveFromManufacturer as receive11_59_0_, unit0_.shipAddress as shipAdd12_59_0_, unit0_.SHIP_ADMINUNIT_ID as SHIP_AD29_59_0_, unit0_.shipAddressCompl as shipAdd13_59_0_, unit0_.shipZipCode as shipZip14_59_0_, unit0_.shipContactName as shipCon15_59_0_, unit0_.shipContactPhone as shipCon16_59_0_, unit0_.SUPPLIER_ID as SUPPLIE30_59_0_, unit0_.performCulture as perform17_59_0_, unit0_.performDst as perform18_59_0_, unit0_.performMicroscopy as perform19_59_0_, unit0_.performXpert as perform20_59_0_, unit0_.drtbFacility as drtbFac21_59_0_, unit0_.notificationUnit as notific22_59_0_, unit0_.ntmFacility as ntmFaci23_59_0_, unit0_.numDaysOrder as numDays24_59_0_, unit0_.tbFacility as tbFacil25_59_0_, unit0_.DISCRIMINATOR as DISCRIMI1_59_0_ from unit unit0_ where unit0_.id=?
Hibernate: select administra0_.id as id1_0_0_, administra0_.WORKSPACE_ID as WORKSPAC6_0_0_, administra0_.code as code2_0_0_, administra0_.COUNTRYSTRUCTURE_ID as COUNTRYS7_0_0_, administra0_.customId as customId3_0_0_, administra0_.name as name4_0_0_, administra0_.PARENT_ID as PARENT_I8_0_0_, administra0_.unitsCount as unitsCou5_0_0_, administra1_.id as id1_0_1_, administra1_.WORKSPACE_ID as WORKSPAC6_0_1_, administra1_.code as code2_0_1_, administra1_.COUNTRYSTRUCTURE_ID as COUNTRYS7_0_1_, administra1_.customId as customId3_0_1_, administra1_.name as name4_0_1_, administra1_.PARENT_ID as PARENT_I8_0_1_, administra1_.unitsCount as unitsCou5_0_1_ from administrativeunit administra0_ left outer join administrativeunit administra1_ on administra0_.PARENT_ID=administra1_.id where administra0_.id=?
Hibernate: select countrystr0_.id as id1_10_0_, countrystr0_.WORKSPACE_ID as WORKSPAC4_10_0_, countrystr0_.STRUCTURE_LEVEL as STRUCTUR2_10_0_, countrystr0_.name as name3_10_0_ from countrystructure countrystr0_ where countrystr0_.id=?
Hibernate: select countrystr0_.id as id1_10_0_, countrystr0_.WORKSPACE_ID as WORKSPAC4_10_0_, countrystr0_.STRUCTURE_LEVEL as STRUCTUR2_10_0_, countrystr0_.name as name3_10_0_ from countrystructure countrystr0_ where countrystr0_.id=?
Hibernate: select user0_.id as id1_48_, user0_.comments as comments2_48_, user0_.customId as customId3_48_, user0_.DEFAULTWORKSPACE_ID as DEFAULT14_48_, user0_.email as email4_48_, user0_.login as login5_48_, user0_.name as name6_48_, user0_.PARENTUSER_ID as PARENTU15_48_, user0_.password as password7_48_, user0_.pwdChangeRequest as pwdChang8_48_, user0_.registrationDate as registra9_48_, user0_.sendSystemMessages as sendSys10_48_, user0_.state as state11_48_, user0_.timeZone as timeZon12_48_, user0_.ulaAccepted as ulaAcce13_48_ from sys_user user0_ where user0_.login=? and upper(user0_.password)=? and user0_.state<>?
Hibernate: select userworksp0_.id as id1_64_, userworksp0_.WORKSPACE_ID as WORKSPAC5_64_, userworksp0_.ADMINUNIT_ID as ADMINUNI6_64_, userworksp0_.administrator as administ2_64_, userworksp0_.playOtherUnits as playOthe3_64_, userworksp0_.UNIT_ID as UNIT_ID7_64_, userworksp0_.USER_ID as USER_ID8_64_, userworksp0_.USER_VIEW as USER_VIE4_64_ from userworkspace userworksp0_ where userworksp0_.id=(select min(userworksp1_.id) from userworkspace userworksp1_ where userworksp1_.USER_ID=?) limit ?
Hibernate: insert into userlogin (Application, IpAddress, lastAccess, loginDate, logoutDate, USER_ID, WORKSPACE_ID, id) values (?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: select workspace0_.id as id1_66_0_, workspace0_.caseValidationDRTB as caseVali2_66_0_, workspace0_.caseValidationNTM as caseVali3_66_0_, workspace0_.caseValidationTB as caseVali4_66_0_, workspace0_.confirmedCaseNumber as confirme5_66_0_, workspace0_.customId as customId6_66_0_, workspace0_.maxStockOnHand as maxStock7_66_0_, workspace0_.minStockOnHand as minStock8_66_0_, workspace0_.monthsToAlertExpiredMedicines as monthsTo9_66_0_, workspace0_.name as name10_66_0_, workspace0_.patientAddrRequiredLevels as patient11_66_0_, workspace0_.patientNameComposition as patient12_66_0_, workspace0_.sendSystemMessages as sendSys13_66_0_, workspace0_.suspectCaseNumber as suspect14_66_0_, workspace0_.treatMonitoringInput as treatMo15_66_0_, workspace0_.weekFreq1 as weekFre16_66_0_, workspace0_.weekFreq2 as weekFre17_66_0_, workspace0_.weekFreq3 as weekFre18_66_0_, workspace0_.weekFreq4 as weekFre19_66_0_, workspace0_.weekFreq5 as weekFre20_66_0_, workspace0_.weekFreq6 as weekFre21_66_0_, workspace0_.weekFreq7 as weekFre22_66_0_ from workspace workspace0_ where workspace0_.id=?
Hibernate: select workspacev0_.id as id1_68_0_, workspacev0_.logoImage as logoImag2_68_0_, workspacev0_.picture as picture3_68_0_, workspacev0_.pictureContentType as pictureC4_68_0_, workspace1_.id as id1_66_1_, workspace1_.caseValidationDRTB as caseVali2_66_1_, workspace1_.caseValidationNTM as caseVali3_66_1_, workspace1_.caseValidationTB as caseVali4_66_1_, workspace1_.confirmedCaseNumber as confirme5_66_1_, workspace1_.customId as customId6_66_1_, workspace1_.maxStockOnHand as maxStock7_66_1_, workspace1_.minStockOnHand as minStock8_66_1_, workspace1_.monthsToAlertExpiredMedicines as monthsTo9_66_1_, workspace1_.name as name10_66_1_, workspace1_.patientAddrRequiredLevels as patient11_66_1_, workspace1_.patientNameComposition as patient12_66_1_, workspace1_.sendSystemMessages as sendSys13_66_1_, workspace1_.suspectCaseNumber as suspect14_66_1_, workspace1_.treatMonitoringInput as treatMo15_66_1_, workspace1_.weekFreq1 as weekFre16_66_1_, workspace1_.weekFreq2 as weekFre17_66_1_, workspace1_.weekFreq3 as weekFre18_66_1_, workspace1_.weekFreq4 as weekFre19_66_1_, workspace1_.weekFreq5 as weekFre20_66_1_, workspace1_.weekFreq6 as weekFre21_66_1_, workspace1_.weekFreq7 as weekFre22_66_1_ from workspaceview workspacev0_ left outer join workspace workspace1_ on workspacev0_.id=workspace1_.id where workspacev0_.id=?
Hibernate: select userworksp0_.id as id1_64_0_, user1_.id as id1_48_1_, workspace2_.id as id1_66_2_, userworksp0_.WORKSPACE_ID as WORKSPAC5_64_0_, userworksp0_.ADMINUNIT_ID as ADMINUNI6_64_0_, userworksp0_.administrator as administ2_64_0_, userworksp0_.playOtherUnits as playOthe3_64_0_, userworksp0_.UNIT_ID as UNIT_ID7_64_0_, userworksp0_.USER_ID as USER_ID8_64_0_, userworksp0_.USER_VIEW as USER_VIE4_64_0_, user1_.comments as comments2_48_1_, user1_.customId as customId3_48_1_, user1_.DEFAULTWORKSPACE_ID as DEFAULT14_48_1_, user1_.email as email4_48_1_, user1_.login as login5_48_1_, user1_.name as name6_48_1_, user1_.PARENTUSER_ID as PARENTU15_48_1_, user1_.password as password7_48_1_, user1_.pwdChangeRequest as pwdChang8_48_1_, user1_.registrationDate as registra9_48_1_, user1_.sendSystemMessages as sendSys10_48_1_, user1_.state as state11_48_1_, user1_.timeZone as timeZon12_48_1_, user1_.ulaAccepted as ulaAcce13_48_1_, workspace2_.caseValidationDRTB as caseVali2_66_2_, workspace2_.caseValidationNTM as caseVali3_66_2_, workspace2_.caseValidationTB as caseVali4_66_2_, workspace2_.confirmedCaseNumber as confirme5_66_2_, workspace2_.customId as customId6_66_2_, workspace2_.maxStockOnHand as maxStock7_66_2_, workspace2_.minStockOnHand as minStock8_66_2_, workspace2_.monthsToAlertExpiredMedicines as monthsTo9_66_2_, workspace2_.name as name10_66_2_, workspace2_.patientAddrRequiredLevels as patient11_66_2_, workspace2_.patientNameComposition as patient12_66_2_, workspace2_.sendSystemMessages as sendSys13_66_2_, workspace2_.suspectCaseNumber as suspect14_66_2_, workspace2_.treatMonitoringInput as treatMo15_66_2_, workspace2_.weekFreq1 as weekFre16_66_2_, workspace2_.weekFreq2 as weekFre17_66_2_, workspace2_.weekFreq3 as weekFre18_66_2_, workspace2_.weekFreq4 as weekFre19_66_2_, workspace2_.weekFreq5 as weekFre20_66_2_, workspace2_.weekFreq6 as weekFre21_66_2_, workspace2_.weekFreq7 as weekFre22_66_2_ from userworkspace userworksp0_ inner join sys_user user1_ on userworksp0_.USER_ID=user1_.id inner join workspace workspace2_ on userworksp0_.WORKSPACE_ID=workspace2_.id where userworksp0_.USER_ID=? and userworksp0_.WORKSPACE_ID=?
Hibernate: select unit0_.id as id2_59_0_, unit0_.WORKSPACE_ID as WORKSPA26_59_0_, unit0_.active as active3_59_0_, unit0_.ADDRESS as ADDRESS4_59_0_, unit0_.ADMINUNIT_ID as ADMINUN27_59_0_, unit0_.addressCompl as addressC5_59_0_, unit0_.zipcode as zipcode6_59_0_, unit0_.AUTHORIZERUNIT_ID as AUTHORI28_59_0_, unit0_.customId as customId7_59_0_, unit0_.inventoryCloseDate as inventor8_59_0_, unit0_.inventoryStartDate as inventor9_59_0_, unit0_.name as name10_59_0_, unit0_.receiveFromManufacturer as receive11_59_0_, unit0_.shipAddress as shipAdd12_59_0_, unit0_.SHIP_ADMINUNIT_ID as SHIP_AD29_59_0_, unit0_.shipAddressCompl as shipAdd13_59_0_, unit0_.shipZipCode as shipZip14_59_0_, unit0_.shipContactName as shipCon15_59_0_, unit0_.shipContactPhone as shipCon16_59_0_, unit0_.SUPPLIER_ID as SUPPLIE30_59_0_, unit0_.performCulture as perform17_59_0_, unit0_.performDst as perform18_59_0_, unit0_.performMicroscopy as perform19_59_0_, unit0_.performXpert as perform20_59_0_, unit0_.drtbFacility as drtbFac21_59_0_, unit0_.notificationUnit as notific22_59_0_, unit0_.ntmFacility as ntmFaci23_59_0_, unit0_.numDaysOrder as numDays24_59_0_, unit0_.tbFacility as tbFacil25_59_0_, unit0_.DISCRIMINATOR as DISCRIMI1_59_0_ from unit unit0_ where unit0_.id=?
Hibernate: select administra0_.id as id1_0_0_, administra0_.WORKSPACE_ID as WORKSPAC6_0_0_, administra0_.code as code2_0_0_, administra0_.COUNTRYSTRUCTURE_ID as COUNTRYS7_0_0_, administra0_.customId as customId3_0_0_, administra0_.name as name4_0_0_, administra0_.PARENT_ID as PARENT_I8_0_0_, administra0_.unitsCount as unitsCou5_0_0_, administra1_.id as id1_0_1_, administra1_.WORKSPACE_ID as WORKSPAC6_0_1_, administra1_.code as code2_0_1_, administra1_.COUNTRYSTRUCTURE_ID as COUNTRYS7_0_1_, administra1_.customId as customId3_0_1_, administra1_.name as name4_0_1_, administra1_.PARENT_ID as PARENT_I8_0_1_, administra1_.unitsCount as unitsCou5_0_1_ from administrativeunit administra0_ left outer join administrativeunit administra1_ on administra0_.PARENT_ID=administra1_.id where administra0_.id=?
Hibernate: select administra0_.id as col_0_0_, administra0_.name as col_1_0_, administra1_.id as col_2_0_, administra1_.name as col_3_0_, administra2_.id as col_4_0_, administra2_.name as col_5_0_, administra3_.id as col_6_0_, administra3_.name as col_7_0_, administra4_.id as col_8_0_, administra4_.name as col_9_0_ from administrativeunit administra0_ left outer join administrativeunit administra1_ on administra0_.PARENT_ID=administra1_.id left outer join administrativeunit administra2_ on administra1_.PARENT_ID=administra2_.id left outer join administrativeunit administra3_ on administra2_.PARENT_ID=administra3_.id left outer join administrativeunit administra4_ on administra3_.PARENT_ID=administra4_.id where administra0_.id=?
2016-05-26 22:06:30.850 INFO 6940 --- [ main] org.msh.etbm.test.TestSetup : User admin authenticated
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.047 sec - in org.msh.etbm.test.services.admin.UserViewOptionsTest
2016-05-26 22:06:30.850 INFO 6940 --- [ Thread-2] o.s.w.c.s.GenericWebApplicationContext : Closing org.springframework.web.context.support.GenericWebApplicationContext@723ca036: startup date [Thu May 26 22:06:05 EDT 2016]; root of context hierarchy
2016-05-26 22:06:30.866 INFO 6940 --- [ Thread-2] j.LocalContainerEntityManagerFactoryBean : Closing JPA EntityManagerFactory for persistence unit 'default'
Results :
Tests run: 31, Failures: 0, Errors: 0, Skipped: 0
[INFO]
[INFO] --- maven-jar-plugin:2.4:jar (default-jar) @ etbmanager ---
[INFO] Building jar: C:\apps\jenkins\workspace\eTBM 3 (master)\target\etbmanager-2.9.1.jar
[INFO]
[INFO] --- maven-dependency-plugin:2.10:copy (copy) @ etbmanager ---
[INFO] Configured Artifact: com.sun.winsw:winsw:bin:?:exe
[INFO] Copying winsw-1.18-bin.exe to C:\apps\jenkins\workspace\eTBM 3 (master)\target\dist\service.exe
[INFO]
[INFO] --- maven-assembly-plugin:2.5.5:single (assembly) @ etbmanager ---
[INFO] Reading assembly descriptor: src/main/assembly/unix.xml
[INFO] Reading assembly descriptor: src/main/assembly/windows.xml
[INFO] Building zip: C:\apps\jenkins\workspace\eTBM 3 (master)\target\etbmanager-2.9.1-unix.zip
[INFO] Building zip: C:\apps\jenkins\workspace\eTBM 3 (master)\target\etbmanager-2.9.1-windows.zip
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESS
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 03:12 min
[INFO] Finished at: 2016-05-26T22:06:36-04:00
[INFO] Final Memory: 47M/799M
[INFO] ------------------------------------------------------------------------
[locks-and-latches] Releasing all the locks
[locks-and-latches] All the locks released
Recording test results
Finished: SUCCESS
Console Output