← Back to team overview

dhis2-devs team mailing list archive

Re: generate resource table error

 

Hi easy,

it seems the error message is in chinese (after org.postgresql.util.
PSQLException: error ), hard for me to understand in order to help, any
chance you can translate or provide in English?

regards,

Lars


On Fri, Jul 26, 2013 at 11:57 AM, easy <lin_xd@xxxxxxx> wrote:

> * 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)
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>

Follow ups

References