Re: [Dhis2-users] dhis version 2.30 is released

2018-09-27 Thread Ifeanyi Okoye 
Dear Viet,We have encountered this issue and I had reported this and got no 
response.
The thing is that for us, the default category option is not used on any of 
these data sets that are encountering this issue. Also, we did not have this 
issue until we upgraded to the latest build of 2.29 on Friday and right now, 
none of our teams can enter any data. 
So, what changed between the updates from the previous version to the latest?
Secondly, why is a category option that is not used in any dataset affecting 
data entry on that dataset?
Thanks

Warm Regards, 

Ifeanyi

Read DrMaestro's Blog
www.ifeanyiokoye.com
 

On Thursday, September 27, 2018, 8:48:23 AM GMT+1, Viet Nguyen 
 wrote:  
 
 Hi Alejandro,
That's a bug, the default category option should be shared by default. I have 
just added a fix for that issue. It will be included in the latest build by 
tomorrow. 
Regards,
On Thu, Sep 27, 2018 at 12:32 AM Alejandro  wrote:

Hi,
We have had the same issue when upgrading from 2.28 to 2.30. When trying to 
enter data in a Tracker Program with all the capture sharings configured for 
the user (Tracked Entity Type, Program, Stages) we got the following message:
{httpStatus: "Conflict", httpStatusCode: 409, status: "ERROR",…}httpStatus: 
"Conflict"httpStatusCode: 409message: "An error occurred, please check import 
summary."response: {responseType: "ImportSummary", status: 
"ERROR",…}description: "[User has no write access to category option: 
rHGSHuG4Ts5]"importCount: {imported: 0, updated: 0, ignored: 1, deleted: 
0}responseType: "ImportSummary"status: "ERROR"status: "ERROR"
The category option rHGSHuG4Ts5 in our system is the system default one (i.e. 
when category option = none):
default
And this category option is not displayed in the UI (we cannot give it the 
Data->Can view or Data->Can capture options). How can we set those permissions 
for the system default category option? Should not this be granted by default?
Thank you in advance!Alejandro


On Tue, Jul 24, 2018 at 8:00 PM Eudson Bambo 
 wrote:

Dear Blake,
It worked. Many thanks.
Adolphe and Viet, I saw your emails also - thank you.
Eudson 

On 23 Jul 2018, at 8:54 PM, Eudson Bambo  
wrote:
Dear Blake,
Thanks for your response, I will have a look at the documentation and give the 
permissions to the users.
Many thanks.Eudson Bambo

On 23 Jul 2018, at 12:15 PM, Blake Hansen  wrote:
Dear Eudson,
What was your DHIS2 version prior to upgrade? It seems like you are 
encountering the change in data entry sharing that occurred from 2.29. Whereas 
previously the ability for data entry was conferred specifically through the 
‘data sets’ and ‘programs’ user roles, this is now done through ‘data’ sharing 
levels. Additionally, the sharing also impacts category options. You can see 
the DHIS2 documentation on this here: 
https://www.dhis2.org/spotlight#datalevelsharing2 - scroll down to the Data 
Level Sharing: Category Options and Data Sets video. 
The route for fixing would seem to be giving your users who enter data the 
sharing level ‘can capture data’. This would mean either conferring this 
ability publicly on your category options, or adding these users to a specific 
user group and giving the capture permission to that user group.
Trust this is a helpful start (and hopefully finish),Blake
-- 



Blake Hansen
Projects Implementation Manager, BAO Systems+1 202-536-1541 | 
bhan...@baosystems.com | http://www.baosystems.com |Skype: blake.a.hansen | 
2900 K Street, Suite 507, Washington D.C. 20007

On 23 Jul 2018, at 11:08, Eudson Bambo  
wrote:
Thanks Lars and Team.
This really great, DHIS2 is getting better and better.
So sorry for sending this on this thread but the problem is related to this 
version.
Last week my team (infrastructure) decided to update our DHIS2 instance to this 
version (2.30) and since then all non-superuser users are having problems 
entering data, everyone is getting the follow error message: User has no data 
write access for CategoryOption
I tried to check on the user roles and category options to see if I could 
give/enable that permission to the non-superuser users but no luck so far.
Your help will be most appreciated.
Kind Regards,Eudson bambo
On 12 Jul 2018, at 1:43 PM, Lars Helge Øverland  wrote:

Hi all,
DHIS version 2.30 is out with many new features, apps and improvements.
Login with admin/district on the demo system.

ANALYTICS FEATURES---
Linkable dashboards: Individual dashboards can now be linked to through the 
URL. This makes it easier to share dashboards through email and chats.
Screenshot | Demo

Mentions in interpretations and comments: You can now mention users in 
interpretations and comments by using @. Users who are mentioned will receive a 
notification in the messaging app. Notifications over email and SMS can also be 
enabled through user settings. Interpretations can be written from the 
right-side panel.
Screenshot | Demo

Subscribe to analytics items:  You can now subscribe to analytics items.

Re: [Dhis2-users] Default category option limiting data entry cross all datasets in 2.29

2018-09-26 Thread Ifeanyi Okoye 
Dear All,Could anyone please provide us some help on this issue?
Thank you.

Warm Regards, 

Ifeanyi

Read DrMaestro's Blog
www.ifeanyiokoye.com
 

On Tuesday, September 25, 2018, 8:01:55 AM GMT+1, Ifeanyi Okoye 
 wrote:  
 
 Hello everyone,
We upgraded to the most recent build of 2.29 last Friday, Build revision: 
1797422.
We noticed yesterday that data entry across ALL our datasets throws up this 
error
[User has no data write access for CategoryOption: Ae5U0j6hHD7]


We checked in the API and the category option that has the code above is 
default and this option is not used on any of our datasets and also does not 
show up on the list of category option so that we could modify its sharing 
settings.
Some help with this would be most appreciated.
Thank you.

Warm Regards, 

Ifeanyi

Read DrMaestro's Blog
www.ifeanyiokoye.com
  ___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] Default category option limiting data entry cross all datasets in 2.29

2018-09-25 Thread Ifeanyi Okoye 
Hello everyone,
We upgraded to the most recent build of 2.29 last Friday, Build revision: 
1797422.
We noticed yesterday that data entry across ALL our datasets throws up this 
error
[User has no data write access for CategoryOption: Ae5U0j6hHD7]


We checked in the API and the category option that has the code above is 
default and this option is not used on any of our datasets and also does not 
show up on the list of category option so that we could modify its sharing 
settings.
Some help with this would be most appreciated.
Thank you.

Warm Regards, 

Ifeanyi

Read DrMaestro's Blog
www.ifeanyiokoye.com
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Metadata Import not Working for 2.29

2018-09-22 Thread Ifeanyi Okoye 
Hi Morten,Was this response for me? I didn’t mention anything about a value 
type. We were trying to do a metadata import. 


Regards,
Ifeanyi

On Saturday, September 22, 2018, 07:55, Morten Olav Hansen  
wrote:

Hi
There is no ValueType called SUM, maybe you are thinking about AggregationType 
column?
-- Morten Olav HansenSenior Engineer, DHIS 2Team Integration LeadUniversity of 
Oslohttp://www.dhis2.org


On Fri, Sep 21, 2018 at 11:59 PM Ifeanyi Okoye  wrote:

Dear All,
We are DHIS 2.29 Build revision: 1797422
We tried to do some metadata import using CSV for data elements and it would 
not run. There is no error or activity on the console but in the logs this is 
what we see
* ERROR 2018-09-21 08:03:50,012 Unexpected error occurred in scheduled task. 
(TaskUtils.java [taskScheduler-23])java.lang.IllegalArgumentException: No enum 
constant org.hisp.dhis.common.ValueType.Sum at 
java.lang.Enum.valueOf(Enum.java:238) at 
org.hisp.dhis.common.ValueType.valueOf(ValueType.java:46) at 
org.hisp.dhis.dxf2.csv.DefaultCsvImportService.dataElementsFromCsv(DefaultCsvImportService.java:321)
 at 
org.hisp.dhis.dxf2.csv.DefaultCsvImportService.fromCsv(DefaultCsvImportService.java:115)
 at 
org.hisp.dhis.importexport.action.util.ImportMetaDataCsvTask.call(ImportMetaDataCsvTask.java:87)
 at 
org.hisp.dhis.security.SecurityContextRunnable.run(SecurityContextRunnable.java:57)
 at 
org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
 at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at 
java.util.concurrent.FutureTask.run(FutureTask.java:266) at 
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
 at 
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
 at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) 
at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) 
at java.lang.Thread.run(Thread.java:745)
Can anybody help out with this?
Thank you.


Warm Regards, 

Ifeanyi

Read DrMaestro's Blog
www.ifeanyiokoye.com
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to     : dhis2-d...@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp




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

[Dhis2-users] Metadata Import not Working for 2.29

2018-09-21 Thread Ifeanyi Okoye 
Dear All,
We are DHIS 2.29 Build revision: 1797422
We tried to do some metadata import using CSV for data elements and it would 
not run. There is no error or activity on the console but in the logs this is 
what we see
* ERROR 2018-09-21 08:03:50,012 Unexpected error occurred in scheduled task. 
(TaskUtils.java [taskScheduler-23])java.lang.IllegalArgumentException: No enum 
constant org.hisp.dhis.common.ValueType.Sum at 
java.lang.Enum.valueOf(Enum.java:238) at 
org.hisp.dhis.common.ValueType.valueOf(ValueType.java:46) at 
org.hisp.dhis.dxf2.csv.DefaultCsvImportService.dataElementsFromCsv(DefaultCsvImportService.java:321)
 at 
org.hisp.dhis.dxf2.csv.DefaultCsvImportService.fromCsv(DefaultCsvImportService.java:115)
 at 
org.hisp.dhis.importexport.action.util.ImportMetaDataCsvTask.call(ImportMetaDataCsvTask.java:87)
 at 
org.hisp.dhis.security.SecurityContextRunnable.run(SecurityContextRunnable.java:57)
 at 
org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
 at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at 
java.util.concurrent.FutureTask.run(FutureTask.java:266) at 
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
 at 
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
 at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) 
at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) 
at java.lang.Thread.run(Thread.java:745)
Can anybody help out with this?
Thank you.


Warm Regards, 

Ifeanyi

Read DrMaestro's Blog
www.ifeanyiokoye.com
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] Error in DHIS2.29: File Resource Clean Up Failed

2018-07-26 Thread Ifeanyi Okoye 
Dear All,After our upgrade last week to 2.29, I started getting this system 
notification and not sure what it means.Could anybody please help with this.

Job 'File resource clean up' failed

System title: 
Base URL: null
Time: 2018-07-26T02:00:00.015+01:00
Message: could not execute statement; SQL [n/a]; constraint 
[fk_document_fileresourceid]; nested exception is 
org.hibernate.exception.ConstraintViolationException: could not execute 
statement

Cause: org.hibernate.exception.ConstraintViolationException: could not execute 
statement
at 
org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:112)
at 
org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
at 
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
at 
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)
at 
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:178)
at 
org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:45)
at 
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:3325)
at 
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:3562)
at 
org.hibernate.action.internal.EntityDeleteAction.execute(EntityDeleteAction.java:99)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:589)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:463)
at 
org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:337)
at 
org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39)
at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1437)
at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:493)
at 
org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3207)
at 
org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2413)
at 
org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:467)
at 
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:156)
at 
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$100(JdbcResourceLocalTransactionCoordinatorImpl.java:38)
at 
org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:231)
at 
org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:68)
at 
org.springframework.orm.hibernate5.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:582)
at 
org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:761)
at 
org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:730)
at 
org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:518)
at 
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:292)
at 
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at 
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
at com.sun.proxy.$Proxy132.deleteFileResource(Unknown Source)
at 
org.hisp.dhis.fileresource.FileResourceCleanUpJob.lambda$execute$0(FileResourceCleanUpJob.java:97)
at java.util.ArrayList.forEach(ArrayList.java:1249)
at 
org.hisp.dhis.fileresource.FileResourceCleanUpJob.execute(FileResourceCleanUpJob.java:95)
at 
org.hisp.dhis.scheduling.DefaultJobInstance.executeJob(DefaultJobInstance.java:145)
at 
org.hisp.dhis.scheduling.DefaultJobInstance.execute(DefaultJobInstance.java:67)
at 
org.hisp.dhis.scheduling.DefaultSchedulingManager.lambda$scheduleJob$1(DefaultSchedulingManager.java:158)
at 
org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
at 
org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:81)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at 
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
at

Re: [Dhis2-users] Tracker Program Not Enrolling

2018-06-27 Thread Ifeanyi Okoye 
Dear All,Just an update on this:
Here are the console scripts of the errors
angular.js:9866 GET 
https://localhost/instancename/api/28/trackedEntityInstances/query.json?ou=uiRXJAdUmTP=SELECTED=created:desc=IJcGR8cZ5mq=50=1=true
 409 (Conflict)
angular.js:9866 GET 
https://localhost/instancename/api/28/userDataStore/trackerCaptureGridColumns/IJcGR8cZ5mq
 404 (Not Found)

angular.js:11655 TypeError: Cannot read property 'id' of undefined    at 
services.js:1064    at Object.r [as forEach] (angular.js:323)    at 
services.js:1063    at angular.js:13248    at n.$eval (angular.js:14466)    at 
n.$digest (angular.js:14282)    at n.$apply (angular.js:14571)    at 
dhis2.storage.IndexedDBAdapter. (services.js:998)    at fire 
(jquery.js:3317)    at Object.fireWith [as resolveWith] (jquery.js:3447)
angular.js:9866 GET 
https://localhost/instancename/api/28/trackedEntityInstances/count.json?ou=uiRXJAdUmTP=ACCESSIBLE=jUchlhUq5kv=qahfVJQbG9x:LIKE:A12347=WFrSyy55iy6:LIKE:Doe=1=1=true
 409 (Conflict)

angular.js:9866 POST 
https://localhost/instancename/api/28/trackedEntityInstances 409 
(Conflict)(anonymous) @ angular.js:9866n @ angular.js:9667f @ 
angular.js:9383(anonymous) @ angular.js:13248$eval @ angular.js:14466$digest @ 
angular.js:14282$apply @ angular.js:14571(anonymous) @ angular.js:21571dispatch 
@ jquery.js:5206elemData.handle @ jquery.js:5014angular.js:11655 TypeError: 
Cannot read property 'responseType' of undefined    at 
registration-controller.js:423    at angular.js:13248    at n.$eval 
(angular.js:14466)    at n.$digest (angular.js:14282)    at n.$apply 
(angular.js:14571)    at l (angular.js:9698)    at M (angular.js:9888)    at 
XMLHttpRequest.F.onload (angular.js:9829)
Kindly help with some guidance.
thank you 

Warm Regards, 

Ifeanyi

Read DrMaestro's Blog
www.ifeanyiokoye.com
 

On Wednesday, June 27, 2018, 10:07:24 AM GMT+1, Ifeanyi Okoye 
 wrote:  
 
 Dear Devs,I created a new instance of DHIS2 running 2.29 to test the new 
features in the tracker program. I created a program and started client 
enrollments. I then updated the WAR file to the latest 2.29 WAR and then tried 
to create another Program.
My new program gets stuck on the enrollment page and just shows a loop going 
round. I thought it was an issue with the setup of the Program.
I then tried to use the previous program and it is also stuck on the 
registration page and does not proceed to enter the event details.
I tried to create a JIRA ticket for this and it kept saying that one of the 
components I entered was not allowed and I could not figure out what it was.
Is anybody else experiencing this issue?

Warm Regards, 

Ifeanyi

Read DrMaestro's Blog
www.ifeanyiokoye.com
  ___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] Access to Demo Site

2018-04-18 Thread Ifeanyi Okoye 
Hello Everyone,I have been trying to access the DHIS2 demo site but it keeps 
saying wrong user name or password.
Anyone else having this issue?

Warm Regards, 

Ifeanyi

Read DrMaestro's Blog
www.ifeanyiokoye.com
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] Removing min-max values

2017-12-05 Thread Ifeanyi Okoye 
Dear All,Just want to find out if the removing min-max values actually still 
works?
We have quite a number of users who cannot complete their forms because of 
min-max values. They have the rights in their user roles to remove them and 
save.
Also, we have tried to remove them centrally for all the datasets but it's 
making no difference at all.
Can anyone look at this?

Warm Regards, 

Ifeanyi

Read DrMaestro's Blog
www.ifeanyiokoye.com
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Update Category option combination

2017-11-30 Thread Ifeanyi Okoye 
Dear All,I have attached a screenshot showing what I had been trying to 
describe. Normally, the catcombo name does not show as part of the data element 
name in the dataset window, but in this case, it is showing up. However, in 
this case, this data element no longer has the catcombo associated with it. We 
had changed it when we were experiencing some difficulty with some of the items 
showing up on the form designer. However, the changes did not take effect until 
we had to remove this from the dataset and then add it back again.
Not sure what is causing this though...

Warm Regards, 

Ifeanyi

Read DrMaestro's Blog
www.ifeanyiokoye.com
 

On Wednesday, November 29, 2017, 8:02:48 AM GMT+1, Ifeanyi Okoye 
<ifeanyiok...@yahoo.com> wrote:  
 
 Dear Djibril,I actually don't think the issues are different. In our own case, 
we renamed category options but when you get to the form designer, what is 
showing up is the old name. Running maintenance did not help. Running data 
integrity showed that the changes made to some of the category option 
combinations did not take effect and we had to recreate all the ones that did 
not take effect.However, it wasn't until we removed the data element that had 
the category option combo (that wasn't changing) from the dataset, and then 
added it back, did the changes take effect. Not sure why this is happening, but 
give it a try and see what happens.

Warm Regards, 

Ifeanyi

Read DrMaestro's Blog
www.ifeanyiokoye.com
 

On Tuesday, November 28, 2017, 4:57:03 PM GMT+1, Djibril Dione 
<djib...@hisp.org> wrote:  
 
 Thanks Ifeanyi for the update.Our issue is a bit different here all is 
populating well on Data entry and people are capturing data. just that the 
category option combination names are not updated with the correct and we use 
those name in a complex completeness report script. 
Test step On Sierra Leon 2.27   
   -  I have renamed the dataelementcategoryoption "Improve access to clean 
water" to "IACW"
   -  then go to administration app > maintenance > select "Update category 
option combinations"  and click "perform maintenance".
   -  then I go to category option combination under maintenance (metadata) and 
search for "IACW" and could not find it but when you search for "Improve access 
to clean water" you get many that pop in. i.e: "AIDSRelief Consortium, Improve 
access to clean water" which supposes to be renamed to "AIDSRelief Consortium, 
IACW"
   - I create a sqlView that search on the categoryoptioncombo Table and I got 
the same result as the front end
so whenever you rename a categoryoption I believe that the category option 
combination name should also reflect the new name once an Update category 
option combinations is performed
On Tue, Nov 28, 2017 at 5:03 PM, Ifeanyi Okoye <ifeanyiok...@yahoo.com> wrote:

Just an update on this. 
Everything I tried initially did not work. I then went to the dataset editor 
window to remove the problematic data elements and once I filtered them, I 
found that each one of them had in parenthesis at the end of the name of the 
data element, the category option combo that was causing the issue. Once I 
removed and put it back, the issue was resolved.
I hope this helps somebody.
Thank you.

Warm Regards, 

Ifeanyi

Read DrMaestro's Blog
www.ifeanyiokoye.com
 

On Monday, November 27, 2017, 10:04:23 AM GMT+1, Ifeanyi Okoye 
<ifeanyiok...@yahoo.com> wrote:  
 
 Hello Lars,This is similar to the issue I raised on this platform last week.
What I noticed is that some data elements will carry the old category option 
combo even after it has been changed or updated. This affects the form designer 
and section forms. In our own case, everything refused to update. I ran 
maintenance severally with no effect whatsoever. 
I am posting the thread below as only one person weighed in on this:
Thread:

Hello Laura,Thank you for your response.
We are currently running the 22nd Nov (dbf5f18) build of version 2.27 which we 
upgraded to on Thursday, this past week but the issue is still persisting.
I have recreated the category option combination and applied it to the data 
element but the same issue is still persisting. When I do a metadata export 
from the API, the missing categories are not on the list. It is as though DHIS 
does not even create them for whatever reason.
I don't know if anyone can provide some insight on what we could do to fix this 
since upgrading did not help.
It's affecting our roll out plans.
Thank you once again.

Warm Regards, 

Ifeanyi

Read DrMaestro's Blog
www.ifeanyiokoye.com


On Tuesday, November 21, 2017, 10:21:58 PM GMT+1, Laura E. Lincks 
<laura.lincks@icap.columbia. edu> wrote:

You may want to upgrade to the latest build. We had a similar problem with 2.27 
(on a build from August) and we just upgraded this very minute to the latest 
build 37edfc2 (Nov 8, 2017)

Re: [Dhis2-users] Update Category option combination

2017-11-28 Thread Ifeanyi Okoye 
Dear Djibril,I actually don't think the issues are different. In our own case, 
we renamed category options but when you get to the form designer, what is 
showing up is the old name. Running maintenance did not help. Running data 
integrity showed that the changes made to some of the category option 
combinations did not take effect and we had to recreate all the ones that did 
not take effect.However, it wasn't until we removed the data element that had 
the category option combo (that wasn't changing) from the dataset, and then 
added it back, did the changes take effect. Not sure why this is happening, but 
give it a try and see what happens.

Warm Regards, 

Ifeanyi

Read DrMaestro's Blog
www.ifeanyiokoye.com
 

On Tuesday, November 28, 2017, 4:57:03 PM GMT+1, Djibril Dione 
<djib...@hisp.org> wrote:  
 
 Thanks Ifeanyi for the update.Our issue is a bit different here all is 
populating well on Data entry and people are capturing data. just that the 
category option combination names are not updated with the correct and we use 
those name in a complex completeness report script. 
Test step On Sierra Leon 2.27   
   -  I have renamed the dataelementcategoryoption "Improve access to clean 
water" to "IACW"
   -  then go to administration app > maintenance > select "Update category 
option combinations"  and click "perform maintenance".
   -  then I go to category option combination under maintenance (metadata) and 
search for "IACW" and could not find it but when you search for "Improve access 
to clean water" you get many that pop in. i.e: "AIDSRelief Consortium, Improve 
access to clean water" which supposes to be renamed to "AIDSRelief Consortium, 
IACW"
   - I create a sqlView that search on the categoryoptioncombo Table and I got 
the same result as the front end
so whenever you rename a categoryoption I believe that the category option 
combination name should also reflect the new name once an Update category 
option combinations is performed
On Tue, Nov 28, 2017 at 5:03 PM, Ifeanyi Okoye <ifeanyiok...@yahoo.com> wrote:

Just an update on this. 
Everything I tried initially did not work. I then went to the dataset editor 
window to remove the problematic data elements and once I filtered them, I 
found that each one of them had in parenthesis at the end of the name of the 
data element, the category option combo that was causing the issue. Once I 
removed and put it back, the issue was resolved.
I hope this helps somebody.
Thank you.

Warm Regards, 

Ifeanyi

Read DrMaestro's Blog
www.ifeanyiokoye.com
 

On Monday, November 27, 2017, 10:04:23 AM GMT+1, Ifeanyi Okoye 
<ifeanyiok...@yahoo.com> wrote:  
 
 Hello Lars,This is similar to the issue I raised on this platform last week.
What I noticed is that some data elements will carry the old category option 
combo even after it has been changed or updated. This affects the form designer 
and section forms. In our own case, everything refused to update. I ran 
maintenance severally with no effect whatsoever. 
I am posting the thread below as only one person weighed in on this:
Thread:

Hello Laura,Thank you for your response.
We are currently running the 22nd Nov (dbf5f18) build of version 2.27 which we 
upgraded to on Thursday, this past week but the issue is still persisting.
I have recreated the category option combination and applied it to the data 
element but the same issue is still persisting. When I do a metadata export 
from the API, the missing categories are not on the list. It is as though DHIS 
does not even create them for whatever reason.
I don't know if anyone can provide some insight on what we could do to fix this 
since upgrading did not help.
It's affecting our roll out plans.
Thank you once again.

Warm Regards, 

Ifeanyi

Read DrMaestro's Blog
www.ifeanyiokoye.com


On Tuesday, November 21, 2017, 10:21:58 PM GMT+1, Laura E. Lincks 
<laura.lincks@icap.columbia. edu> wrote:

You may want to upgrade to the latest build. We had a similar problem with 2.27 
(on a build from August) and we just upgraded this very minute to the latest 
build 37edfc2 (Nov 8, 2017) and the problem appears fixed.

Laura E. Lincks
Database Manager/Developer
ICAP - Columbia University
Mailman School of Public Health
60 Haven Ave, Floor B1
New York, NY 10032
Tel: 212 304 7132


On Mon, Nov 20, 2017 at 1:13 PM, Ifeanyi Okoye <ifeanyiok...@yahoo.com>  wrote:

Hello All,We are encountering this issue with the form designer where either 
the data element does not show up in the form designer i.e. after having been 
assigned to a dataset, or some of the category options do not show up.

In this instance I have a data element disaggregated by testing modalities, 
sex, and age (age categories <1,1-4,5-9,10-14,15-19,20-24, 
25-29,30-34,35-39,40-44,45-49, 50+).
The way it is showing up, a number of the age bands are missing in the form 
d

Re: [Dhis2-users] Update Category option combination

2017-11-28 Thread Ifeanyi Okoye 
Just an update on this. 
Everything I tried initially did not work. I then went to the dataset editor 
window to remove the problematic data elements and once I filtered them, I 
found that each one of them had in parenthesis at the end of the name of the 
data element, the category option combo that was causing the issue. Once I 
removed and put it back, the issue was resolved.
I hope this helps somebody.
Thank you.

Warm Regards, 

Ifeanyi

Read DrMaestro's Blog
www.ifeanyiokoye.com
 

On Monday, November 27, 2017, 10:04:23 AM GMT+1, Ifeanyi Okoye 
<ifeanyiok...@yahoo.com> wrote:  
 
 Hello Lars,This is similar to the issue I raised on this platform last week.
What I noticed is that some data elements will carry the old category option 
combo even after it has been changed or updated. This affects the form designer 
and section forms. In our own case, everything refused to update. I ran 
maintenance severally with no effect whatsoever. 
I am posting the thread below as only one person weighed in on this:
Thread:

Hello Laura,Thank you for your response.
We are currently running the 22nd Nov (dbf5f18) build of version 2.27 which we 
upgraded to on Thursday, this past week but the issue is still persisting.
I have recreated the category option combination and applied it to the data 
element but the same issue is still persisting. When I do a metadata export 
from the API, the missing categories are not on the list. It is as though DHIS 
does not even create them for whatever reason.
I don't know if anyone can provide some insight on what we could do to fix this 
since upgrading did not help.
It's affecting our roll out plans.
Thank you once again.

Warm Regards, 

Ifeanyi

Read DrMaestro's Blog
www.ifeanyiokoye.com


On Tuesday, November 21, 2017, 10:21:58 PM GMT+1, Laura E. Lincks 
<laura.lin...@icap.columbia.edu> wrote:

You may want to upgrade to the latest build. We had a similar problem with 2.27 
(on a build from August) and we just upgraded this very minute to the latest 
build 37edfc2 (Nov 8, 2017) and the problem appears fixed.

Laura E. Lincks
Database Manager/Developer
ICAP - Columbia University
Mailman School of Public Health
60 Haven Ave, Floor B1
New York, NY 10032
Tel: 212 304 7132


On Mon, Nov 20, 2017 at 1:13 PM, Ifeanyi Okoye <ifeanyiok...@yahoo.com> wrote:

Hello All,We are encountering this issue with the form designer where either 
the data element does not show up in the form designer i.e. after having been 
assigned to a dataset, or some of the category options do not show up.

In this instance I have a data element disaggregated by testing modalities, 
sex, and age (age categories <1,1-4,5-9,10-14,15-19,20-24, 
25-29,30-34,35-39,40-44,45-49, 50+).
The way it is showing up, a number of the age bands are missing in the form 
designer and it is not uniform. E.g. VCT has female 15-19, VCT is missing male 
15-19.
I have run maintenance, generated resource tables, run analytics, removed the 
options from the category combo and put them back again, but still not showing 
up.
We use custom forms a lot and this is not the first time we are encountering 
this, but then, not to this degree.

Can anybody please help with this?
We are running DHIS2 ver 2.27 Build revision: a8283e0 Build date: 2017-09-21 
06:25
Thank you.




Warm Regards, 

Ifeanyi

Read DrMaestro's Blog
www.ifeanyiokoye.com
 

On Sunday, November 26, 2017, 9:51:05 AM GMT+1, Lars Helge Øverland 
<l...@dhis2.org> wrote:  
 
 For data entry module, you might have to clean your browser cache.
regards,
Lars

On 25 November 2017 at 08:52, Djibril Dione <djib...@hisp.org> wrote:

Hi Lars,I did perform Update category option combinations as decrypt on my 
email but there was no change in the name.similarly, I renamed the category 
option "Improve Access to Improve access to clean water" on Sierra Leon demo 
2.27. but no change after performing maintenance.
On Fri, Nov 24, 2017 at 11:28 PM, Lars Helge Øverland <l...@dhis2.org> wrote:

Hi there,
try going to data administration app > maintenance > select "Update category 
option combinations"  and click "perform maintenance".
regards,
Lars

On 24 November 2017 at 15:01, Djibril Dione <djib...@hisp.org> wrote:

Dear DHIS2 community, We are setting up an aggregated system using Attribute 
option as part of the disaggregation. Some of the category option names were 
not correct and we have renamed them.
Now after updating the category option combination through data 
administration/Maintenance, the old combination name is still appearing on the 
category option combinations on the frontend and at the backend.
we have renamed some attribute option on Sierra Leon Demo 2.27 and still found 
the same issue.
Is there anyone experiencing the same issue.
we are using version 2.27 build:5c148f4
-- 


Kind Regards




Djibril Dione 

Database Specialist



Health Information Systems Program – SA

Cell: +27

Re: [Dhis2-users] Update Category option combination

2017-11-27 Thread Ifeanyi Okoye 
Hello Lars,This is similar to the issue I raised on this platform last week.
What I noticed is that some data elements will carry the old category option 
combo even after it has been changed or updated. This affects the form designer 
and section forms. In our own case, everything refused to update. I ran 
maintenance severally with no effect whatsoever. 
I am posting the thread below as only one person weighed in on this:
Thread:

Hello Laura,Thank you for your response.
We are currently running the 22nd Nov (dbf5f18) build of version 2.27 which we 
upgraded to on Thursday, this past week but the issue is still persisting.
I have recreated the category option combination and applied it to the data 
element but the same issue is still persisting. When I do a metadata export 
from the API, the missing categories are not on the list. It is as though DHIS 
does not even create them for whatever reason.
I don't know if anyone can provide some insight on what we could do to fix this 
since upgrading did not help.
It's affecting our roll out plans.
Thank you once again.

Warm Regards, 

Ifeanyi

Read DrMaestro's Blog
www.ifeanyiokoye.com


On Tuesday, November 21, 2017, 10:21:58 PM GMT+1, Laura E. Lincks 
<laura.lin...@icap.columbia.edu> wrote:

You may want to upgrade to the latest build. We had a similar problem with 2.27 
(on a build from August) and we just upgraded this very minute to the latest 
build 37edfc2 (Nov 8, 2017) and the problem appears fixed.

Laura E. Lincks
Database Manager/Developer
ICAP - Columbia University
Mailman School of Public Health
60 Haven Ave, Floor B1
New York, NY 10032
Tel: 212 304 7132


On Mon, Nov 20, 2017 at 1:13 PM, Ifeanyi Okoye <ifeanyiok...@yahoo.com> wrote:

Hello All,We are encountering this issue with the form designer where either 
the data element does not show up in the form designer i.e. after having been 
assigned to a dataset, or some of the category options do not show up.

In this instance I have a data element disaggregated by testing modalities, 
sex, and age (age categories <1,1-4,5-9,10-14,15-19,20-24, 
25-29,30-34,35-39,40-44,45-49, 50+).
The way it is showing up, a number of the age bands are missing in the form 
designer and it is not uniform. E.g. VCT has female 15-19, VCT is missing male 
15-19.
I have run maintenance, generated resource tables, run analytics, removed the 
options from the category combo and put them back again, but still not showing 
up.
We use custom forms a lot and this is not the first time we are encountering 
this, but then, not to this degree.

Can anybody please help with this?
We are running DHIS2 ver 2.27 Build revision: a8283e0 Build date: 2017-09-21 
06:25
Thank you.




Warm Regards, 

Ifeanyi

Read DrMaestro's Blog
www.ifeanyiokoye.com
 

On Sunday, November 26, 2017, 9:51:05 AM GMT+1, Lars Helge Øverland 
<l...@dhis2.org> wrote:  
 
 For data entry module, you might have to clean your browser cache.
regards,
Lars

On 25 November 2017 at 08:52, Djibril Dione <djib...@hisp.org> wrote:

Hi Lars,I did perform Update category option combinations as decrypt on my 
email but there was no change in the name.similarly, I renamed the category 
option "Improve Access to Improve access to clean water" on Sierra Leon demo 
2.27. but no change after performing maintenance.
On Fri, Nov 24, 2017 at 11:28 PM, Lars Helge Øverland <l...@dhis2.org> wrote:

Hi there,
try going to data administration app > maintenance > select "Update category 
option combinations"  and click "perform maintenance".
regards,
Lars

On 24 November 2017 at 15:01, Djibril Dione <djib...@hisp.org> wrote:

Dear DHIS2 community, We are setting up an aggregated system using Attribute 
option as part of the disaggregation. Some of the category option names were 
not correct and we have renamed them.
Now after updating the category option combination through data 
administration/Maintenance, the old combination name is still appearing on the 
category option combinations on the frontend and at the backend.
we have renamed some attribute option on Sierra Leon Demo 2.27 and still found 
the same issue.
Is there anyone experiencing the same issue.
we are using version 2.27 build:5c148f4
-- 


Kind Regards




Djibril Dione 

Database Specialist



Health Information Systems Program – SA

Cell: +27 71 711 5421

Skype: dione.djibril

Address: 66 Rigel Ave North, Waterkloof Ridge, Pretoria, 0181
Web: www.hisp.org
NPR Reg No: 2003/005786/08


This message and any attachments are subject to a disclaimer publishedat 
http://www.hisp.org/policies.h tml#comms_disclaimer. Please read the disclaimer 
before opening any attachment or taking any otheraction in terms of this 
electronic transmission.  If you cannot access thedisclaimer, kindly send an 
email to disclai...@hisp.org and a copy will be provided to you. Byreplying to 
this e-mail or openi

Re: [Dhis2-users] Data Elements and Category Options Not Showing Up in Form Designer

2017-11-25 Thread Ifeanyi Okoye 
Hello Laura,Thank you for your response.
We are currently running the 22nd Nov (dbf5f18) build of version 2.27 which we 
upgraded to on Thursday, this past week but the issue is still persisting.
I have recreated the category option combination and applied it to the data 
element but the same issue is still persisting. When I do a metadata export 
from the API, the missing categories are not on the list. It is as though DHIS 
does not even create them for whatever reason.
I don't know if anyone can provide some insight on what we could do to fix this 
since upgrading did not help.
It's affecting our roll out plans.
Thank you once again.

Warm Regards, 

Ifeanyi

Read DrMaestro's Blog
www.ifeanyiokoye.com
 

On Tuesday, November 21, 2017, 10:21:58 PM GMT+1, Laura E. Lincks 
<laura.lin...@icap.columbia.edu> wrote:  
 
 You may want to upgrade to the latest build. We had a similar problem with 
2.27 (on a build from August) and we just upgraded this very minute to the 
latest build 37edfc2 (Nov 8, 2017) and the problem appears fixed.

Laura E. Lincks
Database Manager/Developer
ICAP -Columbia University
Mailman School of Public Health
60 Haven Ave, Floor B1
New York, NY 10032
Tel: 212 304 7132


On Mon, Nov 20, 2017 at 1:13 PM, Ifeanyi Okoye <ifeanyiok...@yahoo.com> wrote:

Hello All,We are encountering this issue with the form designer where either 
the data element does not show up in the form designer i.e. after having been 
assigned to a dataset, or some of the category options do not show up.

In this instance I have a data element disaggregated by testing modalities, 
sex, and age (age categories <1,1-4,5-9,10-14,15-19,20-24, 
25-29,30-34,35-39,40-44,45-49, 50+).
The way it is showing up, a number of the age bands are missing in the form 
designer and it is not uniform. E.g. VCT has female 15-19, VCT is missing male 
15-19.
I have run maintenance, generated resource tables, run analytics, removed the 
options from the category combo and put them back again, but still not showing 
up.
We use custom forms a lot and this is not the first time we are encountering 
this, but then, not to this degree.

Can anybody please help with this?
We are running DHIS2 ver 2.27 Build revision: a8283e0 Build date: 2017-09-21 
06:25
Thank you.
Warm Regards, 

Ifeanyi

Read DrMaestro's Blog
www.ifeanyiokoye.com


__ _
Mailing list: https://launchpad.net/~dhis2- users
Post to     : dhis2-users@lists.launchpad. net
Unsubscribe : https://launchpad.net/~dhis2- users
More help   : https://help.launchpad.net/ ListHelp



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

[Dhis2-users] Data Elements and Category Options Not Showing Up in Form Designer

2017-11-20 Thread Ifeanyi Okoye 
Hello All,We are encountering this issue with the form designer where either 
the data element does not show up in the form designer i.e. after having been 
assigned to a dataset, or some of the category options do not show up.

In this instance I have a data element disaggregated by testing modalities, 
sex, and age (age categories 
<1,1-4,5-9,10-14,15-19,20-24,25-29,30-34,35-39,40-44,45-49,50+).
The way it is showing up, a number of the age bands are missing in the form 
designer and it is not uniform. E.g. VCT has female 15-19, VCT is missing male 
15-19.
I have run maintenance, generated resource tables, run analytics, removed the 
options from the category combo and put them back again, but still not showing 
up.
We use custom forms a lot and this is not the first time we are encountering 
this, but then, not to this degree.

Can anybody please help with this?
We are running DHIS2 ver 2.27 Build revision: a8283e0 Build date: 2017-09-21 
06:25
Thank you.
Warm Regards, 

Ifeanyi

Read DrMaestro's Blog
www.ifeanyiokoye.com

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

Re: [Dhis2-users] [Dhis2-devs] [Android] New Releases of Data Capture and Tracker Capture Apps is out!!

2017-07-25 Thread Ifeanyi Okoye 
Hello Android Team,We already have a bunch of about 60 facilities already using 
the DHIS2 data capture app. We are currently in a meeting and trying to update 
the app to the latest version (July 2017). The version we are seeing on the 
Play Store is a March 27, 2017 version. See below. These are Samsung phones 
running Android 4.4. What do we do to get the latest app?




Regards,
Ifeanyi

On Friday, July 7, 2017, 20:58, Android  wrote:

Dear Community,
as part of the activities to reinforce the availability of offline mobile data 
collection options we are releasing new versions of our current Android Apps 
with all known bugs fixed, some functionalities added, and a new set of 
documentation. 
The first Apps to be released are Data Capture and Tracker Capture. They come 
with a lot of fixes (read the Release notes for further details). You can 
install them through Google Play (Data Capture, Tracker Capture) or download 
the apk from Github (Data Capture, Tracker Capture)We recommend going to Github 
for a complete list of issues solved.
Following the links below, you will find documentation with detailed 
information on the functionalities included in the Apps and how they behaves 
compare to the Web. *We recommend to download the PDF files, internal links do 
not work if you open them online).   
   - Documentation Data Capture
   - Documentation Tracker Capture
This documents are a tool for implementers who need to understand if the Apps 
will cover their needs and respond to their configurations of DHIS2 in the web. 
We encourage you to download the Apps and test them, they are compatible with 
DHIS2 versions 2.25, 2.26 and 2.27.
Please remember to create a Jira Issue if you find a bug or you want to propose 
a new functionality to be added!

Special thanks to the teams behind the development, testing and documentation 
of this release: Adrian Quintana, Araz Abishov, Bill Hartley, Emma van de 
Weerd, Erling Fjelstad, Ignacio del Cano, Ignacio Foche, Jorge Sánchez, Manuel 
Plazas, Sam Johnson, Thomas Lindsjørn and Vlad Alfredov.
Best,Marta on behalf of the Android team 
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to    : dhis2-d...@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help  : https://help.launchpad.net/ListHelp



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

[Dhis2-users] Org Unit Levels (2.24 7088b7e)

2017-02-13 Thread Ifeanyi Okoye 
Hello Everyone,
We need some help/guidance with cleaning up our Org Unit levels.
We initially created org units at 6 levels in a hierarchy i.e. (from top to 
bottom) National (1) -->State (2) -->Local Government Area (3)-->Comprehensive 
Site (4)-->Satellite Site (5) -->Outreach Site (6).
We were having issues with the data aggregation and decided to put all 
facilities at one level (4) and changed the level name to Facility. We also 
plan to use the org unit groups to differentiate the sites.
In the maintenance app --> Org Unit --> Org Unit Level, it shows that we have 
only 4 levels but in the pivot tables and in the aggregation levels section 
when creating data elements, it's still showing the 6 levels even though the 
last 2 levels are no longer showing in the org unit level management section.
What do we need to do so that only the 4 levels show to avoid confusion with 
the users and program managers?
Looking forward to your response.
Thank you.
We use DHIS2 2.24 version 7088b7e

 
Warm Regards, 

Ifeanyi


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

[Dhis2-users] Issue with Combination of Categories in Dataset/Data Entry Form

2016-09-12 Thread Ifeanyi Okoye 
Dear Devs/Users,Good evening.
DHIS2 ver 2.22 build 22086
I am having a bit of a challenge with our data entry forms.
When I add a combination of categories to the dataset, once data is entered on 
the data entry form, the data field turns from yellow to red instead of green 
(see attachment). The combination of categories is important in this dataset so 
we can use it as a data dimension in the analytics. Once I set the combination 
of categories to default, then the issue goes away.
Since this issue started, I can no longer open, edit, or delete the first 
category combination I used with the data set. Running maintenance just runs in 
an endless loop. Generating resource tables or analytics do not complete. 
Not sure what is going on. 
Has anyone encountered this issue and what can we do about it?
Thanks

 
Warm Regards, 

Ifeanyi

Read DrMaestro's Blog
www.ifeanyiokoye.com
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] About filter in Data visualizer

2016-08-16 Thread Ifeanyi Okoye 
Hello Elmarie,Forgive me, but I am not sure where to set the aggregation start 
level.
For the reports, what we have started to do is to select org units at levels 
(Comprehensive, Satellite, and Outreach) when we noted this issue. I do not 
know if this is a wrong method.
But this is a big concern as we would not like to misrepresent the data.
Thank you.
 
Warm Regards, 

Ifeanyi

Read DrMaestro's Blog
www.ifeanyiokoye.com


  From: Elmarie Claasen <elma...@hisp.org>
 To: 'Ifeanyi Okoye' <ifeanyiok...@yahoo.com>; 'Derek Kahongo Mukenge' 
<derek.eli...@gmail.com> 
Cc: dhis2-users@lists.launchpad.net; 'Lars Helge Øverland' 
<larshe...@gmail.com>; 'DHIS 2 Developers list' <dhis2-d...@lists.launchpad.net>
 Sent: Monday, August 15, 2016 2:46 PM
 Subject: RE: [Dhis2-devs] [Dhis2-users] About filter in Data visualizer
   
#yiv9262767628 #yiv9262767628 -- _filtered #yiv9262767628 
{font-family:Helvetica;panose-1:2 11 6 4 2 2 2 2 2 4;} _filtered #yiv9262767628 
{font-family:Helvetica;panose-1:2 11 6 4 2 2 2 2 2 4;} _filtered #yiv9262767628 
{font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #yiv9262767628 
{font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;} _filtered #yiv9262767628 
{font-family:Garamond;panose-1:2 2 4 4 3 3 1 1 8 3;} _filtered #yiv9262767628 
{panose-1:3 6 8 2 4 4 6 7 3 4;} _filtered #yiv9262767628 
{font-family:Verdana;panose-1:2 11 6 4 3 5 4 4 2 4;}#yiv9262767628 
#yiv9262767628 p.yiv9262767628MsoNormal, #yiv9262767628 
li.yiv9262767628MsoNormal, #yiv9262767628 div.yiv9262767628MsoNormal 
{margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;}#yiv9262767628 a:link, 
#yiv9262767628 span.yiv9262767628MsoHyperlink 
{color:blue;text-decoration:underline;}#yiv9262767628 a:visited, #yiv9262767628 
span.yiv9262767628MsoHyperlinkFollowed 
{color:purple;text-decoration:underline;}#yiv9262767628 
p.yiv9262767628MsoAcetate, #yiv9262767628 li.yiv9262767628MsoAcetate, 
#yiv9262767628 div.yiv9262767628MsoAcetate 
{margin:0cm;margin-bottom:.0001pt;font-size:8.0pt;}#yiv9262767628 
span.yiv9262767628BalloonTextChar {}#yiv9262767628 
span.yiv9262767628EmailStyle19 {color:#1F497D;}#yiv9262767628 
.yiv9262767628MsoChpDefault {font-size:10.0pt;} _filtered #yiv9262767628 
{margin:72.0pt 72.0pt 72.0pt 72.0pt;}#yiv9262767628 
div.yiv9262767628WordSection1 {}#yiv9262767628 Hi Ifeanyi,  Did you perhaps 
define the aggregation start level for your data elements as OU4 or are you 
also filtering on orgunitgroups in the report which can cause the inconsistency 
in reports at different levels?     Regards,  Elmarie ClaasenProject 
ManagerHealth Information Systems ProgramTel:  041-367 1027Cell: 082 
374 2209E-mail: elmarie@hisp.orgSkype:  elmarie.claasen52     This message and 
any attachments are subject to a disclaimer published at 
http://www.hisp.org/policies.html#comms_disclaimer .   Please read the 
disclaimer before opening any attachment or taking any other action in terms of 
this electronic transmission. 
If you cannot access the disclaimer, kindly send an email to 
disclai...@hisp.org and a copy will be provided to you. By replying to this 
e-mail or opening any attachment you agree to be bound by the provisions of the 
disclaimer.   From: Ifeanyi Okoye [mailto:ifeanyiok...@yahoo.com] 
Sent: 15 August 2016 02:38 PM
To: Derek Kahongo Mukenge; Elmarie Claasen
Cc: dhis2-users@lists.launchpad.net; Lars Helge Øverland; DHIS 2 Developers list
Subject: Re: [Dhis2-devs] [Dhis2-users] About filter in Data visualizer  Hello 
Everyone,I had reported this a few weeks ago and did not get any response.  We 
have data entered at OU4 (comprehensive sites), OU5 (satellite sites), and OU6 
(outreach sites).  When we do tables or charts and select the parent OU (OU1), 
the data displayed is for OU4 (comprehensive sites) alone. When I select the 
different levels, I get a different output.  I have taken the time to compare 
the outputs from the tables and the data entry forms and I see that for some 
reason, DHIS isn't aggregating data below OU4 into the parent OU. Not sure why. 
 We use DHIS2. 22.  Any explanation or help would be most appreciated. 
Warm Regards, 

Ifeanyi

Read DrMaestro's Blog
www.ifeanyiokoye.com

  From: Derek Kahongo Mukenge <derek.eli...@gmail.com>
To: Elmarie Claasen <elma...@hisp.org> 
Cc: dhis2-users@lists.launchpad.net; Lars Helge Øverland <larshe...@gmail.com>; 
DHIS 2 Developers list <dhis2-d...@lists.launchpad.net>
Sent: Monday, August 15, 2016 12:00 PM
Subject: Re: [Dhis2-devs] [Dhis2-users] About filter in Data visualizer  Hi 
Everybody,I'm facing the same issue with 2.23. As Elmarie said, I checked but 
everything stand as same as before. I think that it may be a bug. Is there 
another way to resolve this?  2016-08-09 21:56 GMT+01:00 Elmarie Claasen 
<elma...@hisp.org>:Carlos, From my experience this can be due to one of 2 
reasons:  1)  Check that you don’t have any data integrity errors. If for 
instance you have

[Dhis2-users] Data Discrepancy in Pivot Tables and Charts

2016-08-04 Thread Ifeanyi Okoye 
DHIS 2.22
Dear All,We are having a bit of a confusing situation here with our pivot 
tables and charts.
When we select Org Unit at country level, we get a different total from when we 
do a facility-by-facility list using the same Indicator. We grouped our 
facilities into 4 groups - Comprehensive, Satellite, Outreach, and Above Site. 
So, when we select with the groups, which then gives us a list of the 
facilities and their data, the facility listing data is higher than when we 
just select the Country-level org unit.Just a bit confused as to how this is 
possible.
We are looking very closely to see what the issue may be but will appreciate 
any thoughts on this.
Thank you. 
Warm Regards, 

Ifeanyi

Read DrMaestro's Blog
www.ifeanyiokoye.com
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Data approval does not adhere to datasets assigned to Orgunits

2016-08-02 Thread Ifeanyi Okoye 
Elmarie,We had even more serious issues with trying to setup approvals in DHIS 
2.22.
We suddenly realized that analytics were not working and were wondering what 
had gone wrong. Pivot tables and dataset report were blank. The last action we 
setup before this was the creating the category option groupsets and setting up 
the approval workflow.
So, we started removing everything related to the approvals but when it got to 
removing the category option groupsets from the users we assigned to the 2 
groupsets we created, it appeared to unassign, but when you saved and opened 
again, the groupsets were still assigned to the user. This gave us a huge 
challenge. I reported this on this forum, but go very little help with it. 
Eventually we managed move the things off but then we could not delete the 
option groupsets because they were assigned to users which we could not 
immediately locate.
Yesterday, 2 users who did not even have the option groupsets applied to their 
accounts reported that they were getting exception errors when trying to run 
pivot tables. I checked those users profiles and saw that the option groupsets 
had been assigned to them. Given that I created the users and the option 
groupsets, it was a bit bewildering that how that got assigned to them.
I wish the data approval app in DATIM could be made available to users with 
clear instructions on how to set it up. I think it would be quite helpful.
I plan to actually check the users one by one to see if other users have this 
issue. I probably will do this easier from the backend, but access to the 
server is not convenient right now.
Thank you. 
Warm Regards, 

Ifeanyi

Read DrMaestro's Blog
www.ifeanyiokoye.com


  From: Elmarie Claasen 
 To: dhis2-d...@lists.launchpad.net; dhis2-users@lists.launchpad.net 
 Sent: Tuesday, August 2, 2016 12:39 PM
 Subject: [Dhis2-users] Data approval does not adhere to datasets assigned to 
Orgunits
   
Hi all, 
 I would like views on what I perceive to be a bug in DHIS2 that Data Approval 
Workflow does not respect/adhere to Dataset/Orgunit assignment. I’ll paint the 
scenario:   An integrated HIS reporting system where different facility types 
report on data elements applicable to them so the Orgunit and Dataset assigned 
could look something like this:   
| Country |    |    |    | Dataset assigned | Workflow period |
|    | Region 1 |    |    |    |    |
|    |    | District 1 |    |    |    |
|    |    |    | Clinic A | PHC dataset | Monthly |
|    |    |    | Community Health Centre B | PHC dataset + Delivery dataset | 
Monthly |
|    |    |    | Hospital C | Hospital dataset | Monthly |
|    |    |    | Community outreach D | Community Dataset | Monthly |
|    |    |    | Emergency Service E | EMS dataset | Monthly |

    If you set up a workflow for e.g. PHC dataset – Monthly you have to let the 
Manager of not only Clinic A and Community Health Centre B approve that dataset 
BUT also Hospital C, Community Outreach D and Emergency Service E while they 
DON’T REPORT and are not assigned to that dataset. If they don’t all approve 
the same workflow then District 1 cannot approve the dataset.   Yes, it is 
possible to create one overall dataset which everyone then approves but it 
looks very “dirty” because most of the signoff report is elements they should 
not report on thus blank and it is not easy for them to identify the REAL GAPS 
which they should have reported on if >50% of the form is blank and it is too 
long.   What would it take to attach the data approval to the Dataset>Orgunit 
Assignment that is done for data entry thus only requiring approval at lower 
level if that orgunit is assigned to the dataset. If that is done then only 
Clinic A and Community Health Centre B would be assigned to the workflow and be 
required to approve before District 1 can approve. I would appreciate some 
feedback and prepared to write a blueprint for it if required.  
  Regards,  Elmarie 
ClaasenProject ManagerHealth Information Systems ProgramTel:  041-367 
1027Cell: 082 374 2209E-mail: elmarie@hisp.orgSkype:  elmarie.claasen52     
This message and any attachments are subject to a disclaimer published at 
http://www.hisp.org/policies.html#comms_disclaimer .   Please read the 
disclaimer before opening any attachment or taking any other action in terms of 
this electronic transmission. 
If you cannot access the disclaimer, kindly send an email to 
disclai...@hisp.org and a copy will be provided to you. By replying to this 
e-mail or opening any attachment you agree to be bound by the provisions of the 
disclaimer.    
This message and any attachments are subject to a disclaimer publishedat 
http://www.hisp.org/policies. html#comms_disclaimer. Please read the disclaimer 
before opening any attachment or taking any otheraction in terms of this 
electronic transmission.  If you cannot access thedisclaimer,

Re: [Dhis2-users] Possible removal of mobile "light" and mobile "smartphone" in 2.25

2016-07-27 Thread Ifeanyi Okoye 
Hello Morten,We are using mainly for data capture.
The smartphone module is a bit more flexible than the android app. We are using 
android phones and have the data entry app installed on the phones. We have had 
instances where the users entered data for several months at a stretch using 
the app and we could not find the data in the database (possibly a network 
issue). If the app can be upgraded to simulate the smartphone module, it would 
prove more useful. For example, you do not get a completed entry report using 
the app each time a user submits data, which you get using the module. Also, 
the messaging function is quite a useful tool.
Thanks 
Warm Regards, 

Ifeanyi

Read DrMaestro's Blog
www.ifeanyiokoye.com


  From: Morten Olav Hansen <mor...@dhis2.org>
 To: Ifeanyi Okoye <ifeanyiok...@yahoo.com> 
Cc: Prosper BT <ptb3...@gmail.com>; dhis2-users 
<dhis2-users@lists.launchpad.net>; dhis2-devs <dhis2-d...@lists.launchpad.net>
 Sent: Wednesday, July 27, 2016 3:27 PM
 Subject: Re: [Dhis2-users] Possible removal of mobile "light" and mobile 
"smartphone" in 2.25
   
Hi Ifeanyi
What version of DHIS2 are you on? are you using it mainly for data collection, 
or also messaging?
What kind of phones are they using? have you also tried our Android clients?
-- Morten Olav HansenSenior Engineer, DHIS 2University of 
Oslohttp://www.dhis2.org
On Wed, Jul 27, 2016 at 4:20 PM, Ifeanyi Okoye <ifeanyiok...@yahoo.com> wrote:

Dear Morten,Our program uses the Smartphone module for our outreach 
sites.Thanks 
Warm Regards, 

Ifeanyi

Read DrMaestro's Blog
www.ifeanyiokoye.com


  From: Prosper BT <ptb3...@gmail.com>
 To: Morten Olav Hansen <mor...@dhis2.org> 
Cc: dhis2-users <dhis2-users@lists.launchpad.net>; dhis2-devs 
<dhis2-d...@lists.launchpad.net>
 Sent: Wednesday, July 27, 2016 2:30 PM
 Subject: Re: [Dhis2-users] Possible removal of mobile "light" and mobile 
"smartphone" in 2.25
  
Dear Morten,
For HISP Uganda uses we have never used them at all. We are okay with them going
Regards
On Wed, Jul 27, 2016 at 3:03 PM, Morten Olav Hansen <mor...@dhis2.org> wrote:

Hi everyone
We are thinking of possibly removing these 2 projects from DHIS 2 Core in 2.25 
release, but we wanted to know if anyone is still using them?
They haven't been updated in a very long time (4-5 releases at least) and is 
not updated to work with any of the latest model changes.
-- Morten Olav HansenSenior Engineer, DHIS 2University of 
Oslohttp://www.dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to     : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp





-- 
Prosper Behumbiize, MPH
Global DHIS2 Implementation| HISP Uganda/University Of Oslo
+256 752 751 776 | +256 776 139 139pros...@hispuganda.org | pros...@dhis2.org | 
Skype: prospertb
___
Mailing list: https://launchpad.net/~dhis2-users
Post to    : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help  : https://help.launchpad.net/ListHelp


   



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

Re: [Dhis2-users] Possible removal of mobile "light" and mobile "smartphone" in 2.25

2016-07-27 Thread Ifeanyi Okoye 
Dear Morten,Our program uses the Smartphone module for our outreach 
sites.Thanks 
Warm Regards, 

Ifeanyi

Read DrMaestro's Blog
www.ifeanyiokoye.com


  From: Prosper BT 
 To: Morten Olav Hansen  
Cc: dhis2-users ; dhis2-devs 

 Sent: Wednesday, July 27, 2016 2:30 PM
 Subject: Re: [Dhis2-users] Possible removal of mobile "light" and mobile 
"smartphone" in 2.25
   
Dear Morten,
For HISP Uganda uses we have never used them at all. We are okay with them going
Regards
On Wed, Jul 27, 2016 at 3:03 PM, Morten Olav Hansen  wrote:

Hi everyone
We are thinking of possibly removing these 2 projects from DHIS 2 Core in 2.25 
release, but we wanted to know if anyone is still using them?
They haven't been updated in a very long time (4-5 releases at least) and is 
not updated to work with any of the latest model changes.
-- Morten Olav HansenSenior Engineer, DHIS 2University of 
Oslohttp://www.dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to     : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp





-- 
Prosper Behumbiize, MPH
Global DHIS2 Implementation| HISP Uganda/University Of Oslo
+256 752 751 776 | +256 776 139 139pros...@hispuganda.org | pros...@dhis2.org | 
Skype: prospertb
___
Mailing list: https://launchpad.net/~dhis2-users
Post to    : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help  : https://help.launchpad.net/ListHelp


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

[Dhis2-users] Formatting Numbers Data Entry Forms

2016-07-27 Thread Ifeanyi Okoye 
Dear All,
DHIS v 2.22
Is there a way to do some extra formatting with numbers on the form designer to 
include stuff like comma separator?
Thank you.
Warm Regards, 

Ifeanyi

Read DrMaestro's Blog
www.ifeanyiokoye.com
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] Analytics Not Working - Help Needed

2016-06-26 Thread Ifeanyi Okoye 
:34:55 WAT ERROR:  table "analytics_1502" does not exist2016-06-19 07:34:55 
WAT STATEMENT:  drop table analytics_15022016-06-19 07:34:55 WAT ERROR:  table 
"analytics_temp_1502" does not exist2016-06-19 07:34:55 WAT STATEMENT:  drop 
table analytics_temp_15022016-06-19 07:34:55 WAT ERROR:  table "analytics_1502" 
does not exist2016-06-19 07:34:55 WAT STATEMENT:  drop table 
analytics_15022016-06-19 07:34:55 WAT ERROR:  table "analytics_1503" does not 
exist2016-06-19 07:34:55 WAT STATEMENT:  drop table analytics_15032016-06-19 
07:34:55 WAT ERROR:  table "analytics_1503" does not exist2016-06-19 07:34:55 
WAT STATEMENT:  drop table analytics_15032016-06-19 07:34:55 WAT ERROR:  table 
"analytics_temp_1503" does not exist2016-06-19 07:34:55 WAT STATEMENT:  drop 
table analytics_temp_15032016-06-19 07:34:55 WAT ERROR:  table "analytics_1503" 
does not exist2016-06-19 07:34:55 WAT STATEMENT:  drop table 
analytics_15032016-06-19 07:34:55 WAT ERROR:  table "analytics_1504" does not 
exist2016-06-19 07:34:55 WAT STATEMENT:  drop table analytics_15042016-06-19 
07:34:55 WAT ERROR:  table "analytics_1504" does not exist2016-06-19 07:34:55 
WAT STATEMENT:  drop table analytics_15042016-06-19 07:34:55 WAT ERROR:  table 
"analytics_temp_1504" does not exist2016-06-19 07:34:55 WAT STATEMENT:  drop 
table analytics_temp_15042016-06-19 07:34:55 WAT ERROR:  table "analytics_1504" 
does not exist2016-06-19 07:34:55 WAT STATEMENT:  drop table 
analytics_15042016-06-19 07:34:55 WAT ERROR:  table "analytics_1505" does not 
exist2016-06-19 07:34:55 WAT STATEMENT:  drop table analytics_15052016-06-19 
07:34:55 WAT ERROR:  table "analytics_1505" does not exist2016-06-19 07:34:55 
WAT STATEMENT:  drop table analytics_15052016-06-19 07:34:55 WAT ERROR:  table 
"analytics_temp_1505" does not exist2016-06-19 07:34:55 WAT STATEMENT:  drop 
table analytics_temp_15052016-06-19 07:34:55 WAT ERROR:  table "analytics_1505" 
does not exist2016-06-19 07:34:55 WAT STATEMENT:  drop table 
analytics_15052016-06-19 07:34:55 WAT ERROR:  table "analytics_1506" does not 
exist2016-06-19 07:34:55 WAT STATEMENT:  drop table analytics_15062016-06-19 
07:34:55 WAT ERROR:  table "analytics_1506" does not exist2016-06-19 07:34:55 
WAT STATEMENT:  drop table analytics_15062016-06-19 07:34:55 WAT ERROR:  table 
"analytics_temp_1506" does not exist2016-06-19 07:34:55 WAT STATEMENT:  drop 
table analytics_temp_15062016-06-19 07:34:55 WAT ERROR:  table "analytics_1506" 
does not exist2016-06-19 07:34:55 WAT STATEMENT:  drop table 
analytics_15062016-06-19 07:34:55 WAT ERROR:  table "analytics_1507" does not 
exist2016-06-19 07:34:55 WAT STATEMENT:  drop table analytics_15072016-06-19 
07:34:55 WAT ERROR:  table "analytics_1507" does not exist


What can we do to resolve this?

 
Warm Regards, 

Ifeanyi



Ifeanyi Okoye MB;BS, M.Inf.Sc
Strategic Information Manager,
US Department of Defense-Walter Reed Program Nigeria
Embassy of the United States of America 
Plot 1075 Diplomatic Drive Central Business District, Abuja, Nigeria 
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] Data Not Showing Up in Reports and Pivot Tables

2016-06-21 Thread Ifeanyi Okoye 
Hello,
 

Weare currently experiencing an issue with the analytics on our 
DHIS2installation.

 

Theinstance went live on Thursday and data entry commenced that same day. 
OnSaturday, I tried to run dataset reports and got no output (just the 
formstructure). Pivot tables also returned no data.

 

Iran the analytics generation, which completed successfully each time from 
thefront end but still no data. Tried running maintenance but that went 
onindefinitely.

 

 

Iasked our IT folks to pull the database and system logs and noticed some 
errors(see attached PostgreSQL and Catalina logs). 

 

Here'sa subsection:

 

INFO 2016-06-18 20:51:25,517 Query failed, likely because the 
requestedanalytics table does not exist 
(JdbcAnalyticsManager.java[SimpleAsyncTaskExecutor-487])

org.springframework.jdbc.BadSqlGrammarException:StatementCallback; bad SQL 
grammar [select"dx","co","monthly","uidlevel1",sum(value) as value from 
analytics_2016 where "dx" in ('txAGdhIyCoP')and "co" in ('L8BiaJcGlDA', 
'Nii07uRlq9I', 'aajj1DKxqPa','deVhyY1hfDO', 'QLmvl8CxNYs', 'UdufjVycW0s', 
'Kf0uVFPuA8s', 'hlgJQWw4vlY','RSq3AOSIUh1', 'pErlxyLqK8G', 'ofRCydRthqG', 
'E0oECMnEhKK', 'Lr49tVveh4n','AmgnnAu4Raw', 'hvMYNwgY0fN', 'wy5xiY6VZNM', 
'yKSHLcb0fVY', 'M3gaIIkX5Ea','zq5W69j1A5O', 'iBipMNkNvEU', 'mQGIahEkqQr', 
'rVbaaj8FKdA', 'iOr97drPOoZ','WW0OzurqWny', 'dAZsyxKTru2', 'z4R5rXEPVcN', 
'GenN3reQduf', 'FWDHae3zoIz','dwPdgJxljWD', 'rfVGtr1syCt', 'FQ0T8oicM1q', 
'zeOLrHi1DED', 'wZey9PSViRb','x4aIvEhgnCX', 'skAHXkrqvUx', 'L6j7K9kmltt', 
'LVhjAVcUC8z', 'XhCoL9nItWA','O1uKi3kQsGi', 'Fmy4z8hQFri', 'B6Kdba5mGpB', 
'Ya8X9slYFDV', 'H8HAVyunZwj','ofCLpSSvqFp', 'IXTMAi8ASDP', 'C0cgd3RxLRF', 
'e2o6yW76PzJ', 'nddeqMEE0s4','qn32iuP28aI', 'REeTM8YMG5t', 'VfrL2mVMKtW', 
'qU7giGjkkUw', 'oysF1o76Qxl','HPAxapmoBvr', 's9CyZFKA9n7', 'A8A8JF9lpue', 
'qTTDZKszW4O', 'ujy6e2O2Y6W','BRmlLoDHsjT', 'e27h0KUYBEK', 'okuojwTFZo3', 
'dQfpHrCSl0J', 'xBHYXY7Lfip','kru3fGkvxka', 'GJMevtelfZp', 'TrhQf5tFVih', 
'sbWJ3tN5DuY', 'VGt0aLQgbdc') and"monthly" in ('201604') and "uidlevel1" in 
('C983g0J6p9m')and ( "sASLYFgAkiG" in ('CW20DvNk041') ) and ("LKC6LlcxjzT" in 
('jj2GfLHSgGP') ) group by"dx","co","monthly","uidlevel1"];nested exception is 
org.postgresql.util.PSQLException: ERROR: column "sASLYFgAkiG" does not exist

 Position: 1213

   
atorg.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:99)

   
atorg.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)

   
atorg.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)

   at 
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)

   at 
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416)

   at 
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:471)

   at 
org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:526)

   
atorg.hisp.dhis.analytics.data.JdbcAnalyticsManager.getKeyValueMap(JdbcAnalyticsManager.java:395)

   
atorg.hisp.dhis.analytics.data.JdbcAnalyticsManager.getAggregatedDataValues(JdbcAnalyticsManager.java:143)

   at sun.reflect.GeneratedMethodAccessor538.invoke(Unknown Source)

 

Thetext in red is pretty recurrent across the catalina logs from the 18th of 
June.

 

Weare running DHIS2 2.22 build 22057. 

 

Dokindly take a look and help us resolve this.

 

Wouldgladly provide any other information  required.

 

Thankyou.

 
Warm Regards, 

Ifeanyi

Read DrMaestro's Blog
www.ifeanyiokoye.com
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp