dhis2-devs team mailing list archive

[Adebusoye Anifalaje <busoye@xxxxxxxx>]

Try saving the levels as they are and then run analytics again. See what happens. If that doesn’t work change the names to 1, 2, 3, 4, 5 and 6 and try to run the analytics again. 

Let’s know how you get on.

Cheers.

Busoye




On 17 Dec 2013, at 18:01, Paulo Grácio <pgracio@xxxxxxxxxxxxxxxxxxxx> wrote:

> Hi Busoye,
>  
> We are not using the default OU Levels, please see the attachment.
>  
> Regards,
> Paulo Grácio
>  
> From: Adebusoye Anifalaje [mailto:busoye@xxxxxxxx] 
> Sent: terça-feira, 17 de Dezembro de 2013 17:19
> To: Paulo Grácio
> Cc: DHIS 2 developers
> Subject: Re: [Dhis2-devs] Generating Analytics in Live version
> Importance: High
>  
> Hi Paulo,
>  
> There have been a number of people with this problem. What you need to do is save your organisation unit levels. Do the following
>  
> 1) Go to Maintenance -> Organisation Units
>  
> 2) Select Organisation Unit Level
>  
> 3) Click on “Save” or change the default Names (i.e. Level 1, Level 2 etc) to actually level names (e.g. National, Province, District etc).
>  
>  
> This should resolve the problem.
>  
> Let the group know if you have any more problems.
>  
> Regards,
>  
> Busoye   
>  
>  
> On 17 Dec 2013, at 17:01, Paulo Grácio <pgracio@xxxxxxxxxxxxxxxxxxxx> wrote:
> 
> 
> Hi,
> It looks like the problem is related with quoted names http://h2database.com/html/grammar.html#quoted_name
> Please see attached imaged, any idea of how to work around this problem?
> 
> Regards,
> Paulo Grácio
> On Fri, Dec 13, 2013 at 3:21 PM, Paulo Grácio <pgracio@xxxxxxxxxxxxxxxxxxxx> wrote:
> Hi all,
>  
> Any idea of what might be causing this problem?
>  
> Caused by: org.h2.jdbc.JdbcSQLException: Column "OUS.uidlevel1" not found; SQL statement:
>  
> Regards,
> Paulo Grácio
>  
> From: Dhis2-users [mailto:dhis2-users-bounces+pgracio=criticalsoftware.com@xxxxxxxxxxxxxxxxxxx] On Behalf Of Paulo Grácio
> Sent: sexta-feira, 13 de Dezembro de 2013 11:09
> To: 'Marta Vila'; 'Busoye Anifalaje'; 'dhis2-users'
> 
> Subject: Re: [Dhis2-users] Generating Analytics in Live version
>  
> I’m also getting a similar problem…
>  
> * INFO  10:29:50,023 [Level: ERROR, category: DATAMART, time: Fri Dec 13 10:29:50 GMT 2013, message: Process failed:
> er-2])
> * ERROR 10:29:50,123 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-2])
> java.lang.RuntimeException: Exception during execution
>         at org.hisp.dhis.system.util.ConcurrentUtils.waitForCompletion(ConcurrentUtils.java:55)
>         at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.populateTables(DefaultAnalyticsTableService.ja
>         at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.update(DefaultAnalyticsTableService.java:113)
>         at org.hisp.dhis.analytics.scheduling.AnalyticsTableTask.run(AnalyticsTableTask.java:95)
>         at org.hisp.dhis.scheduling.ScheduledTasks.run(ScheduledTasks.java:60)
>         at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnabl
>         at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)
>         at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
>         at java.util.concurrent.FutureTask.run(FutureTask.java:138)
>         at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecut
>         at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java
>         at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
>         at java.lang.Thread.run(Thread.java:662)
>  
> Regards,
> Paulo Grácio
>  
> From: Dhis2-users [mailto:dhis2-users-bounces+pgracio=criticalsoftware.com@xxxxxxxxxxxxxxxxxxx] On Behalf Of Marta Vila
> Sent: quinta-feira, 12 de Dezembro de 2013 11:55
> To: Busoye Anifalaje
> Cc: dhis2-users
> Subject: Re: [Dhis2-users] Generating Analytics in Live version
>  
> Hi Busoye,
>  
> I followed your instructions but data was not there... :( 
>  
> Thanks!
>  
> 
> On 11 December 2013 13:06, Busoye Anifalaje <busoye@xxxxxxxx> wrote:
> Hi Marta,
>  
> It is likely that there is no problem with your analytics generating and the error is actually related to the Data Mart (your error log also implies this is the case). I also found this error confusing the first time I saw it. Check your pivot table to confirm if your data is updated. You will be surprised that it's actually all there. 
>  
>  
> Best 
>  
> Busoye
>  
> 
> On 11 December 2013 11:01, Marta Vila <martavila@xxxxxxxxx> wrote:
> Hi all,
>  
> I´m running a live version with data and metadata imported and it all works fine but I don´t find the way to generate the Analytic tables. 
>  
> If I run them manually I get this Process failed: Exception during execution   (log attached). 
>  
> If I remember well it expects the tables to be generated by the automatic process so i scheduled the task yesterday to be executed daily and left the laptop on... but nothing changes... 
> Maybe it got suspended and the task was never executed... (will change that now and lets see tomorrow) but anyway, if that is my problem, I suggest it may be useful to generate the tables even if the task is triggered manually for the first time. 
>  
>  
> Version:
> 2.13
> Build revision:
> 12908
> Build date:
> 2013-12-04 16:24
>  
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
> 
>  
>  
> 
> _______________________________________________
> 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
> 
>  
> <ERROR-QUERY.png>_______________________________________________
> 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
>  
> <OULevel.png>