Problem with Analytic Reports (Vizualizer and pivot table)

Hello Guys
I think I need a little help out there. everything is set up, and I completed few forms in data entry for some months and org units, when running dataset reports, we can see the data is stored.

scheduling is started, when I run analytic reports it takes a while in showing the working/progress bar, but doesn’t give the complete status, and when i try to pull up data in the pivot table it doesn’t show values (no value found).

···


Charles Emmanuel Willer
12,Lilavois 50 Croix des Bouquets, HT
Tels: +509-3842-3854 / +509-3270-0655
Skype: emmanuelwiller
emmanuelwiller@gmail.com
emmanuelwiller@yahoo.com

Hi Emmanuel, pls let us know the version and build number, and share your log file.

···

Sent from my mobile

On 5 Feb 2014 17:43, “Emmanuel Willer CHARLES” emmanuelwiller@gmail.com wrote:

Hello Guys
I think I need a little help out there. everything is set up, and I completed few forms in data entry for some months and org units, when running dataset reports, we can see the data is stored.

scheduling is started, when I run analytic reports it takes a while in showing the working/progress bar, but doesn’t give the complete status, and when i try to pull up data in the pivot table it doesn’t show values (no value found).


Charles Emmanuel Willer
12,Lilavois 50 Croix des Bouquets, HT
Tels: +509-3842-3854 / +509-3270-0655
Skype: emmanuelwiller
emmanuelwiller@gmail.com
emmanuelwiller@yahoo.com


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 Knut,

here are the requested information.

version 2.13

build number: 12941.

thanks

···

On Wed, Feb 5, 2014 at 1:31 PM, Knut Staring knutst@gmail.com wrote:

Hi Emmanuel, pls let us know the version and build number, and share your log file.

Sent from my mobile

On 5 Feb 2014 17:43, “Emmanuel Willer CHARLES” emmanuelwiller@gmail.com wrote:

Hello Guys
I think I need a little help out there. everything is set up, and I completed few forms in data entry for some months and org units, when running dataset reports, we can see the data is stored.

scheduling is started, when I run analytic reports it takes a while in showing the working/progress bar, but doesn’t give the complete status, and when i try to pull up data in the pivot table it doesn’t show values (no value found).


Charles Emmanuel Willer
12,Lilavois 50 Croix des Bouquets, HT
Tels: +509-3842-3854 / +509-3270-0655
Skype: emmanuelwiller
emmanuelwiller@gmail.com
emmanuelwiller@yahoo.com


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


Charles Emmanuel Willer
12,Lilavois 50 Croix des Bouquets, HT
Tels: +509-3842-3854 / +509-3270-0655
Skype: emmanuelwiller
emmanuelwiller@gmail.com
emmanuelwiller@yahoo.com

Fine. But the most important is your Tomcat log file.

···

On Wed, Feb 5, 2014 at 1:31 PM, Knut Staring knutst@gmail.com wrote:

Hi Emmanuel, pls let us know the version and build number, and share your log file.

Sent from my mobile

On 5 Feb 2014 17:43, “Emmanuel Willer CHARLES” emmanuelwiller@gmail.com wrote:

Hello Guys
I think I need a little help out there. everything is set up, and I completed few forms in data entry for some months and org units, when running dataset reports, we can see the data is stored.

scheduling is started, when I run analytic reports it takes a while in showing the working/progress bar, but doesn’t give the complete status, and when i try to pull up data in the pivot table it doesn’t show values (no value found).


Charles Emmanuel Willer
12,Lilavois 50 Croix des Bouquets, HT
Tels: +509-3842-3854 / +509-3270-0655
Skype: emmanuelwiller
emmanuelwiller@gmail.com
emmanuelwiller@yahoo.com


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


Charles Emmanuel Willer
12,Lilavois 50 Croix des Bouquets, HT
Tels: +509-3842-3854 / +509-3270-0655
Skype: emmanuelwiller
emmanuelwiller@gmail.com
emmanuelwiller@yahoo.com

ok. i send all files found in the logs folder.

localhost_access_log.2014-02-05.txt (8.29 KB)

catalina.2014-02-05.log (2.97 KB)

commons-daemon.2014-02-05.log (282 Bytes)

localhost.2014-02-05.log (654 Bytes)

tomcat7-stderr.2014-02-05.log (3.03 KB)

tomcat7-stdout.2014-02-05.log (7.67 KB)

···

On Wed, Feb 5, 2014 at 1:34 PM, Knut Staring knutst@gmail.com wrote:

Fine. But the most important is your Tomcat log file.

Sent from my mobile

On 5 Feb 2014 20:33, “Emmanuel Willer CHARLES” emmanuelwiller@gmail.com wrote:

Hi Knut,

here are the requested information.

version 2.13

build number: 12941.

thanks


Charles Emmanuel Willer
12,Lilavois 50 Croix des Bouquets, HT
Tels: +509-3842-3854 / +509-3270-0655
Skype: emmanuelwiller
emmanuelwiller@gmail.com
emmanuelwiller@yahoo.com

On Wed, Feb 5, 2014 at 1:31 PM, Knut Staring knutst@gmail.com wrote:

Hi Emmanuel, pls let us know the version and build number, and share your log file.

Sent from my mobile

On 5 Feb 2014 17:43, “Emmanuel Willer CHARLES” emmanuelwiller@gmail.com wrote:

Hello Guys
I think I need a little help out there. everything is set up, and I completed few forms in data entry for some months and org units, when running dataset reports, we can see the data is stored.

scheduling is started, when I run analytic reports it takes a while in showing the working/progress bar, but doesn’t give the complete status, and when i try to pull up data in the pivot table it doesn’t show values (no value found).


Charles Emmanuel Willer
12,Lilavois 50 Croix des Bouquets, HT
Tels: +509-3842-3854 / +509-3270-0655
Skype: emmanuelwiller
emmanuelwiller@gmail.com
emmanuelwiller@yahoo.com


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


Charles Emmanuel Willer
12,Lilavois 50 Croix des Bouquets, HT
Tels: +509-3842-3854 / +509-3270-0655
Skype: emmanuelwiller
emmanuelwiller@gmail.com
emmanuelwiller@yahoo.com

I think the relevant file is tomcat7-stdout.2014-02-05.log. I see you are running on Windows 7, is that just for testing on your laptop or is it meant to be a server?

Below is the last part of the log, which seems to show a problem with categories. Others should have more insight on this, but you could try going to Maintenance → Data Administration → Resource Table and click on Generate Table.

···

On Wed, Feb 5, 2014 at 9:05 PM, Emmanuel Willer CHARLES emmanuelwiller@gmail.com wrote:

ok. i send all files found in the logs folder.


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

On Wed, Feb 5, 2014 at 1:34 PM, Knut Staring knutst@gmail.com wrote:

Fine. But the most important is your Tomcat log file.

Sent from my mobile

On 5 Feb 2014 20:33, “Emmanuel Willer CHARLES” emmanuelwiller@gmail.com wrote:

Hi Knut,

here are the requested information.

version 2.13

build number: 12941.

thanks


Charles Emmanuel Willer
12,Lilavois 50 Croix des Bouquets, HT
Tels: +509-3842-3854 / +509-3270-0655
Skype: emmanuelwiller
emmanuelwiller@gmail.com
emmanuelwiller@yahoo.com

On Wed, Feb 5, 2014 at 1:31 PM, Knut Staring knutst@gmail.com wrote:

Hi Emmanuel, pls let us know the version and build number, and share your log file.

Sent from my mobile

On 5 Feb 2014 17:43, “Emmanuel Willer CHARLES” emmanuelwiller@gmail.com wrote:

Hello Guys
I think I need a little help out there. everything is set up, and I completed few forms in data entry for some months and org units, when running dataset reports, we can see the data is stored.

scheduling is started, when I run analytic reports it takes a while in showing the working/progress bar, but doesn’t give the complete status, and when i try to pull up data in the pivot table it doesn’t show values (no value found).


Charles Emmanuel Willer
12,Lilavois 50 Croix des Bouquets, HT
Tels: +509-3842-3854 / +509-3270-0655
Skype: emmanuelwiller
emmanuelwiller@gmail.com
emmanuelwiller@yahoo.com


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


Charles Emmanuel Willer
12,Lilavois 50 Croix des Bouquets, HT
Tels: +509-3842-3854 / +509-3270-0655
Skype: emmanuelwiller
emmanuelwiller@gmail.com
emmanuelwiller@yahoo.com

it is surely for test.

i tried to run resource table

i have the attached error message.

image

···

On Wed, Feb 5, 2014 at 2:19 PM, Knut Staring knutst@gmail.com wrote:

I think the relevant file is tomcat7-stdout.2014-02-05.log. I see you are running on Windows 7, is that just for testing on your laptop or is it meant to be a server?

Below is the last part of the log, which seems to show a problem with categories. Others should have more insight on this, but you could try going to Maintenance → Data Administration → Resource Table and click on Generate Table.


  • INFO 2014-02-05 15:03:10,491 Version: 3.5.3 (Service.java [taskScheduler-1])
  • INFO 2014-02-05 15:03:10,491 JRE Version: 1.7.0_40 (Service.java [taskScheduler-1])
  • INFO 2014-02-05 15:03:10,491 JRE Impl Version: 24.0-b56 (Service.java [taskScheduler-1])
  • INFO 2014-02-05 15:03:10,491 O/S: Windows 7 / amd64 / 6.1 (Service.java [taskScheduler-1])
  • ERROR 2014-02-05 15:03:10,501 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-1])

java.lang.ArrayIndexOutOfBoundsException: 0

at org.hisp.dhis.common.CombinationGenerator.getCurrent(CombinationGenerator.java:124)

at org.hisp.dhis.common.CombinationGenerator.getNext(CombinationGenerator.java:98)

at org.hisp.dhis.dataelement.DataElementCategoryCombo.getSortedOptionCombos(DataElementCategoryCombo.java:171)

at org.hisp.dhis.resourcetable.DefaultResourceTableService.generateCategoryOptionComboNames(DefaultResourceTableService.java:206)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

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

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

at java.lang.reflect.Method.invoke(Unknown Source)


Charles Emmanuel Willer
12,Lilavois 50 Croix des Bouquets, HT
Tels: +509-3842-3854 / +509-3270-0655
Skype: emmanuelwiller
emmanuelwiller@gmail.com
emmanuelwiller@yahoo.com

On Wed, Feb 5, 2014 at 9:05 PM, Emmanuel Willer CHARLES emmanuelwiller@gmail.com wrote:

ok. i send all files found in the logs folder.

Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

On Wed, Feb 5, 2014 at 1:34 PM, Knut Staring knutst@gmail.com wrote:

Fine. But the most important is your Tomcat log file.

Sent from my mobile

On 5 Feb 2014 20:33, “Emmanuel Willer CHARLES” emmanuelwiller@gmail.com wrote:

Hi Knut,

here are the requested information.

version 2.13

build number: 12941.

thanks


Charles Emmanuel Willer
12,Lilavois 50 Croix des Bouquets, HT
Tels: +509-3842-3854 / +509-3270-0655
Skype: emmanuelwiller
emmanuelwiller@gmail.com
emmanuelwiller@yahoo.com

On Wed, Feb 5, 2014 at 1:31 PM, Knut Staring knutst@gmail.com wrote:

Hi Emmanuel, pls let us know the version and build number, and share your log file.

Sent from my mobile

On 5 Feb 2014 17:43, “Emmanuel Willer CHARLES” emmanuelwiller@gmail.com wrote:

Hello Guys
I think I need a little help out there. everything is set up, and I completed few forms in data entry for some months and org units, when running dataset reports, we can see the data is stored.

scheduling is started, when I run analytic reports it takes a while in showing the working/progress bar, but doesn’t give the complete status, and when i try to pull up data in the pivot table it doesn’t show values (no value found).


Charles Emmanuel Willer
12,Lilavois 50 Croix des Bouquets, HT
Tels: +509-3842-3854 / +509-3270-0655
Skype: emmanuelwiller
emmanuelwiller@gmail.com
emmanuelwiller@yahoo.com


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


Charles Emmanuel Willer
12,Lilavois 50 Croix des Bouquets, HT
Tels: +509-3842-3854 / +509-3270-0655
Skype: emmanuelwiller
emmanuelwiller@gmail.com
emmanuelwiller@yahoo.com

.My guess is a problem with your categoryoptioncombos, but again, whenever there is an error, please share the (same) log file. Perhaps someone has time to have a look at your db, though if you don’t have much in it yet, it could be advisable to start a fresh (just create a new empty db and point to that one in hibernate.properties)

···

On Wed, Feb 5, 2014 at 10:47 PM, Emmanuel Willer CHARLES emmanuelwiller@gmail.com wrote:

it is surely for test.

i tried to run resource table

i have the attached error message.


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

On Wed, Feb 5, 2014 at 2:19 PM, Knut Staring knutst@gmail.com wrote:

I think the relevant file is tomcat7-stdout.2014-02-05.log. I see you are running on Windows 7, is that just for testing on your laptop or is it meant to be a server?

Below is the last part of the log, which seems to show a problem with categories. Others should have more insight on this, but you could try going to Maintenance → Data Administration → Resource Table and click on Generate Table.


  • INFO 2014-02-05 15:03:10,491 Version: 3.5.3 (Service.java [taskScheduler-1])
  • INFO 2014-02-05 15:03:10,491 JRE Version: 1.7.0_40 (Service.java [taskScheduler-1])
  • INFO 2014-02-05 15:03:10,491 JRE Impl Version: 24.0-b56 (Service.java [taskScheduler-1])
  • INFO 2014-02-05 15:03:10,491 O/S: Windows 7 / amd64 / 6.1 (Service.java [taskScheduler-1])
  • ERROR 2014-02-05 15:03:10,501 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-1])

java.lang.ArrayIndexOutOfBoundsException: 0

at org.hisp.dhis.common.CombinationGenerator.getCurrent(CombinationGenerator.java:124)

at org.hisp.dhis.common.CombinationGenerator.getNext(CombinationGenerator.java:98)

at org.hisp.dhis.dataelement.DataElementCategoryCombo.getSortedOptionCombos(DataElementCategoryCombo.java:171)

at org.hisp.dhis.resourcetable.DefaultResourceTableService.generateCategoryOptionComboNames(DefaultResourceTableService.java:206)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

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

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

at java.lang.reflect.Method.invoke(Unknown Source)


Charles Emmanuel Willer
12,Lilavois 50 Croix des Bouquets, HT
Tels: +509-3842-3854 / +509-3270-0655
Skype: emmanuelwiller
emmanuelwiller@gmail.com
emmanuelwiller@yahoo.com

On Wed, Feb 5, 2014 at 9:05 PM, Emmanuel Willer CHARLES emmanuelwiller@gmail.com wrote:

ok. i send all files found in the logs folder.

Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

On Wed, Feb 5, 2014 at 1:34 PM, Knut Staring knutst@gmail.com wrote:

Fine. But the most important is your Tomcat log file.

Sent from my mobile

On 5 Feb 2014 20:33, “Emmanuel Willer CHARLES” emmanuelwiller@gmail.com wrote:

Hi Knut,

here are the requested information.

version 2.13

build number: 12941.

thanks


Charles Emmanuel Willer
12,Lilavois 50 Croix des Bouquets, HT
Tels: +509-3842-3854 / +509-3270-0655
Skype: emmanuelwiller
emmanuelwiller@gmail.com
emmanuelwiller@yahoo.com

On Wed, Feb 5, 2014 at 1:31 PM, Knut Staring knutst@gmail.com wrote:

Hi Emmanuel, pls let us know the version and build number, and share your log file.

Sent from my mobile

On 5 Feb 2014 17:43, “Emmanuel Willer CHARLES” emmanuelwiller@gmail.com wrote:

Hello Guys
I think I need a little help out there. everything is set up, and I completed few forms in data entry for some months and org units, when running dataset reports, we can see the data is stored.

scheduling is started, when I run analytic reports it takes a while in showing the working/progress bar, but doesn’t give the complete status, and when i try to pull up data in the pivot table it doesn’t show values (no value found).


Charles Emmanuel Willer
12,Lilavois 50 Croix des Bouquets, HT
Tels: +509-3842-3854 / +509-3270-0655
Skype: emmanuelwiller
emmanuelwiller@gmail.com
emmanuelwiller@yahoo.com


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


Charles Emmanuel Willer
12,Lilavois 50 Croix des Bouquets, HT
Tels: +509-3842-3854 / +509-3270-0655
Skype: emmanuelwiller
emmanuelwiller@gmail.com
emmanuelwiller@yahoo.com

Hi Emmanuel,

first try to go to data administration > maintenance > generate category option combos and go. Then try running analytics again.

If that does not help, please chech whether you have any categories without any category options. If so remove them.

Let us know how it goes.

regards,

Lars

···

On Wed, Feb 5, 2014 at 10:47 PM, Emmanuel Willer CHARLES emmanuelwiller@gmail.com wrote:

it is surely for test.

i tried to run resource table

i have the attached error message.


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

On Wed, Feb 5, 2014 at 2:19 PM, Knut Staring knutst@gmail.com wrote:

I think the relevant file is tomcat7-stdout.2014-02-05.log. I see you are running on Windows 7, is that just for testing on your laptop or is it meant to be a server?

Below is the last part of the log, which seems to show a problem with categories. Others should have more insight on this, but you could try going to Maintenance → Data Administration → Resource Table and click on Generate Table.


  • INFO 2014-02-05 15:03:10,491 Version: 3.5.3 (Service.java [taskScheduler-1])
  • INFO 2014-02-05 15:03:10,491 JRE Version: 1.7.0_40 (Service.java [taskScheduler-1])
  • INFO 2014-02-05 15:03:10,491 JRE Impl Version: 24.0-b56 (Service.java [taskScheduler-1])
  • INFO 2014-02-05 15:03:10,491 O/S: Windows 7 / amd64 / 6.1 (Service.java [taskScheduler-1])
  • ERROR 2014-02-05 15:03:10,501 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-1])

java.lang.ArrayIndexOutOfBoundsException: 0

at org.hisp.dhis.common.CombinationGenerator.getCurrent(CombinationGenerator.java:124)

at org.hisp.dhis.common.CombinationGenerator.getNext(CombinationGenerator.java:98)

at org.hisp.dhis.dataelement.DataElementCategoryCombo.getSortedOptionCombos(DataElementCategoryCombo.java:171)

at org.hisp.dhis.resourcetable.DefaultResourceTableService.generateCategoryOptionComboNames(DefaultResourceTableService.java:206)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

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

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

at java.lang.reflect.Method.invoke(Unknown Source)


Charles Emmanuel Willer
12,Lilavois 50 Croix des Bouquets, HT
Tels: +509-3842-3854 / +509-3270-0655
Skype: emmanuelwiller
emmanuelwiller@gmail.com
emmanuelwiller@yahoo.com

On Wed, Feb 5, 2014 at 9:05 PM, Emmanuel Willer CHARLES emmanuelwiller@gmail.com wrote:

ok. i send all files found in the logs folder.

Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

On Wed, Feb 5, 2014 at 1:34 PM, Knut Staring knutst@gmail.com wrote:

Fine. But the most important is your Tomcat log file.

Sent from my mobile

On 5 Feb 2014 20:33, “Emmanuel Willer CHARLES” emmanuelwiller@gmail.com wrote:

Hi Knut,

here are the requested information.

version 2.13

build number: 12941.

thanks


Charles Emmanuel Willer
12,Lilavois 50 Croix des Bouquets, HT
Tels: +509-3842-3854 / +509-3270-0655
Skype: emmanuelwiller
emmanuelwiller@gmail.com
emmanuelwiller@yahoo.com

On Wed, Feb 5, 2014 at 1:31 PM, Knut Staring knutst@gmail.com wrote:

Hi Emmanuel, pls let us know the version and build number, and share your log file.

Sent from my mobile

On 5 Feb 2014 17:43, “Emmanuel Willer CHARLES” emmanuelwiller@gmail.com wrote:

Hello Guys
I think I need a little help out there. everything is set up, and I completed few forms in data entry for some months and org units, when running dataset reports, we can see the data is stored.

scheduling is started, when I run analytic reports it takes a while in showing the working/progress bar, but doesn’t give the complete status, and when i try to pull up data in the pivot table it doesn’t show values (no value found).


Charles Emmanuel Willer
12,Lilavois 50 Croix des Bouquets, HT
Tels: +509-3842-3854 / +509-3270-0655
Skype: emmanuelwiller
emmanuelwiller@gmail.com
emmanuelwiller@yahoo.com


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


Charles Emmanuel Willer
12,Lilavois 50 Croix des Bouquets, HT
Tels: +509-3842-3854 / +509-3270-0655
Skype: emmanuelwiller
emmanuelwiller@gmail.com
emmanuelwiller@yahoo.com

Hi all,

you were all right, it was a problem with category and category combination thank you all.

now that the problem is solve i can take the time to tackle another issue. that you all are going to be in copy.

···

On Thu, Feb 6, 2014 at 2:18 AM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Emmanuel,

first try to go to data administration > maintenance > generate category option combos and go. Then try running analytics again.

If that does not help, please chech whether you have any categories without any category options. If so remove them.

Let us know how it goes.

regards,

Lars

On Feb 5, 2014 11:13 PM, “Knut Staring” knutst@gmail.com wrote:

.My guess is a problem with your categoryoptioncombos, but again, whenever there is an error, please share the (same) log file. Perhaps someone has time to have a look at your db, though if you don’t have much in it yet, it could be advisable to start a fresh (just create a new empty db and point to that one in hibernate.properties)


Charles Emmanuel Willer
12,Lilavois 50 Croix des Bouquets, HT
Tels: +509-3842-3854 / +509-3270-0655
Skype: emmanuelwiller
emmanuelwiller@gmail.com
emmanuelwiller@yahoo.com

On Wed, Feb 5, 2014 at 10:47 PM, Emmanuel Willer CHARLES emmanuelwiller@gmail.com wrote:

it is surely for test.

i tried to run resource table

i have the attached error message.


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

On Wed, Feb 5, 2014 at 2:19 PM, Knut Staring knutst@gmail.com wrote:

I think the relevant file is tomcat7-stdout.2014-02-05.log. I see you are running on Windows 7, is that just for testing on your laptop or is it meant to be a server?

Below is the last part of the log, which seems to show a problem with categories. Others should have more insight on this, but you could try going to Maintenance → Data Administration → Resource Table and click on Generate Table.


  • INFO 2014-02-05 15:03:10,491 Version: 3.5.3 (Service.java [taskScheduler-1])
  • INFO 2014-02-05 15:03:10,491 JRE Version: 1.7.0_40 (Service.java [taskScheduler-1])
  • INFO 2014-02-05 15:03:10,491 JRE Impl Version: 24.0-b56 (Service.java [taskScheduler-1])
  • INFO 2014-02-05 15:03:10,491 O/S: Windows 7 / amd64 / 6.1 (Service.java [taskScheduler-1])
  • ERROR 2014-02-05 15:03:10,501 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-1])

java.lang.ArrayIndexOutOfBoundsException: 0

at org.hisp.dhis.common.CombinationGenerator.getCurrent(CombinationGenerator.java:124)

at org.hisp.dhis.common.CombinationGenerator.getNext(CombinationGenerator.java:98)

at org.hisp.dhis.dataelement.DataElementCategoryCombo.getSortedOptionCombos(DataElementCategoryCombo.java:171)

at org.hisp.dhis.resourcetable.DefaultResourceTableService.generateCategoryOptionComboNames(DefaultResourceTableService.java:206)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

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

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

at java.lang.reflect.Method.invoke(Unknown Source)


Charles Emmanuel Willer
12,Lilavois 50 Croix des Bouquets, HT
Tels: +509-3842-3854 / +509-3270-0655
Skype: emmanuelwiller
emmanuelwiller@gmail.com
emmanuelwiller@yahoo.com

On Wed, Feb 5, 2014 at 9:05 PM, Emmanuel Willer CHARLES emmanuelwiller@gmail.com wrote:

ok. i send all files found in the logs folder.

Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

On Wed, Feb 5, 2014 at 1:34 PM, Knut Staring knutst@gmail.com wrote:

Fine. But the most important is your Tomcat log file.

Sent from my mobile

On 5 Feb 2014 20:33, “Emmanuel Willer CHARLES” emmanuelwiller@gmail.com wrote:

Hi Knut,

here are the requested information.

version 2.13

build number: 12941.

thanks


Charles Emmanuel Willer
12,Lilavois 50 Croix des Bouquets, HT
Tels: +509-3842-3854 / +509-3270-0655
Skype: emmanuelwiller
emmanuelwiller@gmail.com
emmanuelwiller@yahoo.com

On Wed, Feb 5, 2014 at 1:31 PM, Knut Staring knutst@gmail.com wrote:

Hi Emmanuel, pls let us know the version and build number, and share your log file.

Sent from my mobile

On 5 Feb 2014 17:43, “Emmanuel Willer CHARLES” emmanuelwiller@gmail.com wrote:

Hello Guys
I think I need a little help out there. everything is set up, and I completed few forms in data entry for some months and org units, when running dataset reports, we can see the data is stored.

scheduling is started, when I run analytic reports it takes a while in showing the working/progress bar, but doesn’t give the complete status, and when i try to pull up data in the pivot table it doesn’t show values (no value found).


Charles Emmanuel Willer
12,Lilavois 50 Croix des Bouquets, HT
Tels: +509-3842-3854 / +509-3270-0655
Skype: emmanuelwiller
emmanuelwiller@gmail.com
emmanuelwiller@yahoo.com


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


Charles Emmanuel Willer
12,Lilavois 50 Croix des Bouquets, HT
Tels: +509-3842-3854 / +509-3270-0655
Skype: emmanuelwiller
emmanuelwiller@gmail.com
emmanuelwiller@yahoo.com

Hi,

could you please tell us if it was the first (option combos) or second problem (missing options) that caused it? We could make a check for this to prevent it happening.

Lars

···

On Thu, Feb 6, 2014 at 5:21 PM, Emmanuel Willer CHARLES emmanuelwiller@gmail.com wrote:

Hi all,

you were all right, it was a problem with category and category combination thank you all.

now that the problem is solve i can take the time to tackle another issue. that you all are going to be in copy.

On Thu, Feb 6, 2014 at 2:18 AM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Emmanuel,

first try to go to data administration > maintenance > generate category option combos and go. Then try running analytics again.

If that does not help, please chech whether you have any categories without any category options. If so remove them.

Let us know how it goes.

regards,

Lars

On Feb 5, 2014 11:13 PM, “Knut Staring” knutst@gmail.com wrote:

.My guess is a problem with your categoryoptioncombos, but again, whenever there is an error, please share the (same) log file. Perhaps someone has time to have a look at your db, though if you don’t have much in it yet, it could be advisable to start a fresh (just create a new empty db and point to that one in hibernate.properties)


Charles Emmanuel Willer
12,Lilavois 50 Croix des Bouquets, HT
Tels: +509-3842-3854 / +509-3270-0655
Skype: emmanuelwiller
emmanuelwiller@gmail.com
emmanuelwiller@yahoo.com

On Wed, Feb 5, 2014 at 10:47 PM, Emmanuel Willer CHARLES emmanuelwiller@gmail.com wrote:

it is surely for test.

i tried to run resource table

i have the attached error message.


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

On Wed, Feb 5, 2014 at 2:19 PM, Knut Staring knutst@gmail.com wrote:

I think the relevant file is tomcat7-stdout.2014-02-05.log. I see you are running on Windows 7, is that just for testing on your laptop or is it meant to be a server?

Below is the last part of the log, which seems to show a problem with categories. Others should have more insight on this, but you could try going to Maintenance → Data Administration → Resource Table and click on Generate Table.


  • INFO 2014-02-05 15:03:10,491 Version: 3.5.3 (Service.java [taskScheduler-1])
  • INFO 2014-02-05 15:03:10,491 JRE Version: 1.7.0_40 (Service.java [taskScheduler-1])
  • INFO 2014-02-05 15:03:10,491 JRE Impl Version: 24.0-b56 (Service.java [taskScheduler-1])
  • INFO 2014-02-05 15:03:10,491 O/S: Windows 7 / amd64 / 6.1 (Service.java [taskScheduler-1])
  • ERROR 2014-02-05 15:03:10,501 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-1])

java.lang.ArrayIndexOutOfBoundsException: 0

at org.hisp.dhis.common.CombinationGenerator.getCurrent(CombinationGenerator.java:124)

at org.hisp.dhis.common.CombinationGenerator.getNext(CombinationGenerator.java:98)

at org.hisp.dhis.dataelement.DataElementCategoryCombo.getSortedOptionCombos(DataElementCategoryCombo.java:171)

at org.hisp.dhis.resourcetable.DefaultResourceTableService.generateCategoryOptionComboNames(DefaultResourceTableService.java:206)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

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

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

at java.lang.reflect.Method.invoke(Unknown Source)


Charles Emmanuel Willer
12,Lilavois 50 Croix des Bouquets, HT
Tels: +509-3842-3854 / +509-3270-0655
Skype: emmanuelwiller
emmanuelwiller@gmail.com
emmanuelwiller@yahoo.com

On Wed, Feb 5, 2014 at 9:05 PM, Emmanuel Willer CHARLES emmanuelwiller@gmail.com wrote:

ok. i send all files found in the logs folder.

Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

On Wed, Feb 5, 2014 at 1:34 PM, Knut Staring knutst@gmail.com wrote:

Fine. But the most important is your Tomcat log file.

Sent from my mobile

On 5 Feb 2014 20:33, “Emmanuel Willer CHARLES” emmanuelwiller@gmail.com wrote:

Hi Knut,

here are the requested information.

version 2.13

build number: 12941.

thanks


Charles Emmanuel Willer
12,Lilavois 50 Croix des Bouquets, HT
Tels: +509-3842-3854 / +509-3270-0655
Skype: emmanuelwiller
emmanuelwiller@gmail.com
emmanuelwiller@yahoo.com

On Wed, Feb 5, 2014 at 1:31 PM, Knut Staring knutst@gmail.com wrote:

Hi Emmanuel, pls let us know the version and build number, and share your log file.

Sent from my mobile

On 5 Feb 2014 17:43, “Emmanuel Willer CHARLES” emmanuelwiller@gmail.com wrote:

Hello Guys
I think I need a little help out there. everything is set up, and I completed few forms in data entry for some months and org units, when running dataset reports, we can see the data is stored.

scheduling is started, when I run analytic reports it takes a while in showing the working/progress bar, but doesn’t give the complete status, and when i try to pull up data in the pivot table it doesn’t show values (no value found).


Charles Emmanuel Willer
12,Lilavois 50 Croix des Bouquets, HT
Tels: +509-3842-3854 / +509-3270-0655
Skype: emmanuelwiller
emmanuelwiller@gmail.com
emmanuelwiller@yahoo.com


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


Charles Emmanuel Willer
12,Lilavois 50 Croix des Bouquets, HT
Tels: +509-3842-3854 / +509-3270-0655
Skype: emmanuelwiller
emmanuelwiller@gmail.com
emmanuelwiller@yahoo.com

we created a category combination A which depends on two categories x;y, where x and y had category options, then we deleted the options that were in y in category options management. so y category became void (without options). to solve the problem, we simply deleted the category y.

i hope the explanation is clear.

···

On Thu, Feb 6, 2014 at 11:31 AM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi,

could you please tell us if it was the first (option combos) or second problem (missing options) that caused it? We could make a check for this to prevent it happening.

Lars


Charles Emmanuel Willer
12,Lilavois 50 Croix des Bouquets, HT
Tels: +509-3842-3854 / +509-3270-0655
Skype: emmanuelwiller
emmanuelwiller@gmail.com
emmanuelwiller@yahoo.com

On Thu, Feb 6, 2014 at 5:21 PM, Emmanuel Willer CHARLES emmanuelwiller@gmail.com wrote:

Hi all,

you were all right, it was a problem with category and category combination thank you all.

now that the problem is solve i can take the time to tackle another issue. that you all are going to be in copy.

On Thu, Feb 6, 2014 at 2:18 AM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Emmanuel,

first try to go to data administration > maintenance > generate category option combos and go. Then try running analytics again.

If that does not help, please chech whether you have any categories without any category options. If so remove them.

Let us know how it goes.

regards,

Lars

On Feb 5, 2014 11:13 PM, “Knut Staring” knutst@gmail.com wrote:

.My guess is a problem with your categoryoptioncombos, but again, whenever there is an error, please share the (same) log file. Perhaps someone has time to have a look at your db, though if you don’t have much in it yet, it could be advisable to start a fresh (just create a new empty db and point to that one in hibernate.properties)


Charles Emmanuel Willer
12,Lilavois 50 Croix des Bouquets, HT
Tels: +509-3842-3854 / +509-3270-0655
Skype: emmanuelwiller
emmanuelwiller@gmail.com
emmanuelwiller@yahoo.com

On Wed, Feb 5, 2014 at 10:47 PM, Emmanuel Willer CHARLES emmanuelwiller@gmail.com wrote:

it is surely for test.

i tried to run resource table

i have the attached error message.


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

On Wed, Feb 5, 2014 at 2:19 PM, Knut Staring knutst@gmail.com wrote:

I think the relevant file is tomcat7-stdout.2014-02-05.log. I see you are running on Windows 7, is that just for testing on your laptop or is it meant to be a server?

Below is the last part of the log, which seems to show a problem with categories. Others should have more insight on this, but you could try going to Maintenance → Data Administration → Resource Table and click on Generate Table.


  • INFO 2014-02-05 15:03:10,491 Version: 3.5.3 (Service.java [taskScheduler-1])
  • INFO 2014-02-05 15:03:10,491 JRE Version: 1.7.0_40 (Service.java [taskScheduler-1])
  • INFO 2014-02-05 15:03:10,491 JRE Impl Version: 24.0-b56 (Service.java [taskScheduler-1])
  • INFO 2014-02-05 15:03:10,491 O/S: Windows 7 / amd64 / 6.1 (Service.java [taskScheduler-1])
  • ERROR 2014-02-05 15:03:10,501 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-1])

java.lang.ArrayIndexOutOfBoundsException: 0

at org.hisp.dhis.common.CombinationGenerator.getCurrent(CombinationGenerator.java:124)

at org.hisp.dhis.common.CombinationGenerator.getNext(CombinationGenerator.java:98)

at org.hisp.dhis.dataelement.DataElementCategoryCombo.getSortedOptionCombos(DataElementCategoryCombo.java:171)

at org.hisp.dhis.resourcetable.DefaultResourceTableService.generateCategoryOptionComboNames(DefaultResourceTableService.java:206)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

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

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

at java.lang.reflect.Method.invoke(Unknown Source)


Charles Emmanuel Willer
12,Lilavois 50 Croix des Bouquets, HT
Tels: +509-3842-3854 / +509-3270-0655
Skype: emmanuelwiller
emmanuelwiller@gmail.com
emmanuelwiller@yahoo.com

On Wed, Feb 5, 2014 at 9:05 PM, Emmanuel Willer CHARLES emmanuelwiller@gmail.com wrote:

ok. i send all files found in the logs folder.

Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

On Wed, Feb 5, 2014 at 1:34 PM, Knut Staring knutst@gmail.com wrote:

Fine. But the most important is your Tomcat log file.

Sent from my mobile

On 5 Feb 2014 20:33, “Emmanuel Willer CHARLES” emmanuelwiller@gmail.com wrote:

Hi Knut,

here are the requested information.

version 2.13

build number: 12941.

thanks


Charles Emmanuel Willer
12,Lilavois 50 Croix des Bouquets, HT
Tels: +509-3842-3854 / +509-3270-0655
Skype: emmanuelwiller
emmanuelwiller@gmail.com
emmanuelwiller@yahoo.com

On Wed, Feb 5, 2014 at 1:31 PM, Knut Staring knutst@gmail.com wrote:

Hi Emmanuel, pls let us know the version and build number, and share your log file.

Sent from my mobile

On 5 Feb 2014 17:43, “Emmanuel Willer CHARLES” emmanuelwiller@gmail.com wrote:

Hello Guys
I think I need a little help out there. everything is set up, and I completed few forms in data entry for some months and org units, when running dataset reports, we can see the data is stored.

scheduling is started, when I run analytic reports it takes a while in showing the working/progress bar, but doesn’t give the complete status, and when i try to pull up data in the pivot table it doesn’t show values (no value found).


Charles Emmanuel Willer
12,Lilavois 50 Croix des Bouquets, HT
Tels: +509-3842-3854 / +509-3270-0655
Skype: emmanuelwiller
emmanuelwiller@gmail.com
emmanuelwiller@yahoo.com


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


Charles Emmanuel Willer
12,Lilavois 50 Croix des Bouquets, HT
Tels: +509-3842-3854 / +509-3270-0655
Skype: emmanuelwiller
emmanuelwiller@gmail.com
emmanuelwiller@yahoo.com

That is perfectly clear. We will add in a log message to make it more apparent what is going on in this case.

Lars

···

On Thu, Feb 6, 2014 at 7:56 PM, Emmanuel Willer CHARLES emmanuelwiller@gmail.com wrote:

we created a category combination A which depends on two categories x;y, where x and y had category options, then we deleted the options that were in y in category options management. so y category became void (without options). to solve the problem, we simply deleted the category y.

i hope the explanation is clear.

On Thu, Feb 6, 2014 at 11:31 AM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi,

could you please tell us if it was the first (option combos) or second problem (missing options) that caused it? We could make a check for this to prevent it happening.

Lars


Charles Emmanuel Willer
12,Lilavois 50 Croix des Bouquets, HT
Tels: +509-3842-3854 / +509-3270-0655
Skype: emmanuelwiller
emmanuelwiller@gmail.com
emmanuelwiller@yahoo.com

On Thu, Feb 6, 2014 at 5:21 PM, Emmanuel Willer CHARLES emmanuelwiller@gmail.com wrote:

Hi all,

you were all right, it was a problem with category and category combination thank you all.

now that the problem is solve i can take the time to tackle another issue. that you all are going to be in copy.

On Thu, Feb 6, 2014 at 2:18 AM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Emmanuel,

first try to go to data administration > maintenance > generate category option combos and go. Then try running analytics again.

If that does not help, please chech whether you have any categories without any category options. If so remove them.

Let us know how it goes.

regards,

Lars

On Feb 5, 2014 11:13 PM, “Knut Staring” knutst@gmail.com wrote:

.My guess is a problem with your categoryoptioncombos, but again, whenever there is an error, please share the (same) log file. Perhaps someone has time to have a look at your db, though if you don’t have much in it yet, it could be advisable to start a fresh (just create a new empty db and point to that one in hibernate.properties)


Charles Emmanuel Willer
12,Lilavois 50 Croix des Bouquets, HT
Tels: +509-3842-3854 / +509-3270-0655
Skype: emmanuelwiller
emmanuelwiller@gmail.com
emmanuelwiller@yahoo.com

On Wed, Feb 5, 2014 at 10:47 PM, Emmanuel Willer CHARLES emmanuelwiller@gmail.com wrote:

it is surely for test.

i tried to run resource table

i have the attached error message.


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

On Wed, Feb 5, 2014 at 2:19 PM, Knut Staring knutst@gmail.com wrote:

I think the relevant file is tomcat7-stdout.2014-02-05.log. I see you are running on Windows 7, is that just for testing on your laptop or is it meant to be a server?

Below is the last part of the log, which seems to show a problem with categories. Others should have more insight on this, but you could try going to Maintenance → Data Administration → Resource Table and click on Generate Table.


  • INFO 2014-02-05 15:03:10,491 Version: 3.5.3 (Service.java [taskScheduler-1])
  • INFO 2014-02-05 15:03:10,491 JRE Version: 1.7.0_40 (Service.java [taskScheduler-1])
  • INFO 2014-02-05 15:03:10,491 JRE Impl Version: 24.0-b56 (Service.java [taskScheduler-1])
  • INFO 2014-02-05 15:03:10,491 O/S: Windows 7 / amd64 / 6.1 (Service.java [taskScheduler-1])
  • ERROR 2014-02-05 15:03:10,501 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-1])

java.lang.ArrayIndexOutOfBoundsException: 0

at org.hisp.dhis.common.CombinationGenerator.getCurrent(CombinationGenerator.java:124)

at org.hisp.dhis.common.CombinationGenerator.getNext(CombinationGenerator.java:98)

at org.hisp.dhis.dataelement.DataElementCategoryCombo.getSortedOptionCombos(DataElementCategoryCombo.java:171)

at org.hisp.dhis.resourcetable.DefaultResourceTableService.generateCategoryOptionComboNames(DefaultResourceTableService.java:206)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

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

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

at java.lang.reflect.Method.invoke(Unknown Source)


Charles Emmanuel Willer
12,Lilavois 50 Croix des Bouquets, HT
Tels: +509-3842-3854 / +509-3270-0655
Skype: emmanuelwiller
emmanuelwiller@gmail.com
emmanuelwiller@yahoo.com

On Wed, Feb 5, 2014 at 9:05 PM, Emmanuel Willer CHARLES emmanuelwiller@gmail.com wrote:

ok. i send all files found in the logs folder.

Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

On Wed, Feb 5, 2014 at 1:34 PM, Knut Staring knutst@gmail.com wrote:

Fine. But the most important is your Tomcat log file.

Sent from my mobile

On 5 Feb 2014 20:33, “Emmanuel Willer CHARLES” emmanuelwiller@gmail.com wrote:

Hi Knut,

here are the requested information.

version 2.13

build number: 12941.

thanks


Charles Emmanuel Willer
12,Lilavois 50 Croix des Bouquets, HT
Tels: +509-3842-3854 / +509-3270-0655
Skype: emmanuelwiller
emmanuelwiller@gmail.com
emmanuelwiller@yahoo.com

On Wed, Feb 5, 2014 at 1:31 PM, Knut Staring knutst@gmail.com wrote:

Hi Emmanuel, pls let us know the version and build number, and share your log file.

Sent from my mobile

On 5 Feb 2014 17:43, “Emmanuel Willer CHARLES” emmanuelwiller@gmail.com wrote:

Hello Guys
I think I need a little help out there. everything is set up, and I completed few forms in data entry for some months and org units, when running dataset reports, we can see the data is stored.

scheduling is started, when I run analytic reports it takes a while in showing the working/progress bar, but doesn’t give the complete status, and when i try to pull up data in the pivot table it doesn’t show values (no value found).


Charles Emmanuel Willer
12,Lilavois 50 Croix des Bouquets, HT
Tels: +509-3842-3854 / +509-3270-0655
Skype: emmanuelwiller
emmanuelwiller@gmail.com
emmanuelwiller@yahoo.com


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


Charles Emmanuel Willer
12,Lilavois 50 Croix des Bouquets, HT
Tels: +509-3842-3854 / +509-3270-0655
Skype: emmanuelwiller
emmanuelwiller@gmail.com
emmanuelwiller@yahoo.com