dhis2-devs team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

Hi Jim,
Not sure what happened to the image, but its not really important.

My workaround was to basically to

1) Create a category option group set  with type attribute (I did not have
any)
2) Create the approval levels and approval workflow using that category
option group set through the UI.
3) Update the dataapproval table manually

UPDATE dataapprovallevel set categoryoptiongroupsetid = NULL;

4) Adjust the dataset to use the workflow I created. I had to do this with
SQL as well, as the UI did not work for me for some reason.

After all of that, it seems to work (for those who need a work around!)

Regards,
Jason


On Tue, Nov 1, 2016 at 8:07 PM, Jim Grace <jim@xxxxxxxxx> wrote:

> Hi Jason,
>
> Your image didn't come through; it was a broken link image.
>
> When I create or edit a dataset through the 2.25 UI, I can't find a place
> to select the workflow. (It was there in 2.23 and 2.24.) So I'm not sure
> what you mean by "added the workflow to the dataset which needs approval
> through the UI". But glad you got something working.
>
> Cheers,
> Jim
>
>
> On Tue, Nov 1, 2016 at 9:24 AM, Jason Pickering <
> jason.p.pickering@xxxxxxxxx> wrote:
>
>>
>> Hi Jim,
>>
>> ​I think i did that actually. Have a look at these three tables.
>>
>>
>> ​
>>
>> After making those adjustments, and clearing the application cache, i
>> went to data approvals, but nothing appeared there, even though I had added
>> the workflow to the dataset which needs approval through the UI. However,
>> after checking in the database, it seems the UI did nothing actually. After
>> adding the workflow via SQL, it seems to work.
>>
>> Seems like a series of bugs really, but I guess I did manage to find a
>> workaround.
>>
>> Regards,
>> Jason
>>
>>
>>
>>
>>
>> On Tue, Nov 1, 2016 at 12:52 PM, Jim Grace <jim@xxxxxxxxx> wrote:
>>
>>> Hi Jason,
>>>
>>> 1. After you patched dataapprovallevel.categoryoptiongroupsetid to NULL
>>> in the DB, subsequently could you view the approval level with no cat
>>> option combo in the edit approval level screen?
>>>
>>> 2. In order to approve a dataset, you need to create an approval
>>> workflow, assign one or more approval levels to it, and then assign the
>>> workflow to one or more datasets (the other bug I mentioned -- you may have
>>> to patch the workflowid column in the dataset record.)
>>>
>>> Cheers,
>>> Jim
>>>
>>>
>>> On Tue, Nov 1, 2016 at 8:40 AM, Jason Pickering <
>>> jason.p.pickering@xxxxxxxxx> wrote:
>>>
>>>> I tried that actually but could not get any data-sets to appear in the
>>>> approvals dialog.
>>>>
>>>> I even tried to create a "Default category option group set",
>>>> containing only the "default" category option, but that did not work
>>>> either.
>>>>
>>>> Neither hack worked.
>>>>
>>>> Unfortunately, we cannot go back to 2.24 at this point, but can wait
>>>> for this to be fixed to implement the approvals.
>>>>
>>>> Thanks for looking into it.
>>>>
>>>> Regards,
>>>> Jason
>>>>
>>>>
>>>> On Tue, Nov 1, 2016 at 12:31 PM, Jim Grace <jim@xxxxxxxxx> wrote:
>>>>
>>>>> Lars, should I create bug reports for these two 2.25 approvals-related
>>>>> problems?
>>>>>
>>>>> Jason, you could use 2.24, or you could try defining an approval level
>>>>> with a cat option group set, then find that record in the dataapprovallevel
>>>>> table and patch the categoryoptiongroupsetid column to null (and flush the
>>>>> hibernate cache.)
>>>>>
>>>>>
>>>>> On Tue, Nov 1, 2016 at 5:04 AM, Jason Pickering <
>>>>> jason.p.pickering@xxxxxxxxx> wrote:
>>>>>
>>>>>> Hi Jim and Lars,
>>>>>>
>>>>>> Has this been solved, or is there a workaround which I can use?
>>>>>>
>>>>>> Regards,
>>>>>> Jason
>>>>>>
>>>>>>
>>>>>> On Tue, Oct 25, 2016 at 12:59 PM, Jim Grace <jim@xxxxxxxxx> wrote:
>>>>>>
>>>>>>> I get the same results. In 2.24 and earlier I am able to save a new
>>>>>>> approval level with no category option group set. But 2.25 does not allow
>>>>>>> me to do so.
>>>>>>>
>>>>>>> Note that this is not related to the new category combination field
>>>>>>> that we will be adding to approval workflows in 2.26. This has always been
>>>>>>> an optional field for approval levels.
>>>>>>>
>>>>>>> Also in 2.25 when adding or updating a data set, there is no field
>>>>>>> for data approval workflow. It was there in 2.24.
>>>>>>>
>>>>>>>
>>>>>>> On Tue, Oct 25, 2016 at 2:03 AM, Jason Pickering <
>>>>>>> jason.p.pickering@xxxxxxxxx> wrote:
>>>>>>>
>>>>>>>> Hi Lars,
>>>>>>>>
>>>>>>>> Here is the info you asked for.
>>>>>>>>
>>>>>>>> Version:2.25Build revision:8e07d2fBuild date:2016-10-17 06:38
>>>>>>>>
>>>>>>>> Regards,
>>>>>>>> Jason
>>>>>>>>
>>>>>>>>
>>>>>>>> On Tue, Oct 25, 2016 at 4:58 AM, Lars Helge Øverland <
>>>>>>>> lars@xxxxxxxxx> wrote:
>>>>>>>>
>>>>>>>>> Hi Jason,
>>>>>>>>>
>>>>>>>>> could you tell us the exact build date for this WAR file?
>>>>>>>>>
>>>>>>>>> Could you also try again with the latest 2.25 WAR build?
>>>>>>>>>
>>>>>>>>> We have introduced this property "categoryOptionGroupSet" in
>>>>>>>>> master, but should not be there in 2.25.
>>>>>>>>>
>>>>>>>>> regards,
>>>>>>>>>
>>>>>>>>> Lars
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> On Sun, Oct 23, 2016 at 12:32 AM, Jason Pickering <
>>>>>>>>> jason.p.pickering@xxxxxxxxx> wrote:
>>>>>>>>>
>>>>>>>>>> I am trying to configure a workflow for population projections in
>>>>>>>>>> 2.25.
>>>>>>>>>> First, I created a new approval worfklow called "Population" with
>>>>>>>>>> a yearly frequency.
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> I  then created a new approval level in the UI like this
>>>>>>>>>>
>>>>>>>>>> [image: Inline image 1]
>>>>>>>>>>
>>>>>>>>>> We are not using and category options here. In the logs I see:
>>>>>>>>>>
>>>>>>>>>> * INFO  2016-10-23 06:27:23,519 (admin) Import:Start
>>>>>>>>>> (DefaultMetadataImportService.java [http-bio-127.0.0.1-8090-exec-
>>>>>>>>>> 4])
>>>>>>>>>> * INFO  2016-10-23 06:27:23,860 (admin) Import:Preheat[REFERENCE]
>>>>>>>>>> took 0.33 seconds (DefaultPreheatService.java [http-bio-127.0.0.1-8090-exec-
>>>>>>>>>> 4])
>>>>>>>>>> * INFO  2016-10-23 06:27:23,864 (admin) Import:Validation took
>>>>>>>>>> 0.00 seconds (DefaultObjectBundleValidationService.java
>>>>>>>>>> [http-bio-127.0.0.1-8090-exec-4])
>>>>>>>>>> * INFO  2016-10-23 06:27:23,890 (admin) Creating 1 object(s) of
>>>>>>>>>> type DataApprovalWorkflow (DefaultObjectBundleService.java
>>>>>>>>>> [http-bio-127.0.0.1-8090-exec-4])
>>>>>>>>>> * INFO  2016-10-23 06:27:24,067 (admin) Import:Commit took 0.20
>>>>>>>>>> seconds (DefaultMetadataImportService.java
>>>>>>>>>> [http-bio-127.0.0.1-8090-exec-4])
>>>>>>>>>> * INFO  2016-10-23 06:27:24,067 (admin) Import:Done took 0.55
>>>>>>>>>> seconds (DefaultMetadataImportService.java
>>>>>>>>>> [http-bio-127.0.0.1-8090-exec-4])
>>>>>>>>>> * INFO  2016-10-23 06:27:39,034 (admin) Import:Start
>>>>>>>>>> (DefaultMetadataImportService.java [http-bio-127.0.0.1-8090-exec-
>>>>>>>>>> 4])
>>>>>>>>>> * INFO  2016-10-23 06:27:40,309 (admin) Import:Preheat[REFERENCE]
>>>>>>>>>> took 1.27 seconds (DefaultPreheatService.java [http-bio-127.0.0.1-8090-exec-
>>>>>>>>>> 4])
>>>>>>>>>> * INFO  2016-10-23 06:27:40,314 (admin) Import:Validation took
>>>>>>>>>> 0.00 seconds (DefaultObjectBundleValidationService.java
>>>>>>>>>> [http-bio-127.0.0.1-8090-exec-4])
>>>>>>>>>> * INFO  2016-10-23 06:27:40,314 (admin) Import:Done took 1.28
>>>>>>>>>> seconds (DefaultMetadataImportService.java
>>>>>>>>>> [http-bio-127.0.0.1-8090-exec-4])
>>>>>>>>>>
>>>>>>>>>> which seems to be OK, but in the UI, I get a message that
>>>>>>>>>> creation of the approval level failed and in the JS console I see
>>>>>>>>>>
>>>>>>>>>> {"httpStatus":"Conflict","httpStatusCode":409,"status":"WARNING","message":"One
>>>>>>>>>> more more errors occurred, please see full details in import
>>>>>>>>>> report.","response":{"responseType":"ObjectReport","uid":"AD
>>>>>>>>>> Od9xfvDjH","klass":"org.hisp.dhis.dataapproval.DataApprovalL
>>>>>>>>>> evel","errorReports":[{"message":"Missing required property
>>>>>>>>>> `categoryOptionGroupSet`.","mainKlass":"org.hisp.dhis.dataap
>>>>>>>>>> proval.DataApprovalLevel","errorKlass":"org.hisp.dhis.datael
>>>>>>>>>> ement.CategoryOptionGroupSet","errorCode":"E4000"}]}}
>>>>>>>>>>
>>>>>>>>>> So, I guess the question is, how do I configure a data approval
>>>>>>>>>> workflow with no category option group?
>>>>>>>>>>
>>>>>>>>>> Regards,
>>>>>>>>>> Jason
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> --
>>>>>>>>>> Jason P. Pickering
>>>>>>>>>> email: jason.p.pickering@xxxxxxxxx
>>>>>>>>>> tel:+46764147049
>>>>>>>>>>
>>>>>>>>>> _______________________________________________
>>>>>>>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>>>>>>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>>>>>>>>> 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
>>>>>>>>> lars@xxxxxxxxx
>>>>>>>>> http://www.dhis2.org <https://www.dhis2.org/>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> --
>>>>>>>> Jason P. Pickering
>>>>>>>> email: jason.p.pickering@xxxxxxxxx
>>>>>>>> tel:+46764147049
>>>>>>>>
>>>>>>>> _______________________________________________
>>>>>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>>>>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>>>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> Jim Grace
>>>>>>> Core developer, DHIS 2
>>>>>>> HISP US Inc.
>>>>>>> http://www.dhis2.org <https://www.dhis2.org/>
>>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Jason P. Pickering
>>>>>> email: jason.p.pickering@xxxxxxxxx
>>>>>> tel:+46764147049
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Jim Grace
>>>>> Core developer, DHIS 2
>>>>> HISP US Inc.
>>>>> http://www.dhis2.org <https://www.dhis2.org/>
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Jason P. Pickering
>>>> email: jason.p.pickering@xxxxxxxxx
>>>> tel:+46764147049
>>>>
>>>
>>>
>>>
>>> --
>>> Jim Grace
>>> Core developer, DHIS 2
>>> HISP US Inc.
>>> http://www.dhis2.org <https://www.dhis2.org/>
>>>
>>
>>
>>
>> --
>> Jason P. Pickering
>> email: jason.p.pickering@xxxxxxxxx
>> tel:+46764147049
>>
>
>
>
> --
> Jim Grace
> Core developer, DHIS 2
> HISP US Inc.
> http://www.dhis2.org <https://www.dhis2.org/>
>



-- 
Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx
tel:+46764147049