dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #23662
generate resource table error
* ERROR 2013-07-26 17:46:46,431 Error while executing action (ExceptionInterceptor.java [htt
p-apr-8080-exec-2])
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [CREATE
TABLE _dataelementgroupsetstructure ( dataelementid INTEGER NOT NULL, dataelementname VARCHA
R (250), VARCHAR (250), qr7oQXJ4LW9 CHARACTER(11), VARCHAR (250), PVBSMpEIesq CHARACTER(11
), PRIMARY KEY ( dataelementid ) )]; nested exception is org.postgresql.util.PSQLException:
error: 语法错误 在 "(" 或附近的
位置:118
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(S
QLErrorCodeSQLExceptionTranslator.java:237)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.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.createDataElementGroupSet
Structure(JdbcResourceTableStore.java:163)
at org.hisp.dhis.resourcetable.DefaultResourceTableService.generateDataElementGroupS
etTable(DefaultResourceTableService.java:276)
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.invokeJoinpointUsingReflection(AopUtils.
java:317)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(Refl
ectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMe
thodInvocation.java:150)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithI
nvocation(TransactionInterceptor.java:96)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithin
Transaction(TransactionAspectSupport.java:260)
Follow ups