[Dhis2-devs] Error while running analytics

2017-08-28 Thread Mithilesh Kumar Thakur
Dear Team, We are using the following credentials: Version:2.26Build revision:b853b77ceBuild date:2017-06-22 13:39 While running analytics we are getting the following error: Your help will be highly appreciated! Process failed: StatementCallback; SQL [create table analytics_event_temp_2010_s

Re: [Dhis2-devs] Showing Identifiers in Relationship box

2017-08-28 Thread Markus Bekken
The tracked entity attributes would also have to be part of the program that the relationship links to. If they are part of the program and also has the "display in list without program" checked they should be in the relationship table. There should not be a limit. Assuming the attributes in fa

Re: [Dhis2-devs] [Dhis2-users] Options not showing in tracker data entry (version 2.26; build revision 7db3ef8)

2017-08-28 Thread Stanley Kalyati
For me I simply designed the data entry form instead of using the default.This has worked for me. However,surprisingly,when using the default form on Android,the options are visible. Alot to learn I guess. On Aug 28, 2017 12:20, "Terence Scott" wrote: > Dear All > > I have had a similar prob

Re: [Dhis2-devs] [Dhis2-users] Timeout when updating large organisation unit group in large instance (2.23)

2017-08-28 Thread Morten Olav Hansen
Sure, but if you are on 2.23... dot dot dot... some concessions has to be made -- Morten Olav Hansen Senior Engineer, DHIS 2 University of Oslo http://www.dhis2.org On Tue, Aug 29, 2017 at 2:07 AM, Martin Van Aken wrote: > Agree on the upgrade but not every system we support is ours - ie decis

Re: [Dhis2-devs] [Dhis2-users] Timeout when updating large organisation unit group in large instance (2.23)

2017-08-28 Thread Martin Van Aken
Agree on the upgrade but not every system we support is ours - ie decision not 100% in our hands. We manage with the API for now, but that's not practical for end users. Martin On Mon, Aug 28, 2017 at 8:47 PM, Morten Olav Hansen wrote: > If you are willing to do manual import (using the command

Re: [Dhis2-devs] [Dhis2-users] Timeout when updating large organisation unit group in large instance (2.23)

2017-08-28 Thread Morten Olav Hansen
If you are willing to do manual import (using the command line), in 223 you can use /api/23/metadata I think... it will use the "new" importer.. which should be quicker, please be aware that 223 is not supported anymore, so please update ASAP if you can.. -- Morten Olav Hansen Senior Engineer, DH

Re: [Dhis2-devs] [Dhis2-users] Timeout when updating large organisation unit group in large instance (2.23)

2017-08-28 Thread Martin Van Aken
Hi Morten, This is on 2.23 - I tried to manipulate big groups on the play demo instance and it goes well there. I'll try to get some logs. Martin On Mon, Aug 28, 2017 at 5:27 PM, Morten Olav Hansen wrote: > Hi Martin > > What version of DHIS2 are you on? if you are on 227 there is currently a

Re: [Dhis2-devs] [Dhis2-users] Timeout when updating large organisation unit group in large instance (2.23)

2017-08-28 Thread Morten Olav Hansen
Hi Martin What version of DHIS2 are you on? if you are on 227 there is currently a bug that has lowered performance in 227 vs the older versions (226, 225, etc..) If you are not, if you could.. please file a JIRA issue and either attach the org units, or email me directly -- Morten Olav Hansen

Re: [Dhis2-devs] BUG - 2.27 - Logged as different user

2017-08-28 Thread Bob Jolliffe
If you are getting remnants of SJ's session appearing on your computer it might mean some stuff is being (incorrectly) cached on the server side. Do you have nginx or apache cache enabled. If so try disabling that. On 28 August 2017 at 10:51, Ramón José Jiménez Pomareta wrote: > I think that ca

Re: [Dhis2-devs] [Dhis2-users] Timeout when updating large organisation unit group in large instance (2.23)

2017-08-28 Thread Martin Van Aken
Hello Joseph, Thanks for the feedback. I'll try rh On Mon, Aug 28, 2017 at 5:13 PM, Joseph K. Osborn wrote: > Hello Martin, > > We had this problem with 2.22 or 2.23, the solution was to perform these > updates during off-peak hours, times when the server was not too busy, so > after 10pm, and i

Re: [Dhis2-devs] [Dhis2-users] Timeout when updating large organisation unit group in large instance (2.23)

2017-08-28 Thread Joseph K. Osborn
Hello Martin, We had this problem with 2.22 or 2.23, the solution was to perform these updates during off-peak hours, times when the server was not too busy, so after 10pm, and it worked. But with 2.26 which has improved the analytic time and executions of several queries, we do our updates ev

Re: [Dhis2-devs] Request For WebAPI DataStore Documentation

2017-08-28 Thread Farai Mutero
Thanks Jason and Stian for the prompt response. Much appreciated. Regards Farai On Mon, Aug 28, 2017 at 1:10 PM, Jason Pickering < jason.p.picker...@gmail.com> wrote: > https://docs.dhis2.org/master/en/developer/html/webapi_data_store.html > > On Mon, Aug 28, 2017 at 12:55 PM, Farai Mutero wr

Re: [Dhis2-devs] [Dhis2-users] Timeout when updating large organisation unit group in large instance (2.23)

2017-08-28 Thread Martin Van Aken
Got nothing until now but I'm investigating in that direction right now. Thanks already for the pointer! Martin On Mon, Aug 28, 2017 at 4:12 PM, Michael Mwebaze wrote: > Hi Martin, > > do you have access to the Tomcat logs? If an exception is being thrown > that would also be helpful to figure

[Dhis2-devs] Embed chart - 2.24

2017-08-28 Thread Martin Van Aken
Hi, I'm trying to embed chart using a 2.24 version. Jan did help me a while ago with a 2.22 version, but when I go to the doc for the 2.24 it does not look up to date - https://docs.dhis2.org/2.24/en/developer/html/dhis2_developer_manual_full.html#d7652e7049. >From the CDN it looks like there is no

Re: [Dhis2-devs] BUG - 2.27 - Logged as different user

2017-08-28 Thread Knut Staring
And SJ has not been logged in on your computer at all? Clearing browser cache has no effect? Could you try and test this also on https://play.dhis2.org/demo? Knut On Mon, Aug 28, 2017 at 11:51 AM, Ramón José Jiménez Pomareta < dh...@pomareta.ch> wrote: > I think that can be useful: > Usually SJ

Re: [Dhis2-devs] [Dhis2-users] Timeout when updating large organisation unit group in large instance (2.23)

2017-08-28 Thread Michael Mwebaze
Hi Martin, do you have access to the Tomcat logs? If an exception is being thrown that would also be helpful to figure out what is happening. Regards, Michael On 28 August 2017 at 10:04, Martin Van Aken wrote: > Hi DHIS2 users & developers, > We have a relatively large instance of DHIS2 (30 0

Re: [Dhis2-devs] Showing Identifiers in Relationship box

2017-08-28 Thread Immaculate Ayebazibwe
Hi Markus, Does this have a limit? I have checked like three attributes to display without program but I can only see one. Thank you and Kind Regards *Immarcqulate. A (Emma Kassy) * *"You miss 100% of the shots you don't take."* On Mon, Aug 28, 2017 at 12:06 PM, Markus Bekken wrote: > Sorry,

[Dhis2-devs] Timeout when updating large organisation unit group in large instance (2.23)

2017-08-28 Thread Martin Van Aken
Hi DHIS2 users & developers, We have a relatively large instance of DHIS2 (30 000 org units) where we have several groups that can make up to 3 000 org unit each. When trying to update them through the UX, our server get a timeout (looking in the console for the network calls). The call is like t

Re: [Dhis2-devs] [Dhis2-users] Switch enrolling organisation unit

2017-08-28 Thread Markus Bekken
Thank you for alerting us - we will add the button to the tabular entry. In the meantime you can still use the referral function if you temporarily show the timeline widget. Hope this helps. Markus > 28. aug. 2017 kl. 15.45 skrev Georgi Chakarov : > > Hi, > > It’s available only in Timelin

Re: [Dhis2-devs] [Dhis2-users] Switch enrolling organisation unit

2017-08-28 Thread Markus Bekken
Hi :) Assuming this is on 2.27 - you could open these records in Tracker Capture and use the "Referral" functionality. The button for referral is located below the schedule event button. Select the correct organization unit to move the enrollment to, and select "Move permanently" in the referral

Re: [Dhis2-devs] [Dhis2-users] HELP with program indicator/report

2017-08-28 Thread Markus Bekken
Hey again Georgi, this seems like a bug with the d2:hasValue function. Using enrollment analytics, the intended outcome for d2:hasValue(#{programStageWithNoEvents.dataelement}) is false. Just making sure your program indcator was an enrollment program indicator - could you register this as a bu

Re: [Dhis2-devs] [Dhis2-users] Assign value to a tracked entity attribute with an option set

2017-08-28 Thread Markus Bekken
Ok, that makes it a bit more tricky. You probably want to assign and save tracked entity instance attributes while filling in data in an event. The problem with this is that the assignments to tracked entity attributes will be triggered when you are in the registration form, or if you open the e

Re: [Dhis2-devs] Request For WebAPI DataStore Documentation

2017-08-28 Thread Stian Sandvold
https://docs.dhis2.org/2.27/en/developer/html/webapi_data_store.html On Mon, Aug 28, 2017 at 12:55 PM, Farai Mutero wrote: > Hi All > > Could someone please share links to the WebAPI documentation on using the > "api/dataStore/" endpoint? > > Regards > > -- > Farai Mutero > > > _

Re: [Dhis2-devs] Request For WebAPI DataStore Documentation

2017-08-28 Thread Jason Pickering
https://docs.dhis2.org/master/en/developer/html/webapi_data_store.html On Mon, Aug 28, 2017 at 12:55 PM, Farai Mutero wrote: > Hi All > > Could someone please share links to the WebAPI documentation on using the > "api/dataStore/" endpoint? > > Regards > > -- > Farai Mutero > > > ___

[Dhis2-devs] Request For WebAPI DataStore Documentation

2017-08-28 Thread Farai Mutero
Hi All Could someone please share links to the WebAPI documentation on using the "api/dataStore/" endpoint? Regards -- Farai Mutero ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://

Re: [Dhis2-devs] [Dhis2-users] Options not showing in tracker data entry (version 2.26; build revision 7db3ef8)

2017-08-28 Thread Terence Scott
Dear All I have had a similar problem in the past and have simply cleared cache, worked in 'incognito mode' and run analytics. This has solved the problem as all has been correct with the build side, but it did not reflect. I hope this helps. Kind regards, Terence Terence Scott Global Alliance

Re: [Dhis2-devs] [Dhis2-users] Options not showing in tracker data entry (version 2.26; build revision 7db3ef8)

2017-08-28 Thread Stanley Kalyati
Has anybody really responded to this? I am also facing the same challenge. Regards On Wed, Aug 2, 2017 at 3:07 PM, Nayeem Al Mifthah wrote: > Dear Mithilesh > It is working fine on my instance with 2.26. I have faced same after first > upgradation. But after re upgrading with clearing server ca

Re: [Dhis2-devs] DHIS2- API

2017-08-28 Thread Harsh Atal
Hi, You can filter by current user UID on the dataset endpoint : /api/dataSets?fields=id,name,user&filter=user.id:eq:*UID* On 28 August 2017 at 15:03, Omer Butt wrote: > Sir, > > How to get Data sets of current user login? > > Thanks > > ___ > Maili

Re: [Dhis2-devs] BUG - 2.27 - Logged as different user

2017-08-28 Thread Ramón José Jiménez Pomareta
I think that can be useful: Usually SJ is an user has been recently or is currently logged on another computer. 2017-08-28 11:44 GMT+02:00 Ramón José Jiménez Pomareta : > Hello, > > > When I log with my credentials (ramon), DHIS2 shows SJ and the name of > another user on the top right corner in

[Dhis2-devs] BUG - 2.27 - Logged as different user

2017-08-28 Thread Ramón José Jiménez Pomareta
Hello, When I log with my credentials (ramon), DHIS2 shows SJ and the name of another user on the top right corner instead of mine (RJ and Ramon Jimenez). The apps I can see are the apps allowed for SJ. I am not able to see mines. On the server log, I am logged correctly and there's no trace abou

[Dhis2-devs] DHIS2- API

2017-08-28 Thread Omer Butt
Sir, How to get Data sets of current user login? Thanks ___ 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] Showing Identifiers in Relationship box

2017-08-28 Thread Markus Bekken
Sorry, I misunderstood your original question. To display an attribute in the relationship table, you have to open the tracked entity attribute and select the "display in list without program" option. Markus > 27. aug. 2017 kl. 08.48 skrev Immaculate Ayebazibwe : > > Hi Everyone, > I am worki

Re: [Dhis2-devs] Showing Identifiers in Relationship box

2017-08-28 Thread Immaculate Ayebazibwe
​Well I have Program A HouseHold and Program B Beneficiary Created a relationship type HouseHold with relationships A to B​ as Household and B to A as Beneficiary. Added this to program A with new relative as Beneficiary. I hope this helps. Thank you and Kind Regards *Immarcqulate. A (Emma Kassy

Re: [Dhis2-devs] [Dhis2-users] HELP with program indicator/report

2017-08-28 Thread Markus Bekken
Hi there Georgi, We do not have a function that does exactly what you asked for, but hopefully we can find a way if we examine the data elements in your stages. Do the stages have a data element that is mandatory, or at least so pivotal that you can sue that data element to determine wether the

Re: [Dhis2-devs] Showing Identifiers in Relationship box

2017-08-28 Thread Markus Bekken
Thank you, In the relationships widget you should see one table for each program that is represented within the relationships that belongs to your local tracked entity attribute. Could you provide some more details on your local setup of relationships and programs? > 28. aug. 2017 kl. 09.49 sk

Re: [Dhis2-devs] [Dhis2-users] Assign value to a tracked entity attribute with an option set

2017-08-28 Thread Markus Bekken
Hi there Gorgi! You mention a "Yes only" data element, but did you mean a "Yes only" tracked entity attribute? Meaning, is the checkbox and the dropdown both located inside same registration/profile form? If they are, you can make a rule in the way you describe below. The correct expression wo

Re: [Dhis2-devs] Showing Identifiers in Relationship box

2017-08-28 Thread Immaculate Ayebazibwe
​Hey Markus, Thx for the quick response Yes it has Version: 2.27Build revision:0303f0dBuild date: 2017-08-24 12:02 ​ Thank you and Kind Regards *Immarcqulate. A (Emma Kassy) * *"You miss 100% of the shots you don't take."* On Mon, Aug 28, 2017 at 10:44 AM, Markus Bekken wrote: > Hi Emma, > s

Re: [Dhis2-devs] Downloading Event Reports and Picot Tables

2017-08-28 Thread Markus Bekken
Hey there, seems like a feature you can request in Jira! Markus > 27. aug. 2017 kl. 09.20 skrev Immaculate Ayebazibwe : > > Hi All, > When I download event reports or program indicators in pivot tables under > Table Layout as Csv or Microsoft excel they have, the orgUnits and data > elements/I

Re: [Dhis2-devs] Showing Identifiers in Relationship box

2017-08-28 Thread Markus Bekken
Hi Emma, splitting the relationship into tables(one for each program) is a pretty new improvement. Have your local instance(assuming it is 2.27) been updated recently? Best regards, Markus > 27. aug. 2017 kl. 08.48 skrev Immaculate Ayebazibwe : > > Hi Everyone, > I am working with relationship

Re: [Dhis2-devs] [Dhis2-users] Program rules not running for custom forms

2017-08-28 Thread Stian Sandvold
Hi Timothy, Are you running on the newest development branch? There has been a couple of changes to the validation rules processing the last week, so you might be experiencing an unfinished feature or bug. If you run the validation rules in the data quality app, are you getting the correct result