← Back to team overview

dhis2-users team mailing list archive

Re: Resource Table generation Problem

 

Dear sumudu Have u updated ur java version ?


On Sat, May 10, 2014 at 8:06 PM, sumudu weerasinghe <sumuduw00@xxxxxxxxx>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.MySQLSyntaxErrorException: 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 7OS 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@xxxxxxxxxxxxxxxx.
> For more options, visit https://groups.google.com/d/optout.
>



-- 
Gayan Yasantha Piyasena

References