kaweesi

_________________________________________________________M_________________________________________________________x
TX_TB NUM
_________________________________________________________W_________________________________________________________
PACIENTES COM RASTREIO DE TB (EXCLUINDO OS COM INICIO TB 6 MESES ATRAS)
> patients who started TB treatment or enrolled in TB program within reporting period but didn't start TB Treatment within 6 months before startDate


SELECT patient_id FROM
(
    -- PATIENT STARTED TB TREATMENT

kaweesi

 Marker - 27 Mar 2019, 20:09:38
INFO - LoggingAdvice.invoke(115) |2019-03-27 20:09:48,476| In method AdministrationService.saveGlobalProperty. Arguments: GlobalProperty=property: reporting.dataEvaluationBatchSize value: -1, 
INFO - LoggingAdvice.invoke(155) |2019-03-27 20:09:48,875| Exiting method saveGlobalProperty
WARN - HL7InQueueProcessor.processHL7InQueue(104) |2019-03-27 20:10:00,016| HL7 processor aborting (another processor already running)
ERROR - CommonsLoggingOutput.error(75) |2019-03-27 20:10:07,953| Parameter mismatch parsing signatures section in dwr.xml on line: DWREncounterService.findEncounters(String phrase, Integer patientId, boolean includeVoided)
WARN - SerializedDefinitionServiceImpl.getDefinitionByUuid(131) |2019-03-27 20:10:15,819| Unable to deserialize Definition : Serialized org.openmrs.module.reporting.report.definition.ReportDefinition named <IM-ER-Report>
org.openmrs.api.db.DAOException: Unable to deserialize object: Serialized org.openmrs.module.reporting.report.definition.Report

kaweesi

 Marker - 27 Mar 2019, 19:24:05
INFO - LoggingAdvice.invoke(115) |2019-03-27 19:24:11,716| In method DefinitionService.purgeDefinition. Arguments: Definition=TX_CURR Report 2.1, 
INFO - LoggingAdvice.invoke(115) |2019-03-27 19:24:11,744| In method ReportService.purgeReportDesign. Arguments: ReportDesign=TXCURR_2.1.xls_, 
INFO - LoggingAdvice.invoke(155) |2019-03-27 19:24:11,756| Exiting method purgeReportDesign
INFO - LoggingAdvice.invoke(115) |2019-03-27 19:24:11,758| In method SerializedDefinitionService.purgeDefinition. Arguments: Definition=TX_CURR Report 2.1, 
INFO - LoggingAdvice.invoke(155) |2019-03-27 19:24:11,766| Exiting method purgeDefinition
INFO - LoggingAdvice.invoke(155) |2019-03-27 19:24:11,767| Exiting method purgeDefinition
INFO - LoggingAdvice.invoke(115) |2019-03-27 19:24:11,779| In method SyncService.createSyncRecord. Arguments: SyncRecord=SyncRecord(null) contains org.openmrs.module.reporting.report.ReportDesign,org.openmrs.module.reporting.report.ReportDesignResource,org.openmrs.api.db.

kaweesi

 Marker - 27 Mar 2019, 18:58:11
INFO - LoggingAdvice.invoke(115) |2019-03-27 18:58:16,110| In method DefinitionService.purgeDefinition. Arguments: Definition=TX_CURR Report 2.1, 
INFO - LoggingAdvice.invoke(115) |2019-03-27 18:58:16,125| In method ReportService.purgeReportDesign. Arguments: ReportDesign=TXCURR_2.1.xls_, 
INFO - LoggingAdvice.invoke(155) |2019-03-27 18:58:16,136| Exiting method purgeReportDesign
INFO - LoggingAdvice.invoke(115) |2019-03-27 18:58:16,139| In method SerializedDefinitionService.purgeDefinition. Arguments: Definition=TX_CURR Report 2.1, 
INFO - LoggingAdvice.invoke(155) |2019-03-27 18:58:16,147| Exiting method purgeDefinition
INFO - LoggingAdvice.invoke(155) |2019-03-27 18:58:16,153| Exiting method purgeDefinition
INFO - LoggingAdvice.invoke(115) |2019-03-27 18:58:16,163| In method SyncService.createSyncRecord. Arguments: SyncRecord=SyncRecord(null) contains org.openmrs.module.reporting.report.ReportDesign,org.openmrs.module.reporting.report.ReportDesignResource,org.openmrs.api.db.

kaweesi

 Marker - 27 Mar 2019, 18:06:30
INFO - LoggingAdvice.invoke(115) |2019-03-27 18:06:32,212| In method SchedulerService.saveToMemento. Arguments: 
INFO - LoggingAdvice.invoke(155) |2019-03-27 18:06:32,232| Exiting method saveToMemento
INFO - ServiceContext.startRefreshingContext(902) |2019-03-27 18:06:32,244| Refreshing Context
INFO - AbstractSessionFactoryBean.destroy(223) |2019-03-27 18:06:32,265| Closing Hibernate SessionFactory
WARN - DisposableBeanAdapter.destroy(247) |2019-03-27 18:06:32,267| Invocation of destroy method failed on bean with name 'sessionFactory': org.hibernate.cache.CacheException: java.lang.IllegalStateException: The CacheManager has been shut down. It can no longer be used.
INFO - LocalSessionFactoryBean.buildSessionFactory(780) |2019-03-27 18:06:34,659| Building new Hibernate SessionFactory
INFO - ServiceContext.doneRefreshingContext(913) |2019-03-27 18:06:36,553| Done refreshing Context
ERROR - CommonsLoggingOutput.error(75) |2019-03-27 18:06:39,145| Parameter mismatch parsing signatu

kaweesi

select p.patient_id 
from patient p inner join encounter e on e.patient_id=p.patient_id 
where e.voided=0 and p.voided=0 and e.encounter_type in (5,7) and e.encounter_datetime<=:endDate and e.location_id = :location

union

select 	pg.patient_id
from 	patient p inner join patient_program pg on p.patient_id=pg.patient_id
where 	pg.voided=0 and p.voided=0 and program_id=1 and date_enrolled<=:endDate and location_id=:location

kaweesi

package org.openmrs.module.eptsreports.reporting.unit.utils;

import static org.mockito.Matchers.any;
import static org.mockito.Mockito.when;

import java.util.Arrays;
import java.util.HashMap;
import java.util.HashSet;
import java.util.List;
import java.util.Map;

kaweesi

java.net.ConnectException: Connection refused at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339) at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200) at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) at java.net.Socket.connect(Socket.java:579) at sun.reflect.GeneratedMethodAccessor213.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.apache.commons.httpclient.protocol.ReflectionSocketFactory.createSocket(ReflectionSocketFactory.java:140) at org.apache.commons.httpclient.protocol.DefaultProtocolSocketFactory.createSocket(DefaultProtocolSocketFactory.java:125) at org.apache.commons.httpclient.HttpConnection.open(HttpConnection.java:707) at org.apache.commons.httpclient.HttpMethodDirecto

kaweesi

Results :

Tests in error: 
  saveAllergies_shouldThrowsExceptionSavingAllergies(org.openmrs.module.msfcore.api.FormActionServiceTest): Unexpected exception, expected<java.lang.IllegalArgumentException> but was<org.dbunit.DatabaseUnitRuntimeException>
  saveDrugOrders_shouldCreateDrugOrders(org.openmrs.module.msfcore.api.FormActionServiceTest): org.dbunit.dataset.NoSuchColumnException: ALLERGY.COMMENT -  (Non-uppercase input column: comment) in ColumnNameToIndexes cache map. Note that the map's column names are NOT case sensitive.
  getObservationsByPatientAndOrderAndConcept_shouldRetrieveNoObsIfConceptDoesntMatch(org.openmrs.module.msfcore.api.MSFCoreServiceTest): org.dbunit.dataset.NoSuchColumnException: ALLERGY.COMMENT -  (Non-uppercase input column: comment) in ColumnNameToIndexes cache map. Note that the map's column names are NOT case sensitive.
  getObservationsByPatientAndOrderAndConcept_shouldRetrieveCorrectObs(org.openmrs.module.msfcore.api.MSFCoreServiceTest): org.dbunit.dataset.NoSuchColumnExcepti

kaweesi

chrome:Version 71.0.3578.98 (Official Build) (64-bit)
>>>>
bootstrap-datepicker.cy.min.js:1 Uncaught TypeError: Cannot read property 'dates' of undefined
    at bootstrap-datepicker.cy.min.js:1
    at Object.<anonymous> (bootstrap-datepicker.cy.min.js:1)
    at Object.<anonymous> (coreapps.vendor.js:67465)
    at t (bootstrap bc0dd8c8c8f2ed7c811a:54)
    at Object.153 (index.js:4)
    at t (bootstrap bc0dd8c8c8f2ed7c811a:54)
    at Object.132 (index.js:4)