classification as classifi7_25_, tbcase0_.comments as comments25_, tbcase0_.CURR_ADDRESS as CURR9_25_, tbcase0_.CURR_ADMINUNIT_ID as CURR53_25_, tbcase0_.CURR_COMPLEMENT as CURR10_25_, tbcase0_.CURR_LOCALITYTYPE as CURR11_25_, tbcase0_.CURR_ZIPCODE as CURR12_25_, tbcase0_.daysTreatPlanned as daysTre13_25_, tbcase0_.diagnosisDate as diagnos14_25_, tbcase0_.diagnosisType as diagnos15_25_, tbcase0_.drugResistanceType as drugRes16_25_, tbcase0_.otherExtrapulmonary as otherEx17_25_, tbcase0_.EXTRAPULMONARY_ID as EXTRAPU54_25_, tbcase0_.otherExtrapulmonary2 as otherEx18_25_, tbcase0_.EXTRAPULMONARY2_ID as EXTRAPU55_25_, tbcase0_.infectionSite as infecti19_25_, tbcase0_.iniContinuousPhase as iniCont20_25_, tbcase0_.initialRegimenWithSecondLineDrugs as initial21_25_, tbcase0_.issueCounter as issueCo22_25_, tbcase0_.lastBmuDateTbRegister as lastBmu23_25_, tbcase0_.lastBmuTbRegistNumber as lastBmu24_25_, tbcase0_.legacyId as legacyId25_, tbcase0_.mobileNumber as mobileN26_25_, tbcase0_.movedSecondLineTreatment as movedSe27_25_, tbcase0_.nationality as nationa28_25_, tbcase0_.NOTIF_ADDRESS as NOTIF29_25_, tbcase0_.NOTIF_ADMINUNIT_ID as NOTIF56_25_, tbcase0_.NOTIF_COMPLEMENT as NOTIF30_25_, tbcase0_.NOTIF_LOCALITYTYPE as NOTIF31_25_, tbcase0_.NOTIF_ZIPCODE as NOTIF32_25_, tbcase0_.notifAddressChanged as notifAd33_25_, tbcase0_.NOTIFICATION_UNIT_ID as NOTIFIC57_25_, tbcase0_.otherOutcome as otherOu34_25_, tbcase0_.outcomeDate as outcome35_25_, tbcase0_.OWNER_UNIT_ID as OWNER58_25_, tbcase0_.PATIENT_ID as PATIENT59_25_, tbcase0_.patientContactName as patient36_25_, tbcase0_.patientType as patient37_25_, tbcase0_.patientTypeOther as patient38_25_, tbcase0_.phoneNumber as phoneNu39_25_, tbcase0_.previouslyTreatedType as previou40_25_, tbcase0_.PULMONARY_ID as PULMONARY60_25_, tbcase0_.REGIMEN_ID as REGIMEN61_25_, tbcase0_.REGIMEN_INI_ID as REGIMEN62_25_, tbcase0_.registrationCode as registr41_25_, tbcase0_.registrationDate as registr42_25_, tbcase0_.secDrugsReceived as secDrug43_25_, tbcase0_.state as state25_, tbcase0_.suspectClassification as suspect45_25_, tbcase0_.suspectRegistrationCode as suspect46_25_, tbcase0_.tbContact as tbContact25_, tbcase0_.treatmentCategory as treatme48_25_, tbcase0_.endTreatmentDate as endTrea49_25_, tbcase0_.iniTreatmentDate as iniTrea50_25_, tbcase0_.validationState as validat51_25_, tbcase0_.version as version25_, tbcase0_1_.bcgScar as bcgScar36_, tbcase0_1_.followUpSmearStatus as followUp2_36_, tbcase0_1_.occupation as occupation36_, tbcase0_1_.PATIENTREFTO_ID as PATIENTR9_36_, tbcase0_1_.pulmonaryTypesBD as pulmonar4_36_, tbcase0_1_.REF_TO_DATE as REF5_36_, tbcase0_1_.referredToUnitName as referred6_36_, tbcase0_1_.salary as salary36_, case when tbcase0_1_.id is not null then 1 when tbcase0_.id is not null then 0 end as clazz_ from tbcase tbcase0_ left outer join tbcasebd tbcase0_1_ on tbcase0_.id=tbcase0_1_.id where tbcase0_.sync_serverId=?
Hibernate: insert into tags_case (case_id, tag_id) values (?, ?)
class org.msh.etbm.sync.CaseTag -> null
Hibernate: select tbcase0_.id as id25_, tbcase0_.sync_changed as sync2_25_, tbcase0_.sync_serverId as sync3_25_, tbcase0_.age as age25_, tbcase0_.caseDefinition as caseDefi5_25_, tbcase0_.caseNumber as caseNumber25_, tbcase0_.classification as classifi7_25_, tbcase0_.comments as comments25_, tbcase0_.CURR_ADDRESS as CURR9_25_, tbcase0_.CURR_ADMINUNIT_ID as CURR53_25_, tbcase0_.CURR_COMPLEMENT as CURR10_25_, tbcase0_.CURR_LOCALITYTYPE as CURR11_25_, tbcase0_.CURR_ZIPCODE as CURR12_25_, tbcase0_.daysTreatPlanned as daysTre13_25_, tbcase0_.diagnosisDate as diagnos14_25_, tbcase0_.diagnosisType as diagnos15_25_, tbcase0_.drugResistanceType as drugRes16_25_, tbcase0_.otherExtrapulmonary as otherEx17_25_, tbcase0_.EXTRAPULMONARY_ID as EXTRAPU54_25_, tbcase0_.otherExtrapulmonary2 as otherEx18_25_, tbcase0_.EXTRAPULMONARY2_ID as EXTRAPU55_25_, tbcase0_.infectionSite as infecti19_25_, tbcase0_.iniContinuousPhase as iniCont20_25_, tbcase0_.initialRegimenWithSecondLineDrugs as initial21_25_, tbcase0_.issueCounter as issueCo22_25_, tbcase0_.lastBmuDateTbRegister as lastBmu23_25_, tbcase0_.lastBmuTbRegistNumber as lastBmu24_25_, tbcase0_.legacyId as legacyId25_, tbcase0_.mobileNumber as mobileN26_25_, tbcase0_.movedSecondLineTreatment as movedSe27_25_, tbcase0_.nationality as nationa28_25_, tbcase0_.NOTIF_ADDRESS as NOTIF29_25_, tbcase0_.NOTIF_ADMINUNIT_ID as NOTIF56_25_, tbcase0_.NOTIF_COMPLEMENT as NOTIF30_25_, tbcase0_.NOTIF_LOCALITYTYPE as NOTIF31_25_, tbcase0_.NOTIF_ZIPCODE as NOTIF32_25_, tbcase0_.notifAddressChanged as notifAd33_25_, tbcase0_.NOTIFICATION_UNIT_ID as NOTIFIC57_25_, tbcase0_.otherOutcome as otherOu34_25_, tbcase0_.outcomeDate as outcome35_25_, tbcase0_.OWNER_UNIT_ID as OWNER58_25_, tbcase0_.PATIENT_ID as PATIENT59_25_, tbcase0_.patientContactName as patient36_25_, tbcase0_.patientType as patient37_25_, tbcase0_.patientTypeOther as patient38_25_, tbcase0_.phoneNumber as phoneNu39_25_, tbcase0_.previouslyTreatedType as previou40_25_, tbcase0_.PULMONARY_ID as PULMONARY60_25_, tbcase0_.REGIMEN_ID as REGIMEN61_25_, tbcase0_.REGIMEN_INI_ID as REGIMEN62_25_, tbcase0_.registrationCode as registr41_25_, tbcase0_.registrationDate as registr42_25_, tbcase0_.secDrugsReceived as secDrug43_25_, tbcase0_.state as state25_, tbcase0_.suspectClassification as suspect45_25_, tbcase0_.suspectRegistrationCode as suspect46_25_, tbcase0_.tbContact as tbContact25_, tbcase0_.treatmentCategory as treatme48_25_, tbcase0_.endTreatmentDate as endTrea49_25_, tbcase0_.iniTreatmentDate as iniTrea50_25_, tbcase0_.validationState as validat51_25_, tbcase0_.version as version25_, tbcase0_1_.bcgScar as bcgScar36_, tbcase0_1_.followUpSmearStatus as followUp2_36_, tbcase0_1_.occupation as occupation36_, tbcase0_1_.PATIENTREFTO_ID as PATIENTR9_36_, tbcase0_1_.pulmonaryTypesBD as pulmonar4_36_, tbcase0_1_.REF_TO_DATE as REF5_36_, tbcase0_1_.referredToUnitName as referred6_36_, tbcase0_1_.salary as salary36_, case when tbcase0_1_.id is not null then 1 when tbcase0_.id is not null then 0 end as clazz_ from tbcase tbcase0_ left outer join tbcasebd tbcase0_1_ on tbcase0_.id=tbcase0_1_.id where tbcase0_.sync_serverId=?
Hibernate: insert into tags_case (case_id, tag_id) values (?, ?)
class org.msh.etbm.sync.CaseTag -> null
Hibernate: select tbcase0_.id as id25_, tbcase0_.sync_changed as sync2_25_, tbcase0_.sync_serverId as sync3_25_, tbcase0_.age as age25_, tbcase0_.caseDefinition as caseDefi5_25_, tbcase0_.caseNumber as caseNumber25_, tbcase0_.classification as classifi7_25_, tbcase0_.comments as comments25_, tbcase0_.CURR_ADDRESS as CURR9_25_, tbcase0_.CURR_ADMINUNIT_ID as CURR53_25_, tbcase0_.CURR_COMPLEMENT as CURR10_25_, tbcase0_.CURR_LOCALITYTYPE as CURR11_25_, tbcase0_.CURR_ZIPCODE as CURR12_25_, tbcase0_.daysTreatPlanned as daysTre13_25_, tbcase0_.diagnosisDate as diagnos14_25_, tbcase0_.diagnosisType as diagnos15_25_, tbcase0_.drugResistanceType as drugRes16_25_, tbcase0_.otherExtrapulmonary as otherEx17_25_, tbcase0_.EXTRAPULMONARY_ID as EXTRAPU54_25_, tbcase0_.otherExtrapulmonary2 as otherEx18_25_, tbcase0_.EXTRAPULMONARY2_ID as EXTRAPU55_25_, tbcase0_.infectionSite as infecti19_25_, tbcase0_.iniContinuousPhase as iniCont20_25_, tbcase0_.initialRegimenWithSecondLineDrugs as initial21_25_, tbcase0_.issueCounter as issueCo22_25_, tbcase0_.lastBmuDateTbRegister as lastBmu23_25_, tbcase0_.lastBmuTbRegistNumber as lastBmu24_25_, tbcase0_.legacyId as legacyId25_, tbcase0_.mobileNumber as mobileN26_25_, tbcase0_.movedSecondLineTreatment as movedSe27_25_, tbcase0_.nationality as nationa28_25_, tbcase0_.NOTIF_ADDRESS as NOTIF29_25_, tbcase0_.NOTIF_ADMINUNIT_ID as NOTIF56_25_, tbcase0_.NOTIF_COMPLEMENT as NOTIF30_25_, tbcase0_.NOTIF_LOCALITYTYPE as NOTIF31_25_, tbcase0_.NOTIF_ZIPCODE as NOTIF32_25_, tbcase0_.notifAddressChanged as notifAd33_25_, tbcase0_.NOTIFICATION_UNIT_ID as NOTIFIC57_25_, tbcase0_.otherOutcome as otherOu34_25_, tbcase0_.outcomeDate as outcome35_25_, tbcase0_.OWNER_UNIT_ID as OWNER58_25_, tbcase0_.PATIENT_ID as PATIENT59_25_, tbcase0_.patientContactName as patient36_25_, tbcase0_.patientType as patient37_25_, tbcase0_.patientTypeOther as patient38_25_, tbcase0_.phoneNumber as phoneNu39_25_, tbcase0_.previouslyTreatedType as previou40_25_, tbcase0_.PULMONARY_ID as PULMONARY60_25_, tbcase0_.REGIMEN_ID as REGIMEN61_25_, tbcase0_.REGIMEN_INI_ID as REGIMEN62_25_, tbcase0_.registrationCode as registr41_25_, tbcase0_.registrationDate as registr42_25_, tbcase0_.secDrugsReceived as secDrug43_25_, tbcase0_.state as state25_, tbcase0_.suspectClassification as suspect45_25_, tbcase0_.suspectRegistrationCode as suspect46_25_, tbcase0_.tbContact as tbContact25_, tbcase0_.treatmentCategory as treatme48_25_, tbcase0_.endTreatmentDate as endTrea49_25_, tbcase0_.iniTreatmentDate as iniTrea50_25_, tbcase0_.validationState as validat51_25_, tbcase0_.version as version25_, tbcase0_1_.bcgScar as bcgScar36_, tbcase0_1_.followUpSmearStatus as followUp2_36_, tbcase0_1_.occupation as occupation36_, tbcase0_1_.PATIENTREFTO_ID as PATIENTR9_36_, tbcase0_1_.pulmonaryTypesBD as pulmonar4_36_, tbcase0_1_.REF_TO_DATE as REF5_36_, tbcase0_1_.referredToUnitName as referred6_36_, tbcase0_1_.salary as salary36_, case when tbcase0_1_.id is not null then 1 when tbcase0_.id is not null then 0 end as clazz_ from tbcase tbcase0_ left outer join tbcasebd tbcase0_1_ on tbcase0_.id=tbcase0_1_.id where tbcase0_.sync_serverId=?
Hibernate: insert into tags_case (case_id, tag_id) values (?, ?)
class org.msh.etbm.sync.CaseTag -> null
Hibernate: select tbcase0_.id as id25_, tbcase0_.sync_changed as sync2_25_, tbcase0_.sync_serverId as sync3_25_, tbcase0_.age as age25_, tbcase0_.caseDefinition as caseDefi5_25_, tbcase0_.caseNumber as caseNumber25_, tbcase0_.classification as classifi7_25_, tbcase0_.comments as comments25_, tbcase0_.CURR_ADDRESS as CURR9_25_, tbcase0_.CURR_ADMINUNIT_ID as CURR53_25_, tbcase0_.CURR_COMPLEMENT as CURR10_25_, tbcase0_.CURR_LOCALITYTYPE as CURR11_25_, tbcase0_.CURR_ZIPCODE as CURR12_25_, tbcase0_.daysTreatPlanned as daysTre13_25_, tbcase0_.diagnosisDate as diagnos14_25_, tbcase0_.diagnosisType as diagnos15_25_, tbcase0_.drugResistanceType as drugRes16_25_, tbcase0_.otherExtrapulmonary as otherEx17_25_, tbcase0_.EXTRAPULMONARY_ID as EXTRAPU54_25_, tbcase0_.otherExtrapulmonary2 as otherEx18_25_, tbcase0_.EXTRAPULMONARY2_ID as EXTRAPU55_25_, tbcase0_.infectionSite as infecti19_25_, tbcase0_.iniContinuousPhase as iniCont20_25_, tbcase0_.initialRegimenWithSecondLineDrugs as initial21_25_, tbcase0_.issueCounter as issueCo22_25_, tbcase0_.lastBmuDateTbRegister as lastBmu23_25_, tbcase0_.lastBmuTbRegistNumber as lastBmu24_25_, tbcase0_.legacyId as legacyId25_, tbcase0_.mobileNumber as mobileN26_25_, tbcase0_.movedSecondLineTreatment as movedSe27_25_, tbcase0_.nationality as nationa28_25_, tbcase0_.NOTIF_ADDRESS as NOTIF29_25_, tbcase0_.NOTIF_ADMINUNIT_ID as NOTIF56_25_, tbcase0_.NOTIF_COMPLEMENT as NOTIF30_25_, tbcase0_.NOTIF_LOCALITYTYPE as NOTIF31_25_, tbcase0_.NOTIF_ZIPCODE as NOTIF32_25_, tbcase0_.notifAddressChanged as notifAd33_25_, tbcase0_.NOTIFICATION_UNIT_ID as NOTIFIC57_25_, tbcase0_.otherOutcome as otherOu34_25_, tbcase0_.outcomeDate as outcome35_25_, tbcase0_.OWNER_UNIT_ID as OWNER58_25_, tbcase0_.PATIENT_ID as PATIENT59_25_, tbcase0_.patientContactName as patient36_25_, tbcase0_.patientType as patient37_25_, tbcase0_.patientTypeOther as patient38_25_, tbcase0_.phoneNumber as phoneNu39_25_, tbcase0_.previouslyTreatedType as previou40_25_, tbcase0_.PULMONARY_ID as PULMONARY60_25_, tbcase0_.REGIMEN_ID as REGIMEN61_25_, tbcase0_.REGIMEN_INI_ID as REGIMEN62_25_, tbcase0_.registrationCode as registr41_25_, tbcase0_.registrationDate as registr42_25_, tbcase0_.secDrugsReceived as secDrug43_25_, tbcase0_.state as state25_, tbcase0_.suspectClassification as suspect45_25_, tbcase0_.suspectRegistrationCode as suspect46_25_, tbcase0_.tbContact as tbContact25_, tbcase0_.treatmentCategory as treatme48_25_, tbcase0_.endTreatmentDate as endTrea49_25_, tbcase0_.iniTreatmentDate as iniTrea50_25_, tbcase0_.validationState as validat51_25_, tbcase0_.version as version25_, tbcase0_1_.bcgScar as bcgScar36_, tbcase0_1_.followUpSmearStatus as followUp2_36_, tbcase0_1_.occupation as occupation36_, tbcase0_1_.PATIENTREFTO_ID as PATIENTR9_36_, tbcase0_1_.pulmonaryTypesBD as pulmonar4_36_, tbcase0_1_.REF_TO_DATE as REF5_36_, tbcase0_1_.referredToUnitName as referred6_36_, tbcase0_1_.salary as salary36_, case when tbcase0_1_.id is not null then 1 when tbcase0_.id is not null then 0 end as clazz_ from tbcase tbcase0_ left outer join tbcasebd tbcase0_1_ on tbcase0_.id=tbcase0_1_.id where tbcase0_.sync_serverId=?
Hibernate: insert into tags_case (case_id, tag_id) values (?, ?)
class org.msh.etbm.sync.CaseTag -> null
Hibernate: select tbcase0_.id as id25_, tbcase0_.sync_changed as sync2_25_, tbcase0_.sync_serverId as sync3_25_, tbcase0_.age as age25_, tbcase0_.caseDefinition as caseDefi5_25_, tbcase0_.caseNumber as caseNumber25_, tbcase0_.classification as classifi7_25_, tbcase0_.comments as comments25_, tbcase0_.CURR_ADDRESS as CURR9_25_, tbcase0_.CURR_ADMINUNIT_ID as CURR53_25_, tbcase0_.CURR_COMPLEMENT as CURR10_25_, tbcase0_.CURR_LOCALITYTYPE as CURR11_25_, tbcase0_.CURR_ZIPCODE as CURR12_25_, tbcase0_.daysTreatPlanned as daysTre13_25_, tbcase0_.diagnosisDate as diagnos14_25_, tbcase0_.diagnosisType as diagnos15_25_, tbcase0_.drugResistanceType as drugRes16_25_, tbcase0_.otherExtrapulmonary as otherEx17_25_, tbcase0_.EXTRAPULMONARY_ID as EXTRAPU54_25_, tbcase0_.otherExtrapulmonary2 as otherEx18_25_, tbcase0_.EXTRAPULMONARY2_ID as EXTRAPU55_25_, tbcase0_.infectionSite as infecti19_25_, tbcase0_.iniContinuousPhase as iniCont20_25_, tbcase0_.initialRegimenWithSecondLineDrugs as initial21_25_, tbcase0_.issueCounter as issueCo22_25_, tbcase0_.lastBmuDateTbRegister as lastBmu23_25_, tbcase0_.lastBmuTbRegistNumber as lastBmu24_25_, tbcase0_.legacyId as legacyId25_, tbcase0_.mobileNumber as mobileN26_25_, tbcase0_.movedSecondLineTreatment as movedSe27_25_, tbcase0_.nationality as nationa28_25_, tbcase0_.NOTIF_ADDRESS as NOTIF29_25_, tbcase0_.NOTIF_ADMINUNIT_ID as NOTIF56_25_, tbcase0_.NOTIF_COMPLEMENT as NOTIF30_25_, tbcase0_.NOTIF_LOCALITYTYPE as NOTIF31_25_, tbcase0_.NOTIF_ZIPCODE as NOTIF32_25_, tbcase0_.notifAddressChanged as notifAd33_25_, tbcase0_.NOTIFICATION_UNIT_ID as NOTIFIC57_25_, tbcase0_.otherOutcome as otherOu34_25_, tbcase0_.outcomeDate as outcome35_25_, tbcase0_.OWNER_UNIT_ID as OWNER58_25_, tbcase0_.PATIENT_ID as PATIENT59_25_, tbcase0_.patientContactName as patient36_25_, tbcase0_.patientType as patient37_25_, tbcase0_.patientTypeOther as patient38_25_, tbcase0_.phoneNumber as phoneNu39_25_, tbcase0_.previouslyTreatedType as previou40_25_, tbcase0_.PULMONARY_ID as PULMONARY60_25_, tbcase0_.REGIMEN_ID as REGIMEN61_25_, tbcase0_.REGIMEN_INI_ID as REGIMEN62_25_, tbcase0_.registrationCode as registr41_25_, tbcase0_.registrationDate as registr42_25_, tbcase0_.secDrugsReceived as secDrug43_25_, tbcase0_.state as state25_, tbcase0_.suspectClassification as suspect45_25_, tbcase0_.suspectRegistrationCode as suspect46_25_, tbcase0_.tbContact as tbContact25_, tbcase0_.treatmentCategory as treatme48_25_, tbcase0_.endTreatmentDate as endTrea49_25_, tbcase0_.iniTreatmentDate as iniTrea50_25_, tbcase0_.validationState as validat51_25_, tbcase0_.version as version25_, tbcase0_1_.bcgScar as bcgScar36_, tbcase0_1_.followUpSmearStatus as followUp2_36_, tbcase0_1_.occupation as occupation36_, tbcase0_1_.PATIENTREFTO_ID as PATIENTR9_36_, tbcase0_1_.pulmonaryTypesBD as pulmonar4_36_, tbcase0_1_.REF_TO_DATE as REF5_36_, tbcase0_1_.referredToUnitName as referred6_36_, tbcase0_1_.salary as salary36_, case when tbcase0_1_.id is not null then 1 when tbcase0_.id is not null then 0 end as clazz_ from tbcase tbcase0_ left outer join tbcasebd tbcase0_1_ on tbcase0_.id=tbcase0_1_.id where tbcase0_.sync_serverId=?
Hibernate: insert into tags_case (case_id, tag_id) values (?, ?)
class org.msh.etbm.sync.CaseTag -> null
Hibernate: select tbcase0_.id as id25_, tbcase0_.sync_changed as sync2_25_, tbcase0_.sync_serverId as sync3_25_, tbcase0_.age as age25_, tbcase0_.caseDefinition as caseDefi5_25_, tbcase0_.caseNumber as caseNumber25_, tbcase0_.classification as classifi7_25_, tbcase0_.comments as comments25_, tbcase0_.CURR_ADDRESS as CURR9_25_, tbcase0_.CURR_ADMINUNIT_ID as CURR53_25_, tbcase0_.CURR_COMPLEMENT as CURR10_25_, tbcase0_.CURR_LOCALITYTYPE as CURR11_25_, tbcase0_.CURR_ZIPCODE as CURR12_25_, tbcase0_.daysTreatPlanned as daysTre13_25_, tbcase0_.diagnosisDate as diagnos14_25_, tbcase0_.diagnosisType as diagnos15_25_, tbcase0_.drugResistanceType as drugRes16_25_, tbcase0_.otherExtrapulmonary as otherEx17_25_, tbcase0_.EXTRAPULMONARY_ID as EXTRAPU54_25_, tbcase0_.otherExtrapulmonary2 as otherEx18_25_, tbcase0_.EXTRAPULMONARY2_ID as EXTRAPU55_25_, tbcase0_.infectionSite as infecti19_25_, tbcase0_.iniContinuousPhase as iniCont20_25_, tbcase0_.initialRegimenWithSecondLineDrugs as initial21_25_, tbcase0_.issueCounter as issueCo22_25_, tbcase0_.lastBmuDateTbRegister as lastBmu23_25_, tbcase0_.lastBmuTbRegistNumber as lastBmu24_25_, tbcase0_.legacyId as legacyId25_, tbcase0_.mobileNumber as mobileN26_25_, tbcase0_.movedSecondLineTreatment as movedSe27_25_, tbcase0_.nationality as nationa28_25_, tbcase0_.NOTIF_ADDRESS as NOTIF29_25_, tbcase0_.NOTIF_ADMINUNIT_ID as NOTIF56_25_, tbcase0_.NOTIF_COMPLEMENT as NOTIF30_25_, tbcase0_.NOTIF_LOCALITYTYPE as NOTIF31_25_, tbcase0_.NOTIF_ZIPCODE as NOTIF32_25_, tbcase0_.notifAddressChanged as notifAd33_25_, tbcase0_.NOTIFICATION_UNIT_ID as NOTIFIC57_25_, tbcase0_.otherOutcome as otherOu34_25_, tbcase0_.outcomeDate as outcome35_25_, tbcase0_.OWNER_UNIT_ID as OWNER58_25_, tbcase0_.PATIENT_ID as PATIENT59_25_, tbcase0_.patientContactName as patient36_25_, tbcase0_.patientType as patient37_25_, tbcase0_.patientTypeOther as patient38_25_, tbcase0_.phoneNumber as phoneNu39_25_, tbcase0_.previouslyTreatedType as previou40_25_, tbcase0_.PULMONARY_ID as PULMONARY60_25_, tbcase0_.REGIMEN_ID as REGIMEN61_25_, tbcase0_.REGIMEN_INI_ID as REGIMEN62_25_, tbcase0_.registrationCode as registr41_25_, tbcase0_.registrationDate as registr42_25_, tbcase0_.secDrugsReceived as secDrug43_25_, tbcase0_.state as state25_, tbcase0_.suspectClassification as suspect45_25_, tbcase0_.suspectRegistrationCode as suspect46_25_, tbcase0_.tbContact as tbContact25_, tbcase0_.treatmentCategory as treatme48_25_, tbcase0_.endTreatmentDate as endTrea49_25_, tbcase0_.iniTreatmentDate as iniTrea50_25_, tbcase0_.validationState as validat51_25_, tbcase0_.version as version25_, tbcase0_1_.bcgScar as bcgScar36_, tbcase0_1_.followUpSmearStatus as followUp2_36_, tbcase0_1_.occupation as occupation36_, tbcase0_1_.PATIENTREFTO_ID as PATIENTR9_36_, tbcase0_1_.pulmonaryTypesBD as pulmonar4_36_, tbcase0_1_.REF_TO_DATE as REF5_36_, tbcase0_1_.referredToUnitName as referred6_36_, tbcase0_1_.salary as salary36_, case when tbcase0_1_.id is not null then 1 when tbcase0_.id is not null then 0 end as clazz_ from tbcase tbcase0_ left outer join tbcasebd tbcase0_1_ on tbcase0_.id=tbcase0_1_.id where tbcase0_.sync_serverId=?
Hibernate: insert into tags_case (case_id, tag_id) values (?, ?)
class org.msh.etbm.sync.CaseTag -> null
Hibernate: select tbcase0_.id as id25_, tbcase0_.sync_changed as sync2_25_, tbcase0_.sync_serverId as sync3_25_, tbcase0_.age as age25_, tbcase0_.caseDefinition as caseDefi5_25_, tbcase0_.caseNumber as caseNumber25_, tbcase0_.classification as classifi7_25_, tbcase0_.comments as comments25_, tbcase0_.CURR_ADDRESS as CURR9_25_, tbcase0_.CURR_ADMINUNIT_ID as CURR53_25_, tbcase0_.CURR_COMPLEMENT as CURR10_25_, tbcase0_.CURR_LOCALITYTYPE as CURR11_25_, tbcase0_.CURR_ZIPCODE as CURR12_25_, tbcase0_.daysTreatPlanned as daysTre13_25_, tbcase0_.diagnosisDate as diagnos14_25_, tbcase0_.diagnosisType as diagnos15_25_, tbcase0_.drugResistanceType as drugRes16_25_, tbcase0_.otherExtrapulmonary as otherEx17_25_, tbcase0_.EXTRAPULMONARY_ID as EXTRAPU54_25_, tbcase0_.otherExtrapulmonary2 as otherEx18_25_, tbcase0_.EXTRAPULMONARY2_ID as EXTRAPU55_25_, tbcase0_.infectionSite as infecti19_25_, tbcase0_.iniContinuousPhase as iniCont20_25_, tbcase0_.initialRegimenWithSecondLineDrugs as initial21_25_, tbcase0_.issueCounter as issueCo22_25_, tbcase0_.lastBmuDateTbRegister as lastBmu23_25_, tbcase0_.lastBmuTbRegistNumber as lastBmu24_25_, tbcase0_.legacyId as legacyId25_, tbcase0_.mobileNumber as mobileN26_25_, tbcase0_.movedSecondLineTreatment as movedSe27_25_, tbcase0_.nationality as nationa28_25_, tbcase0_.NOTIF_ADDRESS as NOTIF29_25_, tbcase0_.NOTIF_ADMINUNIT_ID as NOTIF56_25_, tbcase0_.NOTIF_COMPLEMENT as NOTIF30_25_, tbcase0_.NOTIF_LOCALITYTYPE as NOTIF31_25_, tbcase0_.NOTIF_ZIPCODE as NOTIF32_25_, tbcase0_.notifAddressChanged as notifAd33_25_, tbcase0_.NOTIFICATION_UNIT_ID as NOTIFIC57_25_, tbcase0_.otherOutcome as otherOu34_25_, tbcase0_.outcomeDate as outcome35_25_, tbcase0_.OWNER_UNIT_ID as OWNER58_25_, tbcase0_.PATIENT_ID as PATIENT59_25_, tbcase0_.patientContactName as patient36_25_, tbcase0_.patientType as patient37_25_, tbcase0_.patientTypeOther as patient38_25_, tbcase0_.phoneNumber as phoneNu39_25_, tbcase0_.previouslyTreatedType as previou40_25_, tbcase0_.PULMONARY_ID as PULMONARY60_25_, tbcase0_.REGIMEN_ID as REGIMEN61_25_, tbcase0_.REGIMEN_INI_ID as REGIMEN62_25_, tbcase0_.registrationCode as registr41_25_, tbcase0_.registrationDate as registr42_25_, tbcase0_.secDrugsReceived as secDrug43_25_, tbcase0_.state as state25_, tbcase0_.suspectClassification as suspect45_25_, tbcase0_.suspectRegistrationCode as suspect46_25_, tbcase0_.tbContact as tbContact25_, tbcase0_.treatmentCategory as treatme48_25_, tbcase0_.endTreatmentDate as endTrea49_25_, tbcase0_.iniTreatmentDate as iniTrea50_25_, tbcase0_.validationState as validat51_25_, tbcase0_.version as version25_, tbcase0_1_.bcgScar as bcgScar36_, tbcase0_1_.followUpSmearStatus as followUp2_36_, tbcase0_1_.occupation as occupation36_, tbcase0_1_.PATIENTREFTO_ID as PATIENTR9_36_, tbcase0_1_.pulmonaryTypesBD as pulmonar4_36_, tbcase0_1_.REF_TO_DATE as REF5_36_, tbcase0_1_.referredToUnitName as referred6_36_, tbcase0_1_.salary as salary36_, case when tbcase0_1_.id is not null then 1 when tbcase0_.id is not null then 0 end as clazz_ from tbcase tbcase0_ left outer join tbcasebd tbcase0_1_ on tbcase0_.id=tbcase0_1_.id where tbcase0_.sync_serverId=?
Hibernate: insert into tags_case (case_id, tag_id) values (?, ?)
class org.msh.etbm.sync.CaseTag -> null
Hibernate: select tbcase0_.id as id25_, tbcase0_.sync_changed as sync2_25_, tbcase0_.sync_serverId as sync3_25_, tbcase0_.age as age25_, tbcase0_.caseDefinition as caseDefi5_25_, tbcase0_.caseNumber as caseNumber25_, tbcase0_.classification as classifi7_25_, tbcase0_.comments as comments25_, tbcase0_.CURR_ADDRESS as CURR9_25_, tbcase0_.CURR_ADMINUNIT_ID as CURR53_25_, tbcase0_.CURR_COMPLEMENT as CURR10_25_, tbcase0_.CURR_LOCALITYTYPE as CURR11_25_, tbcase0_.CURR_ZIPCODE as CURR12_25_, tbcase0_.daysTreatPlanned as daysTre13_25_, tbcase0_.diagnosisDate as diagnos14_25_, tbcase0_.diagnosisType as diagnos15_25_, tbcase0_.drugResistanceType as drugRes16_25_, tbcase0_.otherExtrapulmonary as otherEx17_25_, tbcase0_.EXTRAPULMONARY_ID as EXTRAPU54_25_, tbcase0_.otherExtrapulmonary2 as otherEx18_25_, tbcase0_.EXTRAPULMONARY2_ID as EXTRAPU55_25_, tbcase0_.infectionSite as infecti19_25_, tbcase0_.iniContinuousPhase as iniCont20_25_, tbcase0_.initialRegimenWithSecondLineDrugs as initial21_25_, tbcase0_.issueCounter as issueCo22_25_, tbcase0_.lastBmuDateTbRegister as lastBmu23_25_, tbcase0_.lastBmuTbRegistNumber as lastBmu24_25_, tbcase0_.legacyId as legacyId25_, tbcase0_.mobileNumber as mobileN26_25_, tbcase0_.movedSecondLineTreatment as movedSe27_25_, tbcase0_.nationality as nationa28_25_, tbcase0_.NOTIF_ADDRESS as NOTIF29_25_, tbcase0_.NOTIF_ADMINUNIT_ID as NOTIF56_25_, tbcase0_.NOTIF_COMPLEMENT as NOTIF30_25_, tbcase0_.NOTIF_LOCALITYTYPE as NOTIF31_25_, tbcase0_.NOTIF_ZIPCODE as NOTIF32_25_, tbcase0_.notifAddressChanged as notifAd33_25_, tbcase0_.NOTIFICATION_UNIT_ID as NOTIFIC57_25_, tbcase0_.otherOutcome as otherOu34_25_, tbcase0_.outcomeDate as outcome35_25_, tbcase0_.OWNER_UNIT_ID as OWNER58_25_, tbcase0_.PATIENT_ID as PATIENT59_25_, tbcase0_.patientContactName as patient36_25_, tbcase0_.patientType as patient37_25_, tbcase0_.patientTypeOther as patient38_25_, tbcase0_.phoneNumber as phoneNu39_25_, tbcase0_.previouslyTreatedType as previou40_25_, tbcase0_.PULMONARY_ID as PULMONARY60_25_, tbcase0_.REGIMEN_ID as REGIMEN61_25_, tbcase0_.REGIMEN_INI_ID as REGIMEN62_25_, tbcase0_.registrationCode as registr41_25_, tbcase0_.registrationDate as registr42_25_, tbcase0_.secDrugsReceived as secDrug43_25_, tbcase0_.state as state25_, tbcase0_.suspectClassification as suspect45_25_, tbcase0_.suspectRegistrationCode as suspect46_25_, tbcase0_.tbContact as tbContact25_, tbcase0_.treatmentCategory as treatme48_25_, tbcase0_.endTreatmentDate as endTrea49_25_, tbcase0_.iniTreatmentDate as iniTrea50_25_, tbcase0_.validationState as validat51_25_, tbcase0_.version as version25_, tbcase0_1_.bcgScar as bcgScar36_, tbcase0_1_.followUpSmearStatus as followUp2_36_, tbcase0_1_.occupation as occupation36_, tbcase0_1_.PATIENTREFTO_ID as PATIENTR9_36_, tbcase0_1_.pulmonaryTypesBD as pulmonar4_36_, tbcase0_1_.REF_TO_DATE as REF5_36_, tbcase0_1_.referredToUnitName as referred6_36_, tbcase0_1_.salary as salary36_, case when tbcase0_1_.id is not null then 1 when tbcase0_.id is not null then 0 end as clazz_ from tbcase tbcase0_ left outer join tbcasebd tbcase0_1_ on tbcase0_.id=tbcase0_1_.id where tbcase0_.sync_serverId=?
Hibernate: insert into tags_case (case_id, tag_id) values (?, ?)
class org.msh.etbm.sync.CaseTag -> null
Hibernate: select tbcase0_.id as id25_, tbcase0_.sync_changed as sync2_25_, tbcase0_.sync_serverId as sync3_25_, tbcase0_.age as age25_, tbcase0_.caseDefinition as caseDefi5_25_, tbcase0_.caseNumber as caseNumber25_, tbcase0_.classification as classifi7_25_, tbcase0_.comments as comments25_, tbcase0_.CURR_ADDRESS as CURR9_25_, tbcase0_.CURR_ADMINUNIT_ID as CURR53_25_, tbcase0_.CURR_COMPLEMENT as CURR10_25_, tbcase0_.CURR_LOCALITYTYPE as CURR11_25_, tbcase0_.CURR_ZIPCODE as CURR12_25_, tbcase0_.daysTreatPlanned as daysTre13_25_, tbcase0_.diagnosisDate as diagnos14_25_, tbcase0_.diagnosisType as diagnos15_25_, tbcase0_.drugResistanceType as drugRes16_25_, tbcase0_.otherExtrapulmonary as otherEx17_25_, tbcase0_.EXTRAPULMONARY_ID as EXTRAPU54_25_, tbcase0_.otherExtrapulmonary2 as otherEx18_25_, tbcase0_.EXTRAPULMONARY2_ID as EXTRAPU55_25_, tbcase0_.infectionSite as infecti19_25_, tbcase0_.iniContinuousPhase as iniCont20_25_, tbcase0_.initialRegimenWithSecondLineDrugs as initial21_25_, tbcase0_.issueCounter as issueCo22_25_, tbcase0_.lastBmuDateTbRegister as lastBmu23_25_, tbcase0_.lastBmuTbRegistNumber as lastBmu24_25_, tbcase0_.legacyId as legacyId25_, tbcase0_.mobileNumber as mobileN26_25_, tbcase0_.movedSecondLineTreatment as movedSe27_25_, tbcase0_.nationality as nationa28_25_, tbcase0_.NOTIF_ADDRESS as NOTIF29_25_, tbcase0_.NOTIF_ADMINUNIT_ID as NOTIF56_25_, tbcase0_.NOTIF_COMPLEMENT as NOTIF30_25_, tbcase0_.NOTIF_LOCALITYTYPE as NOTIF31_25_, tbcase0_.NOTIF_ZIPCODE as NOTIF32_25_, tbcase0_.notifAddressChanged as notifAd33_25_, tbcase0_.NOTIFICATION_UNIT_ID as NOTIFIC57_25_, tbcase0_.otherOutcome as otherOu34_25_, tbcase0_.outcomeDate as outcome35_25_, tbcase0_.OWNER_UNIT_ID as OWNER58_25_, tbcase0_.PATIENT_ID as PATIENT59_25_, tbcase0_.patientContactName as patient36_25_, tbcase0_.patientType as patient37_25_, tbcase0_.patientTypeOther as patient38_25_, tbcase0_.phoneNumber as phoneNu39_25_, tbcase0_.previouslyTreatedType as previou40_25_, tbcase0_.PULMONARY_ID as PULMONARY60_25_, tbcase0_.REGIMEN_ID as REGIMEN61_25_, tbcase0_.REGIMEN_INI_ID as REGIMEN62_25_, tbcase0_.registrationCode as registr41_25_, tbcase0_.registrationDate as registr42_25_, tbcase0_.secDrugsReceived as secDrug43_25_, tbcase0_.state as state25_, tbcase0_.suspectClassification as suspect45_25_, tbcase0_.suspectRegistrationCode as suspect46_25_, tbcase0_.tbContact as tbContact25_, tbcase0_.treatmentCategory as treatme48_25_, tbcase0_.endTreatmentDate as endTrea49_25_, tbcase0_.iniTreatmentDate as iniTrea50_25_, tbcase0_.validationState as validat51_25_, tbcase0_.version as version25_, tbcase0_1_.bcgScar as bcgScar36_, tbcase0_1_.followUpSmearStatus as followUp2_36_, tbcase0_1_.occupation as occupation36_, tbcase0_1_.PATIENTREFTO_ID as PATIENTR9_36_, tbcase0_1_.pulmonaryTypesBD as pulmonar4_36_, tbcase0_1_.REF_TO_DATE as REF5_36_, tbcase0_1_.referredToUnitName as referred6_36_, tbcase0_1_.salary as salary36_, case when tbcase0_1_.id is not null then 1 when tbcase0_.id is not null then 0 end as clazz_ from tbcase tbcase0_ left outer join tbcasebd tbcase0_1_ on tbcase0_.id=tbcase0_1_.id where tbcase0_.sync_serverId=?
Hibernate: insert into tags_case (case_id, tag_id) values (?, ?)
class org.msh.etbm.sync.CaseTag -> null
Hibernate: select tbcase0_.id as id25_, tbcase0_.sync_changed as sync2_25_, tbcase0_.sync_serverId as sync3_25_, tbcase0_.age as age25_, tbcase0_.caseDefinition as caseDefi5_25_, tbcase0_.caseNumber as caseNumber25_, tbcase0_.classification as classifi7_25_, tbcase0_.comments as comments25_, tbcase0_.CURR_ADDRESS as CURR9_25_, tbcase0_.CURR_ADMINUNIT_ID as CURR53_25_, tbcase0_.CURR_COMPLEMENT as CURR10_25_, tbcase0_.CURR_LOCALITYTYPE as CURR11_25_, tbcase0_.CURR_ZIPCODE as CURR12_25_, tbcase0_.daysTreatPlanned as daysTre13_25_, tbcase0_.diagnosisDate as diagnos14_25_, tbcase0_.diagnosisType as diagnos15_25_, tbcase0_.drugResistanceType as drugRes16_25_, tbcase0_.otherExtrapulmonary as otherEx17_25_, tbcase0_.EXTRAPULMONARY_ID as EXTRAPU54_25_, tbcase0_.otherExtrapulmonary2 as otherEx18_25_, tbcase0_.EXTRAPULMONARY2_ID as EXTRAPU55_25_, tbcase0_.infectionSite as infecti19_25_, tbcase0_.iniContinuousPhase as iniCont20_25_, tbcase0_.initialRegimenWithSecondLineDrugs as initial21_25_, tbcase0_.issueCounter as issueCo22_25_, tbcase0_.lastBmuDateTbRegister as lastBmu23_25_, tbcase0_.lastBmuTbRegistNumber as lastBmu24_25_, tbcase0_.legacyId as legacyId25_, tbcase0_.mobileNumber as mobileN26_25_, tbcase0_.movedSecondLineTreatment as movedSe27_25_, tbcase0_.nationality as nationa28_25_, tbcase0_.NOTIF_ADDRESS as NOTIF29_25_, tbcase0_.NOTIF_ADMINUNIT_ID as NOTIF56_25_, tbcase0_.NOTIF_COMPLEMENT as NOTIF30_25_, tbcase0_.NOTIF_LOCALITYTYPE as NOTIF31_25_, tbcase0_.NOTIF_ZIPCODE as NOTIF32_25_, tbcase0_.notifAddressChanged as notifAd33_25_, tbcase0_.NOTIFICATION_UNIT_ID as NOTIFIC57_25_, tbcase0_.otherOutcome as otherOu34_25_, tbcase0_.outcomeDate as outcome35_25_, tbcase0_.OWNER_UNIT_ID as OWNER58_25_, tbcase0_.PATIENT_ID as PATIENT59_25_, tbcase0_.patientContactName as patient36_25_, tbcase0_.patientType as patient37_25_, tbcase0_.patientTypeOther as patient38_25_, tbcase0_.phoneNumber as phoneNu39_25_, tbcase0_.previouslyTreatedType as previou40_25_, tbcase0_.PULMONARY_ID as PULMONARY60_25_, tbcase0_.REGIMEN_ID as REGIMEN61_25_, tbcase0_.REGIMEN_INI_ID as REGIMEN62_25_, tbcase0_.registrationCode as registr41_25_, tbcase0_.registrationDate as registr42_25_, tbcase0_.secDrugsReceived as secDrug43_25_, tbcase0_.state as state25_, tbcase0_.suspectClassification as suspect45_25_, tbcase0_.suspectRegistrationCode as suspect46_25_, tbcase0_.tbContact as tbContact25_, tbcase0_.treatmentCategory as treatme48_25_, tbcase0_.endTreatmentDate as endTrea49_25_, tbcase0_.iniTreatmentDate as iniTrea50_25_, tbcase0_.validationState as validat51_25_, tbcase0_.version as version25_, tbcase0_1_.bcgScar as bcgScar36_, tbcase0_1_.followUpSmearStatus as followUp2_36_, tbcase0_1_.occupation as occupation36_, tbcase0_1_.PATIENTREFTO_ID as PATIENTR9_36_, tbcase0_1_.pulmonaryTypesBD as pulmonar4_36_, tbcase0_1_.REF_TO_DATE as REF5_36_, tbcase0_1_.referredToUnitName as referred6_36_, tbcase0_1_.salary as salary36_, case when tbcase0_1_.id is not null then 1 when tbcase0_.id is not null then 0 end as clazz_ from tbcase tbcase0_ left outer join tbcasebd tbcase0_1_ on tbcase0_.id=tbcase0_1_.id where tbcase0_.sync_serverId=?
Hibernate: insert into tags_case (case_id, tag_id) values (?, ?)
class org.msh.etbm.sync.CaseTag -> null
Hibernate: select tbcase0_.id as id25_, tbcase0_.sync_changed as sync2_25_, tbcase0_.sync_serverId as sync3_25_, tbcase0_.age as age25_, tbcase0_.caseDefinition as caseDefi5_25_, tbcase0_.caseNumber as caseNumber25_, tbcase0_.classification as classifi7_25_, tbcase0_.comments as comments25_, tbcase0_.CURR_ADDRESS as CURR9_25_, tbcase0_.CURR_ADMINUNIT_ID as CURR53_25_, tbcase0_.CURR_COMPLEMENT as CURR10_25_, tbcase0_.CURR_LOCALITYTYPE as CURR11_25_, tbcase0_.CURR_ZIPCODE as CURR12_25_, tbcase0_.daysTreatPlanned as daysTre13_25_, tbcase0_.diagnosisDate as diagnos14_25_, tbcase0_.diagnosisType as diagnos15_25_, tbcase0_.drugResistanceType as drugRes16_25_, tbcase0_.otherExtrapulmonary as otherEx17_25_, tbcase0_.EXTRAPULMONARY_ID as EXTRAPU54_25_, tbcase0_.otherExtrapulmonary2 as otherEx18_25_, tbcase0_.EXTRAPULMONARY2_ID as EXTRAPU55_25_, tbcase0_.infectionSite as infecti19_25_, tbcase0_.iniContinuousPhase as iniCont20_25_, tbcase0_.initialRegimenWithSecondLineDrugs as initial21_25_, tbcase0_.issueCounter as issueCo22_25_, tbcase0_.lastBmuDateTbRegister as lastBmu23_25_, tbcase0_.lastBmuTbRegistNumber as lastBmu24_25_, tbcase0_.legacyId as legacyId25_, tbcase0_.mobileNumber as mobileN26_25_, tbcase0_.movedSecondLineTreatment as movedSe27_25_, tbcase0_.nationality as nationa28_25_, tbcase0_.NOTIF_ADDRESS as NOTIF29_25_, tbcase0_.NOTIF_ADMINUNIT_ID as NOTIF56_25_, tbcase0_.NOTIF_COMPLEMENT as NOTIF30_25_, tbcase0_.NOTIF_LOCALITYTYPE as NOTIF31_25_, tbcase0_.NOTIF_ZIPCODE as NOTIF32_25_, tbcase0_.notifAddressChanged as notifAd33_25_, tbcase0_.NOTIFICATION_UNIT_ID as NOTIFIC57_25_, tbcase0_.otherOutcome as otherOu34_25_, tbcase0_.outcomeDate as outcome35_25_, tbcase0_.OWNER_UNIT_ID as OWNER58_25_, tbcase0_.PATIENT_ID as PATIENT59_25_, tbcase0_.patientContactName as patient36_25_, tbcase0_.patientType as patient37_25_, tbcase0_.patientTypeOther as patient38_25_, tbcase0_.phoneNumber as phoneNu39_25_, tbcase0_.previouslyTreatedType as previou40_25_, tbcase0_.PULMONARY_ID as PULMONARY60_25_, tbcase0_.REGIMEN_ID as REGIMEN61_25_, tbcase0_.REGIMEN_INI_ID as REGIMEN62_25_, tbcase0_.registrationCode as registr41_25_, tbcase0_.registrationDate as registr42_25_, tbcase0_.secDrugsReceived as secDrug43_25_, tbcase0_.state as state25_, tbcase0_.suspectClassification as suspect45_25_, tbcase0_.suspectRegistrationCode as suspect46_25_, tbcase0_.tbContact as tbContact25_, tbcase0_.treatmentCategory as treatme48_25_, tbcase0_.endTreatmentDate as endTrea49_25_, tbcase0_.iniTreatmentDate as iniTrea50_25_, tbcase0_.validationState as validat51_25_, tbcase0_.version as version25_, tbcase0_1_.bcgScar as bcgScar36_, tbcase0_1_.followUpSmearStatus as followUp2_36_, tbcase0_1_.occupation as occupation36_, tbcase0_1_.PATIENTREFTO_ID as PATIENTR9_36_, tbcase0_1_.pulmonaryTypesBD as pulmonar4_36_, tbcase0_1_.REF_TO_DATE as REF5_36_, tbcase0_1_.referredToUnitName as referred6_36_, tbcase0_1_.salary as salary36_, case when tbcase0_1_.id is not null then 1 when tbcase0_.id is not null then 0 end as clazz_ from tbcase tbcase0_ left outer join tbcasebd tbcase0_1_ on tbcase0_.id=tbcase0_1_.id where tbcase0_.sync_serverId=?
Hibernate: insert into tags_case (case_id, tag_id) values (?, ?)
class org.msh.etbm.sync.CaseTag -> null
Hibernate: select tbcase0_.id as id25_, tbcase0_.sync_changed as sync2_25_, tbcase0_.sync_serverId as sync3_25_, tbcase0_.age as age25_, tbcase0_.caseDefinition as caseDefi5_25_, tbcase0_.caseNumber as caseNumber25_, tbcase0_.classification as classifi7_25_, tbcase0_.comments as comments25_, tbcase0_.CURR_ADDRESS as CURR9_25_, tbcase0_.CURR_ADMINUNIT_ID as CURR53_25_, tbcase0_.CURR_COMPLEMENT as CURR10_25_, tbcase0_.CURR_LOCALITYTYPE as CURR11_25_, tbcase0_.CURR_ZIPCODE as CURR12_25_, tbcase0_.daysTreatPlanned as daysTre13_25_, tbcase0_.diagnosisDate as diagnos14_25_, tbcase0_.diagnosisType as diagnos15_25_, tbcase0_.drugResistanceType as drugRes16_25_, tbcase0_.otherExtrapulmonary as otherEx17_25_, tbcase0_.EXTRAPULMONARY_ID as EXTRAPU54_25_, tbcase0_.otherExtrapulmonary2 as otherEx18_25_, tbcase0_.EXTRAPULMONARY2_ID as EXTRAPU55_25_, tbcase0_.infectionSite as infecti19_25_, tbcase0_.iniContinuousPhase as iniCont20_25_, tbcase0_.initialRegimenWithSecondLineDrugs as initial21_25_, tbcase0_.issueCounter as issueCo22_25_, tbcase0_.lastBmuDateTbRegister as lastBmu23_25_, tbcase0_.lastBmuTbRegistNumber as lastBmu24_25_, tbcase0_.legacyId as legacyId25_, tbcase0_.mobileNumber as mobileN26_25_, tbcase0_.movedSecondLineTreatment as movedSe27_25_, tbcase0_.nationality as nationa28_25_, tbcase0_.NOTIF_ADDRESS as NOTIF29_25_, tbcase0_.NOTIF_ADMINUNIT_ID as NOTIF56_25_, tbcase0_.NOTIF_COMPLEMENT as NOTIF30_25_, tbcase0_.NOTIF_LOCALITYTYPE as NOTIF31_25_, tbcase0_.NOTIF_ZIPCODE as NOTIF32_25_, tbcase0_.notifAddressChanged as notifAd33_25_, tbcase0_.NOTIFICATION_UNIT_ID as NOTIFIC57_25_, tbcase0_.otherOutcome as otherOu34_25_, tbcase0_.outcomeDate as outcome35_25_, tbcase0_.OWNER_UNIT_ID as OWNER58_25_, tbcase0_.PATIENT_ID as PATIENT59_25_, tbcase0_.patientContactName as patient36_25_, tbcase0_.patientType as patient37_25_, tbcase0_.patientTypeOther as patient38_25_, tbcase0_.phoneNumber as phoneNu39_25_, tbcase0_.previouslyTreatedType as previou40_25_, tbcase0_.PULMONARY_ID as PULMONARY60_25_, tbcase0_.REGIMEN_ID as REGIMEN61_25_, tbcase0_.REGIMEN_INI_ID as REGIMEN62_25_, tbcase0_.registrationCode as registr41_25_, tbcase0_.registrationDate as registr42_25_, tbcase0_.secDrugsReceived as secDrug43_25_, tbcase0_.state as state25_, tbcase0_.suspectClassification as suspect45_25_, tbcase0_.suspectRegistrationCode as suspect46_25_, tbcase0_.tbContact as tbContact25_, tbcase0_.treatmentCategory as treatme48_25_, tbcase0_.endTreatmentDate as endTrea49_25_, tbcase0_.iniTreatmentDate as iniTrea50_25_, tbcase0_.validationState as validat51_25_, tbcase0_.version as version25_, tbcase0_1_.bcgScar as bcgScar36_, tbcase0_1_.followUpSmearStatus as followUp2_36_, tbcase0_1_.occupation as occupation36_, tbcase0_1_.PATIENTREFTO_ID as PATIENTR9_36_, tbcase0_1_.pulmonaryTypesBD as pulmonar4_36_, tbcase0_1_.REF_TO_DATE as REF5_36_, tbcase0_1_.referredToUnitName as referred6_36_, tbcase0_1_.salary as salary36_, case when tbcase0_1_.id is not null then 1 when tbcase0_.id is not null then 0 end as clazz_ from tbcase tbcase0_ left outer join tbcasebd tbcase0_1_ on tbcase0_.id=tbcase0_1_.id where tbcase0_.sync_serverId=?
Hibernate: insert into tags_case (case_id, tag_id) values (?, ?)
class org.msh.etbm.sync.CaseTag -> null
Hibernate: select tbcase0_.id as id25_, tbcase0_.sync_changed as sync2_25_, tbcase0_.sync_serverId as sync3_25_, tbcase0_.age as age25_, tbcase0_.caseDefinition as caseDefi5_25_, tbcase0_.caseNumber as caseNumber25_, tbcase0_.classification as classifi7_25_, tbcase0_.comments as comments25_, tbcase0_.CURR_ADDRESS as CURR9_25_, tbcase0_.CURR_ADMINUNIT_ID as CURR53_25_, tbcase0_.CURR_COMPLEMENT as CURR10_25_, tbcase0_.CURR_LOCALITYTYPE as CURR11_25_, tbcase0_.CURR_ZIPCODE as CURR12_25_, tbcase0_.daysTreatPlanned as daysTre13_25_, tbcase0_.diagnosisDate as diagnos14_25_, tbcase0_.diagnosisType as diagnos15_25_, tbcase0_.drugResistanceType as drugRes16_25_, tbcase0_.otherExtrapulmonary as otherEx17_25_, tbcase0_.EXTRAPULMONARY_ID as EXTRAPU54_25_, tbcase0_.otherExtrapulmonary2 as otherEx18_25_, tbcase0_.EXTRAPULMONARY2_ID as EXTRAPU55_25_, tbcase0_.infectionSite as infecti19_25_, tbcase0_.iniContinuousPhase as iniCont20_25_, tbcase0_.initialRegimenWithSecondLineDrugs as initial21_25_, tbcase0_.issueCounter as issueCo22_25_, tbcase0_.lastBmuDateTbRegister as lastBmu23_25_, tbcase0_.lastBmuTbRegistNumber as lastBmu24_25_, tbcase0_.legacyId as legacyId25_, tbcase0_.mobileNumber as mobileN26_25_, tbcase0_.movedSecondLineTreatment as movedSe27_25_, tbcase0_.nationality as nationa28_25_, tbcase0_.NOTIF_ADDRESS as NOTIF29_25_, tbcase0_.NOTIF_ADMINUNIT_ID as NOTIF56_25_, tbcase0_.NOTIF_COMPLEMENT as NOTIF30_25_, tbcase0_.NOTIF_LOCALITYTYPE as NOTIF31_25_, tbcase0_.NOTIF_ZIPCODE as NOTIF32_25_, tbcase0_.notifAddressChanged as notifAd33_25_, tbcase0_.NOTIFICATION_UNIT_ID as NOTIFIC57_25_, tbcase0_.otherOutcome as otherOu34_25_, tbcase0_.outcomeDate as outcome35_25_, tbcase0_.OWNER_UNIT_ID as OWNER58_25_, tbcase0_.PATIENT_ID as PATIENT59_25_, tbcase0_.patientContactName as patient36_25_, tbcase0_.patientType as patient37_25_, tbcase0_.patientTypeOther as patient38_25_, tbcase0_.phoneNumber as phoneNu39_25_, tbcase0_.previouslyTreatedType as previou40_25_, tbcase0_.PULMONARY_ID as PULMONARY60_25_, tbcase0_.REGIMEN_ID as REGIMEN61_25_, tbcase0_.REGIMEN_INI_ID as REGIMEN62_25_, tbcase0_.registrationCode as registr41_25_, tbcase0_.registrationDate as registr42_25_, tbcase0_.secDrugsReceived as secDrug43_25_, tbcase0_.state as state25_, tbcase0_.suspectClassification as suspect45_25_, tbcase0_.suspectRegistrationCode as suspect46_25_, tbcase0_.tbContact as tbContact25_, tbcase0_.treatmentCategory as treatme48_25_, tbcase0_.endTreatmentDate as endTrea49_25_, tbcase0_.iniTreatmentDate as iniTrea50_25_, tbcase0_.validationState as validat51_25_, tbcase0_.version as version25_, tbcase0_1_.bcgScar as bcgScar36_, tbcase0_1_.followUpSmearStatus as followUp2_36_, tbcase0_1_.occupation as occupation36_, tbcase0_1_.PATIENTREFTO_ID as PATIENTR9_36_, tbcase0_1_.pulmonaryTypesBD as pulmonar4_36_, tbcase0_1_.REF_TO_DATE as REF5_36_, tbcase0_1_.referredToUnitName as referred6_36_, tbcase0_1_.salary as salary36_, case when tbcase0_1_.id is not null then 1 when tbcase0_.id is not null then 0 end as clazz_ from tbcase tbcase0_ left outer join tbcasebd tbcase0_1_ on tbcase0_.id=tbcase0_1_.id where tbcase0_.sync_serverId=?
Hibernate: insert into tags_case (case_id, tag_id) values (?, ?)
class org.msh.etbm.sync.CaseTag -> null
Hibernate: select tbcase0_.id as id25_, tbcase0_.sync_changed as sync2_25_, tbcase0_.sync_serverId as sync3_25_, tbcase0_.age as age25_, tbcase0_.caseDefinition as caseDefi5_25_, tbcase0_.caseNumber as caseNumber25_, tbcase0_.classification as classifi7_25_, tbcase0_.comments as comments25_, tbcase0_.CURR_ADDRESS as CURR9_25_, tbcase0_.CURR_ADMINUNIT_ID as CURR53_25_, tbcase0_.CURR_COMPLEMENT as CURR10_25_, tbcase0_.CURR_LOCALITYTYPE as CURR11_25_, tbcase0_.CURR_ZIPCODE as CURR12_25_, tbcase0_.daysTreatPlanned as daysTre13_25_, tbcase0_.diagnosisDate as diagnos14_25_, tbcase0_.diagnosisType as diagnos15_25_, tbcase0_.drugResistanceType as drugRes16_25_, tbcase0_.otherExtrapulmonary as otherEx17_25_, tbcase0_.EXTRAPULMONARY_ID as EXTRAPU54_25_, tbcase0_.otherExtrapulmonary2 as otherEx18_25_, tbcase0_.EXTRAPULMONARY2_ID as EXTRAPU55_25_, tbcase0_.infectionSite as infecti19_25_, tbcase0_.iniContinuousPhase as iniCont20_25_, tbcase0_.initialRegimenWithSecondLineDrugs as initial21_25_, tbcase0_.issueCounter as issueCo22_25_, tbcase0_.lastBmuDateTbRegister as lastBmu23_25_, tbcase0_.lastBmuTbRegistNumber as lastBmu24_25_, tbcase0_.legacyId as legacyId25_, tbcase0_.mobileNumber as mobileN26_25_, tbcase0_.movedSecondLineTreatment as movedSe27_25_, tbcase0_.nationality as nationa28_25_, tbcase0_.NOTIF_ADDRESS as NOTIF29_25_, tbcase0_.NOTIF_ADMINUNIT_ID as NOTIF56_25_, tbcase0_.NOTIF_COMPLEMENT as NOTIF30_25_, tbcase0_.NOTIF_LOCALITYTYPE as NOTIF31_25_, tbcase0_.NOTIF_ZIPCODE as NOTIF32_25_, tbcase0_.notifAddressChanged as notifAd33_25_, tbcase0_.NOTIFICATION_UNIT_ID as NOTIFIC57_25_, tbcase0_.otherOutcome as otherOu34_25_, tbcase0_.outcomeDate as outcome35_25_, tbcase0_.OWNER_UNIT_ID as OWNER58_25_, tbcase0_.PATIENT_ID as PATIENT59_25_, tbcase0_.patientContactName as patient36_25_, tbcase0_.patientType as patient37_25_, tbcase0_.patientTypeOther as patient38_25_, tbcase0_.phoneNumber as phoneNu39_25_, tbcase0_.previouslyTreatedType as previou40_25_, tbcase0_.PULMONARY_ID as PULMONARY60_25_, tbcase0_.REGIMEN_ID as REGIMEN61_25_, tbcase0_.REGIMEN_INI_ID as REGIMEN62_25_, tbcase0_.registrationCode as registr41_25_, tbcase0_.registrationDate as registr42_25_, tbcase0_.secDrugsReceived as secDrug43_25_, tbcase0_.state as state25_, tbcase0_.suspectClassification as suspect45_25_, tbcase0_.suspectRegistrationCode as suspect46_25_, tbcase0_.tbContact as tbContact25_, tbcase0_.treatmentCategory as treatme48_25_, tbcase0_.endTreatmentDate as endTrea49_25_, tbcase0_.iniTreatmentDate as iniTrea50_25_, tbcase0_.validationState as validat51_25_, tbcase0_.version as version25_, tbcase0_1_.bcgScar as bcgScar36_, tbcase0_1_.followUpSmearStatus as followUp2_36_, tbcase0_1_.occupation as occupation36_, tbcase0_1_.PATIENTREFTO_ID as PATIENTR9_36_, tbcase0_1_.pulmonaryTypesBD as pulmonar4_36_, tbcase0_1_.REF_TO_DATE as REF5_36_, tbcase0_1_.referredToUnitName as referred6_36_, tbcase0_1_.salary as salary36_, case when tbcase0_1_.id is not null then 1 when tbcase0_.id is not null then 0 end as clazz_ from tbcase tbcase0_ left outer join tbcasebd tbcase0_1_ on tbcase0_.id=tbcase0_1_.id where tbcase0_.sync_serverId=?
Hibernate: insert into tags_case (case_id, tag_id) values (?, ?)
class org.msh.etbm.sync.CaseTag -> null
Hibernate: select tbcase0_.id as id25_, tbcase0_.sync_changed as sync2_25_, tbcase0_.sync_serverId as sync3_25_, tbcase0_.age as age25_, tbcase0_.caseDefinition as caseDefi5_25_, tbcase0_.caseNumber as caseNumber25_, tbcase0_.classification as classifi7_25_, tbcase0_.comments as comments25_, tbcase0_.CURR_ADDRESS as CURR9_25_, tbcase0_.CURR_ADMINUNIT_ID as CURR53_25_, tbcase0_.CURR_COMPLEMENT as CURR10_25_, tbcase0_.CURR_LOCALITYTYPE as CURR11_25_, tbcase0_.CURR_ZIPCODE as CURR12_25_, tbcase0_.daysTreatPlanned as daysTre13_25_, tbcase0_.diagnosisDate as diagnos14_25_, tbcase0_.diagnosisType as diagnos15_25_, tbcase0_.drugResistanceType as drugRes16_25_, tbcase0_.otherExtrapulmonary as otherEx17_25_, tbcase0_.EXTRAPULMONARY_ID as EXTRAPU54_25_, tbcase0_.otherExtrapulmonary2 as otherEx18_25_, tbcase0_.EXTRAPULMONARY2_ID as EXTRAPU55_25_, tbcase0_.infectionSite as infecti19_25_, tbcase0_.iniContinuousPhase as iniCont20_25_, tbcase0_.initialRegimenWithSecondLineDrugs as initial21_25_, tbcase0_.issueCounter as issueCo22_25_, tbcase0_.lastBmuDateTbRegister as lastBmu23_25_, tbcase0_.lastBmuTbRegistNumber as lastBmu24_25_, tbcase0_.legacyId as legacyId25_, tbcase0_.mobileNumber as mobileN26_25_, tbcase0_.movedSecondLineTreatment as movedSe27_25_, tbcase0_.nationality as nationa28_25_, tbcase0_.NOTIF_ADDRESS as NOTIF29_25_, tbcase0_.NOTIF_ADMINUNIT_ID as NOTIF56_25_, tbcase0_.NOTIF_COMPLEMENT as NOTIF30_25_, tbcase0_.NOTIF_LOCALITYTYPE as NOTIF31_25_, tbcase0_.NOTIF_ZIPCODE as NOTIF32_25_, tbcase0_.notifAddressChanged as notifAd33_25_, tbcase0_.NOTIFICATION_UNIT_ID as NOTIFIC57_25_, tbcase0_.otherOutcome as otherOu34_25_, tbcase0_.outcomeDate as outcome35_25_, tbcase0_.OWNER_UNIT_ID as OWNER58_25_, tbcase0_.PATIENT_ID as PATIENT59_25_, tbcase0_.patientContactName as patient36_25_, tbcase0_.patientType as patient37_25_, tbcase0_.patientTypeOther as patient38_25_, tbcase0_.phoneNumber as phoneNu39_25_, tbcase0_.previouslyTreatedType as previou40_25_, tbcase0_.PULMONARY_ID as PULMONARY60_25_, tbcase0_.REGIMEN_ID as REGIMEN61_25_, tbcase0_.REGIMEN_INI_ID as REGIMEN62_25_, tbcase0_.registrationCode as registr41_25_, tbcase0_.registrationDate as registr42_25_, tbcase0_.secDrugsReceived as secDrug43_25_, tbcase0_.state as state25_, tbcase0_.suspectClassification as suspect45_25_, tbcase0_.suspectRegistrationCode as suspect46_25_, tbcase0_.tbContact as tbContact25_, tbcase0_.treatmentCategory as treatme48_25_, tbcase0_.endTreatmentDate as endTrea49_25_, tbcase0_.iniTreatmentDate as iniTrea50_25_, tbcase0_.validationState as validat51_25_, tbcase0_.version as version25_, tbcase0_1_.bcgScar as bcgScar36_, tbcase0_1_.followUpSmearStatus as followUp2_36_, tbcase0_1_.occupation as occupation36_, tbcase0_1_.PATIENTREFTO_ID as PATIENTR9_36_, tbcase0_1_.pulmonaryTypesBD as pulmonar4_36_, tbcase0_1_.REF_TO_DATE as REF5_36_, tbcase0_1_.referredToUnitName as referred6_36_, tbcase0_1_.salary as salary36_, case when tbcase0_1_.id is not null then 1 when tbcase0_.id is not null then 0 end as clazz_ from tbcase tbcase0_ left outer join tbcasebd tbcase0_1_ on tbcase0_.id=tbcase0_1_.id where tbcase0_.sync_serverId=?
Hibernate: insert into tags_case (case_id, tag_id) values (?, ?)
class org.msh.etbm.sync.CaseTag -> null
Hibernate: select tbcase0_.id as id25_, tbcase0_.sync_changed as sync2_25_, tbcase0_.sync_serverId as sync3_25_, tbcase0_.age as age25_, tbcase0_.caseDefinition as caseDefi5_25_, tbcase0_.caseNumber as caseNumber25_, tbcase0_.classification as classifi7_25_, tbcase0_.comments as comments25_, tbcase0_.CURR_ADDRESS as CURR9_25_, tbcase0_.CURR_ADMINUNIT_ID as CURR53_25_, tbcase0_.CURR_COMPLEMENT as CURR10_25_, tbcase0_.CURR_LOCALITYTYPE as CURR11_25_, tbcase0_.CURR_ZIPCODE as CURR12_25_, tbcase0_.daysTreatPlanned as daysTre13_25_, tbcase0_.diagnosisDate as diagnos14_25_, tbcase0_.diagnosisType as diagnos15_25_, tbcase0_.drugResistanceType as drugRes16_25_, tbcase0_.otherExtrapulmonary as otherEx17_25_, tbcase0_.EXTRAPULMONARY_ID as EXTRAPU54_25_, tbcase0_.otherExtrapulmonary2 as otherEx18_25_, tbcase0_.EXTRAPULMONARY2_ID as EXTRAPU55_25_, tbcase0_.infectionSite as infecti19_25_, tbcase0_.iniContinuousPhase as iniCont20_25_, tbcase0_.initialRegimenWithSecondLineDrugs as initial21_25_, tbcase0_.issueCounter as issueCo22_25_, tbcase0_.lastBmuDateTbRegister as lastBmu23_25_, tbcase0_.lastBmuTbRegistNumber as lastBmu24_25_, tbcase0_.legacyId as legacyId25_, tbcase0_.mobileNumber as mobileN26_25_, tbcase0_.movedSecondLineTreatment as movedSe27_25_, tbcase0_.nationality as nationa28_25_, tbcase0_.NOTIF_ADDRESS as NOTIF29_25_, tbcase0_.NOTIF_ADMINUNIT_ID as NOTIF56_25_, tbcase0_.NOTIF_COMPLEMENT as NOTIF30_25_, tbcase0_.NOTIF_LOCALITYTYPE as NOTIF31_25_, tbcase0_.NOTIF_ZIPCODE as NOTIF32_25_, tbcase0_.notifAddressChanged as notifAd33_25_, tbcase0_.NOTIFICATION_UNIT_ID as NOTIFIC57_25_, tbcase0_.otherOutcome as otherOu34_25_, tbcase0_.outcomeDate as outcome35_25_, tbcase0_.OWNER_UNIT_ID as OWNER58_25_, tbcase0_.PATIENT_ID as PATIENT59_25_, tbcase0_.patientContactName as patient36_25_, tbcase0_.patientType as patient37_25_, tbcase0_.patientTypeOther as patient38_25_, tbcase0_.phoneNumber as phoneNu39_25_, tbcase0_.previouslyTreatedType as previou40_25_, tbcase0_.PULMONARY_ID as PULMONARY60_25_, tbcase0_.REGIMEN_ID as REGIMEN61_25_, tbcase0_.REGIMEN_INI_ID as REGIMEN62_25_, tbcase0_.registrationCode as registr41_25_, tbcase0_.registrationDate as registr42_25_, tbcase0_.secDrugsReceived as secDrug43_25_, tbcase0_.state as state25_, tbcase0_.suspectClassification as suspect45_25_, tbcase0_.suspectRegistrationCode as suspect46_25_, tbcase0_.tbContact as tbContact25_, tbcase0_.treatmentCategory as treatme48_25_, tbcase0_.endTreatmentDate as endTrea49_25_, tbcase0_.iniTreatmentDate as iniTrea50_25_, tbcase0_.validationState as validat51_25_, tbcase0_.version as version25_, tbcase0_1_.bcgScar as bcgScar36_, tbcase0_1_.followUpSmearStatus as followUp2_36_, tbcase0_1_.occupation as occupation36_, tbcase0_1_.PATIENTREFTO_ID as PATIENTR9_36_, tbcase0_1_.pulmonaryTypesBD as pulmonar4_36_, tbcase0_1_.REF_TO_DATE as REF5_36_, tbcase0_1_.referredToUnitName as referred6_36_, tbcase0_1_.salary as salary36_, case when tbcase0_1_.id is not null then 1 when tbcase0_.id is not null then 0 end as clazz_ from tbcase tbcase0_ left outer join tbcasebd tbcase0_1_ on tbcase0_.id=tbcase0_1_.id where tbcase0_.sync_serverId=?
Hibernate: insert into tags_case (case_id, tag_id) values (?, ?)
class org.msh.etbm.sync.CaseTag -> null
Hibernate: select tbcase0_.id as id25_, tbcase0_.sync_changed as sync2_25_, tbcase0_.sync_serverId as sync3_25_, tbcase0_.age as age25_, tbcase0_.caseDefinition as caseDefi5_25_, tbcase0_.caseNumber as caseNumber25_, tbcase0_.classification as classifi7_25_, tbcase0_.comments as comments25_, tbcase0_.CURR_ADDRESS as CURR9_25_, tbcase0_.CURR_ADMINUNIT_ID as CURR53_25_, tbcase0_.CURR_COMPLEMENT as CURR10_25_, tbcase0_.CURR_LOCALITYTYPE as CURR11_25_, tbcase0_.CURR_ZIPCODE as CURR12_25_, tbcase0_.daysTreatPlanned as daysTre13_25_, tbcase0_.diagnosisDate as diagnos14_25_, tbcase0_.diagnosisType as diagnos15_25_, tbcase0_.drugResistanceType as drugRes16_25_, tbcase0_.otherExtrapulmonary as otherEx17_25_, tbcase0_.EXTRAPULMONARY_ID as EXTRAPU54_25_, tbcase0_.otherExtrapulmonary2 as otherEx18_25_, tbcase0_.EXTRAPULMONARY2_ID as EXTRAPU55_25_, tbcase0_.infectionSite as infecti19_25_, tbcase0_.iniContinuousPhase as iniCont20_25_, tbcase0_.initialRegimenWithSecondLineDrugs as initial21_25_, tbcase0_.issueCounter as issueCo22_25_, tbcase0_.lastBmuDateTbRegister as lastBmu23_25_, tbcase0_.lastBmuTbRegistNumber as lastBmu24_25_, tbcase0_.legacyId as legacyId25_, tbcase0_.mobileNumber as mobileN26_25_, tbcase0_.movedSecondLineTreatment as movedSe27_25_, tbcase0_.nationality as nationa28_25_, tbcase0_.NOTIF_ADDRESS as NOTIF29_25_, tbcase0_.NOTIF_ADMINUNIT_ID as NOTIF56_25_, tbcase0_.NOTIF_COMPLEMENT as NOTIF30_25_, tbcase0_.NOTIF_LOCALITYTYPE as NOTIF31_25_, tbcase0_.NOTIF_ZIPCODE as NOTIF32_25_, tbcase0_.notifAddressChanged as notifAd33_25_, tbcase0_.NOTIFICATION_UNIT_ID as NOTIFIC57_25_, tbcase0_.otherOutcome as otherOu34_25_, tbcase0_.outcomeDate as outcome35_25_, tbcase0_.OWNER_UNIT_ID as OWNER58_25_, tbcase0_.PATIENT_ID as PATIENT59_25_, tbcase0_.patientContactName as patient36_25_, tbcase0_.patientType as patient37_25_, tbcase0_.patientTypeOther as patient38_25_, tbcase0_.phoneNumber as phoneNu39_25_, tbcase0_.previouslyTreatedType as previou40_25_, tbcase0_.PULMONARY_ID as PULMONARY60_25_, tbcase0_.REGIMEN_ID as REGIMEN61_25_, tbcase0_.REGIMEN_INI_ID as REGIMEN62_25_, tbcase0_.registrationCode as registr41_25_, tbcase0_.registrationDate as registr42_25_, tbcase0_.secDrugsReceived as secDrug43_25_, tbcase0_.state as state25_, tbcase0_.suspectClassification as suspect45_25_, tbcase0_.suspectRegistrationCode as suspect46_25_, tbcase0_.tbContact as tbContact25_, tbcase0_.treatmentCategory as treatme48_25_, tbcase0_.endTreatmentDate as endTrea49_25_, tbcase0_.iniTreatmentDate as iniTrea50_25_, tbcase0_.validationState as validat51_25_, tbcase0_.version as version25_, tbcase0_1_.bcgScar as bcgScar36_, tbcase0_1_.followUpSmearStatus as followUp2_36_, tbcase0_1_.occupation as occupation36_, tbcase0_1_.PATIENTREFTO_ID as PATIENTR9_36_, tbcase0_1_.pulmonaryTypesBD as pulmonar4_36_, tbcase0_1_.REF_TO_DATE as REF5_36_, tbcase0_1_.referredToUnitName as referred6_36_, tbcase0_1_.salary as salary36_, case when tbcase0_1_.id is not null then 1 when tbcase0_.id is not null then 0 end as clazz_ from tbcase tbcase0_ left outer join tbcasebd tbcase0_1_ on tbcase0_.id=tbcase0_1_.id where tbcase0_.sync_serverId=?
Hibernate: insert into tags_case (case_id, tag_id) values (?, ?)
class org.msh.etbm.sync.CaseTag -> null
Hibernate: select tbcase0_.id as id25_, tbcase0_.sync_changed as sync2_25_, tbcase0_.sync_serverId as sync3_25_, tbcase0_.age as age25_, tbcase0_.caseDefinition as caseDefi5_25_, tbcase0_.caseNumber as caseNumber25_, tbcase0_.classification as classifi7_25_, tbcase0_.comments as comments25_, tbcase0_.CURR_ADDRESS as CURR9_25_, tbcase0_.CURR_ADMINUNIT_ID as CURR53_25_, tbcase0_.CURR_COMPLEMENT as CURR10_25_, tbcase0_.CURR_LOCALITYTYPE as CURR11_25_, tbcase0_.CURR_ZIPCODE as CURR12_25_, tbcase0_.daysTreatPlanned as daysTre13_25_, tbcase0_.diagnosisDate as diagnos14_25_, tbcase0_.diagnosisType as diagnos15_25_, tbcase0_.drugResistanceType as drugRes16_25_, tbcase0_.otherExtrapulmonary as otherEx17_25_, tbcase0_.EXTRAPULMONARY_ID as EXTRAPU54_25_, tbcase0_.otherExtrapulmonary2 as otherEx18_25_, tbcase0_.EXTRAPULMONARY2_ID as EXTRAPU55_25_, tbcase0_.infectionSite as infecti19_25_, tbcase0_.iniContinuousPhase as iniCont20_25_, tbcase0_.initialRegimenWithSecondLineDrugs as initial21_25_, tbcase0_.issueCounter as issueCo22_25_, tbcase0_.lastBmuDateTbRegister as lastBmu23_25_, tbcase0_.lastBmuTbRegistNumber as lastBmu24_25_, tbcase0_.legacyId as legacyId25_, tbcase0_.mobileNumber as mobileN26_25_, tbcase0_.movedSecondLineTreatment as movedSe27_25_, tbcase0_.nationality as nationa28_25_, tbcase0_.NOTIF_ADDRESS as NOTIF29_25_, tbcase0_.NOTIF_ADMINUNIT_ID as NOTIF56_25_, tbcase0_.NOTIF_COMPLEMENT as NOTIF30_25_, tbcase0_.NOTIF_LOCALITYTYPE as NOTIF31_25_, tbcase0_.NOTIF_ZIPCODE as NOTIF32_25_, tbcase0_.notifAddressChanged as notifAd33_25_, tbcase0_.NOTIFICATION_UNIT_ID as NOTIFIC57_25_, tbcase0_.otherOutcome as otherOu34_25_, tbcase0_.outcomeDate as outcome35_25_, tbcase0_.OWNER_UNIT_ID as OWNER58_25_, tbcase0_.PATIENT_ID as PATIENT59_25_, tbcase0_.patientContactName as patient36_25_, tbcase0_.patientType as patient37_25_, tbcase0_.patientTypeOther as patient38_25_, tbcase0_.phoneNumber as phoneNu39_25_, tbcase0_.previouslyTreatedType as previou40_25_, tbcase0_.PULMONARY_ID as PULMONARY60_25_, tbcase0_.REGIMEN_ID as REGIMEN61_25_, tbcase0_.REGIMEN_INI_ID as REGIMEN62_25_, tbcase0_.registrationCode as registr41_25_, tbcase0_.registrationDate as registr42_25_, tbcase0_.secDrugsReceived as secDrug43_25_, tbcase0_.state as state25_, tbcase0_.suspectClassification as suspect45_25_, tbcase0_.suspectRegistrationCode as suspect46_25_, tbcase0_.tbContact as tbContact25_, tbcase0_.treatmentCategory as treatme48_25_, tbcase0_.endTreatmentDate as endTrea49_25_, tbcase0_.iniTreatmentDate as iniTrea50_25_, tbcase0_.validationState as validat51_25_, tbcase0_.version as version25_, tbcase0_1_.bcgScar as bcgScar36_, tbcase0_1_.followUpSmearStatus as followUp2_36_, tbcase0_1_.occupation as occupation36_, tbcase0_1_.PATIENTREFTO_ID as PATIENTR9_36_, tbcase0_1_.pulmonaryTypesBD as pulmonar4_36_, tbcase0_1_.REF_TO_DATE as REF5_36_, tbcase0_1_.referredToUnitName as referred6_36_, tbcase0_1_.salary as salary36_, case when tbcase0_1_.id is not null then 1 when tbcase0_.id is not null then 0 end as clazz_ from tbcase tbcase0_ left outer join tbcasebd tbcase0_1_ on tbcase0_.id=tbcase0_1_.id where tbcase0_.sync_serverId=?
Hibernate: insert into tags_case (case_id, tag_id) values (?, ?)
class org.msh.etbm.sync.CaseTag -> null
Hibernate: select tbcase0_.id as id25_, tbcase0_.sync_changed as sync2_25_, tbcase0_.sync_serverId as sync3_25_, tbcase0_.age as age25_, tbcase0_.caseDefinition as caseDefi5_25_, tbcase0_.caseNumber as caseNumber25_, tbcase0_.classification as classifi7_25_, tbcase0_.comments as comments25_, tbcase0_.CURR_ADDRESS as CURR9_25_, tbcase0_.CURR_ADMINUNIT_ID as CURR53_25_, tbcase0_.CURR_COMPLEMENT as CURR10_25_, tbcase0_.CURR_LOCALITYTYPE as CURR11_25_, tbcase0_.CURR_ZIPCODE as CURR12_25_, tbcase0_.daysTreatPlanned as daysTre13_25_, tbcase0_.diagnosisDate as diagnos14_25_, tbcase0_.diagnosisType as diagnos15_25_, tbcase0_.drugResistanceType as drugRes16_25_, tbcase0_.otherExtrapulmonary as otherEx17_25_, tbcase0_.EXTRAPULMONARY_ID as EXTRAPU54_25_, tbcase0_.otherExtrapulmonary2 as otherEx18_25_, tbcase0_.EXTRAPULMONARY2_ID as EXTRAPU55_25_, tbcase0_.infectionSite as infecti19_25_, tbcase0_.iniContinuousPhase as iniCont20_25_, tbcase0_.initialRegimenWithSecondLineDrugs as initial21_25_, tbcase0_.issueCounter as issueCo22_25_, tbcase0_.lastBmuDateTbRegister as lastBmu23_25_, tbcase0_.lastBmuTbRegistNumber as lastBmu24_25_, tbcase0_.legacyId as legacyId25_, tbcase0_.mobileNumber as mobileN26_25_, tbcase0_.movedSecondLineTreatment as movedSe27_25_, tbcase0_.nationality as nationa28_25_, tbcase0_.NOTIF_ADDRESS as NOTIF29_25_, tbcase0_.NOTIF_ADMINUNIT_ID as NOTIF56_25_, tbcase0_.NOTIF_COMPLEMENT as NOTIF30_25_, tbcase0_.NOTIF_LOCALITYTYPE as NOTIF31_25_, tbcase0_.NOTIF_ZIPCODE as NOTIF32_25_, tbcase0_.notifAddressChanged as notifAd33_25_, tbcase0_.NOTIFICATION_UNIT_ID as NOTIFIC57_25_, tbcase0_.otherOutcome as otherOu34_25_, tbcase0_.outcomeDate as outcome35_25_, tbcase0_.OWNER_UNIT_ID as OWNER58_25_, tbcase0_.PATIENT_ID as PATIENT59_25_, tbcase0_.patientContactName as patient36_25_, tbcase0_.patientType as patient37_25_, tbcase0_.patientTypeOther as patient38_25_, tbcase0_.phoneNumber as phoneNu39_25_, tbcase0_.previouslyTreatedType as previou40_25_, tbcase0_.PULMONARY_ID as PULMONARY60_25_, tbcase0_.REGIMEN_ID as REGIMEN61_25_, tbcase0_.REGIMEN_INI_ID as REGIMEN62_25_, tbcase0_.registrationCode as registr41_25_, tbcase0_.registrationDate as registr42_25_, tbcase0_.secDrugsReceived as secDrug43_25_, tbcase0_.state as state25_, tbcase0_.suspectClassification as suspect45_25_, tbcase0_.suspectRegistrationCode as suspect46_25_, tbcase0_.tbContact as tbContact25_, tbcase0_.treatmentCategory as treatme48_25_, tbcase0_.endTreatmentDate as endTrea49_25_, tbcase0_.iniTreatmentDate as iniTrea50_25_, tbcase0_.validationState as validat51_25_, tbcase0_.version as version25_, tbcase0_1_.bcgScar as bcgScar36_, tbcase0_1_.followUpSmearStatus as followUp2_36_, tbcase0_1_.occupation as occupation36_, tbcase0_1_.PATIENTREFTO_ID as PATIENTR9_36_, tbcase0_1_.pulmonaryTypesBD as pulmonar4_36_, tbcase0_1_.REF_TO_DATE as REF5_36_, tbcase0_1_.referredToUnitName as referred6_36_, tbcase0_1_.salary as salary36_, case when tbcase0_1_.id is not null then 1 when tbcase0_.id is not null then 0 end as clazz_ from tbcase tbcase0_ left outer join tbcasebd tbcase0_1_ on tbcase0_.id=tbcase0_1_.id where tbcase0_.sync_serverId=?
Hibernate: insert into tags_case (case_id, tag_id) values (?, ?)
class org.msh.etbm.sync.CaseTag -> null
Hibernate: select tbcase0_.id as id25_, tbcase0_.sync_changed as sync2_25_, tbcase0_.sync_serverId as sync3_25_, tbcase0_.age as age25_, tbcase0_.caseDefinition as caseDefi5_25_, tbcase0_.caseNumber as caseNumber25_, tbcase0_.classification as classifi7_25_, tbcase0_.comments as comments25_, tbcase0_.CURR_ADDRESS as CURR9_25_, tbcase0_.CURR_ADMINUNIT_ID as CURR53_25_, tbcase0_.CURR_COMPLEMENT as CURR10_25_, tbcase0_.CURR_LOCALITYTYPE as CURR11_25_, tbcase0_.CURR_ZIPCODE as CURR12_25_, tbcase0_.daysTreatPlanned as daysTre13_25_, tbcase0_.diagnosisDate as diagnos14_25_, tbcase0_.diagnosisType as diagnos15_25_, tbcase0_.drugResistanceType as drugRes16_25_, tbcase0_.otherExtrapulmonary as otherEx17_25_, tbcase0_.EXTRAPULMONARY_ID as EXTRAPU54_25_, tbcase0_.otherExtrapulmonary2 as otherEx18_25_, tbcase0_.EXTRAPULMONARY2_ID as EXTRAPU55_25_, tbcase0_.infectionSite as infecti19_25_, tbcase0_.iniContinuousPhase as iniCont20_25_, tbcase0_.initialRegimenWithSecondLineDrugs as initial21_25_, tbcase0_.issueCounter as issueCo22_25_, tbcase0_.lastBmuDateTbRegister as lastBmu23_25_, tbcase0_.lastBmuTbRegistNumber as lastBmu24_25_, tbcase0_.legacyId as legacyId25_, tbcase0_.mobileNumber as mobileN26_25_, tbcase0_.movedSecondLineTreatment as movedSe27_25_, tbcase0_.nationality as nationa28_25_, tbcase0_.NOTIF_ADDRESS as NOTIF29_25_, tbcase0_.NOTIF_ADMINUNIT_ID as NOTIF56_25_, tbcase0_.NOTIF_COMPLEMENT as NOTIF30_25_, tbcase0_.NOTIF_LOCALITYTYPE as NOTIF31_25_, tbcase0_.NOTIF_ZIPCODE as NOTIF32_25_, tbcase0_.notifAddressChanged as notifAd33_25_, tbcase0_.NOTIFICATION_UNIT_ID as NOTIFIC57_25_, tbcase0_.otherOutcome as otherOu34_25_, tbcase0_.outcomeDate as outcome35_25_, tbcase0_.OWNER_UNIT_ID as OWNER58_25_, tbcase0_.PATIENT_ID as PATIENT59_25_, tbcase0_.patientContactName as patient36_25_, tbcase0_.patientType as patient37_25_, tbcase0_.patientTypeOther as patient38_25_, tbcase0_.phoneNumber as phoneNu39_25_, tbcase0_.previouslyTreatedType as previou40_25_, tbcase0_.PULMONARY_ID as PULMONARY60_25_, tbcase0_.REGIMEN_ID as REGIMEN61_25_, tbcase0_.REGIMEN_INI_ID as REGIMEN62_25_, tbcase0_.registrationCode as registr41_25_, tbcase0_.registrationDate as registr42_25_, tbcase0_.secDrugsReceived as secDrug43_25_, tbcase0_.state as state25_, tbcase0_.suspectClassification as suspect45_25_, tbcase0_.suspectRegistrationCode as suspect46_25_, tbcase0_.tbContact as tbContact25_, tbcase0_.treatmentCategory as treatme48_25_, tbcase0_.endTreatmentDate as endTrea49_25_, tbcase0_.iniTreatmentDate as iniTrea50_25_, tbcase0_.validationState as validat51_25_, tbcase0_.version as version25_, tbcase0_1_.bcgScar as bcgScar36_, tbcase0_1_.followUpSmearStatus as followUp2_36_, tbcase0_1_.occupation as occupation36_, tbcase0_1_.PATIENTREFTO_ID as PATIENTR9_36_, tbcase0_1_.pulmonaryTypesBD as pulmonar4_36_, tbcase0_1_.REF_TO_DATE as REF5_36_, tbcase0_1_.referredToUnitName as referred6_36_, tbcase0_1_.salary as salary36_, case when tbcase0_1_.id is not null then 1 when tbcase0_.id is not null then 0 end as clazz_ from tbcase tbcase0_ left outer join tbcasebd tbcase0_1_ on tbcase0_.id=tbcase0_1_.id where tbcase0_.sync_serverId=?
Hibernate: insert into tags_case (case_id, tag_id) values (?, ?)
class org.msh.etbm.sync.CaseTag -> null
Hibernate: select tbcase0_.id as id25_, tbcase0_.sync_changed as sync2_25_, tbcase0_.sync_serverId as sync3_25_, tbcase0_.age as age25_, tbcase0_.caseDefinition as caseDefi5_25_, tbcase0_.caseNumber as caseNumber25_, tbcase0_.classification as classifi7_25_, tbcase0_.comments as comments25_, tbcase0_.CURR_ADDRESS as CURR9_25_, tbcase0_.CURR_ADMINUNIT_ID as CURR53_25_, tbcase0_.CURR_COMPLEMENT as CURR10_25_, tbcase0_.CURR_LOCALITYTYPE as CURR11_25_, tbcase0_.CURR_ZIPCODE as CURR12_25_, tbcase0_.daysTreatPlanned as daysTre13_25_, tbcase0_.diagnosisDate as diagnos14_25_, tbcase0_.diagnosisType as diagnos15_25_, tbcase0_.drugResistanceType as drugRes16_25_, tbcase0_.otherExtrapulmonary as otherEx17_25_, tbcase0_.EXTRAPULMONARY_ID as EXTRAPU54_25_, tbcase0_.otherExtrapulmonary2 as otherEx18_25_, tbcase0_.EXTRAPULMONARY2_ID as EXTRAPU55_25_, tbcase0_.infectionSite as infecti19_25_, tbcase0_.iniContinuousPhase as iniCont20_25_, tbcase0_.initialRegimenWithSecondLineDrugs as initial21_25_, tbcase0_.issueCounter as issueCo22_25_, tbcase0_.lastBmuDateTbRegister as lastBmu23_25_, tbcase0_.lastBmuTbRegistNumber as lastBmu24_25_, tbcase0_.legacyId as legacyId25_, tbcase0_.mobileNumber as mobileN26_25_, tbcase0_.movedSecondLineTreatment as movedSe27_25_, tbcase0_.nationality as nationa28_25_, tbcase0_.NOTIF_ADDRESS as NOTIF29_25_, tbcase0_.NOTIF_ADMINUNIT_ID as NOTIF56_25_, tbcase0_.NOTIF_COMPLEMENT as NOTIF30_25_, tbcase0_.NOTIF_LOCALITYTYPE as NOTIF31_25_, tbcase0_.NOTIF_ZIPCODE as NOTIF32_25_, tbcase0_.notifAddressChanged as notifAd33_25_, tbcase0_.NOTIFICATION_UNIT_ID as NOTIFIC57_25_, tbcase0_.otherOutcome as otherOu34_25_, tbcase0_.outcomeDate as outcome35_25_, tbcase0_.OWNER_UNIT_ID as OWNER58_25_, tbcase0_.PATIENT_ID as PATIENT59_25_, tbcase0_.patientContactName as patient36_25_, tbcase0_.patientType as patient37_25_, tbcase0_.patientTypeOther as patient38_25_, tbcase0_.phoneNumber as phoneNu39_25_, tbcase0_.previouslyTreatedType as previou40_25_, tbcase0_.PULMONARY_ID as PULMONARY60_25_, tbcase0_.REGIMEN_ID as REGIMEN61_25_, tbcase0_.REGIMEN_INI_ID as REGIMEN62_25_, tbcase0_.registrationCode as registr41_25_, tbcase0_.registrationDate as registr42_25_, tbcase0_.secDrugsReceived as secDrug43_25_, tbcase0_.state as state25_, tbcase0_.suspectClassification as suspect45_25_, tbcase0_.suspectRegistrationCode as suspect46_25_, tbcase0_.tbContact as tbContact25_, tbcase0_.treatmentCategory as treatme48_25_, tbcase0_.endTreatmentDate as endTrea49_25_, tbcase0_.iniTreatmentDate as iniTrea50_25_, tbcase0_.validationState as validat51_25_, tbcase0_.version as version25_, tbcase0_1_.bcgScar as bcgScar36_, tbcase0_1_.followUpSmearStatus as followUp2_36_, tbcase0_1_.occupation as occupation36_, tbcase0_1_.PATIENTREFTO_ID as PATIENTR9_36_, tbcase0_1_.pulmonaryTypesBD as pulmonar4_36_, tbcase0_1_.REF_TO_DATE as REF5_36_, tbcase0_1_.referredToUnitName as referred6_36_, tbcase0_1_.salary as salary36_, case when tbcase0_1_.id is not null then 1 when tbcase0_.id is not null then 0 end as clazz_ from tbcase tbcase0_ left outer join tbcasebd tbcase0_1_ on tbcase0_.id=tbcase0_1_.id where tbcase0_.sync_serverId=?
Hibernate: insert into tags_case (case_id, tag_id) values (?, ?)
class org.msh.etbm.sync.CaseTag -> null
Hibernate: select tbcase0_.id as id25_, tbcase0_.sync_changed as sync2_25_, tbcase0_.sync_serverId as sync3_25_, tbcase0_.age as age25_, tbcase0_.caseDefinition as caseDefi5_25_, tbcase0_.caseNumber as caseNumber25_, tbcase0_.classification as classifi7_25_, tbcase0_.comments as comments25_, tbcase0_.CURR_ADDRESS as CURR9_25_, tbcase0_.CURR_ADMINUNIT_ID as CURR53_25_, tbcase0_.CURR_COMPLEMENT as CURR10_25_, tbcase0_.CURR_LOCALITYTYPE as CURR11_25_, tbcase0_.CURR_ZIPCODE as CURR12_25_, tbcase0_.daysTreatPlanned as daysTre13_25_, tbcase0_.diagnosisDate as diagnos14_25_, tbcase0_.diagnosisType as diagnos15_25_, tbcase0_.drugResistanceType as drugRes16_25_, tbcase0_.otherExtrapulmonary as otherEx17_25_, tbcase0_.EXTRAPULMONARY_ID as EXTRAPU54_25_, tbcase0_.otherExtrapulmonary2 as otherEx18_25_, tbcase0_.EXTRAPULMONARY2_ID as EXTRAPU55_25_, tbcase0_.infectionSite as infecti19_25_, tbcase0_.iniContinuousPhase as iniCont20_25_, tbcase0_.initialRegimenWithSecondLineDrugs as initial21_25_, tbcase0_.issueCounter as issueCo22_25_, tbcase0_.lastBmuDateTbRegister as lastBmu23_25_, tbcase0_.lastBmuTbRegistNumber as lastBmu24_25_, tbcase0_.legacyId as legacyId25_, tbcase0_.mobileNumber as mobileN26_25_, tbcase0_.movedSecondLineTreatment as movedSe27_25_, tbcase0_.nationality as nationa28_25_, tbcase0_.NOTIF_ADDRESS as NOTIF29_25_, tbcase0_.NOTIF_ADMINUNIT_ID as NOTIF56_25_, tbcase0_.NOTIF_COMPLEMENT as NOTIF30_25_, tbcase0_.NOTIF_LOCALITYTYPE as NOTIF31_25_, tbcase0_.NOTIF_ZIPCODE as NOTIF32_25_, tbcase0_.notifAddressChanged as notifAd33_25_, tbcase0_.NOTIFICATION_UNIT_ID as NOTIFIC57_25_, tbcase0_.otherOutcome as otherOu34_25_, tbcase0_.outcomeDate as outcome35_25_, tbcase0_.OWNER_UNIT_ID as OWNER58_25_, tbcase0_.PATIENT_ID as PATIENT59_25_, tbcase0_.patientContactName as patient36_25_, tbcase0_.patientType as patient37_25_, tbcase0_.patientTypeOther as patient38_25_, tbcase0_.phoneNumber as phoneNu39_25_, tbcase0_.previouslyTreatedType as previou40_25_, tbcase0_.PULMONARY_ID as PULMONARY60_25_, tbcase0_.REGIMEN_ID as REGIMEN61_25_, tbcase0_.REGIMEN_INI_ID as REGIMEN62_25_, tbcase0_.registrationCode as registr41_25_, tbcase0_.registrationDate as registr42_25_, tbcase0_.secDrugsReceived as secDrug43_25_, tbcase0_.state as state25_, tbcase0_.suspectClassification as suspect45_25_, tbcase0_.suspectRegistrationCode as suspect46_25_, tbcase0_.tbContact as tbContact25_, tbcase0_.treatmentCategory as treatme48_25_, tbcase0_.endTreatmentDate as endTrea49_25_, tbcase0_.iniTreatmentDate as iniTrea50_25_, tbcase0_.validationState as validat51_25_, tbcase0_.version as version25_, tbcase0_1_.bcgScar as bcgScar36_, tbcase0_1_.followUpSmearStatus as followUp2_36_, tbcase0_1_.occupation as occupation36_, tbcase0_1_.PATIENTREFTO_ID as PATIENTR9_36_, tbcase0_1_.pulmonaryTypesBD as pulmonar4_36_, tbcase0_1_.REF_TO_DATE as REF5_36_, tbcase0_1_.referredToUnitName as referred6_36_, tbcase0_1_.salary as salary36_, case when tbcase0_1_.id is not null then 1 when tbcase0_.id is not null then 0 end as clazz_ from tbcase tbcase0_ left outer join tbcasebd tbcase0_1_ on tbcase0_.id=tbcase0_1_.id where tbcase0_.sync_serverId=?
Hibernate: insert into tags_case (case_id, tag_id) values (?, ?)
class org.msh.etbm.sync.CaseTag -> null
Hibernate: select tbcase0_.id as id25_, tbcase0_.sync_changed as sync2_25_, tbcase0_.sync_serverId as sync3_25_, tbcase0_.age as age25_, tbcase0_.caseDefinition as caseDefi5_25_, tbcase0_.caseNumber as caseNumber25_, tbcase0_.classification as classifi7_25_, tbcase0_.comments as comments25_, tbcase0_.CURR_ADDRESS as CURR9_25_, tbcase0_.CURR_ADMINUNIT_ID as CURR53_25_, tbcase0_.CURR_COMPLEMENT as CURR10_25_, tbcase0_.CURR_LOCALITYTYPE as CURR11_25_, tbcase0_.CURR_ZIPCODE as CURR12_25_, tbcase0_.daysTreatPlanned as daysTre13_25_, tbcase0_.diagnosisDate as diagnos14_25_, tbcase0_.diagnosisType as diagnos15_25_, tbcase0_.drugResistanceType as drugRes16_25_, tbcase0_.otherExtrapulmonary as otherEx17_25_, tbcase0_.EXTRAPULMONARY_ID as EXTRAPU54_25_, tbcase0_.otherExtrapulmonary2 as otherEx18_25_, tbcase0_.EXTRAPULMONARY2_ID as EXTRAPU55_25_, tbcase0_.infectionSite as infecti19_25_, tbcase0_.iniContinuousPhase as iniCont20_25_, tbcase0_.initialRegimenWithSecondLineDrugs as initial21_25_, tbcase0_.issueCounter as issueCo22_25_, tbcase0_.lastBmuDateTbRegister as lastBmu23_25_, tbcase0_.lastBmuTbRegistNumber as lastBmu24_25_, tbcase0_.legacyId as legacyId25_, tbcase0_.mobileNumber as mobileN26_25_, tbcase0_.movedSecondLineTreatment as movedSe27_25_, tbcase0_.nationality as nationa28_25_, tbcase0_.NOTIF_ADDRESS as NOTIF29_25_, tbcase0_.NOTIF_ADMINUNIT_ID as NOTIF56_25_, tbcase0_.NOTIF_COMPLEMENT as NOTIF30_25_, tbcase0_.NOTIF_LOCALITYTYPE as NOTIF31_25_, tbcase0_.NOTIF_ZIPCODE as NOTIF32_25_, tbcase0_.notifAddressChanged as notifAd33_25_, tbcase0_.NOTIFICATION_UNIT_ID as NOTIFIC57_25_, tbcase0_.otherOutcome as otherOu34_25_, tbcase0_.outcomeDate as outcome35_25_, tbcase0_.OWNER_UNIT_ID as OWNER58_25_, tbcase0_.PATIENT_ID as PATIENT59_25_, tbcase0_.patientContactName as patient36_25_, tbcase0_.patientType as patient37_25_, tbcase0_.patientTypeOther as patient38_25_, tbcase0_.phoneNumber as phoneNu39_25_, tbcase0_.previouslyTreatedType as previou40_25_, tbcase0_.PULMONARY_ID as PULMONARY60_25_, tbcase0_.REGIMEN_ID as REGIMEN61_25_, tbcase0_.REGIMEN_INI_ID as REGIMEN62_25_, tbcase0_.registrationCode as registr41_25_, tbcase0_.registrationDate as registr42_25_, tbcase0_.secDrugsReceived as secDrug43_25_, tbcase0_.state as state25_, tbcase0_.suspectClassification as suspect45_25_, tbcase0_.suspectRegistrationCode as suspect46_25_, tbcase0_.tbContact as tbContact25_, tbcase0_.treatmentCategory as treatme48_25_, tbcase0_.endTreatmentDate as endTrea49_25_, tbcase0_.iniTreatmentDate as iniTrea50_25_, tbcase0_.validationState as validat51_25_, tbcase0_.version as version25_, tbcase0_1_.bcgScar as bcgScar36_, tbcase0_1_.followUpSmearStatus as followUp2_36_, tbcase0_1_.occupation as occupation36_, tbcase0_1_.PATIENTREFTO_ID as PATIENTR9_36_, tbcase0_1_.pulmonaryTypesBD as pulmonar4_36_, tbcase0_1_.REF_TO_DATE as REF5_36_, tbcase0_1_.referredToUnitName as referred6_36_, tbcase0_1_.salary as salary36_, case when tbcase0_1_.id is not null then 1 when tbcase0_.id is not null then 0 end as clazz_ from tbcase tbcase0_ left outer join tbcasebd tbcase0_1_ on tbcase0_.id=tbcase0_1_.id where tbcase0_.sync_serverId=?
Hibernate: insert into tags_case (case_id, tag_id) values (?, ?)
class org.msh.etbm.sync.CaseTag -> null
Hibernate: select tbcase0_.id as id25_, tbcase0_.sync_changed as sync2_25_, tbcase0_.sync_serverId as sync3_25_, tbcase0_.age as age25_, tbcase0_.caseDefinition as caseDefi5_25_, tbcase0_.caseNumber as caseNumber25_, tbcase0_.classification as classifi7_25_, tbcase0_.comments as comments25_, tbcase0_.CURR_ADDRESS as CURR9_25_, tbcase0_.CURR_ADMINUNIT_ID as CURR53_25_, tbcase0_.CURR_COMPLEMENT as CURR10_25_, tbcase0_.CURR_LOCALITYTYPE as CURR11_25_, tbcase0_.CURR_ZIPCODE as CURR12_25_, tbcase0_.daysTreatPlanned as daysTre13_25_, tbcase0_.diagnosisDate as diagnos14_25_, tbcase0_.diagnosisType as diagnos15_25_, tbcase0_.drugResistanceType as drugRes16_25_, tbcase0_.otherExtrapulmonary as otherEx17_25_, tbcase0_.EXTRAPULMONARY_ID as EXTRAPU54_25_, tbcase0_.otherExtrapulmonary2 as otherEx18_25_, tbcase0_.EXTRAPULMONARY2_ID as EXTRAPU55_25_, tbcase0_.infectionSite as infecti19_25_, tbcase0_.iniContinuousPhase as iniCont20_25_, tbcase0_.initialRegimenWithSecondLineDrugs as initial21_25_, tbcase0_.issueCounter as issueCo22_25_, tbcase0_.lastBmuDateTbRegister as lastBmu23_25_, tbcase0_.lastBmuTbRegistNumber as lastBmu24_25_, tbcase0_.legacyId as legacyId25_, tbcase0_.mobileNumber as mobileN26_25_, tbcase0_.movedSecondLineTreatment as movedSe27_25_, tbcase0_.nationality as nationa28_25_, tbcase0_.NOTIF_ADDRESS as NOTIF29_25_, tbcase0_.NOTIF_ADMINUNIT_ID as NOTIF56_25_, tbcase0_.NOTIF_COMPLEMENT as NOTIF30_25_, tbcase0_.NOTIF_LOCALITYTYPE as NOTIF31_25_, tbcase0_.NOTIF_ZIPCODE as NOTIF32_25_, tbcase0_.notifAddressChanged as notifAd33_25_, tbcase0_.NOTIFICATION_UNIT_ID as NOTIFIC57_25_, tbcase0_.otherOutcome as otherOu34_25_, tbcase0_.outcomeDate as outcome35_25_, tbcase0_.OWNER_UNIT_ID as OWNER58_25_, tbcase0_.PATIENT_ID as PATIENT59_25_, tbcase0_.patientContactName as patient36_25_, tbcase0_.patientType as patient37_25_, tbcase0_.patientTypeOther as patient38_25_, tbcase0_.phoneNumber as phoneNu39_25_, tbcase0_.previouslyTreatedType as previou40_25_, tbcase0_.PULMONARY_ID as PULMONARY60_25_, tbcase0_.REGIMEN_ID as REGIMEN61_25_, tbcase0_.REGIMEN_INI_ID as REGIMEN62_25_, tbcase0_.registrationCode as registr41_25_, tbcase0_.registrationDate as registr42_25_, tbcase0_.secDrugsReceived as secDrug43_25_, tbcase0_.state as state25_, tbcase0_.suspectClassification as suspect45_25_, tbcase0_.suspectRegistrationCode as suspect46_25_, tbcase0_.tbContact as tbContact25_, tbcase0_.treatmentCategory as treatme48_25_, tbcase0_.endTreatmentDate as endTrea49_25_, tbcase0_.iniTreatmentDate as iniTrea50_25_, tbcase0_.validationState as validat51_25_, tbcase0_.version as version25_, tbcase0_1_.bcgScar as bcgScar36_, tbcase0_1_.followUpSmearStatus as followUp2_36_, tbcase0_1_.occupation as occupation36_, tbcase0_1_.PATIENTREFTO_ID as PATIENTR9_36_, tbcase0_1_.pulmonaryTypesBD as pulmonar4_36_, tbcase0_1_.REF_TO_DATE as REF5_36_, tbcase0_1_.referredToUnitName as referred6_36_, tbcase0_1_.salary as salary36_, case when tbcase0_1_.id is not null then 1 when tbcase0_.id is not null then 0 end as clazz_ from tbcase tbcase0_ left outer join tbcasebd tbcase0_1_ on tbcase0_.id=tbcase0_1_.id where tbcase0_.sync_serverId=?
Hibernate: insert into tags_case (case_id, tag_id) values (?, ?)
class org.msh.etbm.sync.CaseTag -> null
Hibernate: select tbcase0_.id as id25_, tbcase0_.sync_changed as sync2_25_, tbcase0_.sync_serverId as sync3_25_, tbcase0_.age as age25_, tbcase0_.caseDefinition as caseDefi5_25_, tbcase0_.caseNumber as caseNumber25_, tbcase0_.classification as classifi7_25_, tbcase0_.comments as comments25_, tbcase0_.CURR_ADDRESS as CURR9_25_, tbcase0_.CURR_ADMINUNIT_ID as CURR53_25_, tbcase0_.CURR_COMPLEMENT as CURR10_25_, tbcase0_.CURR_LOCALITYTYPE as CURR11_25_, tbcase0_.CURR_ZIPCODE as CURR12_25_, tbcase0_.daysTreatPlanned as daysTre13_25_, tbcase0_.diagnosisDate as diagnos14_25_, tbcase0_.diagnosisType as diagnos15_25_, tbcase0_.drugResistanceType as drugRes16_25_, tbcase0_.otherExtrapulmonary as otherEx17_25_, tbcase0_.EXTRAPULMONARY_ID as EXTRAPU54_25_, tbcase0_.otherExtrapulmonary2 as otherEx18_25_, tbcase0_.EXTRAPULMONARY2_ID as EXTRAPU55_25_, tbcase0_.infectionSite as infecti19_25_, tbcase0_.iniContinuousPhase as iniCont20_25_, tbcase0_.initialRegimenWithSecondLineDrugs as initial21_25_, tbcase0_.issueCounter as issueCo22_25_, tbcase0_.lastBmuDateTbRegister as lastBmu23_25_, tbcase0_.lastBmuTbRegistNumber as lastBmu24_25_, tbcase0_.legacyId as legacyId25_, tbcase0_.mobileNumber as mobileN26_25_, tbcase0_.movedSecondLineTreatment as movedSe27_25_, tbcase0_.nationality as nationa28_25_, tbcase0_.NOTIF_ADDRESS as NOTIF29_25_, tbcase0_.NOTIF_ADMINUNIT_ID as NOTIF56_25_, tbcase0_.NOTIF_COMPLEMENT as NOTIF30_25_, tbcase0_.NOTIF_LOCALITYTYPE as NOTIF31_25_, tbcase0_.NOTIF_ZIPCODE as NOTIF32_25_, tbcase0_.notifAddressChanged as notifAd33_25_, tbcase0_.NOTIFICATION_UNIT_ID as NOTIFIC57_25_, tbcase0_.otherOutcome as otherOu34_25_, tbcase0_.outcomeDate as outcome35_25_, tbcase0_.OWNER_UNIT_ID as OWNER58_25_, tbcase0_.PATIENT_ID as PATIENT59_25_, tbcase0_.patientContactName as patient36_25_, tbcase0_.patientType as patient37_25_, tbcase0_.patientTypeOther as patient38_25_, tbcase0_.phoneNumber as phoneNu39_25_, tbcase0_.previouslyTreatedType as previou40_25_, tbcase0_.PULMONARY_ID as PULMONARY60_25_, tbcase0_.REGIMEN_ID as REGIMEN61_25_, tbcase0_.REGIMEN_INI_ID as REGIMEN62_25_, tbcase0_.registrationCode as registr41_25_, tbcase0_.registrationDate as registr42_25_, tbcase0_.secDrugsReceived as secDrug43_25_, tbcase0_.state as state25_, tbcase0_.suspectClassification as suspect45_25_, tbcase0_.suspectRegistrationCode as suspect46_25_, tbcase0_.tbContact as tbContact25_, tbcase0_.treatmentCategory as treatme48_25_, tbcase0_.endTreatmentDate as endTrea49_25_, tbcase0_.iniTreatmentDate as iniTrea50_25_, tbcase0_.validationState as validat51_25_, tbcase0_.version as version25_, tbcase0_1_.bcgScar as bcgScar36_, tbcase0_1_.followUpSmearStatus as followUp2_36_, tbcase0_1_.occupation as occupation36_, tbcase0_1_.PATIENTREFTO_ID as PATIENTR9_36_, tbcase0_1_.pulmonaryTypesBD as pulmonar4_36_, tbcase0_1_.REF_TO_DATE as REF5_36_, tbcase0_1_.referredToUnitName as referred6_36_, tbcase0_1_.salary as salary36_, case when tbcase0_1_.id is not null then 1 when tbcase0_.id is not null then 0 end as clazz_ from tbcase tbcase0_ left outer join tbcasebd tbcase0_1_ on tbcase0_.id=tbcase0_1_.id where tbcase0_.sync_serverId=?
Hibernate: insert into tags_case (case_id, tag_id) values (?, ?)
class org.msh.etbm.sync.CaseTag -> null
Hibernate: select tbcase0_.id as id25_, tbcase0_.sync_changed as sync2_25_, tbcase0_.sync_serverId as sync3_25_, tbcase0_.age as age25_, tbcase0_.caseDefinition as caseDefi5_25_, tbcase0_.caseNumber as caseNumber25_, tbcase0_.classification as classifi7_25_, tbcase0_.comments as comments25_, tbcase0_.CURR_ADDRESS as CURR9_25_, tbcase0_.CURR_ADMINUNIT_ID as CURR53_25_, tbcase0_.CURR_COMPLEMENT as CURR10_25_, tbcase0_.CURR_LOCALITYTYPE as CURR11_25_, tbcase0_.CURR_ZIPCODE as CURR12_25_, tbcase0_.daysTreatPlanned as daysTre13_25_, tbcase0_.diagnosisDate as diagnos14_25_, tbcase0_.diagnosisType as diagnos15_25_, tbcase0_.drugResistanceType as drugRes16_25_, tbcase0_.otherExtrapulmonary as otherEx17_25_, tbcase0_.EXTRAPULMONARY_ID as EXTRAPU54_25_, tbcase0_.otherExtrapulmonary2 as otherEx18_25_, tbcase0_.EXTRAPULMONARY2_ID as EXTRAPU55_25_, tbcase0_.infectionSite as infecti19_25_, tbcase0_.iniContinuousPhase as iniCont20_25_, tbcase0_.initialRegimenWithSecondLineDrugs as initial21_25_, tbcase0_.issueCounter as issueCo22_25_, tbcase0_.lastBmuDateTbRegister as lastBmu23_25_, tbcase0_.lastBmuTbRegistNumber as lastBmu24_25_, tbcase0_.legacyId as legacyId25_, tbcase0_.mobileNumber as mobileN26_25_, tbcase0_.movedSecondLineTreatment as movedSe27_25_, tbcase0_.nationality as nationa28_25_, tbcase0_.NOTIF_ADDRESS as NOTIF29_25_, tbcase0_.NOTIF_ADMINUNIT_ID as NOTIF56_25_, tbcase0_.NOTIF_COMPLEMENT as NOTIF30_25_, tbcase0_.NOTIF_LOCALITYTYPE as NOTIF31_25_, tbcase0_.NOTIF_ZIPCODE as NOTIF32_25_, tbcase0_.notifAddressChanged as notifAd33_25_, tbcase0_.NOTIFICATION_UNIT_ID as NOTIFIC57_25_, tbcase0_.otherOutcome as otherOu34_25_, tbcase0_.outcomeDate as outcome35_25_, tbcase0_.OWNER_UNIT_ID as OWNER58_25_, tbcase0_.PATIENT_ID as PATIENT59_25_, tbcase0_.patientContactName as patient36_25_, tbcase0_.patientType as patient37_25_, tbcase0_.patientTypeOther as patient38_25_, tbcase0_.phoneNumber as phoneNu39_25_, tbcase0_.previouslyTreatedType as previou40_25_, tbcase0_.PULMONARY_ID as PULMONARY60_25_, tbcase0_.REGIMEN_ID as REGIMEN61_25_, tbcase0_.REGIMEN_INI_ID as REGIMEN62_25_, tbcase0_.registrationCode as registr41_25_, tbcase0_.registrationDate as registr42_25_, tbcase0_.secDrugsReceived as secDrug43_25_, tbcase0_.state as state25_, tbcase0_.suspectClassification as suspect45_25_, tbcase0_.suspectRegistrationCode as suspect46_25_, tbcase0_.tbContact as tbContact25_, tbcase0_.treatmentCategory as treatme48_25_, tbcase0_.endTreatmentDate as endTrea49_25_, tbcase0_.iniTreatmentDate as iniTrea50_25_, tbcase0_.validationState as validat51_25_, tbcase0_.version as version25_, tbcase0_1_.bcgScar as bcgScar36_, tbcase0_1_.followUpSmearStatus as followUp2_36_, tbcase0_1_.occupation as occupation36_, tbcase0_1_.PATIENTREFTO_ID as PATIENTR9_36_, tbcase0_1_.pulmonaryTypesBD as pulmonar4_36_, tbcase0_1_.REF_TO_DATE as REF5_36_, tbcase0_1_.referredToUnitName as referred6_36_, tbcase0_1_.salary as salary36_, case when tbcase0_1_.id is not null then 1 when tbcase0_.id is not null then 0 end as clazz_ from tbcase tbcase0_ left outer join tbcasebd tbcase0_1_ on tbcase0_.id=tbcase0_1_.id where tbcase0_.sync_serverId=?
Hibernate: insert into tags_case (case_id, tag_id) values (?, ?)
class org.msh.etbm.sync.CaseTag -> null
Hibernate: select tbcase0_.id as id25_, tbcase0_.sync_changed as sync2_25_, tbcase0_.sync_serverId as sync3_25_, tbcase0_.age as age25_, tbcase0_.caseDefinition as caseDefi5_25_, tbcase0_.caseNumber as caseNumber25_, tbcase0_.classification as classifi7_25_, tbcase0_.comments as comments25_, tbcase0_.CURR_ADDRESS as CURR9_25_, tbcase0_.CURR_ADMINUNIT_ID as CURR53_25_, tbcase0_.CURR_COMPLEMENT as CURR10_25_, tbcase0_.CURR_LOCALITYTYPE as CURR11_25_, tbcase0_.CURR_ZIPCODE as CURR12_25_, tbcase0_.daysTreatPlanned as daysTre13_25_, tbcase0_.diagnosisDate as diagnos14_25_, tbcase0_.diagnosisType as diagnos15_25_, tbcase0_.drugResistanceType as drugRes16_25_, tbcase0_.otherExtrapulmonary as otherEx17_25_, tbcase0_.EXTRAPULMONARY_ID as EXTRAPU54_25_, tbcase0_.otherExtrapulmonary2 as otherEx18_25_, tbcase0_.EXTRAPULMONARY2_ID as EXTRAPU55_25_, tbcase0_.infectionSite as infecti19_25_, tbcase0_.iniContinuousPhase as iniCont20_25_, tbcase0_.initialRegimenWithSecondLineDrugs as initial21_25_, tbcase0_.issueCounter as issueCo22_25_, tbcase0_.lastBmuDateTbRegister as lastBmu23_25_, tbcase0_.lastBmuTbRegistNumber as lastBmu24_25_, tbcase0_.legacyId as legacyId25_, tbcase0_.mobileNumber as mobileN26_25_, tbcase0_.movedSecondLineTreatment as movedSe27_25_, tbcase0_.nationality as nationa28_25_, tbcase0_.NOTIF_ADDRESS as NOTIF29_25_, tbcase0_.NOTIF_ADMINUNIT_ID as NOTIF56_25_, tbcase0_.NOTIF_COMPLEMENT as NOTIF30_25_, tbcase0_.NOTIF_LOCALITYTYPE as NOTIF31_25_, tbcase0_.NOTIF_ZIPCODE as NOTIF32_25_, tbcase0_.notifAddressChanged as notifAd33_25_, tbcase0_.NOTIFICATION_UNIT_ID as NOTIFIC57_25_, tbcase0_.otherOutcome as otherOu34_25_, tbcase0_.outcomeDate as outcome35_25_, tbcase0_.OWNER_UNIT_ID as OWNER58_25_, tbcase0_.PATIENT_ID as PATIENT59_25_, tbcase0_.patientContactName as patient36_25_, tbcase0_.patientType as patient37_25_, tbcase0_.patientTypeOther as patient38_25_, tbcase0_.phoneNumber as phoneNu39_25_, tbcase0_.previouslyTreatedType as previou40_25_, tbcase0_.PULMONARY_ID as PULMONARY60_25_, tbcase0_.REGIMEN_ID as REGIMEN61_25_, tbcase0_.REGIMEN_INI_ID as REGIMEN62_25_, tbcase0_.registrationCode as registr41_25_, tbcase0_.registrationDate as registr42_25_, tbcase0_.secDrugsReceived as secDrug43_25_, tbcase0_.state as state25_, tbcase0_.suspectClassification as suspect45_25_, tbcase0_.suspectRegistrationCode as suspect46_25_, tbcase0_.tbContact as tbContact25_, tbcase0_.treatmentCategory as treatme48_25_, tbcase0_.endTreatmentDate as endTrea49_25_, tbcase0_.iniTreatmentDate as iniTrea50_25_, tbcase0_.validationState as validat51_25_, tbcase0_.version as version25_, tbcase0_1_.bcgScar as bcgScar36_, tbcase0_1_.followUpSmearStatus as followUp2_36_, tbcase0_1_.occupation as occupation36_, tbcase0_1_.PATIENTREFTO_ID as PATIENTR9_36_, tbcase0_1_.pulmonaryTypesBD as pulmonar4_36_, tbcase0_1_.REF_TO_DATE as REF5_36_, tbcase0_1_.referredToUnitName as referred6_36_, tbcase0_1_.salary as salary36_, case when tbcase0_1_.id is not null then 1 when tbcase0_.id is not null then 0 end as clazz_ from tbcase tbcase0_ left outer join tbcasebd tbcase0_1_ on tbcase0_.id=tbcase0_1_.id where tbcase0_.sync_serverId=?
Hibernate: insert into tags_case (case_id, tag_id) values (?, ?)
class org.msh.etbm.sync.CaseTag -> null
Hibernate: select tbcase0_.id as id25_, tbcase0_.sync_changed as sync2_25_, tbcase0_.sync_serverId as sync3_25_, tbcase0_.age as age25_, tbcase0_.caseDefinition as caseDefi5_25_, tbcase0_.caseNumber as caseNumber25_, tbcase0_.classification as classifi7_25_, tbcase0_.comments as comments25_, tbcase0_.CURR_ADDRESS as CURR9_25_, tbcase0_.CURR_ADMINUNIT_ID as CURR53_25_, tbcase0_.CURR_COMPLEMENT as CURR10_25_, tbcase0_.CURR_LOCALITYTYPE as CURR11_25_, tbcase0_.CURR_ZIPCODE as CURR12_25_, tbcase0_.daysTreatPlanned as daysTre13_25_, tbcase0_.diagnosisDate as diagnos14_25_, tbcase0_.diagnosisType as diagnos15_25_, tbcase0_.drugResistanceType as drugRes16_25_, tbcase0_.otherExtrapulmonary as otherEx17_25_, tbcase0_.EXTRAPULMONARY_ID as EXTRAPU54_25_, tbcase0_.otherExtrapulmonary2 as otherEx18_25_, tbcase0_.EXTRAPULMONARY2_ID as EXTRAPU55_25_, tbcase0_.infectionSite as infecti19_25_, tbcase0_.iniContinuousPhase as iniCont20_25_, tbcase0_.initialRegimenWithSecondLineDrugs as initial21_25_, tbcase0_.issueCounter as issueCo22_25_, tbcase0_.lastBmuDateTbRegister as lastBmu23_25_, tbcase0_.lastBmuTbRegistNumber as lastBmu24_25_, tbcase0_.legacyId as legacyId25_, tbcase0_.mobileNumber as mobileN26_25_, tbcase0_.movedSecondLineTreatment as movedSe27_25_, tbcase0_.nationality as nationa28_25_, tbcase0_.NOTIF_ADDRESS as NOTIF29_25_, tbcase0_.NOTIF_ADMINUNIT_ID as NOTIF56_25_, tbcase0_.NOTIF_COMPLEMENT as NOTIF30_25_, tbcase0_.NOTIF_LOCALITYTYPE as NOTIF31_25_, tbcase0_.NOTIF_ZIPCODE as NOTIF32_25_, tbcase0_.notifAddressChanged as notifAd33_25_, tbcase0_.NOTIFICATION_UNIT_ID as NOTIFIC57_25_, tbcase0_.otherOutcome as otherOu34_25_, tbcase0_.outcomeDate as outcome35_25_, tbcase0_.OWNER_UNIT_ID as OWNER58_25_, tbcase0_.PATIENT_ID as PATIENT59_25_, tbcase0_.patientContactName as patient36_25_, tbcase0_.patientType as patient37_25_, tbcase0_.patientTypeOther as patient38_25_, tbcase0_.phoneNumber as phoneNu39_25_, tbcase0_.previouslyTreatedType as previou40_25_, tbcase0_.PULMONARY_ID as PULMONARY60_25_, tbcase0_.REGIMEN_ID as REGIMEN61_25_, tbcase0_.REGIMEN_INI_ID as REGIMEN62_25_, tbcase0_.registrationCode as registr41_25_, tbcase0_.registrationDate as registr42_25_, tbcase0_.secDrugsReceived as secDrug43_25_, tbcase0_.state as state25_, tbcase0_.suspectClassification as suspect45_25_, tbcase0_.suspectRegistrationCode as suspect46_25_, tbcase0_.tbContact as tbContact25_, tbcase0_.treatmentCategory as treatme48_25_, tbcase0_.endTreatmentDate as endTrea49_25_, tbcase0_.iniTreatmentDate as iniTrea50_25_, tbcase0_.validationState as validat51_25_, tbcase0_.version as version25_, tbcase0_1_.bcgScar as bcgScar36_, tbcase0_1_.followUpSmearStatus as followUp2_36_, tbcase0_1_.occupation as occupation36_, tbcase0_1_.PATIENTREFTO_ID as PATIENTR9_36_, tbcase0_1_.pulmonaryTypesBD as pulmonar4_36_, tbcase0_1_.REF_TO_DATE as REF5_36_, tbcase0_1_.referredToUnitName as referred6_36_, tbcase0_1_.salary as salary36_, case when tbcase0_1_.id is not null then 1 when tbcase0_.id is not null then 0 end as clazz_ from tbcase tbcase0_ left outer join tbcasebd tbcase0_1_ on tbcase0_.id=tbcase0_1_.id where tbcase0_.sync_serverId=?
Hibernate: insert into tags_case (case_id, tag_id) values (?, ?)
Hibernate: select entitylast0_.entityClass as entityCl1_38_, entitylast0_.WORKSPACE_ID as WORKSPACE3_38_, entitylast0_.lastVersion as lastVers2_38_ from entitylastversion entitylast0_ where entitylast0_.entityClass=?
Hibernate: select workspace0_.id as id34_0_, workspace0_.allowDiagAfterTreatment as allowDia2_34_0_, workspace0_.allowRegAfterDiagnosis as allowReg3_34_0_, workspace0_.alternateLocale as alternat4_34_0_, workspace0_.caseValidationDRTB as caseVali5_34_0_, workspace0_.caseValidationNTM as caseVali6_34_0_, workspace0_.caseValidationTB as caseVali7_34_0_, workspace0_.confirmedCaseNumber as confirme8_34_0_, workspace0_.defaultLocale as defaultL9_34_0_, workspace0_.defaultTimeZone as default10_34_0_, workspace0_.description as descrip11_34_0_, workspace0_.extension as extension34_0_, workspace0_.maxStockOnHand as maxStoc13_34_0_, workspace0_.minStockOnHand as minStoc14_34_0_, workspace0_.monthsToAlertExpiredMedicines as monthsT15_34_0_, workspace0_.name1 as name16_34_0_, workspace0_.name2 as name17_34_0_, workspace0_.patientAddrRequiredLevels as patient18_34_0_, workspace0_.patientNameComposition as patient19_34_0_, workspace0_.sendSystemMessages as sendSys20_34_0_, workspace0_.suspectCaseNumber as suspect21_34_0_, workspace0_.treatMonitoringInput as treatMo22_34_0_, workspace0_.ulaActive as ulaActive34_0_, workspace0_.url as url34_0_, workspace0_.weekFreq1 as weekFreq25_34_0_, workspace0_.weekFreq2 as weekFreq26_34_0_, workspace0_.weekFreq3 as weekFreq27_34_0_, workspace0_.weekFreq4 as weekFreq28_34_0_, workspace0_.weekFreq5 as weekFreq29_34_0_, workspace0_.weekFreq6 as weekFreq30_34_0_, workspace0_.weekFreq7 as weekFreq31_34_0_ from workspace workspace0_ where workspace0_.id=?
Hibernate: select workspacev0_.id as id35_0_, workspacev0_.logoImage as logoImage35_0_, workspacev0_.picture as picture35_0_, workspacev0_.pictureContentType as pictureC4_35_0_ from workspaceview workspacev0_ where workspacev0_.id=?
Hibernate: insert into entitylastversion (WORKSPACE_ID, lastVersion, entityClass) values (?, ?, ?)
Hibernate: select entitylast0_.entityClass as entityCl1_38_, entitylast0_.WORKSPACE_ID as WORKSPACE3_38_, entitylast0_.lastVersion as lastVers2_38_ from entitylastversion entitylast0_ where entitylast0_.entityClass=?
Hibernate: select workspace0_.id as id34_0_, workspace0_.allowDiagAfterTreatment as allowDia2_34_0_, workspace0_.allowRegAfterDiagnosis as allowReg3_34_0_, workspace0_.alternateLocale as alternat4_34_0_, workspace0_.caseValidationDRTB as caseVali5_34_0_, workspace0_.caseValidationNTM as caseVali6_34_0_, workspace0_.caseValidationTB as caseVali7_34_0_, workspace0_.confirmedCaseNumber as confirme8_34_0_, workspace0_.defaultLocale as defaultL9_34_0_, workspace0_.defaultTimeZone as default10_34_0_, workspace0_.description as descrip11_34_0_, workspace0_.extension as extension34_0_, workspace0_.maxStockOnHand as maxStoc13_34_0_, workspace0_.minStockOnHand as minStoc14_34_0_, workspace0_.monthsToAlertExpiredMedicines as monthsT15_34_0_, workspace0_.name1 as name16_34_0_, workspace0_.name2 as name17_34_0_, workspace0_.patientAddrRequiredLevels as patient18_34_0_, workspace0_.patientNameComposition as patient19_34_0_, workspace0_.sendSystemMessages as sendSys20_34_0_, workspace0_.suspectCaseNumber as suspect21_34_0_, workspace0_.treatMonitoringInput as treatMo22_34_0_, workspace0_.ulaActive as ulaActive34_0_, workspace0_.url as url34_0_, workspace0_.weekFreq1 as weekFreq25_34_0_, workspace0_.weekFreq2 as weekFreq26_34_0_, workspace0_.weekFreq3 as weekFreq27_34_0_, workspace0_.weekFreq4 as weekFreq28_34_0_, workspace0_.weekFreq5 as weekFreq29_34_0_, workspace0_.weekFreq6 as weekFreq30_34_0_, workspace0_.weekFreq7 as weekFreq31_34_0_ from workspace workspace0_ where workspace0_.id=?
Hibernate: select workspacev0_.id as id35_0_, workspacev0_.logoImage as logoImage35_0_, workspacev0_.picture as picture35_0_, workspacev0_.pictureContentType as pictureC4_35_0_ from workspaceview workspacev0_ where workspacev0_.id=?
Hibernate: insert into entitylastversion (WORKSPACE_ID, lastVersion, entityClass) values (?, ?, ?)
Hibernate: select entitylast0_.entityClass as entityCl1_38_, entitylast0_.WORKSPACE_ID as WORKSPACE3_38_, entitylast0_.lastVersion as lastVers2_38_ from entitylastversion entitylast0_ where entitylast0_.entityClass=?
Hibernate: select workspace0_.id as id34_0_, workspace0_.allowDiagAfterTreatment as allowDia2_34_0_, workspace0_.allowRegAfterDiagnosis as allowReg3_34_0_, workspace0_.alternateLocale as alternat4_34_0_, workspace0_.caseValidationDRTB as caseVali5_34_0_, workspace0_.caseValidationNTM as caseVali6_34_0_, workspace0_.caseValidationTB as caseVali7_34_0_, workspace0_.confirmedCaseNumber as confirme8_34_0_, workspace0_.defaultLocale as defaultL9_34_0_, workspace0_.defaultTimeZone as default10_34_0_, workspace0_.description as descrip11_34_0_, workspace0_.extension as extension34_0_, workspace0_.maxStockOnHand as maxStoc13_34_0_, workspace0_.minStockOnHand as minStoc14_34_0_, workspace0_.monthsToAlertExpiredMedicines as monthsT15_34_0_, workspace0_.name1 as name16_34_0_, workspace0_.name2 as name17_34_0_, workspace0_.patientAddrRequiredLevels as patient18_34_0_, workspace0_.patientNameComposition as patient19_34_0_, workspace0_.sendSystemMessages as sendSys20_34_0_, workspace0_.suspectCaseNumber as suspect21_34_0_, workspace0_.treatMonitoringInput as treatMo22_34_0_, workspace0_.ulaActive as ulaActive34_0_, workspace0_.url as url34_0_, workspace0_.weekFreq1 as weekFreq25_34_0_, workspace0_.weekFreq2 as weekFreq26_34_0_, workspace0_.weekFreq3 as weekFreq27_34_0_, workspace0_.weekFreq4 as weekFreq28_34_0_, workspace0_.weekFreq5 as weekFreq29_34_0_, workspace0_.weekFreq6 as weekFreq30_34_0_, workspace0_.weekFreq7 as weekFreq31_34_0_ from workspace workspace0_ where workspace0_.id=?
Hibernate: select workspacev0_.id as id35_0_, workspacev0_.logoImage as logoImage35_0_, workspacev0_.picture as picture35_0_, workspacev0_.pictureContentType as pictureC4_35_0_ from workspaceview workspacev0_ where workspacev0_.id=?
Hibernate: insert into entitylastversion (WORKSPACE_ID, lastVersion, entityClass) values (?, ?, ?)
Hibernate: select entitylast0_.entityClass as entityCl1_38_, entitylast0_.WORKSPACE_ID as WORKSPACE3_38_, entitylast0_.lastVersion as lastVers2_38_ from entitylastversion entitylast0_ where entitylast0_.entityClass=?
Hibernate: select workspace0_.id as id34_0_, workspace0_.allowDiagAfterTreatment as allowDia2_34_0_, workspace0_.allowRegAfterDiagnosis as allowReg3_34_0_, workspace0_.alternateLocale as alternat4_34_0_, workspace0_.caseValidationDRTB as caseVali5_34_0_, workspace0_.caseValidationNTM as caseVali6_34_0_, workspace0_.caseValidationTB as caseVali7_34_0_, workspace0_.confirmedCaseNumber as confirme8_34_0_, workspace0_.defaultLocale as defaultL9_34_0_, workspace0_.defaultTimeZone as default10_34_0_, workspace0_.description as descrip11_34_0_, workspace0_.extension as extension34_0_, workspace0_.maxStockOnHand as maxStoc13_34_0_, workspace0_.minStockOnHand as minStoc14_34_0_, workspace0_.monthsToAlertExpiredMedicines as monthsT15_34_0_, workspace0_.name1 as name16_34_0_, workspace0_.name2 as name17_34_0_, workspace0_.patientAddrRequiredLevels as patient18_34_0_, workspace0_.patientNameComposition as patient19_34_0_, workspace0_.sendSystemMessages as sendSys20_34_0_, workspace0_.suspectCaseNumber as suspect21_34_0_, workspace0_.treatMonitoringInput as treatMo22_34_0_, workspace0_.ulaActive as ulaActive34_0_, workspace0_.url as url34_0_, workspace0_.weekFreq1 as weekFreq25_34_0_, workspace0_.weekFreq2 as weekFreq26_34_0_, workspace0_.weekFreq3 as weekFreq27_34_0_, workspace0_.weekFreq4 as weekFreq28_34_0_, workspace0_.weekFreq5 as weekFreq29_34_0_, workspace0_.weekFreq6 as weekFreq30_34_0_, workspace0_.weekFreq7 as weekFreq31_34_0_ from workspace workspace0_ where workspace0_.id=?
Hibernate: select workspacev0_.id as id35_0_, workspacev0_.logoImage as logoImage35_0_, workspacev0_.picture as picture35_0_, workspacev0_.pictureContentType as pictureC4_35_0_ from workspaceview workspacev0_ where workspacev0_.id=?
Hibernate: insert into entitylastversion (WORKSPACE_ID, lastVersion, entityClass) values (?, ?, ?)
Hibernate: select entitylast0_.entityClass as entityCl1_38_, entitylast0_.WORKSPACE_ID as WORKSPACE3_38_, entitylast0_.lastVersion as lastVers2_38_ from entitylastversion entitylast0_ where entitylast0_.entityClass=?
Hibernate: select workspace0_.id as id34_0_, workspace0_.allowDiagAfterTreatment as allowDia2_34_0_, workspace0_.allowRegAfterDiagnosis as allowReg3_34_0_, workspace0_.alternateLocale as alternat4_34_0_, workspace0_.caseValidationDRTB as caseVali5_34_0_, workspace0_.caseValidationNTM as caseVali6_34_0_, workspace0_.caseValidationTB as caseVali7_34_0_, workspace0_.confirmedCaseNumber as confirme8_34_0_, workspace0_.defaultLocale as defaultL9_34_0_, workspace0_.defaultTimeZone as default10_34_0_, workspace0_.description as descrip11_34_0_, workspace0_.extension as extension34_0_, workspace0_.maxStockOnHand as maxStoc13_34_0_, workspace0_.minStockOnHand as minStoc14_34_0_, workspace0_.monthsToAlertExpiredMedicines as monthsT15_34_0_, workspace0_.name1 as name16_34_0_, workspace0_.name2 as name17_34_0_, workspace0_.patientAddrRequiredLevels as patient18_34_0_, workspace0_.patientNameComposition as patient19_34_0_, workspace0_.sendSystemMessages as sendSys20_34_0_, workspace0_.suspectCaseNumber as suspect21_34_0_, workspace0_.treatMonitoringInput as treatMo22_34_0_, workspace0_.ulaActive as ulaActive34_0_, workspace0_.url as url34_0_, workspace0_.weekFreq1 as weekFreq25_34_0_, workspace0_.weekFreq2 as weekFreq26_34_0_, workspace0_.weekFreq3 as weekFreq27_34_0_, workspace0_.weekFreq4 as weekFreq28_34_0_, workspace0_.weekFreq5 as weekFreq29_34_0_, workspace0_.weekFreq6 as weekFreq30_34_0_, workspace0_.weekFreq7 as weekFreq31_34_0_ from workspace workspace0_ where workspace0_.id=?
Hibernate: select workspacev0_.id as id35_0_, workspacev0_.logoImage as logoImage35_0_, workspacev0_.picture as picture35_0_, workspacev0_.pictureContentType as pictureC4_35_0_ from workspaceview workspacev0_ where workspacev0_.id=?
Hibernate: insert into entitylastversion (WORKSPACE_ID, lastVersion, entityClass) values (?, ?, ?)
Hibernate: select entitylast0_.entityClass as entityCl1_38_, entitylast0_.WORKSPACE_ID as WORKSPACE3_38_, entitylast0_.lastVersion as lastVers2_38_ from entitylastversion entitylast0_ where entitylast0_.entityClass=?
Hibernate: select workspace0_.id as id34_0_, workspace0_.allowDiagAfterTreatment as allowDia2_34_0_, workspace0_.allowRegAfterDiagnosis as allowReg3_34_0_, workspace0_.alternateLocale as alternat4_34_0_, workspace0_.caseValidationDRTB as caseVali5_34_0_, workspace0_.caseValidationNTM as caseVali6_34_0_, workspace0_.caseValidationTB as caseVali7_34_0_, workspace0_.confirmedCaseNumber as confirme8_34_0_, workspace0_.defaultLocale as defaultL9_34_0_, workspace0_.defaultTimeZone as default10_34_0_, workspace0_.description as descrip11_34_0_, workspace0_.extension as extension34_0_, workspace0_.maxStockOnHand as maxStoc13_34_0_, workspace0_.minStockOnHand as minStoc14_34_0_, workspace0_.monthsToAlertExpiredMedicines as monthsT15_34_0_, workspace0_.name1 as name16_34_0_, workspace0_.name2 as name17_34_0_, workspace0_.patientAddrRequiredLevels as patient18_34_0_, workspace0_.patientNameComposition as patient19_34_0_, workspace0_.sendSystemMessages as sendSys20_34_0_, workspace0_.suspectCaseNumber as suspect21_34_0_, workspace0_.treatMonitoringInput as treatMo22_34_0_, workspace0_.ulaActive as ulaActive34_0_, workspace0_.url as url34_0_, workspace0_.weekFreq1 as weekFreq25_34_0_, workspace0_.weekFreq2 as weekFreq26_34_0_, workspace0_.weekFreq3 as weekFreq27_34_0_, workspace0_.weekFreq4 as weekFreq28_34_0_, workspace0_.weekFreq5 as weekFreq29_34_0_, workspace0_.weekFreq6 as weekFreq30_34_0_, workspace0_.weekFreq7 as weekFreq31_34_0_ from workspace workspace0_ where workspace0_.id=?
Hibernate: select workspacev0_.id as id35_0_, workspacev0_.logoImage as logoImage35_0_, workspacev0_.picture as picture35_0_, workspacev0_.pictureContentType as pictureC4_35_0_ from workspaceview workspacev0_ where workspacev0_.id=?
Hibernate: insert into entitylastversion (WORKSPACE_ID, lastVersion, entityClass) values (?, ?, ?)
Hibernate: select entitylast0_.entityClass as entityCl1_38_, entitylast0_.WORKSPACE_ID as WORKSPACE3_38_, entitylast0_.lastVersion as lastVers2_38_ from entitylastversion entitylast0_ where entitylast0_.entityClass=?
Hibernate: select workspace0_.id as id34_0_, workspace0_.allowDiagAfterTreatment as allowDia2_34_0_, workspace0_.allowRegAfterDiagnosis as allowReg3_34_0_, workspace0_.alternateLocale as alternat4_34_0_, workspace0_.caseValidationDRTB as caseVali5_34_0_, workspace0_.caseValidationNTM as caseVali6_34_0_, workspace0_.caseValidationTB as caseVali7_34_0_, workspace0_.confirmedCaseNumber as confirme8_34_0_, workspace0_.defaultLocale as defaultL9_34_0_, workspace0_.defaultTimeZone as default10_34_0_, workspace0_.description as descrip11_34_0_, workspace0_.extension as extension34_0_, workspace0_.maxStockOnHand as maxStoc13_34_0_, workspace0_.minStockOnHand as minStoc14_34_0_, workspace0_.monthsToAlertExpiredMedicines as monthsT15_34_0_, workspace0_.name1 as name16_34_0_, workspace0_.name2 as name17_34_0_, workspace0_.patientAddrRequiredLevels as patient18_34_0_, workspace0_.patientNameComposition as patient19_34_0_, workspace0_.sendSystemMessages as sendSys20_34_0_, workspace0_.suspectCaseNumber as suspect21_34_0_, workspace0_.treatMonitoringInput as treatMo22_34_0_, workspace0_.ulaActive as ulaActive34_0_, workspace0_.url as url34_0_, workspace0_.weekFreq1 as weekFreq25_34_0_, workspace0_.weekFreq2 as weekFreq26_34_0_, workspace0_.weekFreq3 as weekFreq27_34_0_, workspace0_.weekFreq4 as weekFreq28_34_0_, workspace0_.weekFreq5 as weekFreq29_34_0_, workspace0_.weekFreq6 as weekFreq30_34_0_, workspace0_.weekFreq7 as weekFreq31_34_0_ from workspace workspace0_ where workspace0_.id=?
Hibernate: select workspacev0_.id as id35_0_, workspacev0_.logoImage as logoImage35_0_, workspacev0_.picture as picture35_0_, workspacev0_.pictureContentType as pictureC4_35_0_ from workspaceview workspacev0_ where workspacev0_.id=?
Hibernate: insert into entitylastversion (WORKSPACE_ID, lastVersion, entityClass) values (?, ?, ?)
Hibernate: select entitylast0_.entityClass as entityCl1_38_, entitylast0_.WORKSPACE_ID as WORKSPACE3_38_, entitylast0_.lastVersion as lastVers2_38_ from entitylastversion entitylast0_ where entitylast0_.entityClass=?
Hibernate: select workspace0_.id as id34_0_, workspace0_.allowDiagAfterTreatment as allowDia2_34_0_, workspace0_.allowRegAfterDiagnosis as allowReg3_34_0_, workspace0_.alternateLocale as alternat4_34_0_, workspace0_.caseValidationDRTB as caseVali5_34_0_, workspace0_.caseValidationNTM as caseVali6_34_0_, workspace0_.caseValidationTB as caseVali7_34_0_, workspace0_.confirmedCaseNumber as confirme8_34_0_, workspace0_.defaultLocale as defaultL9_34_0_, workspace0_.defaultTimeZone as default10_34_0_, workspace0_.description as descrip11_34_0_, workspace0_.extension as extension34_0_, workspace0_.maxStockOnHand as maxStoc13_34_0_, workspace0_.minStockOnHand as minStoc14_34_0_, workspace0_.monthsToAlertExpiredMedicines as monthsT15_34_0_, workspace0_.name1 as name16_34_0_, workspace0_.name2 as name17_34_0_, workspace0_.patientAddrRequiredLevels as patient18_34_0_, workspace0_.patientNameComposition as patient19_34_0_, workspace0_.sendSystemMessages as sendSys20_34_0_, workspace0_.suspectCaseNumber as suspect21_34_0_, workspace0_.treatMonitoringInput as treatMo22_34_0_, workspace0_.ulaActive as ulaActive34_0_, workspace0_.url as url34_0_, workspace0_.weekFreq1 as weekFreq25_34_0_, workspace0_.weekFreq2 as weekFreq26_34_0_, workspace0_.weekFreq3 as weekFreq27_34_0_, workspace0_.weekFreq4 as weekFreq28_34_0_, workspace0_.weekFreq5 as weekFreq29_34_0_, workspace0_.weekFreq6 as weekFreq30_34_0_, workspace0_.weekFreq7 as weekFreq31_34_0_ from workspace workspace0_ where workspace0_.id=?
Hibernate: select workspacev0_.id as id35_0_, workspacev0_.logoImage as logoImage35_0_, workspacev0_.picture as picture35_0_, workspacev0_.pictureContentType as pictureC4_35_0_ from workspaceview workspacev0_ where workspacev0_.id=?
Hibernate: insert into entitylastversion (WORKSPACE_ID, lastVersion, entityClass) values (?, ?, ?)
Hibernate: select entitylast0_.entityClass as entityCl1_38_, entitylast0_.WORKSPACE_ID as WORKSPACE3_38_, entitylast0_.lastVersion as lastVers2_38_ from entitylastversion entitylast0_ where entitylast0_.entityClass=?
Hibernate: select workspace0_.id as id34_0_, workspace0_.allowDiagAfterTreatment as allowDia2_34_0_, workspace0_.allowRegAfterDiagnosis as allowReg3_34_0_, workspace0_.alternateLocale as alternat4_34_0_, workspace0_.caseValidationDRTB as caseVali5_34_0_, workspace0_.caseValidationNTM as caseVali6_34_0_, workspace0_.caseValidationTB as caseVali7_34_0_, workspace0_.confirmedCaseNumber as confirme8_34_0_, workspace0_.defaultLocale as defaultL9_34_0_, workspace0_.defaultTimeZone as default10_34_0_, workspace0_.description as descrip11_34_0_, workspace0_.extension as extension34_0_, workspace0_.maxStockOnHand as maxStoc13_34_0_, workspace0_.minStockOnHand as minStoc14_34_0_, workspace0_.monthsToAlertExpiredMedicines as monthsT15_34_0_, workspace0_.name1 as name16_34_0_, workspace0_.name2 as name17_34_0_, workspace0_.patientAddrRequiredLevels as patient18_34_0_, workspace0_.patientNameComposition as patient19_34_0_, workspace0_.sendSystemMessages as sendSys20_34_0_, workspace0_.suspectCaseNumber as suspect21_34_0_, workspace0_.treatMonitoringInput as treatMo22_34_0_, workspace0_.ulaActive as ulaActive34_0_, workspace0_.url as url34_0_, workspace0_.weekFreq1 as weekFreq25_34_0_, workspace0_.weekFreq2 as weekFreq26_34_0_, workspace0_.weekFreq3 as weekFreq27_34_0_, workspace0_.weekFreq4 as weekFreq28_34_0_, workspace0_.weekFreq5 as weekFreq29_34_0_, workspace0_.weekFreq6 as weekFreq30_34_0_, workspace0_.weekFreq7 as weekFreq31_34_0_ from workspace workspace0_ where workspace0_.id=?
Hibernate: select workspacev0_.id as id35_0_, workspacev0_.logoImage as logoImage35_0_, workspacev0_.picture as picture35_0_, workspacev0_.pictureContentType as pictureC4_35_0_ from workspaceview workspacev0_ where workspacev0_.id=?
Hibernate: insert into entitylastversion (WORKSPACE_ID, lastVersion, entityClass) values (?, ?, ?)
Hibernate: select entitylast0_.entityClass as entityCl1_38_, entitylast0_.WORKSPACE_ID as WORKSPACE3_38_, entitylast0_.lastVersion as lastVers2_38_ from entitylastversion entitylast0_ where entitylast0_.entityClass=?
Hibernate: select workspace0_.id as id34_0_, workspace0_.allowDiagAfterTreatment as allowDia2_34_0_, workspace0_.allowRegAfterDiagnosis as allowReg3_34_0_, workspace0_.alternateLocale as alternat4_34_0_, workspace0_.caseValidationDRTB as caseVali5_34_0_, workspace0_.caseValidationNTM as caseVali6_34_0_, workspace0_.caseValidationTB as caseVali7_34_0_, workspace0_.confirmedCaseNumber as confirme8_34_0_, workspace0_.defaultLocale as defaultL9_34_0_, workspace0_.defaultTimeZone as default10_34_0_, workspace0_.description as descrip11_34_0_, workspace0_.extension as extension34_0_, workspace0_.maxStockOnHand as maxStoc13_34_0_, workspace0_.minStockOnHand as minStoc14_34_0_, workspace0_.monthsToAlertExpiredMedicines as monthsT15_34_0_, workspace0_.name1 as name16_34_0_, workspace0_.name2 as name17_34_0_, workspace0_.patientAddrRequiredLevels as patient18_34_0_, workspace0_.patientNameComposition as patient19_34_0_, workspace0_.sendSystemMessages as sendSys20_34_0_, workspace0_.suspectCaseNumber as suspect21_34_0_, workspace0_.treatMonitoringInput as treatMo22_34_0_, workspace0_.ulaActive as ulaActive34_0_, workspace0_.url as url34_0_, workspace0_.weekFreq1 as weekFreq25_34_0_, workspace0_.weekFreq2 as weekFreq26_34_0_, workspace0_.weekFreq3 as weekFreq27_34_0_, workspace0_.weekFreq4 as weekFreq28_34_0_, workspace0_.weekFreq5 as weekFreq29_34_0_, workspace0_.weekFreq6 as weekFreq30_34_0_, workspace0_.weekFreq7 as weekFreq31_34_0_ from workspace workspace0_ where workspace0_.id=?
Hibernate: select workspacev0_.id as id35_0_, workspacev0_.logoImage as logoImage35_0_, workspacev0_.picture as picture35_0_, workspacev0_.pictureContentType as pictureC4_35_0_ from workspaceview workspacev0_ where workspacev0_.id=?
Hibernate: insert into entitylastversion (WORKSPACE_ID, lastVersion, entityClass) values (?, ?, ?)
Hibernate: select entitylast0_.entityClass as entityCl1_38_, entitylast0_.WORKSPACE_ID as WORKSPACE3_38_, entitylast0_.lastVersion as lastVers2_38_ from entitylastversion entitylast0_ where entitylast0_.entityClass=?
Hibernate: select workspace0_.id as id34_0_, workspace0_.allowDiagAfterTreatment as allowDia2_34_0_, workspace0_.allowRegAfterDiagnosis as allowReg3_34_0_, workspace0_.alternateLocale as alternat4_34_0_, workspace0_.caseValidationDRTB as caseVali5_34_0_, workspace0_.caseValidationNTM as caseVali6_34_0_, workspace0_.caseValidationTB as caseVali7_34_0_, workspace0_.confirmedCaseNumber as confirme8_34_0_, workspace0_.defaultLocale as defaultL9_34_0_, workspace0_.defaultTimeZone as default10_34_0_, workspace0_.description as descrip11_34_0_, workspace0_.extension as extension34_0_, workspace0_.maxStockOnHand as maxStoc13_34_0_, workspace0_.minStockOnHand as minStoc14_34_0_, workspace0_.monthsToAlertExpiredMedicines as monthsT15_34_0_, workspace0_.name1 as name16_34_0_, workspace0_.name2 as name17_34_0_, workspace0_.patientAddrRequiredLevels as patient18_34_0_, workspace0_.patientNameComposition as patient19_34_0_, workspace0_.sendSystemMessages as sendSys20_34_0_, workspace0_.suspectCaseNumber as suspect21_34_0_, workspace0_.treatMonitoringInput as treatMo22_34_0_, workspace0_.ulaActive as ulaActive34_0_, workspace0_.url as url34_0_, workspace0_.weekFreq1 as weekFreq25_34_0_, workspace0_.weekFreq2 as weekFreq26_34_0_, workspace0_.weekFreq3 as weekFreq27_34_0_, workspace0_.weekFreq4 as weekFreq28_34_0_, workspace0_.weekFreq5 as weekFreq29_34_0_, workspace0_.weekFreq6 as weekFreq30_34_0_, workspace0_.weekFreq7 as weekFreq31_34_0_ from workspace workspace0_ where workspace0_.id=?
Hibernate: select workspacev0_.id as id35_0_, workspacev0_.logoImage as logoImage35_0_, workspacev0_.picture as picture35_0_, workspacev0_.pictureContentType as pictureC4_35_0_ from workspaceview workspacev0_ where workspacev0_.id=?
Hibernate: insert into entitylastversion (WORKSPACE_ID, lastVersion, entityClass) values (?, ?, ?)
Hibernate: select entitylast0_.entityClass as entityCl1_38_, entitylast0_.WORKSPACE_ID as WORKSPACE3_38_, entitylast0_.lastVersion as lastVers2_38_ from entitylastversion entitylast0_ where entitylast0_.entityClass=?
Hibernate: select workspace0_.id as id34_0_, workspace0_.allowDiagAfterTreatment as allowDia2_34_0_, workspace0_.allowRegAfterDiagnosis as allowReg3_34_0_, workspace0_.alternateLocale as alternat4_34_0_, workspace0_.caseValidationDRTB as caseVali5_34_0_, workspace0_.caseValidationNTM as caseVali6_34_0_, workspace0_.caseValidationTB as caseVali7_34_0_, workspace0_.confirmedCaseNumber as confirme8_34_0_, workspace0_.defaultLocale as defaultL9_34_0_, workspace0_.defaultTimeZone as default10_34_0_, workspace0_.description as descrip11_34_0_, workspace0_.extension as extension34_0_, workspace0_.maxStockOnHand as maxStoc13_34_0_, workspace0_.minStockOnHand as minStoc14_34_0_, workspace0_.monthsToAlertExpiredMedicines as monthsT15_34_0_, workspace0_.name1 as name16_34_0_, workspace0_.name2 as name17_34_0_, workspace0_.patientAddrRequiredLevels as patient18_34_0_, workspace0_.patientNameComposition as patient19_34_0_, workspace0_.sendSystemMessages as sendSys20_34_0_, workspace0_.suspectCaseNumber as suspect21_34_0_, workspace0_.treatMonitoringInput as treatMo22_34_0_, workspace0_.ulaActive as ulaActive34_0_, workspace0_.url as url34_0_, workspace0_.weekFreq1 as weekFreq25_34_0_, workspace0_.weekFreq2 as weekFreq26_34_0_, workspace0_.weekFreq3 as weekFreq27_34_0_, workspace0_.weekFreq4 as weekFreq28_34_0_, workspace0_.weekFreq5 as weekFreq29_34_0_, workspace0_.weekFreq6 as weekFreq30_34_0_, workspace0_.weekFreq7 as weekFreq31_34_0_ from workspace workspace0_ where workspace0_.id=?
Hibernate: select workspacev0_.id as id35_0_, workspacev0_.logoImage as logoImage35_0_, workspacev0_.picture as picture35_0_, workspacev0_.pictureContentType as pictureC4_35_0_ from workspaceview workspacev0_ where workspacev0_.id=?
Hibernate: insert into entitylastversion (WORKSPACE_ID, lastVersion, entityClass) values (?, ?, ?)
Hibernate: select entitylast0_.entityClass as entityCl1_38_, entitylast0_.WORKSPACE_ID as WORKSPACE3_38_, entitylast0_.lastVersion as lastVers2_38_ from entitylastversion entitylast0_ where entitylast0_.entityClass=?
Hibernate: select workspace0_.id as id34_0_, workspace0_.allowDiagAfterTreatment as allowDia2_34_0_, workspace0_.allowRegAfterDiagnosis as allowReg3_34_0_, workspace0_.alternateLocale as alternat4_34_0_, workspace0_.caseValidationDRTB as caseVali5_34_0_, workspace0_.caseValidationNTM as caseVali6_34_0_, workspace0_.caseValidationTB as caseVali7_34_0_, workspace0_.confirmedCaseNumber as confirme8_34_0_, workspace0_.defaultLocale as defaultL9_34_0_, workspace0_.defaultTimeZone as default10_34_0_, workspace0_.description as descrip11_34_0_, workspace0_.extension as extension34_0_, workspace0_.maxStockOnHand as maxStoc13_34_0_, workspace0_.minStockOnHand as minStoc14_34_0_, workspace0_.monthsToAlertExpiredMedicines as monthsT15_34_0_, workspace0_.name1 as name16_34_0_, workspace0_.name2 as name17_34_0_, workspace0_.patientAddrRequiredLevels as patient18_34_0_, workspace0_.patientNameComposition as patient19_34_0_, workspace0_.sendSystemMessages as sendSys20_34_0_, workspace0_.suspectCaseNumber as suspect21_34_0_, workspace0_.treatMonitoringInput as treatMo22_34_0_, workspace0_.ulaActive as ulaActive34_0_, workspace0_.url as url34_0_, workspace0_.weekFreq1 as weekFreq25_34_0_, workspace0_.weekFreq2 as weekFreq26_34_0_, workspace0_.weekFreq3 as weekFreq27_34_0_, workspace0_.weekFreq4 as weekFreq28_34_0_, workspace0_.weekFreq5 as weekFreq29_34_0_, workspace0_.weekFreq6 as weekFreq30_34_0_, workspace0_.weekFreq7 as weekFreq31_34_0_ from workspace workspace0_ where workspace0_.id=?
Hibernate: select workspacev0_.id as id35_0_, workspacev0_.logoImage as logoImage35_0_, workspacev0_.picture as picture35_0_, workspacev0_.pictureContentType as pictureC4_35_0_ from workspaceview workspacev0_ where workspacev0_.id=?
Hibernate: insert into entitylastversion (WORKSPACE_ID, lastVersion, entityClass) values (?, ?, ?)
Hibernate: select entitylast0_.entityClass as entityCl1_38_, entitylast0_.WORKSPACE_ID as WORKSPACE3_38_, entitylast0_.lastVersion as lastVers2_38_ from entitylastversion entitylast0_ where entitylast0_.entityClass=?
Hibernate: select workspace0_.id as id34_0_, workspace0_.allowDiagAfterTreatment as allowDia2_34_0_, workspace0_.allowRegAfterDiagnosis as allowReg3_34_0_, workspace0_.alternateLocale as alternat4_34_0_, workspace0_.caseValidationDRTB as caseVali5_34_0_, workspace0_.caseValidationNTM as caseVali6_34_0_, workspace0_.caseValidationTB as caseVali7_34_0_, workspace0_.confirmedCaseNumber as confirme8_34_0_, workspace0_.defaultLocale as defaultL9_34_0_, workspace0_.defaultTimeZone as default10_34_0_, workspace0_.description as descrip11_34_0_, workspace0_.extension as extension34_0_, workspace0_.maxStockOnHand as maxStoc13_34_0_, workspace0_.minStockOnHand as minStoc14_34_0_, workspace0_.monthsToAlertExpiredMedicines as monthsT15_34_0_, workspace0_.name1 as name16_34_0_, workspace0_.name2 as name17_34_0_, workspace0_.patientAddrRequiredLevels as patient18_34_0_, workspace0_.patientNameComposition as patient19_34_0_, workspace0_.sendSystemMessages as sendSys20_34_0_, workspace0_.suspectCaseNumber as suspect21_34_0_, workspace0_.treatMonitoringInput as treatMo22_34_0_, workspace0_.ulaActive as ulaActive34_0_, workspace0_.url as url34_0_, workspace0_.weekFreq1 as weekFreq25_34_0_, workspace0_.weekFreq2 as weekFreq26_34_0_, workspace0_.weekFreq3 as weekFreq27_34_0_, workspace0_.weekFreq4 as weekFreq28_34_0_, workspace0_.weekFreq5 as weekFreq29_34_0_, workspace0_.weekFreq6 as weekFreq30_34_0_, workspace0_.weekFreq7 as weekFreq31_34_0_ from workspace workspace0_ where workspace0_.id=?
Hibernate: select workspacev0_.id as id35_0_, workspacev0_.logoImage as logoImage35_0_, workspacev0_.picture as picture35_0_, workspacev0_.pictureContentType as pictureC4_35_0_ from workspaceview workspacev0_ where workspacev0_.id=?
Hibernate: insert into entitylastversion (WORKSPACE_ID, lastVersion, entityClass) values (?, ?, ?)
Hibernate: select entitylast0_.entityClass as entityCl1_38_, entitylast0_.WORKSPACE_ID as WORKSPACE3_38_, entitylast0_.lastVersion as lastVers2_38_ from entitylastversion entitylast0_ where entitylast0_.entityClass=?
Hibernate: select workspace0_.id as id34_0_, workspace0_.allowDiagAfterTreatment as allowDia2_34_0_, workspace0_.allowRegAfterDiagnosis as allowReg3_34_0_, workspace0_.alternateLocale as alternat4_34_0_, workspace0_.caseValidationDRTB as caseVali5_34_0_, workspace0_.caseValidationNTM as caseVali6_34_0_, workspace0_.caseValidationTB as caseVali7_34_0_, workspace0_.confirmedCaseNumber as confirme8_34_0_, workspace0_.defaultLocale as defaultL9_34_0_, workspace0_.defaultTimeZone as default10_34_0_, workspace0_.description as descrip11_34_0_, workspace0_.extension as extension34_0_, workspace0_.maxStockOnHand as maxStoc13_34_0_, workspace0_.minStockOnHand as minStoc14_34_0_, workspace0_.monthsToAlertExpiredMedicines as monthsT15_34_0_, workspace0_.name1 as name16_34_0_, workspace0_.name2 as name17_34_0_, workspace0_.patientAddrRequiredLevels as patient18_34_0_, workspace0_.patientNameComposition as patient19_34_0_, workspace0_.sendSystemMessages as sendSys20_34_0_, workspace0_.suspectCaseNumber as suspect21_34_0_, workspace0_.treatMonitoringInput as treatMo22_34_0_, workspace0_.ulaActive as ulaActive34_0_, workspace0_.url as url34_0_, workspace0_.weekFreq1 as weekFreq25_34_0_, workspace0_.weekFreq2 as weekFreq26_34_0_, workspace0_.weekFreq3 as weekFreq27_34_0_, workspace0_.weekFreq4 as weekFreq28_34_0_, workspace0_.weekFreq5 as weekFreq29_34_0_, workspace0_.weekFreq6 as weekFreq30_34_0_, workspace0_.weekFreq7 as weekFreq31_34_0_ from workspace workspace0_ where workspace0_.id=?
Hibernate: select workspacev0_.id as id35_0_, workspacev0_.logoImage as logoImage35_0_, workspacev0_.picture as picture35_0_, workspacev0_.pictureContentType as pictureC4_35_0_ from workspaceview workspacev0_ where workspacev0_.id=?
Hibernate: insert into entitylastversion (WORKSPACE_ID, lastVersion, entityClass) values (?, ?, ?)
Hibernate: select entitylast0_.entityClass as entityCl1_38_, entitylast0_.WORKSPACE_ID as WORKSPACE3_38_, entitylast0_.lastVersion as lastVers2_38_ from entitylastversion entitylast0_ where entitylast0_.entityClass=?
Hibernate: select workspace0_.id as id34_0_, workspace0_.allowDiagAfterTreatment as allowDia2_34_0_, workspace0_.allowRegAfterDiagnosis as allowReg3_34_0_, workspace0_.alternateLocale as alternat4_34_0_, workspace0_.caseValidationDRTB as caseVali5_34_0_, workspace0_.caseValidationNTM as caseVali6_34_0_, workspace0_.caseValidationTB as caseVali7_34_0_, workspace0_.confirmedCaseNumber as confirme8_34_0_, workspace0_.defaultLocale as defaultL9_34_0_, workspace0_.defaultTimeZone as default10_34_0_, workspace0_.description as descrip11_34_0_, workspace0_.extension as extension34_0_, workspace0_.maxStockOnHand as maxStoc13_34_0_, workspace0_.minStockOnHand as minStoc14_34_0_, workspace0_.monthsToAlertExpiredMedicines as monthsT15_34_0_, workspace0_.name1 as name16_34_0_, workspace0_.name2 as name17_34_0_, workspace0_.patientAddrRequiredLevels as patient18_34_0_, workspace0_.patientNameComposition as patient19_34_0_, workspace0_.sendSystemMessages as sendSys20_34_0_, workspace0_.suspectCaseNumber as suspect21_34_0_, workspace0_.treatMonitoringInput as treatMo22_34_0_, workspace0_.ulaActive as ulaActive34_0_, workspace0_.url as url34_0_, workspace0_.weekFreq1 as weekFreq25_34_0_, workspace0_.weekFreq2 as weekFreq26_34_0_, workspace0_.weekFreq3 as weekFreq27_34_0_, workspace0_.weekFreq4 as weekFreq28_34_0_, workspace0_.weekFreq5 as weekFreq29_34_0_, workspace0_.weekFreq6 as weekFreq30_34_0_, workspace0_.weekFreq7 as weekFreq31_34_0_ from workspace workspace0_ where workspace0_.id=?
Hibernate: select workspacev0_.id as id35_0_, workspacev0_.logoImage as logoImage35_0_, workspacev0_.picture as picture35_0_, workspacev0_.pictureContentType as pictureC4_35_0_ from workspaceview workspacev0_ where workspacev0_.id=?
Hibernate: insert into entitylastversion (WORKSPACE_ID, lastVersion, entityClass) values (?, ?, ?)
Hibernate: select entitylast0_.entityClass as entityCl1_38_, entitylast0_.WORKSPACE_ID as WORKSPACE3_38_, entitylast0_.lastVersion as lastVers2_38_ from entitylastversion entitylast0_ where entitylast0_.entityClass=?
Hibernate: select workspace0_.id as id34_0_, workspace0_.allowDiagAfterTreatment as allowDia2_34_0_, workspace0_.allowRegAfterDiagnosis as allowReg3_34_0_, workspace0_.alternateLocale as alternat4_34_0_, workspace0_.caseValidationDRTB as caseVali5_34_0_, workspace0_.caseValidationNTM as caseVali6_34_0_, workspace0_.caseValidationTB as caseVali7_34_0_, workspace0_.confirmedCaseNumber as confirme8_34_0_, workspace0_.defaultLocale as defaultL9_34_0_, workspace0_.defaultTimeZone as default10_34_0_, workspace0_.description as descrip11_34_0_, workspace0_.extension as extension34_0_, workspace0_.maxStockOnHand as maxStoc13_34_0_, workspace0_.minStockOnHand as minStoc14_34_0_, workspace0_.monthsToAlertExpiredMedicines as monthsT15_34_0_, workspace0_.name1 as name16_34_0_, workspace0_.name2 as name17_34_0_, workspace0_.patientAddrRequiredLevels as patient18_34_0_, workspace0_.patientNameComposition as patient19_34_0_, workspace0_.sendSystemMessages as sendSys20_34_0_, workspace0_.suspectCaseNumber as suspect21_34_0_, workspace0_.treatMonitoringInput as treatMo22_34_0_, workspace0_.ulaActive as ulaActive34_0_, workspace0_.url as url34_0_, workspace0_.weekFreq1 as weekFreq25_34_0_, workspace0_.weekFreq2 as weekFreq26_34_0_, workspace0_.weekFreq3 as weekFreq27_34_0_, workspace0_.weekFreq4 as weekFreq28_34_0_, workspace0_.weekFreq5 as weekFreq29_34_0_, workspace0_.weekFreq6 as weekFreq30_34_0_, workspace0_.weekFreq7 as weekFreq31_34_0_ from workspace workspace0_ where workspace0_.id=?
Hibernate: select workspacev0_.id as id35_0_, workspacev0_.logoImage as logoImage35_0_, workspacev0_.picture as picture35_0_, workspacev0_.pictureContentType as pictureC4_35_0_ from workspaceview workspacev0_ where workspacev0_.id=?
Hibernate: insert into entitylastversion (WORKSPACE_ID, lastVersion, entityClass) values (?, ?, ?)
Hibernate: select entitylast0_.entityClass as entityCl1_38_, entitylast0_.WORKSPACE_ID as WORKSPACE3_38_, entitylast0_.lastVersion as lastVers2_38_ from entitylastversion entitylast0_ where entitylast0_.entityClass=?
Hibernate: select workspace0_.id as id34_0_, workspace0_.allowDiagAfterTreatment as allowDia2_34_0_, workspace0_.allowRegAfterDiagnosis as allowReg3_34_0_, workspace0_.alternateLocale as alternat4_34_0_, workspace0_.caseValidationDRTB as caseVali5_34_0_, workspace0_.caseValidationNTM as caseVali6_34_0_, workspace0_.caseValidationTB as caseVali7_34_0_, workspace0_.confirmedCaseNumber as confirme8_34_0_, workspace0_.defaultLocale as defaultL9_34_0_, workspace0_.defaultTimeZone as default10_34_0_, workspace0_.description as descrip11_34_0_, workspace0_.extension as extension34_0_, workspace0_.maxStockOnHand as maxStoc13_34_0_, workspace0_.minStockOnHand as minStoc14_34_0_, workspace0_.monthsToAlertExpiredMedicines as monthsT15_34_0_, workspace0_.name1 as name16_34_0_, workspace0_.name2 as name17_34_0_, workspace0_.patientAddrRequiredLevels as patient18_34_0_, workspace0_.patientNameComposition as patient19_34_0_, workspace0_.sendSystemMessages as sendSys20_34_0_, workspace0_.suspectCaseNumber as suspect21_34_0_, workspace0_.treatMonitoringInput as treatMo22_34_0_, workspace0_.ulaActive as ulaActive34_0_, workspace0_.url as url34_0_, workspace0_.weekFreq1 as weekFreq25_34_0_, workspace0_.weekFreq2 as weekFreq26_34_0_, workspace0_.weekFreq3 as weekFreq27_34_0_, workspace0_.weekFreq4 as weekFreq28_34_0_, workspace0_.weekFreq5 as weekFreq29_34_0_, workspace0_.weekFreq6 as weekFreq30_34_0_, workspace0_.weekFreq7 as weekFreq31_34_0_ from workspace workspace0_ where workspace0_.id=?
Hibernate: select workspacev0_.id as id35_0_, workspacev0_.logoImage as logoImage35_0_, workspacev0_.picture as picture35_0_, workspacev0_.pictureContentType as pictureC4_35_0_ from workspaceview workspacev0_ where workspacev0_.id=?
Hibernate: insert into entitylastversion (WORKSPACE_ID, lastVersion, entityClass) values (?, ?, ?)
Hibernate: select entitylast0_.entityClass as entityCl1_38_, entitylast0_.WORKSPACE_ID as WORKSPACE3_38_, entitylast0_.lastVersion as lastVers2_38_ from entitylastversion entitylast0_ where entitylast0_.entityClass=?
Hibernate: select workspace0_.id as id34_0_, workspace0_.allowDiagAfterTreatment as allowDia2_34_0_, workspace0_.allowRegAfterDiagnosis as allowReg3_34_0_, workspace0_.alternateLocale as alternat4_34_0_, workspace0_.caseValidationDRTB as caseVali5_34_0_, workspace0_.caseValidationNTM as caseVali6_34_0_, workspace0_.caseValidationTB as caseVali7_34_0_, workspace0_.confirmedCaseNumber as confirme8_34_0_, workspace0_.defaultLocale as defaultL9_34_0_, workspace0_.defaultTimeZone as default10_34_0_, workspace0_.description as descrip11_34_0_, workspace0_.extension as extension34_0_, workspace0_.maxStockOnHand as maxStoc13_34_0_, workspace0_.minStockOnHand as minStoc14_34_0_, workspace0_.monthsToAlertExpiredMedicines as monthsT15_34_0_, workspace0_.name1 as name16_34_0_, workspace0_.name2 as name17_34_0_, workspace0_.patientAddrRequiredLevels as patient18_34_0_, workspace0_.patientNameComposition as patient19_34_0_, workspace0_.sendSystemMessages as sendSys20_34_0_, workspace0_.suspectCaseNumber as suspect21_34_0_, workspace0_.treatMonitoringInput as treatMo22_34_0_, workspace0_.ulaActive as ulaActive34_0_, workspace0_.url as url34_0_, workspace0_.weekFreq1 as weekFreq25_34_0_, workspace0_.weekFreq2 as weekFreq26_34_0_, workspace0_.weekFreq3 as weekFreq27_34_0_, workspace0_.weekFreq4 as weekFreq28_34_0_, workspace0_.weekFreq5 as weekFreq29_34_0_, workspace0_.weekFreq6 as weekFreq30_34_0_, workspace0_.weekFreq7 as weekFreq31_34_0_ from workspace workspace0_ where workspace0_.id=?
Hibernate: select workspacev0_.id as id35_0_, workspacev0_.logoImage as logoImage35_0_, workspacev0_.picture as picture35_0_, workspacev0_.pictureContentType as pictureC4_35_0_ from workspaceview workspacev0_ where workspacev0_.id=?
Hibernate: insert into entitylastversion (WORKSPACE_ID, lastVersion, entityClass) values (?, ?, ?)
Hibernate: select entitylast0_.entityClass as entityCl1_38_, entitylast0_.WORKSPACE_ID as WORKSPACE3_38_, entitylast0_.lastVersion as lastVers2_38_ from entitylastversion entitylast0_ where entitylast0_.entityClass=?
Hibernate: select workspace0_.id as id34_0_, workspace0_.allowDiagAfterTreatment as allowDia2_34_0_, workspace0_.allowRegAfterDiagnosis as allowReg3_34_0_, workspace0_.alternateLocale as alternat4_34_0_, workspace0_.caseValidationDRTB as caseVali5_34_0_, workspace0_.caseValidationNTM as caseVali6_34_0_, workspace0_.caseValidationTB as caseVali7_34_0_, workspace0_.confirmedCaseNumber as confirme8_34_0_, workspace0_.defaultLocale as defaultL9_34_0_, workspace0_.defaultTimeZone as default10_34_0_, workspace0_.description as descrip11_34_0_, workspace0_.extension as extension34_0_, workspace0_.maxStockOnHand as maxStoc13_34_0_, workspace0_.minStockOnHand as minStoc14_34_0_, workspace0_.monthsToAlertExpiredMedicines as monthsT15_34_0_, workspace0_.name1 as name16_34_0_, workspace0_.name2 as name17_34_0_, workspace0_.patientAddrRequiredLevels as patient18_34_0_, workspace0_.patientNameComposition as patient19_34_0_, workspace0_.sendSystemMessages as sendSys20_34_0_, workspace0_.suspectCaseNumber as suspect21_34_0_, workspace0_.treatMonitoringInput as treatMo22_34_0_, workspace0_.ulaActive as ulaActive34_0_, workspace0_.url as url34_0_, workspace0_.weekFreq1 as weekFreq25_34_0_, workspace0_.weekFreq2 as weekFreq26_34_0_, workspace0_.weekFreq3 as weekFreq27_34_0_, workspace0_.weekFreq4 as weekFreq28_34_0_, workspace0_.weekFreq5 as weekFreq29_34_0_, workspace0_.weekFreq6 as weekFreq30_34_0_, workspace0_.weekFreq7 as weekFreq31_34_0_ from workspace workspace0_ where workspace0_.id=?
Hibernate: select workspacev0_.id as id35_0_, workspacev0_.logoImage as logoImage35_0_, workspacev0_.picture as picture35_0_, workspacev0_.pictureContentType as pictureC4_35_0_ from workspaceview workspacev0_ where workspacev0_.id=?
Hibernate: insert into entitylastversion (WORKSPACE_ID, lastVersion, entityClass) values (?, ?, ?)
Hibernate: select entitylast0_.entityClass as entityCl1_38_, entitylast0_.WORKSPACE_ID as WORKSPACE3_38_, entitylast0_.lastVersion as lastVers2_38_ from entitylastversion entitylast0_ where entitylast0_.entityClass=?
Hibernate: select workspace0_.id as id34_0_, workspace0_.allowDiagAfterTreatment as allowDia2_34_0_, workspace0_.allowRegAfterDiagnosis as allowReg3_34_0_, workspace0_.alternateLocale as alternat4_34_0_, workspace0_.caseValidationDRTB as caseVali5_34_0_, workspace0_.caseValidationNTM as caseVali6_34_0_, workspace0_.caseValidationTB as caseVali7_34_0_, workspace0_.confirmedCaseNumber as confirme8_34_0_, workspace0_.defaultLocale as defaultL9_34_0_, workspace0_.defaultTimeZone as default10_34_0_, workspace0_.description as descrip11_34_0_, workspace0_.extension as extension34_0_, workspace0_.maxStockOnHand as maxStoc13_34_0_, workspace0_.minStockOnHand as minStoc14_34_0_, workspace0_.monthsToAlertExpiredMedicines as monthsT15_34_0_, workspace0_.name1 as name16_34_0_, workspace0_.name2 as name17_34_0_, workspace0_.patientAddrRequiredLevels as patient18_34_0_, workspace0_.patientNameComposition as patient19_34_0_, workspace0_.sendSystemMessages as sendSys20_34_0_, workspace0_.suspectCaseNumber as suspect21_34_0_, workspace0_.treatMonitoringInput as treatMo22_34_0_, workspace0_.ulaActive as ulaActive34_0_, workspace0_.url as url34_0_, workspace0_.weekFreq1 as weekFreq25_34_0_, workspace0_.weekFreq2 as weekFreq26_34_0_, workspace0_.weekFreq3 as weekFreq27_34_0_, workspace0_.weekFreq4 as weekFreq28_34_0_, workspace0_.weekFreq5 as weekFreq29_34_0_, workspace0_.weekFreq6 as weekFreq30_34_0_, workspace0_.weekFreq7 as weekFreq31_34_0_ from workspace workspace0_ where workspace0_.id=?
Hibernate: select workspacev0_.id as id35_0_, workspacev0_.logoImage as logoImage35_0_, workspacev0_.picture as picture35_0_, workspacev0_.pictureContentType as pictureC4_35_0_ from workspaceview workspacev0_ where workspacev0_.id=?
Hibernate: insert into entitylastversion (WORKSPACE_ID, lastVersion, entityClass) values (?, ?, ?)
Hibernate: select entitylast0_.entityClass as entityCl1_38_, entitylast0_.WORKSPACE_ID as WORKSPACE3_38_, entitylast0_.lastVersion as lastVers2_38_ from entitylastversion entitylast0_ where entitylast0_.entityClass=?
Hibernate: select workspace0_.id as id34_0_, workspace0_.allowDiagAfterTreatment as allowDia2_34_0_, workspace0_.allowRegAfterDiagnosis as allowReg3_34_0_, workspace0_.alternateLocale as alternat4_34_0_, workspace0_.caseValidationDRTB as caseVali5_34_0_, workspace0_.caseValidationNTM as caseVali6_34_0_, workspace0_.caseValidationTB as caseVali7_34_0_, workspace0_.confirmedCaseNumber as confirme8_34_0_, workspace0_.defaultLocale as defaultL9_34_0_, workspace0_.defaultTimeZone as default10_34_0_, workspace0_.description as descrip11_34_0_, workspace0_.extension as extension34_0_, workspace0_.maxStockOnHand as maxStoc13_34_0_, workspace0_.minStockOnHand as minStoc14_34_0_, workspace0_.monthsToAlertExpiredMedicines as monthsT15_34_0_, workspace0_.name1 as name16_34_0_, workspace0_.name2 as name17_34_0_, workspace0_.patientAddrRequiredLevels as patient18_34_0_, workspace0_.patientNameComposition as patient19_34_0_, workspace0_.sendSystemMessages as sendSys20_34_0_, workspace0_.suspectCaseNumber as suspect21_34_0_, workspace0_.treatMonitoringInput as treatMo22_34_0_, workspace0_.ulaActive as ulaActive34_0_, workspace0_.url as url34_0_, workspace0_.weekFreq1 as weekFreq25_34_0_, workspace0_.weekFreq2 as weekFreq26_34_0_, workspace0_.weekFreq3 as weekFreq27_34_0_, workspace0_.weekFreq4 as weekFreq28_34_0_, workspace0_.weekFreq5 as weekFreq29_34_0_, workspace0_.weekFreq6 as weekFreq30_34_0_, workspace0_.weekFreq7 as weekFreq31_34_0_ from workspace workspace0_ where workspace0_.id=?
Hibernate: select workspacev0_.id as id35_0_, workspacev0_.logoImage as logoImage35_0_, workspacev0_.picture as picture35_0_, workspacev0_.pictureContentType as pictureC4_35_0_ from workspaceview workspacev0_ where workspacev0_.id=?
Hibernate: insert into entitylastversion (WORKSPACE_ID, lastVersion, entityClass) values (?, ?, ?)
Start transaction 1
Hibernate: select serversign0_.id as id37_0_, serversign0_.adminMail as adminMail37_0_, serversign0_.countryCode as countryC3_37_0_, serversign0_.initialized as initiali4_37_0_, serversign0_.lastSyncDate as lastSync5_37_0_, serversign0_.pageRootURL as pageRoot6_37_0_, serversign0_.serverUrl as serverUrl37_0_, serversign0_.systemURL as systemURL37_0_ from serversignature serversign0_ where serversign0_.id=?
Start transaction 2
Finish transaction 2
Hibernate: update serversignature set adminMail=?, countryCode=?, initialized=?, lastSyncDate=?, pageRootURL=?, serverUrl=?, systemURL=? where id=?
Finish transaction 1
Start transaction 1
Hibernate: select serversign0_.id as id37_0_, serversign0_.adminMail as adminMail37_0_, serversign0_.countryCode as countryC3_37_0_, serversign0_.initialized as initiali4_37_0_, serversign0_.lastSyncDate as lastSync5_37_0_, serversign0_.pageRootURL as pageRoot6_37_0_, serversign0_.serverUrl as serverUrl37_0_, serversign0_.systemURL as systemURL37_0_ from serversignature serversign0_ where serversign0_.id=?
Start transaction 2
Finish transaction 2
Hibernate: update serversignature set adminMail=?, countryCode=?, initialized=?, lastSyncDate=?, pageRootURL=?, serverUrl=?, systemURL=? where id=?
Finish transaction 1
Hi test
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 51.328 sec
Results :
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0
[INFO]
[INFO] --- replacer:1.5.2:replace (default) @ desktop ---
[INFO] Replacement run on 1 file.
[INFO]
[INFO] --- maven-jar-plugin:2.4:jar (default-jar) @ desktop ---
[INFO] Building jar: C:\apps\jenkins\workspace\eTBM_Desktop\target\etbmdesktop.jar
[INFO]
[INFO] --- maven-dependency-plugin:2.6:copy-dependencies (copy-dependencies) @ desktop ---
[INFO] javassist-3.4.GA.jar already exists in destination.
[INFO] httpcore-4.2.4.jar already exists in destination.
[INFO] log4j-1.2.17.jar already exists in destination.
[INFO] spring-asm-3.1.0.RELEASE.jar already exists in destination.
[INFO] spring-jdbc-3.1.0.RELEASE.jar already exists in destination.
[INFO] aopalliance-1.0.jar already exists in destination.
[INFO] swingx-0.9.7.jar already exists in destination.
[INFO] juel-api-2.2.6.jar already exists in destination.
[INFO] spring-expression-3.1.0.RELEASE.jar already exists in destination.
[INFO] cglib-2.2.2.jar already exists in destination.
[INFO] xml-apis-1.0.b2.jar already exists in destination.
[INFO] datastream-1.2.8.jar already exists in destination.
[INFO] slf4j-api-1.6.4.jar already exists in destination.
[INFO] mail-1.4.jar already exists in destination.
[INFO] spring-beans-3.1.0.RELEASE.jar already exists in destination.
[INFO] axis-1.4.jar already exists in destination.
[INFO] hibernate-core-3.3.0.SP1.jar already exists in destination.
[INFO] asm-3.3.1.jar already exists in destination.
[INFO] commons-logging-1.1.1.jar already exists in destination.
[INFO] hamcrest-core-1.3.jar already exists in destination.
[INFO] laf-widget-7.2.1.jar already exists in destination.
[INFO] commons-collections-3.1.jar already exists in destination.
[INFO] juel-impl-2.2.6.jar already exists in destination.
[INFO] testng-6.1.1.jar already exists in destination.
[INFO] slf4j-log4j12-1.7.2.jar already exists in destination.
[INFO] snakeyaml-1.6.jar already exists in destination.
[INFO] ejb3-persistence-1.0.2.GA.jar already exists in destination.
[INFO] dom4j-1.6.1.jar already exists in destination.
[INFO] commons-codec-1.6.jar already exists in destination.
[INFO] jcommander-1.12.jar already exists in destination.
[INFO] hibernate-3.3.0.SP1.pom already exists in destination.
[INFO] hibernate-commons-annotations-3.1.0.GA.jar already exists in destination.
[INFO] spring-core-3.1.0.RELEASE.jar already exists in destination.
[INFO] spring-context-3.1.0.RELEASE.jar already exists in destination.
[INFO] httpmime-4.2.5.jar already exists in destination.
[INFO] bsh-2.0b4.jar already exists in destination.
[INFO] junit-4.11.jar already exists in destination.
[INFO] hibernate-entitymanager-3.4.0.GA.jar already exists in destination.
[INFO] activation-1.1.jar already exists in destination.
[INFO] spring-tx-3.1.0.RELEASE.jar already exists in destination.
[INFO] commons-beanutils-1.8.0.jar already exists in destination.
[INFO] trident-7.2.1-swing.jar already exists in destination.
[INFO] miglayout-swing-4.2.jar already exists in destination.
[INFO] commons-discovery-0.5.jar already exists in destination.
[INFO] spring-orm-3.1.0.RELEASE.jar already exists in destination.
[INFO] hibernate-annotations-3.4.0.GA.jar already exists in destination.
[INFO] httpclient-4.2.5.jar already exists in destination.
[INFO] jcalendar-1.3.2.jar already exists in destination.
[INFO] antlr-2.7.6.jar already exists in destination.
[INFO] spring-aop-3.1.0.RELEASE.jar already exists in destination.
[INFO] substance-7.2.1.jar already exists in destination.
[INFO] hsqldb-2.2.8.jar already exists in destination.
[INFO] jta-1.1.jar already exists in destination.
[INFO] miglayout-core-4.2.jar already exists in destination.
[INFO] laf-plugin-7.2.1.jar already exists in destination.
[INFO] hibernate-validator-3.1.0.GA.jar already exists in destination.
[INFO] jaxrpc-api-1.1.jar already exists in destination.
[INFO] axis-wsdl4j-1.5.1.jar already exists in destination.
[INFO]
[INFO] --- launch4j-maven-plugin:1.5.2:launch4j (l4j-gui) @ desktop ---
[INFO] Platform-specific work directory already exists: C:\Windows\system32\config\systemprofile\.m2\repository\com\akathist\maven\plugins\launch4j\launch4j-maven-plugin\1.5.2
[INFO] launch4j: Compiling resources
[INFO] launch4j: Linking
[INFO] launch4j: C:\Windows\system32\config\systemprofile\.m2\repository\com\akathist\maven\plugins\launch4j\launch4j-maven-plugin\1.5.2\launch4j-maven-plugin-1.5.2-workdir-win32\bin\ld.exe: C:\Windows\system32\config\systemprofile\.m2\repository\com\akathist\maven\plugins\launch4j\launch4j-maven-plugin\1.5.2\launch4j-maven-plugin-1.5.2-workdir-win32\w32api\crt2.o: No such file: No such file or directory
[ERROR]
net.sf.launch4j.BuilderException: net.sf.launch4j.ExecException: Exec failed (1): C:\Windows\system32\config\systemprofile\.m2\repository\com\akathist\maven\plugins\launch4j\launch4j-maven-plugin\1.5.2\launch4j-maven-plugin-1.5.2-workdir-win32\bin\ld.exe -mi386pe --oformat pei-i386 --subsystem windows -s C:\Windows\system32\config\systemprofile\.m2\repository\com\akathist\maven\plugins\launch4j\launch4j-maven-plugin\1.5.2\launch4j-maven-plugin-1.5.2-workdir-win32\w32api\crt2.o C:\Windows\system32\config\systemprofile\.m2\repository\com\akathist\maven\plugins\launch4j\launch4j-maven-plugin\1.5.2\launch4j-maven-plugin-1.5.2-workdir-win32\head\guihead.o C:\Windows\system32\config\systemprofile\.m2\repository\com\akathist\maven\plugins\launch4j\launch4j-maven-plugin\1.5.2\launch4j-maven-plugin-1.5.2-workdir-win32\head\head.o C:\Windows\TEMP\launch4j3740763632843868776o C:\Windows\system32\config\systemprofile\.m2\repository\com\akathist\maven\plugins\launch4j\launch4j-maven-plugin\1.5.2\launch4j-maven-plugin-1.5.2-workdir-win32\w32api\libmingw32.a C:\Windows\system32\config\systemprofile\.m2\repository\com\akathist\maven\plugins\launch4j\launch4j-maven-plugin\1.5.2\launch4j-maven-plugin-1.5.2-workdir-win32\w32api\libgcc.a C:\Windows\system32\config\systemprofile\.m2\repository\com\akathist\maven\plugins\launch4j\launch4j-maven-plugin\1.5.2\launch4j-maven-plugin-1.5.2-workdir-win32\w32api\libmsvcrt.a C:\Windows\system32\config\systemprofile\.m2\repository\com\akathist\maven\plugins\launch4j\launch4j-maven-plugin\1.5.2\launch4j-maven-plugin-1.5.2-workdir-win32\w32api\libkernel32.a C:\Windows\system32\config\systemprofile\.m2\repository\com\akathist\maven\plugins\launch4j\launch4j-maven-plugin\1.5.2\launch4j-maven-plugin-1.5.2-workdir-win32\w32api\libuser32.a C:\Windows\system32\config\systemprofile\.m2\repository\com\akathist\maven\plugins\launch4j\launch4j-maven-plugin\1.5.2\launch4j-maven-plugin-1.5.2-workdir-win32\w32api\libadvapi32.a C:\Windows\system32\config\systemprofile\.m2\repository\com\akathist\maven\plugins\launch4j\launch4j-maven-plugin\1.5.2\launch4j-maven-plugin-1.5.2-workdir-win32\w32api\libshell32.a -o C:\apps\jenkins\workspace\eTBM_Desktop\target\etbmdesktop.exe
at net.sf.launch4j.Builder.build(Builder.java:144)
at com.akathist.maven.plugins.launch4j.Launch4jMojo.execute(Launch4jMojo.java:359)
at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.java:134)
at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:207)
at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:153)
at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:145)
at org.apache.maven.lifecycle.internal.MojoExecutor.executeForkedExecutions(MojoExecutor.java:352)
at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:197)
at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:153)
at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:145)
at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:116)
at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:80)
at org.apache.maven.lifecycle.internal.builder.singlethreaded.SingleThreadedBuilder.build(SingleThreadedBuilder.java:51)
at org.apache.maven.lifecycle.internal.LifecycleStarter.execute(LifecycleStarter.java:128)
at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:307)
at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:193)
at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:106)
at org.apache.maven.cli.MavenCli.execute(MavenCli.java:863)
at org.apache.maven.cli.MavenCli.doMain(MavenCli.java:288)
at org.apache.maven.cli.MavenCli.main(MavenCli.java:199)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:289)
at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:229)
at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:415)
at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:356)
Caused by: net.sf.launch4j.ExecException: Exec failed (1): C:\Windows\system32\config\systemprofile\.m2\repository\com\akathist\maven\plugins\launch4j\launch4j-maven-plugin\1.5.2\launch4j-maven-plugin-1.5.2-workdir-win32\bin\ld.exe -mi386pe --oformat pei-i386 --subsystem windows -s C:\Windows\system32\config\systemprofile\.m2\repository\com\akathist\maven\plugins\launch4j\launch4j-maven-plugin\1.5.2\launch4j-maven-plugin-1.5.2-workdir-win32\w32api\crt2.o C:\Windows\system32\config\systemprofile\.m2\repository\com\akathist\maven\plugins\launch4j\launch4j-maven-plugin\1.5.2\launch4j-maven-plugin-1.5.2-workdir-win32\head\guihead.o C:\Windows\system32\config\systemprofile\.m2\repository\com\akathist\maven\plugins\launch4j\launch4j-maven-plugin\1.5.2\launch4j-maven-plugin-1.5.2-workdir-win32\head\head.o C:\Windows\TEMP\launch4j3740763632843868776o C:\Windows\system32\config\systemprofile\.m2\repository\com\akathist\maven\plugins\launch4j\launch4j-maven-plugin\1.5.2\launch4j-maven-plugin-1.5.2-workdir-win32\w32api\libmingw32.a C:\Windows\system32\config\systemprofile\.m2\repository\com\akathist\maven\plugins\launch4j\launch4j-maven-plugin\1.5.2\launch4j-maven-plugin-1.5.2-workdir-win32\w32api\libgcc.a C:\Windows\system32\config\systemprofile\.m2\repository\com\akathist\maven\plugins\launch4j\launch4j-maven-plugin\1.5.2\launch4j-maven-plugin-1.5.2-workdir-win32\w32api\libmsvcrt.a C:\Windows\system32\config\systemprofile\.m2\repository\com\akathist\maven\plugins\launch4j\launch4j-maven-plugin\1.5.2\launch4j-maven-plugin-1.5.2-workdir-win32\w32api\libkernel32.a C:\Windows\system32\config\systemprofile\.m2\repository\com\akathist\maven\plugins\launch4j\launch4j-maven-plugin\1.5.2\launch4j-maven-plugin-1.5.2-workdir-win32\w32api\libuser32.a C:\Windows\system32\config\systemprofile\.m2\repository\com\akathist\maven\plugins\launch4j\launch4j-maven-plugin\1.5.2\launch4j-maven-plugin-1.5.2-workdir-win32\w32api\libadvapi32.a C:\Windows\system32\config\systemprofile\.m2\repository\com\akathist\maven\plugins\launch4j\launch4j-maven-plugin\1.5.2\launch4j-maven-plugin-1.5.2-workdir-win32\w32api\libshell32.a -o C:\apps\jenkins\workspace\eTBM_Desktop\target\etbmdesktop.exe
at net.sf.launch4j.Util.exec(Util.java:148)
at net.sf.launch4j.Cmd.exec(Builder.java:205)
at net.sf.launch4j.Builder.build(Builder.java:112)
... 27 more
[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 01:10 min
[INFO] Finished at: 2016-05-26T19:31:24-04:00
[INFO] Final Memory: 37M/1708M
[INFO] ------------------------------------------------------------------------
[ERROR] Failed to execute goal com.akathist.maven.plugins.launch4j:launch4j-maven-plugin:1.5.2:launch4j (l4j-gui) on project desktop: Failed to build the executable; please verify your configuration. net.sf.launch4j.ExecException: Exec failed (1): C:\Windows\system32\config\systemprofile\.m2\repository\com\akathist\maven\plugins\launch4j\launch4j-maven-plugin\1.5.2\launch4j-maven-plugin-1.5.2-workdir-win32\bin\ld.exe -mi386pe --oformat pei-i386 --subsystem windows -s C:\Windows\system32\config\systemprofile\.m2\repository\com\akathist\maven\plugins\launch4j\launch4j-maven-plugin\1.5.2\launch4j-maven-plugin-1.5.2-workdir-win32\w32api\crt2.o C:\Windows\system32\config\systemprofile\.m2\repository\com\akathist\maven\plugins\launch4j\launch4j-maven-plugin\1.5.2\launch4j-maven-plugin-1.5.2-workdir-win32\head\guihead.o C:\Windows\system32\config\systemprofile\.m2\repository\com\akathist\maven\plugins\launch4j\launch4j-maven-plugin\1.5.2\launch4j-maven-plugin-1.5.2-workdir-win32\head\head.o C:\Windows\TEMP\launch4j3740763632843868776o C:\Windows\system32\config\systemprofile\.m2\repository\com\akathist\maven\plugins\launch4j\launch4j-maven-plugin\1.5.2\launch4j-maven-plugin-1.5.2-workdir-win32\w32api\libmingw32.a C:\Windows\system32\config\systemprofile\.m2\repository\com\akathist\maven\plugins\launch4j\launch4j-maven-plugin\1.5.2\launch4j-maven-plugin-1.5.2-workdir-win32\w32api\libgcc.a C:\Windows\system32\config\systemprofile\.m2\repository\com\akathist\maven\plugins\launch4j\launch4j-maven-plugin\1.5.2\launch4j-maven-plugin-1.5.2-workdir-win32\w32api\libmsvcrt.a C:\Windows\system32\config\systemprofile\.m2\repository\com\akathist\maven\plugins\launch4j\launch4j-maven-plugin\1.5.2\launch4j-maven-plugin-1.5.2-workdir-win32\w32api\libkernel32.a C:\Windows\system32\config\systemprofile\.m2\repository\com\akathist\maven\plugins\launch4j\launch4j-maven-plugin\1.5.2\launch4j-maven-plugin-1.5.2-workdir-win32\w32api\libuser32.a C:\Windows\system32\config\systemprofile\.m2\repository\com\akathist\maven\plugins\launch4j\launch4j-maven-plugin\1.5.2\launch4j-maven-plugin-1.5.2-workdir-win32\w32api\libadvapi32.a C:\Windows\system32\config\systemprofile\.m2\repository\com\akathist\maven\plugins\launch4j\launch4j-maven-plugin\1.5.2\launch4j-maven-plugin-1.5.2-workdir-win32\w32api\libshell32.a -o C:\apps\jenkins\workspace\eTBM_Desktop\target\etbmdesktop.exe -> [Help 1]
[ERROR]
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR]
[ERROR] For more information about the errors and possible solutions, please read the following articles:
[ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoExecutionExceptionBuild step 'Invoke top-level Maven targets' marked build as failure
Recording test results
Sending e-mails to: rmemoria@msh.org msantos.msh@gmail.com rmemoria@gmail.com
Finished: FAILURE
Console Output