search

SORMAS-Foundation / SORMAS-Project

SORMAS (Surveillance, Outbreak Response Management and Analysis System) is an early warning and management system to fight the spread of infectious diseases.
https://sormas.org
GNU General Public License v3.0
293 stars 142 forks source link

Statistic export still not possible #3813

Closed TomHutter closed 3 years ago

TomHutter commented 3 years ago

Bug Description

Data Export still not possible anymore

Steps to Reproduce

  1. Trying to export statistics
  2. Select all check marks like in attached screenshot.

Expected Behavior

export finishes

Screenshots

export

fehler

System Details

Additional Information

Three long running SQL statements collected during export:

LOG:  duration: 12426.589 ms  statement: COPY public.cases_history (id, changedate, creationdate, description, disease, investigateddate, reportdate, uuid, caseofficer_id, healthfacility_id, reportinguser_id, surveillanceofficer_id, person_id, symptoms_id, region_id, district_id, community_id, caseclassification, investigationstatus, hospitalization_id, pregnant, epidata_id, epidnumber, sys_period, reportlat, reportlon, reportlatlonaccuracy, smallpoxvaccinationscar, plaguetype, smallpoxvaccinationreceived, vaccinationdate, vaccination, vaccinationdoses, vaccinationinfosource, districtleveldate, outcome, outcomedate, caseage, systemcaseclassification, archived, therapy_id, clinicalcourse_id, sequelae, sequelaedetails, regionleveldate, nationalleveldate, cliniciandetails, notifyingclinic, notifyingclinicdetails, maternalhistory_id, pointofentry_id, pointofentrydetails, caseorigin, porthealthinfo_id, clinicianphone, clinicianemail, duplicateof_id, completeness, deleted, vaccine, rabiestype, additionaldetails, externalid, sharedtocountry, quarantine, quarantinefrom, quarantineto, quarantinehelpneeded, quarantineorderedverbally, quarantineorderedofficialdocument, quarantineorderedverballydate, quarantineorderedofficialdocumentdate, quarantinehomepossible, quarantinehomepossiblecomment, quarantinehomesupplyensured, quarantinehomesupplyensuredcomment, reportingtype, postpartum, trimester, diseasedetails, classificationcomment, healthfacilitydetails, quarantinetypedetails, clinicalconfirmation, epidemiologicalconfirmation, laboratorydiagnosticconfirmation, quarantineextended, followupstatus, followupcomment, followupuntil, overwritefollowupuntil, facilitytype, quarantineofficialordersent, quarantineofficialordersentdate, quarantinereduced, caseidism, covidtestreason, covidtestreasondetails, contacttracingfirstcontacttype, contacttracingfirstcontactdate, quarantinereasonbeforeisolation, quarantinereasonbeforeisolationdetails, endofisolationreason, endofisolationreasondetails, wasinquarantinebeforeisolation) TO stdout;
2020-12-15 11:50:43.582 GMT [3151] LOG:  duration: 38100.986 ms  statement: COPY public.auditlogentry (id, detection_ts, changetype, editinguser, clazz, uuid, transaction_id, transaction_ts) TO stdout;
2020-12-15 11:51:15.760 GMT [3151] LOG:  duration: 32176.256 ms  statement: COPY public.auditlogentry_attributes (auditlogentry_id, attribute_key, attribute_value) TO stdout;
kwa20 commented 3 years ago

3807 workaround would be deselecting epi data and exposures I believe

MateStrysewske commented 3 years ago

This has been fixed on the development branch yesterday.