Got it. I’ve created two new bug reports for these problems:
···
On Wed, Nov 2, 2016 at 2:59 AM, Jason Pickering jason.p.pickering@gmail.com wrote:
Hi Jim,
Not sure what happened to the image, but its not really important.
My workaround was to basically to
- Create a category option group set with type attribute (I did not have any)
- Create the approval levels and approval workflow using that category option group set through the UI.
- Update the dataapproval table manually
UPDATE dataapprovallevel set categoryoptiongroupsetid = NULL;
- 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@dhis2.org 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
–
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049
On Tue, Nov 1, 2016 at 9:24 AM, Jason Pickering jason.p.pickering@gmail.com wrote:
Hi Jim,
I think i did that actually. Have a look at these three tables.
–
Jim Grace
Core developer, DHIS 2
HISP US Inc.
http://www.dhis2.org
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@dhis2.org wrote:
Hi Jason,
- 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?
- 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
–
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049
On Tue, Nov 1, 2016 at 8:40 AM, Jason Pickering jason.p.pickering@gmail.com 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
–
Jim Grace
Core developer, DHIS 2
HISP US Inc.
http://www.dhis2.org
On Tue, Nov 1, 2016 at 12:31 PM, Jim Grace jim@dhis2.org 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.)
–
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049
On Tue, Nov 1, 2016 at 5:04 AM, Jason Pickering jason.p.pickering@gmail.com wrote:
Hi Jim and Lars,
Has this been solved, or is there a workaround which I can use?
Regards,
Jason
–
Jim Grace
Core developer, DHIS 2
HISP US Inc.
http://www.dhis2.org
On Tue, Oct 25, 2016 at 12:59 PM, Jim Grace jim@dhis2.org 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.
–
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049
On Tue, Oct 25, 2016 at 2:03 AM, Jason Pickering jason.p.pickering@gmail.com wrote:
Hi Lars,
Here is the info you asked for.
Version:
2.25
Build revision:
8e07d2f
Build date:
2016-10-17 06:38
Regards,
Jason
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
–
Jim Grace
Core developer, DHIS 2
HISP US Inc.
http://www.dhis2.org
On Tue, Oct 25, 2016 at 4:58 AM, Lars Helge Øverland lars@dhis2.org 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
–
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049
On Sun, Oct 23, 2016 at 12:32 AM, Jason Pickering jason.p.pickering@gmail.com 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
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”:“ADOd9xfvDjH”,“klass”:“org.hisp.dhis.dataapproval.DataApprovalLevel”,“errorReports”:[{“message”:“Missing required property categoryOptionGroupSet
.”,“mainKlass”:“org.hisp.dhis.dataapproval.DataApprovalLevel”,“errorKlass”:“org.hisp.dhis.dataelement.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@gmail.com
tel:+46764147049
–
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
lars@dhis2.org
http://www.dhis2.org
–
Jim Grace
Core developer, DHIS 2
HISP US Inc.
http://www.dhis2.org