Re: [Dhis2-devs] Deletion of Program and all associated objects via API v 2.25

[Lorill Crees]

Hi,

Further to this, for some of our programs we are unable to delete
programdataelements via the Web API due to the following error:

ERROR: update or delete on table "programdataelement" violates foreign key
constraint "fk_datadimensionitem_programdataelementid" on table
"datadimensionitem" Detail: Key (programdataelementid)=(541878) is still
referenced from table "datadimensionitem".

What do I need to do to be able to delete these programdataelements? I have
already deleted all the events and tracked entity instances prior to
deleting programdataelements. I have even tried rerunning analytics prior
to deleting.

Please let me know. Thanks,

Lorill

On Fri, May 26, 2017 at 2:33 PM, Lorill Crees  wrote:

> Hi,
>
> We have been working on functionality to delete full Programs and all
> associated data and metadata via the Web API using:
>
> Version:
> 2.25
> Build revision:
> ee7e61b
> Build date:
> 2017-05-19 12:47
>
> The instance being used is assuming that attributes and data elements are
> specific to a particular program/program stage and will not be reused
> across programs.
>
> I wanted to check to see if there are any other objects we need to worry
> about for deletion that we may be missing.
>
> This is our methodology in order of execution, all via the Web API:
>
>1. Delete Program and Program Stage Data
>   1. delete all program stage events
>   2. delete all tracked entity instances
>2. Delete Program and Program Stage Metadata
>   1. delete all related program indicators
>   2. delete all related program rules
>   3. delete all related program rule variables (I'm not sure why
>   these aren't deleted automatically via the program rule deletion)
>   4. delete programDataElements (is it correct that these are
>   generated by analytics?)
>   5. delete all related indicators for programStage data elements
>   6. delete underlying data elements
>   7. delete related option sets and related options
>   8. delete programTrackedEntityAttributes
>   9. delete related trackedEntityAttributes
>   10. delete related option sets and related options
>3. Delete Program and Program Stages
>   1. delete program stages
>   2. unassign program from all user roles (we note that the dataset
>   deletion API call takes care of this step but the program deletion API 
> call
>   doesn't and throws an error if we miss this step)
>   3. delete program
>
> I see some things in the program payload such as:
>
>- "notificationTemplates": [],
>- "translations": [],
>- "userGroupAccesses": [],
>- "attributeValues": [],
>- "validationCriterias": [],
>
> Do any of these need to be explicitly deleted in order to delete a program
> or will they cascade? Are there any other associated objects I haven't
> mentioned that we need to delete? So far we've been implementing on a trial
> and error basis.
>
> Please let me know if there are any other considerations we should be
> incorporating into our logic.
>
> Thanks,
>
> Lorill
> --
> Lorill Crees
> Project Leader / Senior Developer
> 2Paths Solutions Ltd. 
>
> lcr...@2paths.com
> skype: lorill2paths
> (604) 689-4123 x 15 <(604)%20689-4123>
>



-- 
Lorill Crees
Project Leader / Senior Developer
2Paths Solutions Ltd. 

lcr...@2paths.com
skype: lorill2paths
(604) 689-4123 x 15
___
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] Error Message on Log

[Lars Helge Øverland]

Yep should have been debug, was an oversight.

Lars



On Mon, May 29, 2017 at 6:52 PM, Jasper Timm  wrote:

> Maybe someone should change the logging level from 'Error' to 'Info' for
> the message then?
>
> On Mon, May 29, 2017 at 12:34 PM, gerald thomas 
> wrote:
>
>> Noted Lars!!!
>>
>> Thanks
>>
>> On 5/29/17, Lars Helge Øverland  wrote:
>> > Hi Gerald,
>> >
>> > this is normal and is an internal system log message related to database
>> > connections - nothing to worry about.
>> >
>> > regards,
>> >
>> > Lars
>> >
>> >
>> > On Mon, May 29, 2017 at 1:51 PM, gerald thomas 
>> > wrote:
>> >
>> >> Dear All,
>> >>
>> >> I am having the following errors:
>> >>
>> >> * ERROR 2017-05-29 00:46:10,458 Initialised statement manager
>> >> (StatementInterceptor.java [tomcat-http-191])
>> >> * ERROR 2017-05-29 00:46:15,648 Initialised statement manager
>> >> (StatementInterceptor.java [tomcat-http-191])
>> >> * ERROR 2017-05-29 00:46:42,437 Initialised statement manager
>> >> (StatementInterceptor.java [tomcat-http-187])
>> >> * ERROR 2017-05-29 00:46:47,430 Initialised statement manager
>> >> (StatementInterceptor.java [tomcat-http-152])
>> >>
>> >> Any idea what is it means?
>> >>
>> >> --
>> >> Regards,
>> >>
>> >> Gerald
>> >>
>> >> ___
>> >> 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
>> >>
>> >
>> >
>> >
>> > --
>> > Lars Helge Øverland
>> > Lead developer, DHIS 2
>> > University of Oslo
>> > Skype: larshelgeoverland
>> > l...@dhis2.org
>> > http://www.dhis2.org 
>> >
>>
>>
>> --
>> 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
>>
>
>


-- 
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
l...@dhis2.org
http://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

Re: [Dhis2-devs] [Dhis2-users] Error Message on Log

[Jasper Timm]

Maybe someone should change the logging level from 'Error' to 'Info' for
the message then?

On Mon, May 29, 2017 at 12:34 PM, gerald thomas 
wrote:

> Noted Lars!!!
>
> Thanks
>
> On 5/29/17, Lars Helge Øverland  wrote:
> > Hi Gerald,
> >
> > this is normal and is an internal system log message related to database
> > connections - nothing to worry about.
> >
> > regards,
> >
> > Lars
> >
> >
> > On Mon, May 29, 2017 at 1:51 PM, gerald thomas 
> > wrote:
> >
> >> Dear All,
> >>
> >> I am having the following errors:
> >>
> >> * ERROR 2017-05-29 00:46:10,458 Initialised statement manager
> >> (StatementInterceptor.java [tomcat-http-191])
> >> * ERROR 2017-05-29 00:46:15,648 Initialised statement manager
> >> (StatementInterceptor.java [tomcat-http-191])
> >> * ERROR 2017-05-29 00:46:42,437 Initialised statement manager
> >> (StatementInterceptor.java [tomcat-http-187])
> >> * ERROR 2017-05-29 00:46:47,430 Initialised statement manager
> >> (StatementInterceptor.java [tomcat-http-152])
> >>
> >> Any idea what is it means?
> >>
> >> --
> >> Regards,
> >>
> >> Gerald
> >>
> >> ___
> >> 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
> >>
> >
> >
> >
> > --
> > Lars Helge Øverland
> > Lead developer, DHIS 2
> > University of Oslo
> > Skype: larshelgeoverland
> > l...@dhis2.org
> > http://www.dhis2.org 
> >
>
>
> --
> 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] Troubleshoot CSV data value import on ignored rows

[Lars Helge Øverland]

Hi Trøyel,

okay - could you post the actual feedback you get from the API / UI ?

best,

Lars

On Mon, May 29, 2017 at 6:36 PM, Trøyel Nerbø  wrote:

> 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 <992%2039%20817>
>
> Skype: nrc_troyel
> www.nrc.no
>
> [image: nrclogo] 
>
>
>
>
>
> ___
> 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
>
>


-- 
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
l...@dhis2.org
http://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] 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
[nrclogo]


___
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] Default CategoryOptionCombo

[George Gelaga-King]

Hello Everyone,

I want to use the default category option combo when submitting data value sets 
for some data values. I’ve noticed that if the user thats submitting these 
values does not have the “ALL” permission specified in their user roles they 
get the error message "Category option combo not found or not accessible” and 
the data values with the default category option combos aren’t updated/created. 
Previously we left the category option combos blank for the data values that 
used default but we don’t want this to be the case anymore as we’ve had issues 
when the default category option combo was changed.

In short:
How do you use the default category option combo when submitting data values 
without giving the user role the “ALL” authority?

Thanks,
George.
___
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] develop version: can't edit organization level name

[Knut Staring]

https://jira.dhis2.org/browse/DHIS2-1758?filter=10108

On Mon, May 29, 2017 at 6:02 PM, Knut Staring  wrote:

> Thanks for reporting, Easy.
>
> The online instance seems to have the same problem:
> https://play.dhis2.org/dev/dhis-web-maintenance/#/list/
> organisationUnitSection/organisationUnitLevel
>
> On Mon, May 29, 2017 at 5:30 PM, 林晓东  wrote:
>
>>
>> when I edit the level name( edit default name such as "Level 1" ) ,
>>  infer:
>>
>>
>> --
>> --
>> This field requires a unique value
>>
>> can't update then name.
>>
>> --
>> 此致
>>
>> easy
>>
>> 莫愁前路无知己，天下谁人不识君。
>>
>>
>>
>>
>> ___
>> 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 <+47%20918%2080%20522>
> Skype: knutstar
> http://dhis2.org
>



-- 
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] develop version: can't edit organization level name

[林晓东]

when I edit the level name( edit default name such as "Level 1" ) ,  infer:




This field requires a unique value


can't update then name.


--

此致

easy

莫愁前路无知己，天下谁人不识君。___
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] Error Message on Log

[gerald thomas]

Noted Lars!!!

Thanks

On 5/29/17, Lars Helge Øverland  wrote:
> Hi Gerald,
>
> this is normal and is an internal system log message related to database
> connections - nothing to worry about.
>
> regards,
>
> Lars
>
>
> On Mon, May 29, 2017 at 1:51 PM, gerald thomas 
> wrote:
>
>> Dear All,
>>
>> I am having the following errors:
>>
>> * ERROR 2017-05-29 00:46:10,458 Initialised statement manager
>> (StatementInterceptor.java [tomcat-http-191])
>> * ERROR 2017-05-29 00:46:15,648 Initialised statement manager
>> (StatementInterceptor.java [tomcat-http-191])
>> * ERROR 2017-05-29 00:46:42,437 Initialised statement manager
>> (StatementInterceptor.java [tomcat-http-187])
>> * ERROR 2017-05-29 00:46:47,430 Initialised statement manager
>> (StatementInterceptor.java [tomcat-http-152])
>>
>> Any idea what is it means?
>>
>> --
>> Regards,
>>
>> Gerald
>>
>> ___
>> 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
>>
>
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> l...@dhis2.org
> http://www.dhis2.org 
>


-- 
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

Re: [Dhis2-devs] [Dhis2-users] Error Message on Log

[Lars Helge Øverland]

Hi Gerald,

this is normal and is an internal system log message related to database
connections - nothing to worry about.

regards,

Lars


On Mon, May 29, 2017 at 1:51 PM, gerald thomas 
wrote:

> Dear All,
>
> I am having the following errors:
>
> * ERROR 2017-05-29 00:46:10,458 Initialised statement manager
> (StatementInterceptor.java [tomcat-http-191])
> * ERROR 2017-05-29 00:46:15,648 Initialised statement manager
> (StatementInterceptor.java [tomcat-http-191])
> * ERROR 2017-05-29 00:46:42,437 Initialised statement manager
> (StatementInterceptor.java [tomcat-http-187])
> * ERROR 2017-05-29 00:46:47,430 Initialised statement manager
> (StatementInterceptor.java [tomcat-http-152])
>
> Any idea what is it means?
>
> --
> Regards,
>
> Gerald
>
> ___
> 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
>



-- 
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
l...@dhis2.org
http://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] Error Message on Log

[gerald thomas]

Dear All,

I am having the following errors:

* ERROR 2017-05-29 00:46:10,458 Initialised statement manager
(StatementInterceptor.java [tomcat-http-191])
* ERROR 2017-05-29 00:46:15,648 Initialised statement manager
(StatementInterceptor.java [tomcat-http-191])
* ERROR 2017-05-29 00:46:42,437 Initialised statement manager
(StatementInterceptor.java [tomcat-http-187])
* ERROR 2017-05-29 00:46:47,430 Initialised statement manager
(StatementInterceptor.java [tomcat-http-152])

Any idea what is it means?

-- 
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