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 <[email protected]> wrote: > Hi Busoye, > > We are not using the default OU Levels, please see the attachment. > > Regards, > Paulo Grácio > > From: Adebusoye Anifalaje [mailto:[email protected]] > 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 <[email protected]> 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 <[email protected]> > 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....@lists.launchpad.net] > 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....@lists.launchpad.net] > 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 <[email protected]> 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 <[email protected]> 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 : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > > > > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : [email protected] > 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 : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > <OULevel.png>
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
