Generating Analytics in Live version

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

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

···

On Fri, Dec 13, 2013 at 3:21 PM, Paulo Grácio pgracio@criticalsoftware.com wrote:

From: Dhis2-users [mailto:dhis2-users-bounces+pgracio=criticalsoftware.com@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.com@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… :frowning:

Thanks!

On 11 December 2013 13:06, Busoye Anifalaje busoye@hisp.org 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@gmail.com 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@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp


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

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@criticalsoftware.com> 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@criticalsoftware.com> 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@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.com@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... :frowning:

Thanks!

On 11 December 2013 13:06, Busoye Anifalaje <busoye@hisp.org> 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@gmail.com> 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@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

_______________________________________________
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

<ERROR-QUERY.png>_______________________________________________
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

Hi Busoye,

We are not using the default OU Levels, please see the attachment.

Regards,

Paulo Grácio

image

···

From: Adebusoye Anifalaje [mailto:busoye@hisp.org]
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@criticalsoftware.com 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@criticalsoftware.com 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@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.com@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… :frowning:

Thanks!

On 11 December 2013 13:06, Busoye Anifalaje busoye@hisp.org 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@gmail.com 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@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp


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

<ERROR-QUERY.png>_______________________________________________
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

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@criticalsoftware.com> wrote:

Hi Busoye,

We are not using the default OU Levels, please see the attachment.

Regards,
Paulo Grácio

From: Adebusoye Anifalaje [mailto:busoye@hisp.org]
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@criticalsoftware.com> 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@criticalsoftware.com> 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@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.com@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... :frowning:

Thanks!

On 11 December 2013 13:06, Busoye Anifalaje <busoye@hisp.org> 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@gmail.com> 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@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

_______________________________________________
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

<ERROR-QUERY.png>_______________________________________________
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

<OULevel.png>

That doesn’t work either. After analyse the source code my conclusions are:

Once H2 is casesensitive when using quotes on names and, for this specific problem, column names are quoted

JdbcAnalyticsTableManager 220: String column = quote( PREFIX_ORGUNITLEVEL + level.getLevel() );

Where

JdbcAnalyticsTableManager 66: public static final String PREFIX_ORGUNITLEVEL = “uidlevel”;

Comparing postgres tables with h2 tables I just realize that ones are using lower case and others using upper case.

databaseToUpper

Database setting DATABASE_TO_UPPER (default: true).
Database short names are converted to uppercase for the DATABASE() function, and in the CATALOG column of all database meta data methods. Setting this to “false” is experimental. When set to false, all identifier names (table names, column names) are case sensitive (except aggregate, built-in functions, data types, and keywords).

hibernate.connection.url = jdbc:h2:./database/dhis2;AUTO_SERVER=TRUE;DATABASE_TO_UPPER=false

Adding this to the connection String is not working having an error during server startup.

Any recommendation… ?! L

Regards,

Paulo Grácio

···

From: Adebusoye Anifalaje [mailto:busoye@hisp.org]
Sent: terça-feira, 17 de Dezembro de 2013 18:37
To: Paulo Grácio
Cc: DHIS 2 developers
Subject: Re: [Dhis2-devs] Generating Analytics in Live version

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@criticalsoftware.com wrote:

Hi Busoye,

We are not using the default OU Levels, please see the attachment.

Regards,

Paulo Grácio

From: Adebusoye Anifalaje [mailto:busoye@hisp.org]
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@criticalsoftware.com 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@criticalsoftware.com 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@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.com@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… :frowning:

Thanks!

On 11 December 2013 13:06, Busoye Anifalaje busoye@hisp.org 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@gmail.com 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@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp


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

<ERROR-QUERY.png>_______________________________________________
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

<OULevel.png>