Resource Table generation Problem

Support - Assistance technique
1

My project is on Mental health infromation system
I want to make Data element group sets to Get all type of “dementia” patient numbers together so,

  • I created dataelents , element group ,group set according to my need

  • Then when i try to generate resource table it gives error in mysql

**ERROR 2014-05-09 11:15:45,444 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-4]) …

nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErro
rException: Unknown column ‘d.dataelementid’ in ‘on clause’** (detail catalina out attach)

  • Then i remove the Data element group sets and it works and produce resource table with out an error.
  • But it is unable to create resource tables with data element group sets.
  • Are there any error in my method ?? or error in program?
    I will attach my log file and screen shot.

I am using
dhis 2.15

Build revision:15018
Database type: Mysql

OS name:Windows 7
OS architecture:x86

resourcs table.txt (19.7 KB)

image

image

2

Dear sumudu Have u updated ur java version ?

···

On Sat, May 10, 2014 at 8:06 PM, sumudu weerasinghe sumuduw00@gmail.com wrote:

My project is on Mental health infromation system
I want to make Data element group sets to Get all type of “dementia” patient numbers together so,

  • I created dataelents , element group ,group set according to my need
  • Then when i try to generate resource table it gives error in mysql

**ERROR 2014-05-09 11:15:45,444 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-4]) …

nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErro
rException: Unknown column ‘d.dataelementid’ in ‘on clause’** (detail catalina out attach)

  • Then i remove the Data element group sets and it works and produce resource table with out an error.
  • But it is unable to create resource tables with data element group sets.
  • Are there any error in my method ?? or error in program?
    I will attach my log file and screen shot.

I am using
dhis 2.15

Build revision:15018
Database type: Mysql

OS name:Windows 7
OS architecture:x86

–

You received this message because you are subscribed to the Google Groups “DHIS_BMI4” group.

To unsubscribe from this group and stop receiving emails from it, send an email to dhis_bmi4+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

–
Gayan Yasantha Piyasena

3

Good day team,

I’m facing the same issue being discussed on this thread. The generation of resources tables is failing with an error message “an unexpected error happened during operation”.

What is the best JDK version upgrade to? I’m currently running version 8.0.2710.9 (64bit) on
DHIS2 Version: 2.35.0
Build revision: 4219a14

What else is recommended for solving this problem?

Thanks,

Innocent.