Analytics error

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