← Back to team overview

dhis2-users team mailing list archive

Resource Table generation Problem

 

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:15018Database type: Mysql
OS name:Windows 7OS architecture:x86
ganisationUnitGroup, name: Provinces, uid: pxr6w2RpXng (AuditLogUtil.java [http-
apr-8084-exec-9])
* INFO  2014-05-09 10:20:44,034 [Level: INFO, category: RESOURCETABLE_UPDATE, ti
me: Fri May 09 10:20:44 IST 2014, message: Generating resource tables] (InMemory
Notifier.java [taskScheduler-3])
* INFO  2014-05-09 10:20:44,090 Create organisation unit structure table SQL: CR
EATE TABLE _orgunitstructure ( organisationunitid INTEGER NOT NULL PRIMARY KEY,
organisationunituid CHARACTER(11), level INTEGER, `idlevel1` INTEGER, `uidlevel1
` CHARACTER(11), `idlevel2` INTEGER, `uidlevel2` CHARACTER(11), `idlevel3` INTEG
ER, `uidlevel3` CHARACTER(11), `idlevel4` INTEGER, `uidlevel4` CHARACTER(11)); (
JdbcResourceTableStore.java [taskScheduler-3])
* INFO  2014-05-09 10:20:44,761 Organisation unit structure table generated (Def
aultResourceTableService.java [taskScheduler-3])
* INFO  2014-05-09 10:20:45,071 Create category option combo name table SQL: CRE
ATE TABLE _categoryoptioncomboname ( categoryoptioncomboid INTEGER NOT NULL PRIM
ARY KEY, categoryoptioncomboname VARCHAR(250) ) (JdbcResourceTableStore.java [ta
skScheduler-3])
* INFO  2014-05-09 10:20:45,317 Category option combo name table generated (Defa
ultResourceTableService.java [taskScheduler-3])
* INFO  2014-05-09 10:20:45,511 Create category option group set table SQL: CREA
TE TABLE _categoryoptiongroupsetstructure ( categoryoptioncomboid INTEGER NOT NU
LL, PRIMARY KEY ( categoryoptioncomboid ) ) (CreateCategoryOptionGroupSetTableSt
atement.java [taskScheduler-3])
* INFO  2014-05-09 10:20:45,747 Category option group set table generated (Defau
ltResourceTableService.java [taskScheduler-3])
* INFO  2014-05-09 10:20:46,043 Create data element group set table SQL: CREATE
TABLE _dataelementgroupsetstructure ( dataelementid INTEGER NOT NULL, dataelemen
tname VARCHAR (250), PRIMARY KEY ( dataelementid ) ) (CreateDataElementGroupSetT
ableStatement.java [taskScheduler-3])
* INFO  2014-05-09 10:20:46,211 Populate data element group set structure SQL: i
nsert into _dataelementgroupsetstructure select d.dataelementid as dataelementid
, d.name as dataelementname from dataelement d (JdbcResourceTableStore.java [tas
kScheduler-3])
* INFO  2014-05-09 10:20:46,215 Data element group set table generated (DefaultR
esourceTableService.java [taskScheduler-3])
* INFO  2014-05-09 10:20:46,466 Create indicator group set table SQL: CREATE TAB
LE _indicatorgroupsetstructure ( indicatorid INTEGER NOT NULL, indicatorname VAR
CHAR (250), PRIMARY KEY ( indicatorid ) ) (CreateIndicatorGroupSetTableStatement
.java [taskScheduler-3])
* INFO  2014-05-09 10:20:46,599 Populate indicator group set structure SQL: inse
rt into _indicatorgroupsetstructure select i.indicatorid as indicatorid, i.name
as indicatorname from indicator i (JdbcResourceTableStore.java [taskScheduler-3]
)
* INFO  2014-05-09 10:20:46,601 Indicator group set table generated (DefaultReso
urceTableService.java [taskScheduler-3])
* INFO  2014-05-09 10:20:46,672 Create organisation unit group set table SQL: CR
EATE TABLE _organisationunitgroupsetstructure ( organisationunitid INTEGER NOT N
ULL, organisationunitname VARCHAR (250), PRIMARY KEY ( organisationunitid ) ) (C
reateOrganisationUnitGroupSetTableStatement.java [taskScheduler-3])
* INFO  2014-05-09 10:20:46,820 Populate organisation unit group set structure S
QL: insert into _organisationunitgroupsetstructure select ou.organisationunitid
as organisationunitid, ou.name as organisationunitname from organisationunit ou
(JdbcResourceTableStore.java [taskScheduler-3])
* INFO  2014-05-09 10:20:46,823 Organisation unit group set table generated (Def
aultResourceTableService.java [taskScheduler-3])
* INFO  2014-05-09 10:20:46,912 Create category structure table SQL: CREATE TABL
E _categorystructure ( categoryoptioncomboid INTEGER NOT NULL, categoryoptioncom
boname VARCHAR (250), `Age` VARCHAR (250), `h7wuBGjBiNI` CHARACTER(11), `default
` VARCHAR (250), `rzWfcGBWIWO` CHARACTER(11), `Gender` VARCHAR (250), `fWhBa2DRc
Z3` CHARACTER(11), PRIMARY KEY ( categoryoptioncomboid ) ) (CreateCategoryTableS
tatement.java [taskScheduler-3])
* INFO  2014-05-09 10:20:47,135 Category table generated (DefaultResourceTableSe
rvice.java [taskScheduler-3])
* INFO  2014-05-09 10:20:47,221 Create data element structure SQL: CREATE TABLE
_dataelementstructure ( dataelementid INTEGER NOT NULL PRIMARY KEY, dataelementu
id CHARACTER(11), dataelementname VARCHAR(250), datasetid INTEGER, datasetuid CH
ARACTER(11), datasetname VARCHAR(250), periodtypeid INTEGER, periodtypename VARC
HAR(250) ) (JdbcResourceTableStore.java [taskScheduler-3])
* INFO  2014-05-09 10:20:49,770 Data element table generated (DefaultResourceTab
leService.java [taskScheduler-3])
* INFO  2014-05-09 10:20:49,926 Create period structure SQL: CREATE TABLE _perio
dstructure (periodid INTEGER NOT NULL PRIMARY KEY, iso VARCHAR(15) NOT NULL, day
sno INTEGER NOT NULL, `daily` VARCHAR(15), `weekly` VARCHAR(15), `monthly` VARCH
AR(15), `bimonthly` VARCHAR(15), `quarterly` VARCHAR(15), `sixmonthly` VARCHAR(1
5), `sixmonthlyapril` VARCHAR(15), `yearly` VARCHAR(15), `financialapril` VARCHA
R(15), `financialjuly` VARCHAR(15), `financialoct` VARCHAR(15)) (JdbcResourceTab
leStore.java [taskScheduler-3])
* INFO  2014-05-09 10:20:50,653 Date period table generated (DefaultResourceTabl
eService.java [taskScheduler-3])
* INFO  2014-05-09 10:20:50,656 Create date period structure SQL: CREATE TABLE _
dateperiodstructure (dateperiod DATE NOT NULL PRIMARY KEY, `daily` VARCHAR(15),
`weekly` VARCHAR(15), `monthly` VARCHAR(15), `bimonthly` VARCHAR(15), `quarterly
` VARCHAR(15), `sixmonthly` VARCHAR(15), `sixmonthlyapril` VARCHAR(15), `yearly`
 VARCHAR(15), `financialapril` VARCHAR(15), `financialjuly` VARCHAR(15), `financ
ialoct` VARCHAR(15)) (JdbcResourceTableStore.java [taskScheduler-3])
* INFO  2014-05-09 10:20:58,599 Period table generated (DefaultResourceTableServ
ice.java [taskScheduler-3])
* INFO  2014-05-09 10:20:58,818 Create data element category option combo SQL: C
REATE TABLE _dataelementcategoryoptioncombo (dataelementuid VARCHAR(11) NOT NULL
, categoryoptioncombouid VARCHAR(11) NOT NULL) (JdbcResourceTableStore.java [tas
kScheduler-3])
* INFO  2014-05-09 10:20:58,818 Insert data element category option combo SQL: i
nsert into _dataelementcategoryoptioncombo (dataelementuid, categoryoptioncombou
id) select de.uid as dataelementuid, coc.uid as categoryoptioncombouid from data
element de join categorycombos_optioncombos cc on de.categorycomboid = cc.catego
rycomboid join categoryoptioncombo coc on cc.categoryoptioncomboid = coc.categor
yoptioncomboid (JdbcResourceTableStore.java [taskScheduler-3])
* INFO  2014-05-09 10:20:58,838 Create data element category option combo index
SQL: CREATE INDEX dataelement_categoryoptioncombo ON _dataelementcategoryoptionc
ombo (dataelementuid, categoryoptioncombouid) (JdbcResourceTableStore.java [task
Scheduler-3])
* INFO  2014-05-09 10:20:59,885 Data element category option combo table generat
ed (DefaultResourceTableService.java [taskScheduler-3])
* INFO  2014-05-09 10:20:59,887 [Level: INFO, category: RESOURCETABLE_UPDATE, ti
me: Fri May 09 10:20:59 IST 2014, message: Resource tables generated] (InMemoryN
otifier.java [taskScheduler-3])
* INFO  2014-05-09 10:45:50,395 'admin' create org.hisp.dhis.dataelement.DataEle
mentGroup, name: ICD10 diagnosis, uid: NMa4KIDHw8a (AuditLogUtil.java [http-apr-
8084-exec-2])
* INFO  2014-05-09 10:47:22,773 'admin' create org.hisp.dhis.dataelement.DataEle
mentGroup, name: ICD 10 PCV_5 Diagnosis, uid: uITlu6wsFhe (AuditLogUtil.java [ht
tp-apr-8084-exec-5])
* INFO  2014-05-09 10:53:15,656 'admin' create org.hisp.dhis.dataelement.DataEle
mentGroup, name: #F00dementiaDEG, uid: nUSbNaHT6qf (AuditLogUtil.java [http-apr-
8084-exec-10])
* INFO  2014-05-09 10:55:40,192 'admin' create org.hisp.dhis.dataelement.DataEle
ment, name: F00 Dementia in Alzheimer's disease, uid: kvEJsN2he01 (AuditLogUtil.
java [http-apr-8084-exec-10])
* INFO  2014-05-09 10:55:40,268 'admin' update org.hisp.dhis.dataelement.DataEle
ment, name: F00 Dementia in Alzheimer's disease, uid: kvEJsN2he01 (AuditLogUtil.
java [http-apr-8084-exec-10])
* INFO  2014-05-09 10:56:36,103 'admin' create org.hisp.dhis.dataelement.DataEle
mentGroup, name: F00 Dementia in Alzheimer's DEG, uid: dg4QfiA75ZG (AuditLogUtil
.java [http-apr-8084-exec-3])
* INFO  2014-05-09 10:58:09,253 'admin' create org.hisp.dhis.dataelement.DataEle
mentGroupSet, name: #F00DementiaDEGS, uid: nTBp3jQbVyU (AuditLogUtil.java [http-
apr-8084-exec-2])
* WARN  2014-05-09 11:03:32,009 baseType was not found, returning. (WebUtils.jav
a [http-apr-8084-exec-2])
* INFO  2014-05-09 11:06:44,075 'admin' create org.hisp.dhis.dataset.DataSet, na
me: MONTHLY RETURN OF MH CLINIC_Ministry , uid: MDZPX4y6zcc (AuditLogUtil.java [
http-apr-8084-exec-3])
* INFO  2014-05-09 11:07:25,149 'admin' update org.hisp.dhis.dataset.DataSet, na
me: MONTHLY RETURN OF MH CLINIC_Ministry , uid: MDZPX4y6zcc (AuditLogUtil.java [
http-apr-8084-exec-1])
* INFO  2014-05-09 11:10:18,113 'admin' update org.hisp.dhis.dataset.DataSet, na
me: MONTHLY RETURN OF MH CLINIC_Ministry , uid: MDZPX4y6zcc (AuditLogUtil.java [
http-apr-8084-exec-8])
* INFO  2014-05-09 11:10:22,055 'admin' update org.hisp.dhis.dataset.DataSet, na
me: MONTHLY RETURN OF MH CLINIC_Ministry , uid: MDZPX4y6zcc (AuditLogUtil.java [
http-apr-8084-exec-5])
* WARN  2014-05-09 11:10:42,911 baseType was not found, returning. (WebUtils.jav
a [http-apr-8084-exec-10])
* INFO  2014-05-09 11:11:43,589 'admin' create org.hisp.dhis.dataset.DataSet, na
me: MONTHLY RETURN OF MH CLINIC_Gampaha, uid: NCSCYgXpGx0 (AuditLogUtil.java [ht
tp-apr-8084-exec-3])
* INFO  2014-05-09 11:12:24,800 'admin' update org.hisp.dhis.dataset.DataSet, na
me: MONTHLY RETURN OF MH CLINIC_Gampaha, uid: NCSCYgXpGx0 (AuditLogUtil.java [ht
tp-apr-8084-exec-1])
* INFO  2014-05-09 11:14:09,907 'admin' update org.hisp.dhis.dataset.DataSet, na
me: MONTHLY RETURN OF MH CLINIC_Gampaha, uid: NCSCYgXpGx0 (AuditLogUtil.java [ht
tp-apr-8084-exec-5])
* INFO  2014-05-09 11:14:57,899 'admin' update org.hisp.dhis.dataset.DataSet, na
me: MONTHLY RETURN OF MH CLINIC_Ministry , uid: MDZPX4y6zcc (AuditLogUtil.java [
http-apr-8084-exec-1])
* INFO  2014-05-09 11:15:43,616 [Level: INFO, category: RESOURCETABLE_UPDATE, ti
me: Fri May 09 11:15:43 IST 2014, message: Generating resource tables] (InMemory
Notifier.java [taskScheduler-4])
* INFO  2014-05-09 11:15:43,736 Create organisation unit structure table SQL: CR
EATE TABLE _orgunitstructure ( organisationunitid INTEGER NOT NULL PRIMARY KEY,
organisationunituid CHARACTER(11), level INTEGER, `idlevel1` INTEGER, `uidlevel1
` CHARACTER(11), `idlevel2` INTEGER, `uidlevel2` CHARACTER(11), `idlevel3` INTEG
ER, `uidlevel3` CHARACTER(11), `idlevel4` INTEGER, `uidlevel4` CHARACTER(11)); (
JdbcResourceTableStore.java [taskScheduler-4])
* INFO  2014-05-09 11:15:44,701 Organisation unit structure table generated (Def
aultResourceTableService.java [taskScheduler-4])
* INFO  2014-05-09 11:15:44,810 Create category option combo name table SQL: CRE
ATE TABLE _categoryoptioncomboname ( categoryoptioncomboid INTEGER NOT NULL PRIM
ARY KEY, categoryoptioncomboname VARCHAR(250) ) (JdbcResourceTableStore.java [ta
skScheduler-4])
* INFO  2014-05-09 11:15:44,950 Category option combo name table generated (Defa
ultResourceTableService.java [taskScheduler-4])
* INFO  2014-05-09 11:15:45,043 Create category option group set table SQL: CREA
TE TABLE _categoryoptiongroupsetstructure ( categoryoptioncomboid INTEGER NOT NU
LL, PRIMARY KEY ( categoryoptioncomboid ) ) (CreateCategoryOptionGroupSetTableSt
atement.java [taskScheduler-4])
* INFO  2014-05-09 11:15:45,167 Category option group set table generated (Defau
ltResourceTableService.java [taskScheduler-4])
* INFO  2014-05-09 11:15:45,256 Create data element group set table SQL: CREATE
TABLE _dataelementgroupsetstructure ( dataelementid INTEGER NOT NULL, dataelemen
tname VARCHAR (250), `#F00DementiaDEGS` VARCHAR (250), `nTBp3jQbVyU` CHARACTER(1
1), PRIMARY KEY ( dataelementid ) ) (CreateDataElementGroupSetTableStatement.jav
a [taskScheduler-4])
* INFO  2014-05-09 11:15:45,398 Populate data element group set structure SQL: i
nsert into _dataelementgroupsetstructure select d.dataelementid as dataelementid
, d.name as dataelementname, (select deg.name from dataelementgroup deg inner jo
in dataelementgroupmembers degm on degm.dataelementgroupid = deg.dataelementgrou
pid and degm.dataelementid = d.dataelementid inner join dataelementgroupsetmembe
rs degsm on degsm.dataelementgroupid = degm.dataelementgroupid and degsm.dataele
mentgroupsetid = 1 limit 1) as `#F00DementiaDEGS`, (select deg.uid from dataelem
entgroup deg inner join dataelementgroupmembers degm on degm.dataelementgroupid
= deg.dataelementgroupid and degm.dataelementid = d.dataelementid inner join dat
aelementgroupsetmembers degsm on degsm.dataelementgroupid = degm.dataelementgrou
pid and degsm.dataelementgroupsetid = 1 limit 1) as `nTBp3jQbVyU` from dataeleme
nt d (JdbcResourceTableStore.java [taskScheduler-4])
* INFO  2014-05-09 11:15:45,402 [Level: ERROR, category: RESOURCETABLE_UPDATE, t
ime: Fri May 09 11:15:45 IST 2014, message: Process failed: StatementCallback; b
ad SQL grammar [insert into _dataelementgroupsetstructure select d.dataelementid
 as dataelementid, d.name as dataelementname, (select deg.name from dataelementg
roup deg inner join dataelementgroupmembers degm on degm.dataelementgroupid = de
g.dataelementgroupid and degm.dataelementid = d.dataelementid inner join dataele
mentgroupsetmembers degsm on degsm.dataelementgroupid = degm.dataelementgroupid
and degsm.dataelementgroupsetid = 1 limit 1) as `#F00DementiaDEGS`, (select deg.
uid from dataelementgroup deg inner join dataelementgroupmembers degm on degm.da
taelementgroupid = deg.dataelementgroupid and degm.dataelementid = d.dataelement
id inner join dataelementgroupsetmembers degsm on degsm.dataelementgroupid = deg
m.dataelementgroupid and degsm.dataelementgroupsetid = 1 limit 1) as `nTBp3jQbVy
U` from dataelement d]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQ
LSyntaxErrorException: Unknown column 'd.dataelementid' in 'on clause'] (InMemor
yNotifier.java [taskScheduler-4])
* ERROR 2014-05-09 11:15:45,444 Unexpected error occurred in scheduled task. (Ta
skUtils.java [taskScheduler-4])
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL gram
mar [insert into _dataelementgroupsetstructure select d.dataelementid as dataele
mentid, d.name as dataelementname, (select deg.name from dataelementgroup deg in
ner join dataelementgroupmembers degm on degm.dataelementgroupid = deg.dataeleme
ntgroupid and degm.dataelementid = d.dataelementid inner join dataelementgroupse
tmembers degsm on degsm.dataelementgroupid = degm.dataelementgroupid and degsm.d
ataelementgroupsetid = 1 limit 1) as `#F00DementiaDEGS`, (select deg.uid from da
taelementgroup deg inner join dataelementgroupmembers degm on degm.dataelementgr
oupid = deg.dataelementgroupid and degm.dataelementid = d.dataelementid inner jo
in dataelementgroupsetmembers degsm on degsm.dataelementgroupid = degm.dataeleme
ntgroupid and degsm.dataelementgroupsetid = 1 limit 1) as `nTBp3jQbVyU` from dat
aelement d]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErro
rException: Unknown column 'd.dataelementid' in 'on clause'
        at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.d
oTranslate(SQLErrorCodeSQLExceptionTranslator.java:237)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslat
or.translate(AbstractFallbackSQLExceptionTranslator.java:72)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:
407)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:
428)
        at org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.populateDataE
lementGroupSetStructure(JdbcResourceTableStore.java:230)
        at org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDataE
lementGroupSetTable(DefaultResourceTableService.java:286)
        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)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:317)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:183)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:150)
        at org.springframework.transaction.interceptor.TransactionInterceptor$1.
proceedWithInvocation(TransactionInterceptor.java:96)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.
invokeWithinTransaction(TransactionAspectSupport.java:260)
        at org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:94)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:172)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:204)
        at $Proxy89.generateDataElementGroupSetTable(Unknown Source)
        at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.generateAll(
ResourceTableTask.java:95)
        at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.run(Resource
TableTask.java:71)
        at org.springframework.scheduling.support.DelegatingErrorHandlingRunnabl
e.run(DelegatingErrorHandlingRunnable.java:53)
        at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
        at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
access$201(Unknown Source)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown co
lumn 'd.dataelementid' in 'on clause'
        at sun.reflect.GeneratedConstructorAccessor71.newInstance(Unknown Source
)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
        at java.lang.reflect.Constructor.newInstance(Unknown Source)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
        at com.mysql.jdbc.Util.getInstance(Util.java:386)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2768)
        at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:894)
        at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:732)
        at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.
java:1006)
        at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.
doInStatement(JdbcTemplate.java:421)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:
396)
        ... 27 more

Attachment: dataelementgroupset.JPG
Description: JPEG image

Attachment: WithOut_dataelementgroupset .JPG
Description: JPEG image


Follow ups