[Dhis2-devs] Strange behavior on data entry form

[Trøyel Nerbø]

Hi,
I am encountering some strange behavior in 2.26 after updating some metadata on 
a couple of my aggregate forms. This seems to be related to the category combo 
override & or data set.

Pre change - everything works fine and looks like his:
[cid:image002.jpg@01D38FC9.55A12920]

Then I update the data elements and GL-S5/TMS gets renamed to GL-S513/TS and 
gets a slightly newer disaggregation (new catcombo).
However - as per default data set behavior the old CatCombo is retained on the 
data element in the data set (override says it has the old one same as 
GL-S5/PMS.).
[cid:image008.jpg@01D38FC9.55A12920]
(This behavior is great, btw! :) )

But : when I try to enter data on the form it suddenly is drawn up in the auto 
form as an entirely different cat combo - male female. Which it is not assigned 
either on data element or on data set.
[cid:image009.jpg@01D38FC9.55A12920]
Trying to enter data against it gives an error as that catcombo/catoption is 
not assigned. If I try to create a custom form I am given the list of CORRECT 
disaggregations.

Testing to see how this fits together; I try to change the override on the data 
set to match female and male (sex). However - Surprise! The form now changes to 
default:
[cid:image010.jpg@01D38FC9.55A12920]

However : Creating a new data set does not have this issue. But I would prefer 
not to have to do that in order to fix this..

Any suggestions on cause or fix?

Many thanks!
Best,
Trøyel


Trøyel Nerbø
Data Reporting and Analysis Adviser
Strategic Planning and Development, Head office
Phone: + 47 99239817 | Skype ID nrc_troyel

Norwegian Refugee Council
www.nrc.no<http://www.nrc.no/>| 
Facebook<https://www.facebook.com/norwegianrefugeecouncil> | 
Twitter<https://twitter.com/nrc_norway>

[cid:image001.png@01D348CB.BE410710]

___
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] Getting more info about why data values are ignored during import

[Trøyel Nerbø]

I remember having similar issues at some point... But often for me it has been 
related to attributeoptioncomboes - which you are not using...

Which DHIS2 version are you running?
Have you tried multiple imports with the same file - do you get the same 
results each time?
Another tip for getting more information "back" to try on a database with no 
data values and then compare the imported file of datavalues against the export 
post import to see if there is a pattern to which ones doesn't get imported? 
Also try the latest build of DHIS if you are using an old build.

Best of luck,

Trøyel


Trøyel Nerbø
Data Reporting and Analysis Adviser
Strategic Planning and Development, Head office
Phone: + 47 99239817 | Skype ID nrc_troyel

Norwegian Refugee Council
www.nrc.no<http://www.nrc.no/>| 
Facebook<https://www.facebook.com/norwegianrefugeecouncil> | 
Twitter<https://twitter.com/nrc_norway>

[cid:image001.png@01D348CB.BE410710]



From: Dhis2-devs 
[mailto:dhis2-devs-bounces+troyel.nerbo=nrc...@lists.launchpad.net] On Behalf 
Of Manuel Silva Gallego
Sent: tirsdag 9. januar 2018 11.09
To: dhis2-devs@lists.launchpad.net
Subject: [Dhis2-devs] Getting more info about why data values are ignored 
during import


Hi,
I am sending bulks of data to DHIS2 using the API specifying value, 
dataElement, catOptCombo, orgUnit and Period (attrOptionCombo is always empty). 
An example of the json payload can be found below.
{
  "dataValues": [
{
  "dataElement": "f3650e9e3b6",
  "period": "2013W01",
  "orgUnit": "098b208aabf",
  "categoryOptionCombo": "412b32f973f",
  "attrOptionCombo": "",
  "value": "5"
},
{
  "dataElement": "26d0e2dd673",
  "period": "2013W01",
  "orgUnit": "098b208aabf",
  "categoryOptionCombo": "412b32f973f",
  "attrOptionCombo": "",
  "value": "4"
},
{
  "dataElement": "e638c648d6b",
  "period": "2013W01",
  "orgUnit": "098b208aabf",
  "categoryOptionCombo": "412b32f973f",
  "attrOptionCombo": "",
  "value": "10"
},
{
  "dataElement": "f1ee1df0b4f",
  "period": "2013W01",
  "orgUnit": "098b208aabf",
  "categoryOptionCombo": "412b32f973f",
  "attrOptionCombo": "",
  "value": "3"
},
{
  "dataElement": "94448a0b819",
  "period": "2013W01",
  "orgUnit": "098b208aabf",
  "categoryOptionCombo": "412b32f973f",
  "attrOptionCombo": "",
  "value": "3"
}
  ]
}

So far I imported 10 records in DHIS2 and got 818 ignored (response below). 
I have queries to check and validate that all references used in my data values 
exist and can't find any missing reference. I also made sure there are no zero 
values... So I can't figure out the reason why those 818 records are ignored. 
In there any way to get a response from DHIS2 with more info about ignored 
records? Thanks

{

  "responseType": "ImportSummary",
  "status": "SUCCESS",
  "importOptions": {
"idSchemes": {},
"dryRun": false,
"async": false,
"importStrategy": "CREATE_AND_UPDATE",
"mergeMode": "REPLACE",
"reportMode": "FULL",
"skipExistingCheck": false,
"sharing": false,
"skipNotifications": false,
"datasetAllowsPeriods": false,
"strictPeriods": false,
"strictCategoryOptionCombos": false,
"strictAttributeOptionCombos": false,
"strictOrganisationUnits": false,
"requireCategoryOptionCombo": false,
"requireAttributeOptionCombo": false
  },
  "description": "Import process completed successfully",
  "importCount": {
"imported": 99182,
"updated": 0,
"ignored": 818,
"deleted": 0
  },
  "dataSetComplete": "false"
}



Best regards / Cordialement / Vriendelijke groeten / Atentamente,
[1470312630639_PastedImage]
___
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] Assign Bulk DataSets to a new organisationUnit

[Trøyel Nerbø]

Dear Hakim,
You’re not the only one needing this. In NRC we are working with EyeSeeTea on 
an app to help us configure and create data sets. Most of the functionality 
relies on metadata and  business rules particular to NRC – but on the app main 
screen you will find a generic feature that will help you do bulk sharing and 
bulk assigning of data sets to org units and groups.

Those features are fully tested on 2.26, although they should work on other 
versions of dhis2 as well.

You can find app releases here: 
https://github.com/EyeSeeTea/dataset-configuration-blessed/releases

Screenshot of bulk assign, share and delete from the app.

[cid:image001.jpg@01D38A1F.76FA49D0]

Best,
Trøyel

Trøyel Nerbø
Data Reporting and Analysis Adviser
Strategic Planning and Development, Head office
Phone: + 47 99239817 | Skype ID nrc_troyel

Norwegian Refugee Council
www.nrc.no<http://www.nrc.no/>| 
Facebook<https://www.facebook.com/norwegianrefugeecouncil> | 
Twitter<https://twitter.com/nrc_norway>

[cid:image001.png@01D348CB.BE410710]

---


From: Dhis2-devs 
[mailto:dhis2-devs-bounces+troyel.nerbo=nrc...@lists.launchpad.net] On Behalf 
Of DJIBRIL Hakim
Sent: onsdag 10. januar 2018 13.13
To: dhis2-us...@lists.launchpad.net; DHIS 2 Developers list 
<dhis2-devs@lists.launchpad.net>
Subject: [Dhis2-devs] Assign Bulk DataSets to a new organisationUnit

Happy new All,
Please, It is there a way to assign bulk dataset to a new organisationUnit 
rather going in each dataset and choose this new organisationUnit.

Even the api way doing that!

Thank you.
___
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] Troubleshoot CSV data value import on ignored rows

[Trøyel Nerbø]

Dear all,
I am trying to change and move data values where I have exported the data from 
data value export and then I have modified and split the data on periods only 
(same properties imported back but instead of all data in 201601 some is 
distributed onto 201701). Running the latest on 2.26 I get a few rows that are 
ignored in the CSV import, but no conflicts or information on what this is. Any 
ways to troubleshoot this import to get debug like in metadata import? Thanks!

Best,
Trøyel

Best Regards
Halvar Trøyel Nerbø
Reporting Advisor
+47 992 39 817
Skype: nrc_troyel
www.nrc.no<http://www.nrc.no/>
[nrclogo]<http://www.nrc.no/>


___
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] 500 error on api/users

[Trøyel Nerbø]

Hi Lars,
Thanks a lot for the quick feedback and fix!

Best,
Trøyel

From: Lars Helge Øverland [mailto:l...@dhis2.org]
Sent: torsdag 4. mai 2017 18.07
To: Trøyel Nerbø <troyel.ne...@nrc.no>
Cc: DHIS 2 Developers List <dhis2-devs@lists.launchpad.net>
Subject: Re: [Dhis2-devs] 500 error on api/users


Hi Trøyel,

not sure exactly what happened but seems like a problem with the db upgrade. 
Try to run this SQL for a immediate fix:

update users set externalauth = false where externalauth is null;

regards,

Lars
​

On Thu, May 4, 2017 at 10:04 AM, Trøyel Nerbø 
<troyel.ne...@nrc.no<mailto:troyel.ne...@nrc.no>> wrote:
Dear all,

Today when I try to open /api/users.json?paging=false I get a 500 error of the 
type:
TTP Status 500 - Request processing failed; nested exception is 
org.hibernate.PropertyAccessException: Null value was assigned to a property of 
primitive type setter of org.hisp.dhis.user.UserCredentials.externalAuth

type Exception report
message Request processing failed; nested exception is 
org.hibernate.PropertyAccessException: Null value was assigned to a property of 
primitive type setter of org.hisp.dhis.user.UserCredentials.externalAuth
description The server encountered an internal error that prevented it from 
fulfilling this request.
exception
org.springframework.web.util.NestedServletException: Request processing failed; 
nested exception is org.hibernate.PropertyAccessException: Null value was 
assigned to a property of primitive type setter of 
org.hisp.dhis.user.UserCredentials.externalAuth


Any ideas what this can be caused by? Running 2.23.

Thanks!


Best Regards
Halvar Trøyel Nerbø
Reporting Advisor
+47 992 39 817<tel:992%2039%20817>
Skype: nrc_troyel
www.nrc.no<http://www.nrc.no/>
[nrclogo]<http://www.nrc.no/>




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



--
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
l...@dhis2.org<mailto:l...@dhis2.org>
http://www.dhis2.org<https://www.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] 500 error on api/users

[Trøyel Nerbø]

Dear all,

Today when I try to open /api/users.json?paging=false I get a 500 error of the 
type:
TTP Status 500 - Request processing failed; nested exception is 
org.hibernate.PropertyAccessException: Null value was assigned to a property of 
primitive type setter of org.hisp.dhis.user.UserCredentials.externalAuth

type Exception report
message Request processing failed; nested exception is 
org.hibernate.PropertyAccessException: Null value was assigned to a property of 
primitive type setter of org.hisp.dhis.user.UserCredentials.externalAuth
description The server encountered an internal error that prevented it from 
fulfilling this request.
exception
org.springframework.web.util.NestedServletException: Request processing failed; 
nested exception is org.hibernate.PropertyAccessException: Null value was 
assigned to a property of primitive type setter of 
org.hisp.dhis.user.UserCredentials.externalAuth


Any ideas what this can be caused by? Running 2.23.

Thanks!


Best Regards
Halvar Trøyel Nerbø
Reporting Advisor
+47 992 39 817
Skype: nrc_troyel
www.nrc.no<http://www.nrc.no/>
[nrclogo]<http://www.nrc.no/>



___
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] Transfer data from one category option to another

[Trøyel Nerbø]

Hi Ifeanyi,
You can always export the data and then import it back in with the correct 
reference. And then after that overwrite the original data.

See the documentation: 
https://docs.dhis2.org/master/en/user/html/dhis2_user_manual_en_full.html#d1244e20338

Best,
Trøyel

From: Dhis2-devs 
[mailto:dhis2-devs-bounces+troyel.nerbo=nrc...@lists.launchpad.net] On Behalf 
Of Ifeanyi Okoye
Sent: fredag 7. april 2017 12.53
To: DHIS 2 Developers List 
Subject: [Dhis2-devs] Transfer data from one category option to another

Hello Devs,
I would like to know if it is possible to transfer data stored against a 
category option to a another one?

There was a mistake in the initial setup of the category options for the data 
element and users have entered data against that option. The correct category 
option already exists in the system, and I am asking to know if this is doable 
right now in DHIS2.

I hope this makes sense.

Thank you.


Warm Regards,

Dr. Ifeanyi Okoye



___
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] Pivot table app for DHIS 2.23 is broken

[Trøyel Nerbø]

Be sure to use a different browser or incognito mode. I had a similar 
experience where I didn’t notice the bug  because the cached pivot table 
resources on my browser had working references and then I had to use a 
different browser to experience the bug you are talking about. I’m guessing 
this can work the other way as well.

And yes, pivot tables work now in 2.23.

Trøyel

From: jhansirk [mailto:jhans...@thoughtworks.com]
Sent: tirsdag 21. mars 2017 14.20
To: Jason Pickering <jason.p.picker...@gmail.com>
Cc: Trøyel Nerbø <troyel.ne...@nrc.no>; DHIS 2 Developers list 
<dhis2-devs@lists.launchpad.net>; twmsf <tw...@thoughtworks.com>; Megan Mcguire 
<megan.mcgu...@newyork.msf.org>; David Siang Fong Oh <d...@thoughtworks.com>
Subject: Re: [Dhis2-devs] Pivot table app for DHIS 2.23 is broken

Hi Jason,

Did you get a chance to look into this issue.

We see there are 2 new builds 174 and 175 now. We tested with 175 build and the 
issue still remains.

Thanks,
Jhansi

On 13-Mar-2017, at 8:39 PM, David Siang Fong Oh 
<d...@thoughtworks.com<mailto:d...@thoughtworks.com>> wrote:

Hi Jason,

Yes there was a bad build on Feb 7th I think. Build 173 - which is the latest - 
has the issues. Build 172 is fine.

To fix the issue on our end we forced DHIS2 to compile using build 172.

Hope that helps.

Cheers,

-doh

On Mon, Mar 13, 2017 at 7:28 PM, Jason Pickering 
<jason.p.picker...@gmail.com<mailto:jason.p.picker...@gmail.com>> wrote:
It looks like from here

https://oss.sonatype.org/content/repositories/snapshots/org/hisp/dhis/dhis-app-pivot/2.23-SNAPSHOT/

there was a bad build. I will look into with Jan and see what happened.

Regards,
Jason Pickering


On Mon, Mar 13, 2017 at 2:54 PM, Trøyel Nerbø 
<troyel.ne...@nrc.no<mailto:troyel.ne...@nrc.no>> wrote:
We are also running 2.23 and are having the same issue. Useful to know where it 
came from.
Thanks for sharing!

Best,
Trøyel

Best Regards
Halvar Trøyel Nerbø
Reporting Advisor
+47 992 39 817<tel:+47%20992%2039%20817>
Skype: nrc_troyel
www.nrc.no<http://www.nrc.no/>
<http://www.nrc.no/>



From: Dhis2-devs 
[mailto:dhis2-devs-bounces+troyel.nerbo<mailto:dhis2-devs-bounces%2Btroyel.nerbo>=nrc...@lists.launchpad.net<mailto:nrc...@lists.launchpad.net>]
 On Behalf Of jhansirk
Sent: mandag 13. mars 2017 12.56
To: DHIS 2 Developers list 
<dhis2-devs@lists.launchpad.net<mailto:dhis2-devs@lists.launchpad.net>>
Cc: twmsf <tw...@thoughtworks.com<mailto:tw...@thoughtworks.com>>; Megan 
Mcguire <megan.mcgu...@newyork.msf.org<mailto:megan.mcgu...@newyork.msf.org>>
Subject: [Dhis2-devs] Pivot table app for DHIS 2.23 is broken

Hello everyone,

We are currently on DHIS2 2.23 version. We have recently noticed some issues 
with the pivot table app. In Pivot table app, we see categories are undefined 
and report names are shown as empty strings. When we have looked into it, we 
noticed that the issue is with the newly built pivot table app artifact for 
DHIS 2.23.

Looks like the latest pivot table app is not compatible with DHIS 2.23. We see 
that pivot table app is a maven dependency. In maven repository, we see pivot 
table app for DHIS 2.23 is last built on Feb 7th and that is not compatible 
with DHIS 2.23. While building the DHIS 2.23 app, it is downloading the latest 
pivot table app artifact which is not compatible with DHIS 2.23. Hence, pivot 
table app has an issue with DHIS 2.23. We have verified the same in DHIS 2.25 
and it's not an issue with it.

Please let us know if you want more details.

Thanks,
Raghavendra/Jhansi



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



--
Jason P. Pickering
email: jason.p.picker...@gmail.com<mailto:jason.p.picker...@gmail.com>
tel:+46764147049<tel:+46%2076%20414%2070%2049>


___
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] Run analytics from the API?

[Trøyel Nerbø]

Oh I missed that, thanks Lars!

Trøyel

From: Lars Helge Øverland [mailto:l...@dhis2.org]
Sent: torsdag 16. mars 2017 10.09
To: Trøyel Nerbø <troyel.ne...@nrc.no>
Cc: DHIS 2 Developers list <dhis2-devs@lists.launchpad.net>
Subject: Re: [Dhis2-devs] Run analytics from the API?

Hi Trøyel,

see here:

https://docs.dhis2.org/master/en/developer/html/webapi_generating_resource_analytics_tables.html

Lars


On Thu, Mar 16, 2017 at 10:08 AM, Trøyel Nerbø 
<troyel.ne...@nrc.no<mailto:troyel.ne...@nrc.no>> wrote:
Hi,
Does anyone know if there is a API call or similar to run analytics from 
command line? Useful whenever I am restoring a database I need to immediately 
run analytics if the table is removed from the backup. Couldn’t find anything 
in the documentation on that.

Thanks!
Trøyel


Best Regards
Halvar Trøyel Nerbø
Reporting Advisor
+47 992 39 817<tel:992%2039%20817>
Skype: nrc_troyel
www.nrc.no<http://www.nrc.no/>
[nrclogo]<http://www.nrc.no/>


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



--
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
l...@dhis2.org<mailto:l...@dhis2.org>
http://www.dhis2.org<https://www.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] Run analytics from the API?

[Trøyel Nerbø]

Hi,
Does anyone know if there is a API call or similar to run analytics from 
command line? Useful whenever I am restoring a database I need to immediately 
run analytics if the table is removed from the backup. Couldn't find anything 
in the documentation on that.

Thanks!
Trøyel


Best Regards
Halvar Trøyel Nerbø
Reporting Advisor
+47 992 39 817
Skype: nrc_troyel
www.nrc.no<http://www.nrc.no/>
[nrclogo]<http://www.nrc.no/>

___
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] DHIS 2 (Version 2.23): Data and dimension section don't display in DHIS Pivot table even after running analytics

[Trøyel Nerbø]

Hi Derek,
We had the same issue. This is now fixed in the latest build of 2.23 that can 
be found on https://www.dhis2.org/downloads

Best,
Trøyel

Best Regards
Halvar Trøyel Nerbø
Reporting Advisor
+47 992 39 817
Skype: nrc_troyel
www.nrc.no<http://www.nrc.no/>
[nrclogo]<http://www.nrc.no/>



From: Dhis2-users 
[mailto:dhis2-users-bounces+troyel.nerbo=nrc...@lists.launchpad.net] On Behalf 
Of Derek Kahongo Mukenge
Sent: onsdag 15. mars 2017 12.28
To: dhis2-us...@lists.launchpad.net; DHIS 2 Developers list 
<dhis2-devs@lists.launchpad.net>; Erling Fjelstad <erl...@dhis2.org>; Lars 
Helge Øverland <larshe...@gmail.com>
Subject: [Dhis2-users] DHIS 2 (Version 2.23): Data and dimension section don't 
display in DHIS Pivot table even after running analytics

Hi Everybody
I'm not able to view data, dimension title and dimension content on the pivot 
table. But I can see data on the data set report. I run analytics, browse the 
cache, but nothing change.
Here below the picture that show what happen.
please assist,
Thanks.



--
Derek Kahongo Mukenge
___
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] Pivot table app for DHIS 2.23 is broken

[Trøyel Nerbø]

We are also running 2.23 and are having the same issue. Useful to know where it 
came from.
Thanks for sharing!

Best,
Trøyel

Best Regards
Halvar Trøyel Nerbø
Reporting Advisor
+47 992 39 817
Skype: nrc_troyel
www.nrc.no<http://www.nrc.no/>
[nrclogo]<http://www.nrc.no/>



From: Dhis2-devs 
[mailto:dhis2-devs-bounces+troyel.nerbo=nrc...@lists.launchpad.net] On Behalf 
Of jhansirk
Sent: mandag 13. mars 2017 12.56
To: DHIS 2 Developers list <dhis2-devs@lists.launchpad.net>
Cc: twmsf <tw...@thoughtworks.com>; Megan Mcguire 
<megan.mcgu...@newyork.msf.org>
Subject: [Dhis2-devs] Pivot table app for DHIS 2.23 is broken

Hello everyone,

We are currently on DHIS2 2.23 version. We have recently noticed some issues 
with the pivot table app. In Pivot table app, we see categories are undefined 
and report names are shown as empty strings. When we have looked into it, we 
noticed that the issue is with the newly built pivot table app artifact for 
DHIS 2.23.

Looks like the latest pivot table app is not compatible with DHIS 2.23. We see 
that pivot table app is a maven dependency. In maven repository, we see pivot 
table app for DHIS 2.23 is last built on Feb 7th and that is not compatible 
with DHIS 2.23. While building the DHIS 2.23 app, it is downloading the latest 
pivot table app artifact which is not compatible with DHIS 2.23. Hence, pivot 
table app has an issue with DHIS 2.23. We have verified the same in DHIS 2.25 
and it's not an issue with it.

Please let us know if you want more details.

Thanks,
Raghavendra/Jhansi

[cid:image004.png@01D29C09.A6A89330]
___
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] 500 error on PATCHing categoryOption on 2.23

[Trøyel Nerbø]

Hi all,
I'm trying to batch update my code field on categoryOptions through patching 
the individual UiD's on 
/api/categoryOptions/xxhDxyT8kCD.json?preheatCache=false .

My raw json payload only includes the UiD, name and (new) code field. The 
server log gives a preheat and reports success on update. Comparing the before 
and after json the only change happened to the categoryOption is the intended 
one. The only issue I can see on the log side is that the preheatCache is not 
disabled as intended.

The server log gives the following:
* INFO  2017-03-01 15:45:36,606 Building object-bridge maps (preheatCache: 
true, 6 classes). (DefaultObjectBridge.java [http-apr-8081-exec-9])
* INFO  2017-03-01 15:45:41,828 Building object-bridge maps took 5.21 seconds. 
(DefaultObjectBridge.java [http-apr-8081-exec-9])
* INFO  2017-03-01 15:45:42,548 'admin' update 
org.hisp.dhis.dataelement.DataElementCategoryOption, name: AFFM1302 (Norad 
Education GBV and ICLA), uid: VHqcQwn3cVW (AuditLogUtil.java 
[http-apr-8081-exec-9])

However in Postman I can see the this error:
HTTP Status 500 - Request processing failed; nested exception is 
org.hibernate.HibernateException: A collection with cascade="all-delete-orphan" 
was no longer referenced by the owning entity instance: 
org.hisp.dhis.dataelement.DataElementCategoryOption.attributeValues

type Exception report
message Request processing failed; nested exception is 
org.hibernate.HibernateException: A collection with cascade="all-delete-orphan" 
was no longer referenced by the owning entity instance: 
org.hisp.dhis.dataelement.DataElementCategoryOption.attributeValues
description The server encountered an internal error that prevented it from 
fulfilling this request.
exception
org.springframework.web.util.NestedServletException: Request processing failed; 
nested exception is org.hibernate.HibernateException: A collection with 
cascade="all-delete-orphan" was no longer referenced by the owning entity 
instance: org.hisp.dhis.dataelement.DataElementCategoryOption.attributeValues
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:980)


Since I see only the intended change in the catoption json I'm considering 
ignoring this error and running the update. But, before I do does anyone think 
this could lead to any problems down the line that I don't immediately see? The 
reason I am not using PUT is that I then have to re-send the sharing 
information (for that not to be removed in the process as it does in 2.23).

Thanks!

Running:
Version:
2.23
Build revision:
e5bfc4e
Build date:
2016-12-13 18:01



Best Regards
Halvar Trøyel Nerbø
Reporting Advisor
+47 992 39 817
Skype: nrc_troyel
www.nrc.no<http://www.nrc.no/>
[nrclogo]<http://www.nrc.no/>

___
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] Api PATCH request fail

[Trøyel Nerbø]

Dear devs,
Running 2.23 we're sertting up user provisioning through our SSO solution, Okta.
Trying to update using PATCH on user roles (and not having to first retrieve 
then re-post all values with only minor changes) does not seem to work and 
provides the following error:
type Exception report
message Request processing failed; nested exception is 
org.springframework.dao.InvalidDataAccessApiUsageException: object references 
an unsaved transient instance - save the transient instance before flushing: 
org.hisp.dhis.organisationunit.OrganisationUnit; nested exception is 
org.hibernate.TransientObjectException: object references an unsaved transient 
instance - save the transient instance before flushing: 
org.hisp.dhis.organisationunit.OrganisationUnit
description The server encountered an internal error that prevented it from 
fulfilling this request.
exception
org.springframework.web.util.NestedServletException: Request processing failed; 
nested exception is org.springframework.dao.InvalidDataAccessApiUsageException: 
object references an unsaved transient instance - save the transient instance 
before flushing: org.hisp.dhis.organisationunit.OrganisationUnit; nested 
exception is org.hibernate.TransientObjectException: object references an 
unsaved transient instance - save the transient instance before flushing: 
org.hisp.dhis.organisationunit.OrganisationUnit
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:980)
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:841)
  javax.servlet.http.HttpServlet.service(HttpServlet.java(...)

Any ideas if it is possible to solve this?

Thanks!

Best Regards
Halvar Trøyel Nerbø
Reporting Advisor
+47 992 39 817
Skype: nrc_troyel
www.nrc.no<http://www.nrc.no/>
[nrclogo]<http://www.nrc.no/>

___
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