Hi Subodha=2C
hard to say but my wild guess is that you have values in the datavalue tabl=
e which are either extremely high=2C or have an extreme number of decimal p=
oints. =0A=
The process fails when it tries to write an aggregated value to the aggrega=
teddatavalue table=2C where the value is out of range for the column type o=
f the "value" column: =0A=
Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of rang=
e value for column 'value' at row 96
=0A=
Lars
···
On Thu=2C Apr 25=2C 2013 at 8:46 PM=2C subodha manoj <subodha.manoj@gmail.c= > wrote:
=0A=
Dear all=2C
I face an issue with Datamart export.=20
Server:=20
=0A=
Build revision: 9149 Build date:2013-03-27 13:41User agent:=0A=
Mozilla/5.0 (Windows NT 6.1=3B WOW64=3B rv:20.0) Gecko/20100101 Firefox/20.=
0External configuration directory:Not setEnvironment variable:DHIS2_HOMEDat=
abase type:MySQL=0A=
=0A=
Java Opts:-Xms256m -Xmx1512m -XX:PermSize=3D128m -XX:MaxPermSize=3D512m -Dj=
ava.util.logging.manager=3Dorg.apache.juli.ClassLoaderLogManagerJava versio=
n:1.6.0_24Java vendor:Sun Microsystems Inc.=0A=
=0A=
OS name:LinuxOS architecture:amd64OS version:3.2.0-29-genericServer date:20=
13-04-25 23:59Server memory:Mem Total in JVM: 846 Free in JVM: 403 Max Limi=
t: 1344=0A=
=0A=
CPU cores:4Tomcat log:=20
* INFO 2013-04-25 07:54:05=2C856 Using periods: [[Monthly: Sat Dec 01 00:0=
0:00 IST 2012 - Mon Dec 31 00:00:00 IST 2012]=2C [Quarterly: Mon Oct 01 00:=
00:00 IST 2012 - Mon Dec 31 00:00:00 IST 2012]] (DataMartTask.java [taskSch=
eduler-5])
=0A=
=0A=
* INFO 2013-04-25 07:54:06=2C159 Data mart export process started=2C numbe=
r of CPU cores: 4=2C Mem Total in JVM: 622 Free in JVM: 389 Max Limit: 1344=
: 0:00:00.000 (Clock.java [taskScheduler-5])
* INFO 2013-04-25 07:54:06=2C162 [Level: INFO=2C category: DATAMART=2C tim=
e: Thu Apr 25 07:54:06 IST 2013=2C message: Data mart export process starte=
d] (InMemoryNotifier.java [taskScheduler-5])
=0A=
=0A=
* INFO 2013-04-25 07:54:07=2C206 Recreated temporary tables: 0:00:01.047 (=
Clock.java [taskScheduler-5])
* INFO 2013-04-25 07:54:07=2C206 Data elements: 1228=2C indicators: 294=2C=
periods: 2=2C org units: 1296: 0:00:01.047 (Clock.java [taskScheduler-5])
=0A=
=0A=
* INFO 2013-04-25 07:54:07=2C426 Retrieved meta-data objects=2C using peri=
ods: [[Quarterly: 2012-10-01 - 2012-12-31]=2C [Monthly: 2012-12-01 - 2012-1=
2-31]]: 0:00:01.267 (Clock.java [taskScheduler-5])
* INFO 2013-04-25 07:54:07=2C426 [Level: INFO=2C category: DATAMART=2C tim=
e: Thu Apr 25 07:54:07 IST 2013=2C message: Filtering meta-data] (InMemoryN=
otifier.java [taskScheduler-5])
=0A=
=0A=
* WARN 2013-04-25 07:54:07=2C565 Indicator is invalid: [Number of Dental S=
urgeons per 10=2C000 population] (DefaultExpressionService.java [taskSchedu=
ler-5])
* INFO 2013-04-25 07:54:07=2C716 Filtered objects: 0:00:01.557 (Clock.java=
[taskScheduler-5])
=0A=
=0A=
* INFO 2013-04-25 07:54:07=2C717 [Level: INFO=2C category: DATAMART=2C tim=
e: Thu Apr 25 07:54:07 IST 2013=2C message: Loading indicators] (InMemoryNo=
tifier.java [taskScheduler-5])
* INFO 2013-04-25 07:54:07=2C727 Exploded indicator expressions: 0:00:01.5=
68 (Clock.java [taskScheduler-5])
=0A=
=0A=
* INFO 2013-04-25 07:54:07=2C727 [Level: INFO=2C category: DATAMART=2C tim=
e: Thu Apr 25 07:54:07 IST 2013=2C message: Loading data elements] (InMemor=
yNotifier.java [taskScheduler-5])
* INFO 2013-04-25 07:54:12=2C094 Retrieved operands: 1493: 0:00:05.935 (Cl=
ock.java [taskScheduler-5])
=0A=
=0A=
* INFO 2013-04-25 07:54:12=2C095 [Level: INFO=2C category: DATAMART=2C tim=
e: Thu Apr 25 07:54:12 IST 2013=2C message: Loading periods] (InMemoryNotif=
ier.java [taskScheduler-5])
* INFO 2013-04-25 07:54:12=2C101 Number of periods: 2: 0:00:05.942 (Clock.=
java [taskScheduler-5])
=0A=
=0A=
* INFO 2013-04-25 07:54:12=2C102 [Level: INFO=2C category: DATAMART=2C tim=
e: Thu Apr 25 07:54:12 IST 2013=2C message: Filtering data elements without=
data] (InMemoryNotifier.java [taskScheduler-5])
* INFO 2013-04-25 07:54:14=2C234 Number of operands with data: 487=2C Mem =
Total in JVM: 622 Free in JVM: 285 Max Limit: 1344: 0:00:08.075 (Clock.java=
[taskScheduler-5])
=0A=
=0A=
* INFO 2013-04-25 07:54:14=2C234 [Level: INFO=2C category: DATAMART=2C tim=
e: Thu Apr 25 07:54:14 IST 2013=2C message: Populating crosstabulation tabl=
e] (InMemoryNotifier.java [taskScheduler-5])
* INFO 2013-04-25 07:54:25=2C438 Crosstab table columns: 489=2C rows: 0 (D=
efaultCrossTabService.java [SimpleAsyncTaskExecutor-98])
=0A=
=0A=
* INFO 2013-04-25 07:54:26=2C761 Crosstab table columns: 489=2C rows: 0 (D=
efaultCrossTabService.java [SimpleAsyncTaskExecutor-97])
* INFO 2013-04-25 07:54:27=2C003 Crosstab table columns: 489=2C rows: 1 (D=
efaultCrossTabService.java [SimpleAsyncTaskExecutor-100])
=0A=
=0A=
* INFO 2013-04-25 07:54:27=2C027 Crosstab table columns: 489=2C rows: 1 (D=
efaultCrossTabService.java [SimpleAsyncTaskExecutor-99])
* INFO 2013-04-25 07:54:27=2C027 Populated crosstab table=2C Mem Total in =
JVM: 624 Free in JVM: 385 Max Limit: 1344: 0:00:20.868 (Clock.java [taskSch=
eduler-5])
=0A=
=0A=
* INFO 2013-04-25 07:54:27=2C030 Created aggregated data cache=2C number o=
f indicator operands: 232=2C operands with data: 487: 0:00:20.871 (Clock.ja=
va [taskScheduler-5])
* INFO 2013-04-25 07:54:27=2C039 [Level: INFO=2C category: DATAMART=2C tim=
e: Thu Apr 25 07:54:27 IST 2013=2C message: Exporting data for data element=
data] (InMemoryNotifier.java [taskScheduler-5])
=0A=
=0A=
* INFO 2013-04-25 07:54:28=2C213 Data element export task done (DefaultDat=
aElementDataMart.java [SimpleAsyncTaskExecutor-102])
* ERROR 2013-04-25 07:54:28=2C663 Unexpected error occurred in scheduled ta=
sk. (TaskUtils.java [taskScheduler-5])
=0A=
=0A=
java.lang.RuntimeException: Exception during execution
at org.hisp.dhis.system.util.ConcurrentUtils.waitForCompletion(Concurre=
ntUtils.java:54)
at org.hisp.dhis.datamart.engine.DefaultDataMartEngine.export(DefaultDa=
taMartEngine.java:348)
=0A=
=0A=
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl=
.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcce=
ssorImpl.java:43)
=0A=
=0A=
at java.lang.reflect.Method.invoke(Method.java:616)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflect=
ion(AopUtils.java:318)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJ=
oinpoint(ReflectiveMethodInvocation.java:183)
=0A=
=0A=
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed=
(ReflectiveMethodInvocation.java:150)
at org.springframework.transaction.interceptor.TransactionInterceptor.i=
nvoke(TransactionInterceptor.java:110)
=0A=
=0A=
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed=
(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.=
proceed(MethodInvocationProceedingJoinPoint.java:80)
=0A=
=0A=
at org.amplecode.quick.StatementInterceptor.intercept(StatementIntercep=
tor.java:71)
at sun.reflect.GeneratedMethodAccessor570.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcce=
ssorImpl.java:43)
=0A=
=0A=
at java.lang.reflect.Method.invoke(Method.java:616)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMe=
thodWithGivenArgs(AbstractAspectJAdvice.java:621)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMe=
thod(AbstractAspectJAdvice.java:610)
=0A=
=0A=
at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAr=
oundAdvice.java:65)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed=
(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invo=
ke(ExposeInvocationInterceptor.java:90)
=0A=
=0A=
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed=
(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynam=
icAopProxy.java:202)
at $Proxy105.export(Unknown Source)
=0A=
=0A=
at org.hisp.dhis.system.scheduling.DataMartTask.run(DataMartTask.java:1=
63)
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnab=
le.run(DelegatingErrorHandlingRunnable.java:53)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:4=
71)
=0A=
=0A=
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask=
.access$101(ScheduledThreadPoolExecutor.java:165)
=0A=
=0A=
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask=
.run(ScheduledThreadPoolExecutor.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor=
.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecuto=
r.java:603)
=0A=
=0A=
at java.lang.Thread.run(Thread.java:679)
Caused by: java.util.concurrent.ExecutionException: java.lang.RuntimeExcept=
ion: Failed to flush BatchHandler
at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:252)
=0A=
=0A=
at java.util.concurrent.FutureTask.get(FutureTask.java:111)
at org.hisp.dhis.system.util.ConcurrentUtils.waitForCompletion(Concurre=
ntUtils.java:50)
... 33 more
Caused by: java.lang.RuntimeException: Failed to flush BatchHandler
=0A=
=0A=
at org.amplecode.quick.batchhandler.AbstractBatchHandler.flush(Abstract=
BatchHandler.java:311)
at org.hisp.dhis.datamart.dataelement.DefaultDataElementDataMart.export=
DataValues(DefaultDataElementDataMart.java:217)
=0A=
=0A=
at sun.reflect.GeneratedMethodAccessor521.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcce=
ssorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
=0A=
=0A=
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflect=
ion(AopUtils.java:318)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJ=
oinpoint(ReflectiveMethodInvocation.java:183)
=0A=
=0A=
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed=
(ReflectiveMethodInvocation.java:150)
at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call=
(AsyncExecutionInterceptor.java:80)
=0A=
=0A=
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
... 1 more
Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of rang=
e value for column 'value' at row 96
=0A=
=0A=
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4094)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651)
=0A=
=0A=
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2677)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1748)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1665)
=0A=
=0A=
at org.amplecode.quick.batchhandler.AbstractBatchHandler.flush(Abstract=
BatchHandler.java:295)
... 11 more
Cleared cash.=20
Archived data values and tried to run the datamart to locate the data vulue=
s causing the problem. But it still gives the same result.=20
=0A=
=0A=
How to solve this problem ?
with regards=2C
Subodha.
=0A=
_______________________________________________
=0A=
Mailing list: DHIS 2 Users in Launchpad
=0A=
Post to : dhis2-users@lists.launchpad.net
=0A=
Unsubscribe : DHIS 2 Users in Launchpad
=0A=
More help : ListHelp - Launchpad Help
=0A=
=0A=
_______________________________________________=0A=
Mailing list: https://launchpad.net/~dhis2-users=0A=
Post to : dhis2-users@lists.launchpad.net=0A=
Unsubscribe : https://launchpad.net/~dhis2-users=0A=
More help : ListHelp - Launchpad Help =
--_915a1911-63fc-4e16-a151-4e2c067f3df6_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<html>
<head>
<style><!--
.hmmessage P
{
margin:0px=3B
padding:0px
}
body.hmmessage
{
font-size: 12pt=3B
font-family:Calibri
}
--></style></head>
<body class=3D'hmmessage'><div dir=3D'ltr'>Dear Lars=2C<br><br>Few data ele=
ments collects 12 figure values with 2 decimals (financial data). For the m=
oment getting quarterly data from 13 centers. We'll try to find a workaroun=
d.<br>Thanks=2C<br>Subodha.<br><br><br><div><div id=3D"SkyDrivePlaceholder"=
</div><hr id=3D"stopSpelling">Date: Fri=2C 26 Apr 2013 08:57:02 +0200<br>F=
rom: larshelge@gmail.com<br>To: subodha.manoj@gmail.com<br>CC: dhis2-users@=
lists.launchpad.net<br>Subject: Re: [Dhis2-users] (no subject)<br><br><div =
dir=3D"ltr">Hi =3B<span style=3D"font-family:arial=2Csans-serif=3Bfont-=
size:13px=3B">Subodha=2C</span><div><span style=3D"font-family:arial=2Csans=
-serif=3Bfont-size:13px=3B"><br></span></div><div><font face=3D"arial=2C sa=
ns-serif">hard to say but my wild guess is that you have values in the data=
value table which are either extremely high=2C or have an extreme number of=
decimal points. =3B</font></div>=0A=
<div><font face=3D"arial=2C sans-serif"><br></font></div><div><font face=3D=
"arial=2C sans-serif">The process fails when it tries to write an aggregate=
d value to the aggregateddatavalue table=2C where the value is out of range=
for the column type of the "value" column: =3B</font></div>=0A=
<div><br></div><div><span style=3D"font-family:arial=2Csans-serif=3Bfont-si=
ze:13px=3B">Caused by: com.mysql.jdbc.</span><span style=3D"font-family:ari=
al=2Csans-serif=3Bfont-size:13px=3B">MysqlDataTruncation: Data truncation: =
Out of range value for column 'value' at row 96</span><font face=3D"arial=
=2C sans-serif"><br>=0A=
</font></div><div class=3D"ecxgmail_extra"><br></div><div class=3D"ecxgmail=
_extra"><br></div><div class=3D"ecxgmail_extra">Lars</div><div class=3D"ecx=
gmail_extra"><br><br><div class=3D"ecxgmail_quote">On Thu=2C Apr 25=2C 2013=
at 8:46 PM=2C subodha manoj <span dir=3D"ltr"><=3B<a href=3D"mailto:subo=
dha.manoj@gmail.com" target=3D"_blank">subodha.manoj@gmail.com</a>>=3B</s=
wrote:<br>=0A=
<blockquote class=3D"ecxgmail_quote" style=3D"border-left:1px #ccc solid=3B=
padding-left:1ex=3B"><div dir=3D"ltr"><div><div><div>Dear all=2C<br><br></d=
I face an issue with Datamart export. <br><br><b>Server: </b><br><dl>=0A=
<dt>Build revision:</dt><dd> 9149 </dd><dt>Build date:</dt><dd>2013-03-27 1=
3:41</dd><dt>User agent:</dt>=0A=
<dd>Mozilla/5.0 (Windows NT 6.1=3B WOW64=3B rv:20.0) Gecko/20100101 Firefox=
/20.0</dd><dt>External configuration directory:</dt><dd>Not set</dd><dt>Env=
ironment variable:</dt><dd>DHIS2_HOME</dd><dt>Database type:</dt><dd>MySQL<=
/dd>=0A=
=0A=
<dt>Java Opts:</dt><dd>-Xms256m -Xmx1512m -XX:PermSize=3D128m -XX:MaxPermSi=
ze=3D512m -Djava.util.logging.manager=3Dorg.apache.juli.ClassLoaderLogManag=
er</dd><dt>Java version:</dt><dd>1.6.0_24</dd><dt>Java vendor:</dt><dd>Sun =
Microsystems Inc.</dd>=0A=
=0A=
<dt>OS name:</dt><dd>Linux</dd><dt>OS architecture:</dt><dd>amd64</dd><dt>O=
S version:</dt><dd>3.2.0-29-generic</dd><dt>Server date:</dt><dd>2013-04-25=
23:59</dd><dt>Server memory:</dt><dd>Mem Total in JVM: 846 Free in JVM: 40=
3 Max Limit: 1344</dd>=0A=
=0A=
<dt>CPU cores:</dt><dd>4</dd></dl><b>Tomcat log: </b><br><br>* INFO =3B=
2013-04-25 07:54:05=2C856 Using periods: [[Monthly: Sat Dec 01 00:00:00 IS=
T 2012 - Mon Dec 31 00:00:00 IST 2012]=2C [Quarterly: Mon Oct 01 00:00:00 I=
ST 2012 - Mon Dec 31 00:00:00 IST 2012]] (DataMartTask.java [taskScheduler-=
5])<br>=0A=
=0A=
* INFO =3B 2013-04-25 07:54:06=2C159 Data mart export process started=
=2C number of CPU cores: 4=2C Mem Total in JVM: 622 Free in JVM: 389 Max Li=
mit: 1344: 0:00:00.000 (Clock.java [taskScheduler-5])<br>* INFO =3B 201=
3-04-25 07:54:06=2C162 [Level: INFO=2C category: DATAMART=2C time: Thu Apr =
25 07:54:06 IST 2013=2C message: Data mart export process started] (InMemor=
yNotifier.java [taskScheduler-5])<br>=0A=
=0A=
* INFO =3B 2013-04-25 07:54:07=2C206 Recreated temporary tables: 0:00:<=
a target=3D"_blank">01.047</a> (Clock.java [taskScheduler-5])<br>* INFO&nbs=
p=3B 2013-04-25 07:54:07=2C206 Data elements: 1228=2C indicators: 294=2C pe=
riods: 2=2C org units: 1296: 0:00:01.047 (Clock.java [taskScheduler-5])<br>=
=0A=
=0A=
* INFO =3B 2013-04-25 07:54:07=2C426 Retrieved meta-data objects=2C usi=
ng periods: [[Quarterly: 2012-10-01 - 2012-12-31]=2C [Monthly: 2012-12-01 -=
2012-12-31]]: 0:00:01.267 (Clock.java [taskScheduler-5])<br>* INFO =3B=
2013-04-25 07:54:07=2C426 [Level: INFO=2C category: DATAMART=2C time: Thu =
Apr 25 07:54:07 IST 2013=2C message: Filtering meta-data] (InMemoryNotifier=
.java [taskScheduler-5])<br>=0A=
=0A=
* WARN =3B 2013-04-25 07:54:07=2C565 Indicator is invalid: [Number of D=
ental Surgeons per 10=2C000 population] (DefaultExpressionService.java [tas=
kScheduler-5])<br>* INFO =3B 2013-04-25 07:54:07=2C716 Filtered objects=
: 0:00:<a target=3D"_blank">01.557</a> (Clock.java [taskScheduler-5])<br>=
=0A=
=0A=
* INFO =3B 2013-04-25 07:54:07=2C717 [Level: INFO=2C category: DATAMART=
=2C time: Thu Apr 25 07:54:07 IST 2013=2C message: Loading indicators] (InM=
emoryNotifier.java [taskScheduler-5])<br>* INFO =3B 2013-04-25 07:54:07=
=2C727 Exploded indicator expressions: 0:00:<a target=3D"_blank">01.568</a>=
(Clock.java [taskScheduler-5])<br>=0A=
=0A=
* INFO =3B 2013-04-25 07:54:07=2C727 [Level: INFO=2C category: DATAMART=
=2C time: Thu Apr 25 07:54:07 IST 2013=2C message: Loading data elements] (=
InMemoryNotifier.java [taskScheduler-5])<br>* INFO =3B 2013-04-25 07:54=
:12=2C094 Retrieved operands: 1493: 0:00:<a target=3D"_blank">05.935</a> (C=
lock.java [taskScheduler-5])<br>=0A=
=0A=
* INFO =3B 2013-04-25 07:54:12=2C095 [Level: INFO=2C category: DATAMART=
=2C time: Thu Apr 25 07:54:12 IST 2013=2C message: Loading periods] (InMemo=
ryNotifier.java [taskScheduler-5])<br>* INFO =3B 2013-04-25 07:54:12=2C=
101 Number of periods: 2: 0:00:<a target=3D"_blank">05.942</a> (Clock.java =
[taskScheduler-5])<br>=0A=
=0A=
* INFO =3B 2013-04-25 07:54:12=2C102 [Level: INFO=2C category: DATAMART=
=2C time: Thu Apr 25 07:54:12 IST 2013=2C message: Filtering data elements =
without data] (InMemoryNotifier.java [taskScheduler-5])<br>* INFO =3B 2=
013-04-25 07:54:14=2C234 Number of operands with data: 487=2C Mem Total in =
JVM: 622 Free in JVM: 285 Max Limit: 1344: 0:00:08.075 (Clock.java [taskSch=
eduler-5])<br>=0A=
=0A=
* INFO =3B 2013-04-25 07:54:14=2C234 [Level: INFO=2C category: DATAMART=
=2C time: Thu Apr 25 07:54:14 IST 2013=2C message: Populating crosstabulati=
on table] (InMemoryNotifier.java [taskScheduler-5])<br>* INFO =3B 2013-=
04-25 07:54:25=2C438 Crosstab table columns: 489=2C rows: 0 (DefaultCrossTa=
bService.java [SimpleAsyncTaskExecutor-98])<br>=0A=
=0A=
* INFO =3B 2013-04-25 07:54:26=2C761 Crosstab table columns: 489=2C row=
s: 0 (DefaultCrossTabService.java [SimpleAsyncTaskExecutor-97])<br>* INFO&n=
bsp=3B 2013-04-25 07:54:27=2C003 Crosstab table columns: 489=2C rows: 1 (De=
faultCrossTabService.java [SimpleAsyncTaskExecutor-100])<br>=0A=
=0A=
* INFO =3B 2013-04-25 07:54:27=2C027 Crosstab table columns: 489=2C row=
s: 1 (DefaultCrossTabService.java [SimpleAsyncTaskExecutor-99])<br>* INFO&n=
bsp=3B 2013-04-25 07:54:27=2C027 Populated crosstab table=2C Mem Total in J=
VM: 624 Free in JVM: 385 Max Limit: 1344: 0:00:20.868 (Clock.java [taskSche=
duler-5])<br>=0A=
=0A=
* INFO =3B 2013-04-25 07:54:27=2C030 Created aggregated data cache=2C n=
umber of indicator operands: 232=2C operands with data: 487: 0:00:20.871 (C=
lock.java [taskScheduler-5])<br>* INFO =3B 2013-04-25 07:54:27=2C039 [L=
evel: INFO=2C category: DATAMART=2C time: Thu Apr 25 07:54:27 IST 2013=2C m=
essage: Exporting data for data element data] (InMemoryNotifier.java [taskS=
cheduler-5])<br>=0A=
=0A=
* INFO =3B 2013-04-25 07:54:28=2C213 Data element export task done (Def=
aultDataElementDataMart.java [SimpleAsyncTaskExecutor-102])<br>* ERROR 2013=
-04-25 07:54:28=2C663 Unexpected error occurred in scheduled task. (TaskUti=
ls.java [taskScheduler-5])<br>=0A=
=0A=
java.lang.RuntimeException: Exception during execution<br> =3B =3B&=
nbsp=3B at org.hisp.dhis.system.util.ConcurrentUtils.waitForCompletion(Conc=
urrentUtils.java:54)<br> =3B =3B =3B at org.hisp.dhis.datamart.=
engine.DefaultDataMartEngine.export(DefaultDataMartEngine.java:348)<br>=0A=
=0A=
 =3B =3B =3B at sun.reflect.NativeMethodAccessorImpl.invoke0(Na=
tive Method)<br> =3B =3B =3B at sun.reflect.NativeMethodAccesso=
rImpl.invoke(NativeMethodAccessorImpl.java:57)<br> =3B =3B =3B =
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor=
Impl.java:43)<br>=0A=
=0A=
 =3B =3B =3B at java.lang.reflect.Method.invoke(Method.java:616=
)<br> =3B =3B =3B at org.springframework.aop.support.AopUtils.i=
nvokeJoinpointUsingReflection(AopUtils.java:318)<br> =3B =3B =
=3B at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJ=
oinpoint(ReflectiveMethodInvocation.java:183)<br>=0A=
=0A=
 =3B =3B =3B at org.springframework.aop.framework.ReflectiveMet=
hodInvocation.proceed(ReflectiveMethodInvocation.java:150)<br> =3B =
=3B =3B at org.springframework.transaction.interceptor.TransactionInter=
ceptor.invoke(TransactionInterceptor.java:110)<br>=0A=
=0A=
 =3B =3B =3B at org.springframework.aop.framework.ReflectiveMet=
hodInvocation.proceed(ReflectiveMethodInvocation.java:172)<br> =3B =
=3B =3B at org.springframework.aop.aspectj.MethodInvocationProceedingJo=
inPoint.proceed(MethodInvocationProceedingJoinPoint.java:80)<br>=0A=
=0A=
 =3B =3B =3B at org.amplecode.quick.StatementInterceptor.interc=
ept(StatementInterceptor.java:71)<br> =3B =3B =3B at sun.reflec=
t.GeneratedMethodAccessor570.invoke(Unknown Source)<br> =3B =3B&nbs=
p=3B at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcc=
essorImpl.java:43)<br>=0A=
=0A=
 =3B =3B =3B at java.lang.reflect.Method.invoke(Method.java:616=
)<br> =3B =3B =3B at org.springframework.aop.aspectj.AbstractAs=
pectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621)=
<br> =3B =3B =3B at org.springframework.aop.aspectj.AbstractAsp=
ectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610)<br>=0A=
=0A=
 =3B =3B =3B at org.springframework.aop.aspectj.AspectJAroundAd=
vice.invoke(AspectJAroundAdvice.java:65)<br> =3B =3B =3B at org=
.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Reflectiv=
eMethodInvocation.java:172)<br> =3B =3B =3B at org.springframew=
ork.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInte=
rceptor.java:90)<br>=0A=
=0A=
 =3B =3B =3B at org.springframework.aop.framework.ReflectiveMet=
hodInvocation.proceed(ReflectiveMethodInvocation.java:172)<br> =3B =
=3B =3B at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(=
JdkDynamicAopProxy.java:202)<br> =3B =3B =3B at $Proxy105.expor=
t(Unknown Source)<br>=0A=
=0A=
 =3B =3B =3B at org.hisp.dhis.system.scheduling.DataMartTask.ru=
n(DataMartTask.java:163)<br> =3B =3B =3B at org.springframework=
.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHand=
lingRunnable.java:53)<br> =3B =3B =3B at java.util.concurrent.E=
xecutors$RunnableAdapter.call(Executors.java:471)<br>=0A=
=0A=
 =3B =3B =3B at java.util.concurrent.FutureTask$Sync.innerRun(F=
utureTask.java:334)<br> =3B =3B =3B at java.util.concurrent.Fut=
ureTask.run(FutureTask.java:166)<br> =3B =3B =3B at java.util.c=
oncurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(Schedu=
ledThreadPoolExecutor.java:165)<br>=0A=
=0A=
 =3B =3B =3B at java.util.concurrent.ScheduledThreadPoolExecuto=
r$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:266)<br> =3B=
 =3B =3B at java.util.concurrent.ThreadPoolExecutor.runWorker(Threa=
dPoolExecutor.java:1110)<br> =3B =3B =3B at java.util.concurren=
t.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)<br>=0A=
=0A=
 =3B =3B =3B at java.lang.Thread.run(Thread.java:679)<br>Caused=
by: java.util.concurrent.ExecutionException: java.lang.RuntimeException: F=
ailed to flush BatchHandler<br> =3B =3B =3B at java.util.concur=
rent.FutureTask$Sync.innerGet(FutureTask.java:252)<br>=0A=
=0A=
 =3B =3B =3B at java.util.concurrent.FutureTask.get(FutureTask.=
java:111)<br> =3B =3B =3B at org.hisp.dhis.system.util.Concurre=
ntUtils.waitForCompletion(ConcurrentUtils.java:50)<br> =3B =3B =
=3B ... 33 more<br>Caused by: java.lang.RuntimeException: Failed to flush B=
atchHandler<br>=0A=
=0A=
 =3B =3B =3B at org.amplecode.quick.batchhandler.AbstractBatchH=
andler.flush(AbstractBatchHandler.java:311)<br> =3B =3B =3B at =
org.hisp.dhis.datamart.dataelement.DefaultDataElementDataMart.exportDataVal=
ues(DefaultDataElementDataMart.java:217)<br>=0A=
=0A=
 =3B =3B =3B at sun.reflect.GeneratedMethodAccessor521.invoke(U=
nknown Source)<br> =3B =3B =3B at sun.reflect.DelegatingMethodA=
ccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br> =3B =
=3B =3B at java.lang.reflect.Method.invoke(Method.java:616)<br>=0A=
=0A=
 =3B =3B =3B at org.springframework.aop.support.AopUtils.invoke=
JoinpointUsingReflection(AopUtils.java:318)<br> =3B =3B =3B at =
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoin=
t(ReflectiveMethodInvocation.java:183)<br>=0A=
=0A=
 =3B =3B =3B at org.springframework.aop.framework.ReflectiveMet=
hodInvocation.proceed(ReflectiveMethodInvocation.java:150)<br> =3B =
=3B =3B at org.springframework.aop.interceptor.AsyncExecutionIntercepto=
r$1.call(AsyncExecutionInterceptor.java:80)<br>=0A=
=0A=
 =3B =3B =3B at java.util.concurrent.FutureTask$Sync.innerRun(F=
utureTask.java:334)<br> =3B =3B =3B at java.util.concurrent.Fut=
ureTask.run(FutureTask.java:166)<br> =3B =3B =3B ... 1 more<br>=
Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of rang=
e value for column 'value' at row 96<br>=0A=
=0A=
 =3B =3B =3B at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO=
.java:4094)<br> =3B =3B =3B at com.mysql.jdbc.MysqlIO.checkErro=
rPacket(MysqlIO.java:4028)<br> =3B =3B =3B at com.mysql.jdbc.My=
sqlIO.sendCommand(MysqlIO.java:2490)<br> =3B =3B =3B at com.mys=
ql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651)<br>=0A=
=0A=
 =3B =3B =3B at com.mysql.jdbc.ConnectionImpl.execSQL(Connectio=
nImpl.java:2677)<br> =3B =3B =3B at com.mysql.jdbc.StatementImp=
l.executeUpdate(StatementImpl.java:1748)<br> =3B =3B =3B at com=
.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1665)<br>=0A=
=0A=
 =3B =3B =3B at org.amplecode.quick.batchhandler.AbstractBatchH=
andler.flush(AbstractBatchHandler.java:295)<br> =3B =3B =3B ...=
11 more<br><br></div>Cleared cash. <br>Archived data values and tried to r=
un the datamart to locate the data vulues causing the problem. But it still=
gives the same result. <br>=0A=
=0A=
<br><br></div><div>How to solve this problem ?<br><br></div><div>with regar=
ds=2C<br></div><div>Subodha.<br></div></div>=0A=
<br>_______________________________________________<br>=0A=
Mailing list: <a href=3D"https://launchpad.net/~dhis2-users" target=3D"_bla=
nk">https://launchpad.net/~dhis2-users</a><br>=0A=
Post to  =3B  =3B : <a href=3D"mailto:dhis2-users@lists.launchpad.n=
et">dhis2-users@lists.launchpad.net</a><br>=0A=
Unsubscribe : <a href=3D"https://launchpad.net/~dhis2-users" target=3D"_bla=
nk">https://launchpad.net/~dhis2-users</a><br>=0A=
More help  =3B : <a href=3D"https://help.launchpad.net/ListHelp" target=
=3D"_blank">https://help.launchpad.net/ListHelp</a><br>=0A=
<br></blockquote></div><br></div></div>=0A=
<br>_______________________________________________=0A=
Mailing list: https://launchpad.net/~dhis2-users=0A=
Post to : dhis2-users@lists.launchpad.net=0A=
Unsubscribe : https://launchpad.net/~dhis2-users=0A=
More help : https://help.launchpad.net/ListHelp</div> </div></=
</html>=
--_915a1911-63fc-4e16-a151-4e2c067f3df6_--