[Dhis2-devs] org.postgresql.util.PSQLException: ERROR: column dataelemen1_.shortname does not exist

[Pooben Dass]

Hi Devs

 

Anyone seen this Exception before, is there an upgrade script that I need to
run?

 

 

I'm upgrading the dhis2 instance to 2.18.

 

* ERROR 2015-05-18 08:58:34,353 Error while executing action
(ExceptionInterceptor.java [http-bio-80-exec-3])

org.hibernate.exception.SQLGrammarException: could not extract ResultSet

at
org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLState
ConversionDelegate.java:122)

at
org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(Stand
ardSQLExceptionConverter.java:49)

at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.
java:125)

at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.
java:110)

at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetRetu
rnImpl.java:61)

at org.hibernate.loader.Loader.getResultSet(Loader.java:2031)

at
org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1832)

at
org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1811)

at org.hibernate.loader.Loader.doQuery(Loader.java:899)

at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.ja
va:341)

at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.ja
va:311)

at org.hibernate.loader.Loader.loadCollection(Loader.java:2228)

at
org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader
.java:65)

at
org.hibernate.persister.collection.AbstractCollectionPersister.initialize(Ab
stractCollectionPersister.java:674)

at
org.hibernate.event.internal.DefaultInitializeCollectionEventListener.onInit
ializeCollection(DefaultInitializeCollectionEventListener.java:80)

at
org.hibernate.internal.SessionImpl.initializeCollection(SessionImpl.java:184
8)

at
org.hibernate.collection.internal.AbstractPersistentCollection$4.doWork(Abst
ractPersistentCollection.java:549)

at
org.hibernate.collection.internal.AbstractPersistentCollection.withTemporary
SessionIfNeeded(AbstractPersistentCollection.java:234)

at
org.hibernate.collection.internal.AbstractPersistentCollection.initialize(Ab
stractPersistentCollection.java:545)

at
org.hibernate.collection.internal.AbstractPersistentCollection.read(Abstract
PersistentCollection.java:124)

at
org.hibernate.collection.internal.PersistentList.iterator(PersistentList.jav
a:138)

at
org.apache.velocity.util.introspection.UberspectImpl.getIterator(UberspectIm
pl.java:116)

at
org.apache.velocity.runtime.directive.Foreach.render(Foreach.java:327)

at
org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.jav
a:207)

at
org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)

at
org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroPro
xy.java:216)

at
org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:
311)

at
org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:
230)

at
org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.jav
a:207)

at
org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:34
2)

at
org.apache.velocity.runtime.directive.Parse.render(Parse.java:260)

at
org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.jav
a:207)

at
org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)

at
org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:34
2)

at
org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement
.java:106)

at
org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:34
2)

at org.apache.velocity.Template.merge(Template.java:356)

at org.apache.velocity.Template.merge(Template.java:260)

at
org.apache.struts2.dispatcher.VelocityResult.doExecute(VelocityResult.java:1
56)

at
org.apache.struts2.dispatcher.StrutsResultSupport.execute(StrutsResultSuppor
t.java:186)

at
com.opensymphony.xwork2.DefaultActionInvocation.executeResult(DefaultActionI
nvocation.java:371)

at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocati
on.java:275)

at
org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.intercept(XWo
rkPortalUserInterceptor.java:91)

at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocati
on.java:246)

at
org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.intercept(X
WorkPortalModuleInterceptor.java:92)

at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocati
on.java:246)

at
org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.intercept(XWo
rkPortalMen

Re: [Dhis2-devs] Defect with the Aggregation Query feature?

[Shantala Raman]

Hi Tran,

Here  is the
link to the DB dump of DHIS in dropbox where we have setup the data needed
to replicate the defect. We have associated the *Cholera CTC* program under
the organization hierarchy, MSF->OCP->A new country->A new project->New
Hospital->Cholera->Origin 1. The program is of type *Single event without
registration*.

Steps to reproduce the defect:

   1. In event capture, register an event for the *Cholera CTC* program
   under the *Origin 1* org unit.
   2. Preview the manual aggregation results for *Geographic Origin* data
   set for *Origin 1* org unit for the week of the *Incident date* and save
   all values.
   3. In data entry, you will see that the value of the *Number of Patients
   (Cholera CTC) *data element for the *Geographic Origin* data set for the
   week of the *Incident date* is 1.
   4. In event capture, remove the event for the *Cholera CTC* program
   under the *Origin 1* org unit.
   5. Preview the manual aggregation results for *Geographic Origin* data
   set for *Origin 1* org unit for the week of the *Incident date*. This
   won't return any changes to be updated while the expected behavior is that
   preview shows that the value for the *Number of Patients (Cholera CTC)*
   data element will change from 1 to 0. Save all values.
   6. In data entry, you will see the value of the *Number of Patients
   (Cholera CTC)* data element remains as 1 for the *Geographic Origin*
   data set for the week while the expected behavior is that the value
of the *Number
   of Patients (Cholera CTC)* data element is 0.

Thanks,
Shantala


On Tue, May 12, 2015 at 3:05 PM, Shantala Raman 
wrote:

> Hi Tran,
>
> We are on 2.19 rev 19092. We are not using SQL queries for generating
> summary data values. We are using the aggregation query builder to setup
> the queries. Could you explain how the SQL query is linked to aggregation
> query builder?
>
> Thanks,
> Shantala
>
> On Mon, May 11, 2015 at 7:10 PM, Tran Chau (HISP Vietnam) <
> tran.hispviet...@gmail.com> wrote:
>
>> Hi Shantala,
>>
>> The first, please make sure if the snapshots are from 2.19 version, R
>> 19075  ?  It looks like old version.
>>
>>
>> I couldn't create an example on dev server ( apps.dhis2.org/dev )
>> because the internet is still slow here. I cannot login the dev server to
>> create an example.
>>
>> I am sending the SQL statement which I used to generate the data values
>> from aggregate query formulas.
>>
>> Can you change the IDs in the SQL statement below according to one of
>> your formula and see if it is generated "NULL" value records or not  (
>> these NULL values will be displayed/saved as "0" values in Manual Aggregate
>> )
>>
>>
>>  SELECT '55' as dataelementid, '16' as categoryoptioncomboid,
>> '16' as attributeoptioncomboid, ou.organisationunitid as sourceid,
>> '1234' as periodid,'aggregated_from_tracker' as storedby,
>> '201505' as periodIsoDate,'Agg DE 1' as dataelementname,
>> '(default)' as categoryoptioncomboname, ou.name as organisationunitname,
>>
>> ( select  count(psi.programinstanceid) as value FROM  programinstance as
>> pi
>> INNER JOIN programstageinstance psi ON
>> pi.programinstanceid=psi.programinstanceid
>>  WHERE  EXISTS ( SELECT * FROM trackedentitydatavalue _pdv
>> inner join programstageinstance _psi ON
>> _pdv.programstageinstanceid=_psi.programstageinstanceid
>> JOIN programinstance _pi ON _pi.programinstanceid=_psi.programinstanceid
>> WHERE psi.programstageinstanceid=_pdv.programstageinstanceid
>> AND _pdv.dataelementid=53  AND _psi.organisationunitid in (50, 51, 52)
>> AND _pi.programid = 60 AND _psi.executionDate>='2015-05-01'
>> AND _psi.executionDate <= '2015-05-31'
>> AND _psi.programstageid = 63 AND _pdv.value   is not null  )
>>  and psi.organisationunitid=ou.organisationunitid
>>
>> GROUP BY ou.organisationunitid ) from organisationunit ou where
>> ou.organisationunitid in ( 50, 51, 52 )
>>
>>
>> ...
>> Best regards
>> Tran Chau
>>
>> On Mon, May 11, 2015 at 8:02 PM, Tran Chau (HISP Vietnam) <
>> tran.hispviet...@gmail.com> wrote:
>>
>>> Hi Shantala,
>>>
>>> Are you sure if the snapshots are from 2.19 version, R 19075  ?
>>> It looks like old version.
>>>
>>> ...
>>> Best regards,
>>> Tran Chau
>>> Hi Tran,
>>>
>>> We are still seeing issues with the aggregation. We followed the below
>>> steps -
>>>
>>>- Created a data element with *Store zero data values* property set
>>>to Yes
>>>- Created an aggregation query for the data element
>>>- Created 3 events for the program of type* single event without
>>>registration* - 2 events under orgunit 1 (origin 1) and 1 event
>>>under orgunit 2 (origin 2)
>>>- Ran manual aggregation for both org units
>>>- Deleted the event under org unit 2 (origin 2)
>>>- Ran manual aggregation for both org units
>>>
>>> We observe that the data entry screen for org unit 2 (origin 2) still
>>> has the

[Dhis2-devs] Capture daily data set values on a monthly form (calendar view)

[Pierre Dane]

Hi all,

Has anyone developed a custom form or app that allows one to capture data
values for multiple datasets?
We have a dataset that needs to have a daily period, but want to capture
the entire month on one screen, mirroring the paper form.

Any guidance would be much appreciated. (I'd prefer not to use
categoryoptioncombos to solve this problem)

Thanks!



-- 
Pierre
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Capture daily data set values on a monthly form (calendar view)

[Knut Staring]

So the same dataset but different periods like a spreadsheet/matrix, right?

On Mon, May 18, 2015 at 5:19 PM, Pierre Dane  wrote:

> Hi all,
>
> Has anyone developed a custom form or app that allows one to capture data
> values for multiple datasets?
> We have a dataset that needs to have a daily period, but want to capture
> the entire month on one screen, mirroring the paper form.
>
> Any guidance would be much appreciated. (I'd prefer not to use
> categoryoptioncombos to solve this problem)
>
> Thanks!
>
>
>
> --
> Pierre
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 19163: events now have orgunit - services and tests are changed accordingly; when necessary attributes a...

[noreply]

revno: 19163
committer: Abyot Asalefew Gizaw 
branch nick: dhis2
timestamp: Mon 2015-05-18 19:05:23 +0200
message:
  events now have orgunit - services and tests are changed accordingly; when 
necessary attributes are now fetched as part of the event query
modified:
  
dhis-2/dhis-api/src/main/java/org/hisp/dhis/program/ProgramStageInstanceService.java
  
dhis-2/dhis-services/dhis-service-dxf2/src/main/java/org/hisp/dhis/dxf2/events/event/AbstractEventService.java
  
dhis-2/dhis-services/dhis-service-dxf2/src/main/java/org/hisp/dhis/dxf2/events/event/EventService.java
  
dhis-2/dhis-services/dhis-service-dxf2/src/main/java/org/hisp/dhis/dxf2/events/event/EventStore.java
  
dhis-2/dhis-services/dhis-service-dxf2/src/main/java/org/hisp/dhis/dxf2/events/event/JdbcEventStore.java
  
dhis-2/dhis-services/dhis-service-dxf2/src/main/java/org/hisp/dhis/dxf2/events/report/AbstractEventRowService.java
  
dhis-2/dhis-services/dhis-service-dxf2/src/main/java/org/hisp/dhis/dxf2/events/report/EventRow.java
  
dhis-2/dhis-services/dhis-service-dxf2/src/test/java/org/hisp/dhis/dxf2/events/EnrollmentServiceTest.java
  
dhis-2/dhis-services/dhis-service-dxf2/src/test/java/org/hisp/dhis/dxf2/events/RegistrationMultiEventsServiceTest.java
  
dhis-2/dhis-services/dhis-service-dxf2/src/test/java/org/hisp/dhis/dxf2/events/RegistrationSingleEventServiceTest.java
  
dhis-2/dhis-services/dhis-service-eventreporting/src/test/java/org/hisp/dhis/caseaggregation/CaseAggregationConditionServiceTest.java
  
dhis-2/dhis-services/dhis-service-eventreporting/src/test/java/org/hisp/dhis/caseaggregation/CaseAggregationConditionStoreTest.java
  
dhis-2/dhis-services/dhis-service-tracker/src/main/java/org/hisp/dhis/program/DefaultProgramInstanceService.java
  
dhis-2/dhis-services/dhis-service-tracker/src/main/java/org/hisp/dhis/program/DefaultProgramStageInstanceService.java
  
dhis-2/dhis-services/dhis-service-tracker/src/test/java/org/hisp/dhis/program/ProgramExpressionServiceTest.java
  
dhis-2/dhis-services/dhis-service-tracker/src/test/java/org/hisp/dhis/program/ProgramIndicatorServiceTest.java
  
dhis-2/dhis-services/dhis-service-tracker/src/test/java/org/hisp/dhis/program/ProgramValidationServiceTest.java
  
dhis-2/dhis-services/dhis-service-tracker/src/test/java/org/hisp/dhis/trackedentity/TrackedEntityInstanceReminderServiceTest.java
  
dhis-2/dhis-services/dhis-service-tracker/src/test/java/org/hisp/dhis/trackedentitydatavalue/TrackedEntityDataValueServiceTest.java
  
dhis-2/dhis-services/dhis-service-tracker/src/test/java/org/hisp/dhis/trackedentitydatavalue/TrackedEntityDataValueStoreTest.java
  
dhis-2/dhis-support/dhis-support-test/src/main/java/org/hisp/dhis/DhisConvenienceTest.java
  
dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-tracker-capture/components/dataentry/dataentry-controller.js
  
dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-tracker-capture/components/dataentry/dataentry.html
  
dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-tracker-capture/components/report/overdue-events-controller.js
  
dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-tracker-capture/components/report/program-summary-controller.js
  
dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-tracker-capture/components/report/program-summary.html
  
dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-tracker-capture/scripts/services.js
  
dhis-2/dhis-web/dhis-web-caseentry/src/main/java/org/hisp/dhis/caseentry/action/trackedentity/SaveProgramEnrollmentAction.java
  dhis-2/dhis-web/dhis-web-caseentry/src/main/resources/META-INF/dhis/beans.xml
  
dhis-2/dhis-web/dhis-web-commons-resources/src/main/webapp/dhis-web-commons/javascripts/dhis2/dhis2.angular.directives.js


--
lp:dhis2
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk

Your team DHIS 2 developers is subscribed to branch lp:dhis2.
To unsubscribe from this branch go to 
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk/+edit-subscription
=== modified file 'dhis-2/dhis-api/src/main/java/org/hisp/dhis/program/ProgramStageInstanceService.java'
--- dhis-2/dhis-api/src/main/java/org/hisp/dhis/program/ProgramStageInstanceService.java	2015-04-23 17:00:11 +
+++ dhis-2/dhis-api/src/main/java/org/hisp/dhis/program/ProgramStageInstanceService.java	2015-05-18 17:05:23 +
@@ -52,7 +52,8 @@
  * Adds an {@link TrackedEntityAttribute}
  *
  * @param programStageInstance The to TrackedEntityAttribute add.
- * @return A generated unique id of the added {@link TrackedEntityAttribute}.
+ * @return A generated unique id of the added {@link TrackedEntityAttribute}
+ * .
  */
 int addProgramStageInstance( ProgramStageInstance programStageInstance );
 
@@ -82,7 +83,8 @@
  * Returns the {@link TrackedEntityAttribute} with the given UID.
  *
  * @param uid the UID.
- * @return the TrackedEntityAttribute with the given UID, or null if no match.
+ *

Re: [Dhis2-devs] DHIS2 404 error

[Dan Cocos]

Hi Gerald, 

I looks like it is unable to connect to the database. Is your database started 
and your connection info properly set in hibernate.properties? 


Dan Cocos
BAO Systems
www.baosystems.com 
T: +1 202-352-2671 | skype: dancocos

> On May 18, 2015, at 12:46 PM, gerald thomas  wrote:
> 
> Dear All,
> Why i am getting Error 404 most of the time? What am I doing wrong
> that is creating this error?
> Please help me.
> Attached are my log files.
> 
> -- 
> Regards,
> 
> Gerald
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] DHIS2 404 error

[Alex Tumwesigye]

Dear Gerald,

Please visit this link
https://www.dhis2.org/doc/snapshot/en/implementer/html/ch08s02.html#d5e505

Also ensure that only one tomcat instance is running on the port.


Alex

On Mon, May 18, 2015 at 8:13 PM, Dan Cocos  wrote:

> Hi Gerald,
>
> I looks like it is unable to connect to the database. Is your database
> started and your connection info properly set in hibernate.properties?
>
>
> *Dan Cocos*
> BAO Systems
> www.baosystems.com
> T: +1 202-352-2671 | skype: dancocos
>
> On May 18, 2015, at 12:46 PM, gerald thomas  wrote:
>
> Dear All,
> Why i am getting Error 404 most of the time? What am I doing wrong
> that is creating this error?
> Please help me.
> Attached are my log files.
>
> --
> Regards,
>
> Gerald
> 
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET
Kampala
Uganda

IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya

IT Specialist (Servers, Networks and Security, Health Information Systems -
DHIS2 ) & Solar Consultant

+256 774149 775, + 256 759 800161

"I don't want to be anything other than what I have been - one tree hill "
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 19164: ER individual mode title changed.

[noreply]

Merge authors:
  Jan Henrik Øverland (janhenrik-overland)

revno: 19164 [merge]
committer: Jan Henrik Overland 
branch nick: dhis2
timestamp: Mon 2015-05-18 19:43:52 +0200
message:
  ER individual mode title changed.
modified:
  
dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-event-reports/scripts/app.js


--
lp:dhis2
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk

Your team DHIS 2 developers is subscribed to branch lp:dhis2.
To unsubscribe from this branch go to 
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk/+edit-subscription
=== modified file 'dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-event-reports/scripts/app.js'
--- dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-event-reports/scripts/app.js	2015-05-13 15:44:45 +
+++ dhis-2/dhis-web/dhis-web-apps/src/main/webapp/dhis-web-event-reports/scripts/app.js	2015-05-18 17:41:32 +
@@ -7415,7 +7415,7 @@
 		caseButton = Ext.create('Ext.button.Button', {
 width: 224,
 			param: 'individual_cases',
-text: 'Individual casesShow case-based event report',
+text: 'EventsShow individual event overview',
 style: 'margin-right:1px',
 			listeners: {
 mouseout: function(cmp) {

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] DHIS2 404 error

[Bob Jolliffe]

Hi Gerald

Looks like 2 different things are going on here.  First as Alex says,
check that you don't already have something listening on 8080
(netstat -ntl is your friend).  You are getting that error earlier in
the catalina log - port is already taken.

Then finally it seems to start but it doesn't look like you have dhis
war file deployed.

I think we have been through this before, but do you have 2 different
tomcat installations which are competing with one another?

On 18 May 2015 at 18:25, Alex Tumwesigye  wrote:
> Dear Gerald,
>
> Please visit this link
> https://www.dhis2.org/doc/snapshot/en/implementer/html/ch08s02.html#d5e505
>
> Also ensure that only one tomcat instance is running on the port.
>
>
> Alex
>
> On Mon, May 18, 2015 at 8:13 PM, Dan Cocos  wrote:
>>
>> Hi Gerald,
>>
>> I looks like it is unable to connect to the database. Is your database
>> started and your connection info properly set in hibernate.properties?
>>
>>
>> Dan Cocos
>> BAO Systems
>> www.baosystems.com
>> T: +1 202-352-2671 | skype: dancocos
>>
>> On May 18, 2015, at 12:46 PM, gerald thomas  wrote:
>>
>> Dear All,
>> Why i am getting Error 404 most of the time? What am I doing wrong
>> that is creating this error?
>> Please help me.
>> Attached are my log files.
>>
>> --
>> Regards,
>>
>> Gerald
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>
>
>
> --
> Alex Tumwesigye
>
> Technical Advisor - DHIS2 (Consultant),
> Ministry of Health/AFENET
> Kampala
> Uganda
>
> IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya
>
> IT Specialist (Servers, Networks and Security, Health Information Systems -
> DHIS2 ) & Solar Consultant
>
> +256 774149 775, + 256 759 800161
>
> "I don't want to be anything other than what I have been - one tree hill "
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 19165: Data element, typos

[noreply]

revno: 19165
committer: Lars Helge Overland 
branch nick: dhis2
timestamp: Mon 2015-05-18 17:05:25 -0400
message:
  Data element, typos
modified:
  
dhis-2/dhis-web/dhis-web-maintenance/dhis-web-maintenance-datadictionary/src/main/resources/org/hisp/dhis/dd/i18n_module.properties


--
lp:dhis2
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk

Your team DHIS 2 developers is subscribed to branch lp:dhis2.
To unsubscribe from this branch go to 
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk/+edit-subscription
=== modified file 'dhis-2/dhis-web/dhis-web-maintenance/dhis-web-maintenance-datadictionary/src/main/resources/org/hisp/dhis/dd/i18n_module.properties'
--- dhis-2/dhis-web/dhis-web-maintenance/dhis-web-maintenance-datadictionary/src/main/resources/org/hisp/dhis/dd/i18n_module.properties	2015-04-07 10:51:20 +
+++ dhis-2/dhis-web/dhis-web-maintenance/dhis-web-maintenance-datadictionary/src/main/resources/org/hisp/dhis/dd/i18n_module.properties	2015-05-18 21:05:25 +
@@ -142,12 +142,12 @@
 data_element_does_not_exist=Identifier does not reference a data element
 category_option_combo_does_not_exist=Identifier does not reference a category option combo
 expression_not_well_formed=Expression is not well formed
-intro_data_element=Create, modify, view and delete data elements. Data elements are phenomena for which will be captured and analysed.
+intro_data_element=Create, modify, view and delete data elements. Data elements are phenomena for which will be captured and analyzed.
 intro_data_element_group=Create, modify, view and delete data element groups. Groups are used for improved analysis.
 intro_data_element_group_editor=Easily add or remove data elements to and from data element groups, as well as deleted data elements.
 intro_data_element_group_set=Create, modify, view and delete data element group sets. Group sets are used for improved analysis.
-intro_category_option=Create, modify, view and delete data element category options. Category Option are fine-grained break-downs of catagory.
-intro_category=Create, modify, view and delete data element categories. Categories are fine-grained break-downs of data elements.
+intro_category_option=Create, modify, view and delete data element category options. Category options are options with in category.
+intro_category=Create, modify, view and delete data element categories. Categories are used for disaggregation of data elements.
 intro_category_combo=Create, modify, view and delete data element category combinations.
 intro_category_option_group=Create, modify, view and delete category option groups, which can be used to classify category options.
 intro_category_option_group_set=Create, modify, view and delete category option group sets, which can be used for improved data analysis.
@@ -233,8 +233,8 @@
 id=Id
 min=Min
 max=Max
-category_option_combo = Category Option Combo
-intro_category_option_combo = View and edit data element category option combos. Category Option Combo are fine-grained break-downs of catagory.
+category_option_combo = Category Option Combination
+intro_category_option_combo = View and edit data element category option combinations. Category option combinations are break-downs of category.
 edit_data_element_category_option_combo = Edit data element category option combo
 average_sum_in_org_unit_hierarchy=Average (sum in org unit hierarchy)
 approve_data=Approve data

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Capture daily data set values on a monthly form (calendar view)

[Lars Helge Øverland]

Hi Pierre,

You could use the web API to post data values for any period, but would
have to re-implement or hook into the logic for determining the period and
how the period id is sent to the server. So it would be possible through
Javascript, but I don't see a very simple way of doing it.

regards,

Lars


On Mon, May 18, 2015 at 11:33 AM, Knut Staring  wrote:

> So the same dataset but different periods like a spreadsheet/matrix, right?
>
> On Mon, May 18, 2015 at 5:19 PM, Pierre Dane  wrote:
>
>> Hi all,
>>
>> Has anyone developed a custom form or app that allows one to capture data
>> values for multiple datasets?
>> We have a dataset that needs to have a daily period, but want to capture
>> the entire month on one screen, mirroring the paper form.
>>
>> Any guidance would be much appreciated. (I'd prefer not to use
>> categoryoptioncombos to solve this problem)
>>
>> Thanks!
>>
>>
>>
>> --
>> Pierre
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> Norway: +4791880522
> Skype: knutstar
> http://dhis2.org
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Defect with the Aggregation Query feature?

[Tran Chau (HISP Vietnam)]

HI Shantala,

I will take a look at it couple days later. I will inform you if I find out
the issue.

...
Best regards,
Tran Chau


On Mon, May 18, 2015 at 7:54 PM, Shantala Raman 
wrote:

> Hi Tran,
>
> Here  is
> the link to the DB dump of DHIS in dropbox where we have setup the data
> needed to replicate the defect. We have associated the *Cholera CTC*
> program under the organization hierarchy, MSF->OCP->A new country->A new
> project->New Hospital->Cholera->Origin 1. The program is of type *Single
> event without registration*.
>
> Steps to reproduce the defect:
>
>1. In event capture, register an event for the *Cholera CTC* program
>under the *Origin 1* org unit.
>2. Preview the manual aggregation results for *Geographic Origin* data
>set for *Origin 1* org unit for the week of the *Incident date* and
>save all values.
>3. In data entry, you will see that the value of the *Number of
>Patients (Cholera CTC) *data element for the *Geographic Origin* data
>set for the week of the *Incident date* is 1.
>4. In event capture, remove the event for the *Cholera CTC* program
>under the *Origin 1* org unit.
>5. Preview the manual aggregation results for *Geographic Origin* data
>set for *Origin 1* org unit for the week of the *Incident date*. This
>won't return any changes to be updated while the expected behavior is that
>preview shows that the value for the *Number of Patients (Cholera CTC)*
>data element will change from 1 to 0. Save all values.
>6. In data entry, you will see the value of the *Number of Patients
>(Cholera CTC)* data element remains as 1 for the *Geographic Origin*
>data set for the week while the expected behavior is that the value of the 
> *Number
>of Patients (Cholera CTC)* data element is 0.
>
> Thanks,
> Shantala
>
>
> On Tue, May 12, 2015 at 3:05 PM, Shantala Raman 
> wrote:
>
>> Hi Tran,
>>
>> We are on 2.19 rev 19092. We are not using SQL queries for generating
>> summary data values. We are using the aggregation query builder to setup
>> the queries. Could you explain how the SQL query is linked to aggregation
>> query builder?
>>
>> Thanks,
>> Shantala
>>
>> On Mon, May 11, 2015 at 7:10 PM, Tran Chau (HISP Vietnam) <
>> tran.hispviet...@gmail.com> wrote:
>>
>>> Hi Shantala,
>>>
>>> The first, please make sure if the snapshots are from 2.19 version, R
>>> 19075  ?  It looks like old version.
>>>
>>>
>>> I couldn't create an example on dev server ( apps.dhis2.org/dev )
>>> because the internet is still slow here. I cannot login the dev server to
>>> create an example.
>>>
>>> I am sending the SQL statement which I used to generate the data values
>>> from aggregate query formulas.
>>>
>>> Can you change the IDs in the SQL statement below according to one of
>>> your formula and see if it is generated "NULL" value records or not  (
>>> these NULL values will be displayed/saved as "0" values in Manual Aggregate
>>> )
>>>
>>>
>>>  SELECT '55' as dataelementid, '16' as categoryoptioncomboid,
>>> '16' as attributeoptioncomboid, ou.organisationunitid as sourceid,
>>> '1234' as periodid,'aggregated_from_tracker' as storedby,
>>> '201505' as periodIsoDate,'Agg DE 1' as dataelementname,
>>> '(default)' as categoryoptioncomboname, ou.name as
>>> organisationunitname,
>>> ( select  count(psi.programinstanceid) as value FROM  programinstance as
>>> pi
>>> INNER JOIN programstageinstance psi ON
>>> pi.programinstanceid=psi.programinstanceid
>>>  WHERE  EXISTS ( SELECT * FROM trackedentitydatavalue _pdv
>>> inner join programstageinstance _psi ON
>>> _pdv.programstageinstanceid=_psi.programstageinstanceid
>>> JOIN programinstance _pi ON _pi.programinstanceid=_psi.programinstanceid
>>> WHERE psi.programstageinstanceid=_pdv.programstageinstanceid
>>> AND _pdv.dataelementid=53  AND _psi.organisationunitid in (50, 51, 52)
>>>
>>> AND _pi.programid = 60 AND _psi.executionDate>='2015-05-01'
>>> AND _psi.executionDate <= '2015-05-31'
>>> AND _psi.programstageid = 63 AND _pdv.value   is not null  )
>>>  and psi.organisationunitid=ou.organisationunitid
>>>
>>> GROUP BY ou.organisationunitid ) from organisationunit ou where
>>> ou.organisationunitid in ( 50, 51, 52 )
>>>
>>>
>>> ...
>>> Best regards
>>> Tran Chau
>>>
>>> On Mon, May 11, 2015 at 8:02 PM, Tran Chau (HISP Vietnam) <
>>> tran.hispviet...@gmail.com> wrote:
>>>
 Hi Shantala,

 Are you sure if the snapshots are from 2.19 version, R 19075  ?
 It looks like old version.

 ...
 Best regards,
 Tran Chau
 Hi Tran,

 We are still seeing issues with the aggregation. We followed the below
 steps -

- Created a data element with *Store zero data values* property set
to Yes
- Created an aggregation query for the data element
- Created 3 events for the pro