dhis2-users team mailing list archive

[Marko David Garcia <markodavidgm@xxxxxxxxx>]

Dear all.
We have a datelement with domain type: tracker, value type: text, and text
type: long text.
When I try to run the analyzer, generate an error, because the length of
the text  is upper than 255 characters.

We need use more than 255 characters in this field.

This are the catalina.out details:

...
trackedentityattributevalue where
trackedentityinstanceid=pi.trackedentityinstanceid and
trackedentityattributeid=87836) as
"OcpfkoizNYf",psi.uid,ps.uid,psi.executiondate,psi.longitude,psi.latitude,ou.uid,
ou.name,ou.code,tei.uid from programstageinstance psi inner join
programinstance pi on psi.programinstanceid=pi.programinstanceid inner join
programstage ps on psi.programstageid=ps.programstageid inner join program
pr on pi.programid=pr.programid left join trackedentityinstance tei on
pi.trackedentityinstanceid=tei.trackedentityinstanceid inner join
organisationunit ou on psi.organisationunitid=ou.organisationunitid left
join _orgunitstructure ous on psi.organisationunitid=ous.organisationunitid
left join _organisationunitgroupsetstructure ougs on
psi.organisationunitid=ougs.organisationunitid left join
_dateperiodstructure dps on psi.executiondate=dps.dateperiod where
psi.executiondate >= '2015-01-01' and psi.executiondate <= '2015-12-31' and
pr.programid=112788 and psi.organisationunitid is not null and
psi.executiondate is not null]; ERROR: el valor es demasiado largo para el
tipo character varying(255); nested exception is
org.postgresql.util.PSQLException: ERROR: el valor es demasiado largo para
el tipo character varying(255)
at
org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:102)
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:416)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:440)
at
org.hisp.dhis.analytics.table.AbstractJdbcTableManager.populateAndLog(AbstractJdbcTableManager.java:318)
at
org.hisp.dhis.analytics.table.JdbcEventAnalyticsTableManager.populateTableAsync(JdbcEventAnalyticsTableManager.java:217)
at sun.reflect.GeneratedMethodAccessor631.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at
org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:110)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
... 1 more
Caused by: org.postgresql.util.PSQLException: ERROR: el valor es demasiado
largo para el tipo character varying(255)
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:405)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:397)
at
com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1006)
at
org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:432)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:405)
... 12 more


Best regards,


*Mag. (c). Marko David Garcia M.*
*Ingeniería Telemática*
*Universidad del Cauca*
*Skype: marko_david*