← Back to team overview

dhis2-devs team mailing list archive

  1. dhis2-devs team
  2. Mailing list archive
  3. Message #35671

Import error

  Thread Previous • Date Previous • • Thread Next 
Hi,

I'm getting the following tomcat log import error when trying to import CSV
(attached) - any idea what the root cause is (the tomcat messages does not
make sense to me). The primary message seems to be "failed to flush batch
handler", whatever that means:

* INFO  2015-02-13 14:30:12,895 Importing data values
(DefaultDataValueSetService.java [taskScheduler-3])
* ERROR 2015-02-13 14:30:12,934 java.lang.RuntimeException: Failed to flush
BatchHandler
        at
org.amplecode.quick.batchhandler.AbstractBatchHandler.flush(AbstractBatchHandler.java:360)
        at
org.hisp.dhis.dxf2.datavalueset.DefaultDataValueSetService.saveDataValueSet(DefaultDataValueSetService.java:868)
        at
org.hisp.dhis.dxf2.datavalueset.DefaultDataValueSetService.saveDataValueSetCsv(DefaultDataValueSetService.java:539)
        at
org.hisp.dhis.importexport.action.util.ImportDataValueTask.run(ImportDataValueTask.java:83)
        at
org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
        at java.util.concurrent.Executors$RunnableAdapter.call(Unknown
Source)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown
Source)
        at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown
Source)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
Source)
        at java.lang.Thread.run(Unknown Source)
Caused by: org.postgresql.util.PSQLException: ERROR: value too long for
type character varying(31)
        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.executeUpdate(AbstractJdbc2Statement.java:333)
        at
org.amplecode.quick.batchhandler.AbstractBatchHandler.flush(AbstractBatchHandler.java:342)
        ... 11 more
 (DefaultDataValueSetService.java [taskScheduler-3])
* INFO  2015-02-13 14:30:12,944 [Level: ERROR, category: DATAVALUE_IMPORT,
time: Fri Feb 13 14:30:12 CAT 2015, message: Process failed: Failed to
flush BatchHandler] (InMemoryNotifier.java [taskScheduler-3])
* ERROR 2015-02-13 14:30:19,402 Left side ($summary.conflicts.size()) of
'>' operation has null value at
/dhis-web-importexport/importSummary.vm[line 35, column 33]
(Log4JLogChute.java [http-apr-8080-exec-8])

*******************************************

Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19274

Email: calle.hedberg@xxxxxxxxx

Skype: calle_hedberg

*******************************************

"DataElement","Period","OrgUnit","CategoryOptionComboId","AttributeOptionComboid","Value","StoredBy","LastUpdated","Comment","Followup"
"TB-3.4 Relapse cases registered","2013Q4","CEHAL (Mbeya) HOSP","E7GAgQ3gL4v","tUiK0vIsDaX","0","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.1 New TB cases sputum smear positive","2013Q1","Medicare Family Clinic","E7GAgQ3gL4v","tUiK0vIsDaX","1","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.3 New extra pulmonary TB cases registered","2013Q1","Medicare Family Clinic","E7GAgQ3gL4v","tUiK0vIsDaX","8","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.2 New TB cases Smear negative or not done","2013Q1","Medicare Family Clinic","E7GAgQ3gL4v","tUiK0vIsDaX","6","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.9 Other (outcome)","2013Q1","Medicare Family Clinic","E7GAgQ3gL4v","tUiK0vIsDaX","1","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.6 Treatment after Default","2013Q1","Medicare Family Clinic","E7GAgQ3gL4v","tUiK0vIsDaX","0","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.5 Treatment after Failure","2013Q1","Medicare Family Clinic","E7GAgQ3gL4v","tUiK0vIsDaX","0","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.4 Relapse cases registered","2013Q1","Medicare Family Clinic","E7GAgQ3gL4v","tUiK0vIsDaX","0","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.1 New TB cases sputum smear positive","2013Q2","Medicare Family Clinic","E7GAgQ3gL4v","tUiK0vIsDaX","0","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.3 New extra pulmonary TB cases registered","2013Q2","Medicare Family Clinic","E7GAgQ3gL4v","tUiK0vIsDaX","3","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.2 New TB cases Smear negative or not done","2013Q2","Medicare Family Clinic","E7GAgQ3gL4v","tUiK0vIsDaX","1","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.9 Other (outcome)","2013Q2","Medicare Family Clinic","E7GAgQ3gL4v","tUiK0vIsDaX","3","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.6 Treatment after Default","2013Q2","Medicare Family Clinic","E7GAgQ3gL4v","tUiK0vIsDaX","0","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.5 Treatment after Failure","2013Q2","Medicare Family Clinic","E7GAgQ3gL4v","tUiK0vIsDaX","0","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.4 Relapse cases registered","2013Q2","Medicare Family Clinic","E7GAgQ3gL4v","tUiK0vIsDaX","0","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.1 New TB cases sputum smear positive","2013Q3","Medicare Family Clinic","E7GAgQ3gL4v","tUiK0vIsDaX","0","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.3 New extra pulmonary TB cases registered","2013Q3","Medicare Family Clinic","E7GAgQ3gL4v","tUiK0vIsDaX","3","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.2 New TB cases Smear negative or not done","2013Q3","Medicare Family Clinic","E7GAgQ3gL4v","tUiK0vIsDaX","9","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.9 Other (outcome)","2013Q3","Medicare Family Clinic","E7GAgQ3gL4v","tUiK0vIsDaX","2","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.6 Treatment after Default","2013Q3","Medicare Family Clinic","E7GAgQ3gL4v","tUiK0vIsDaX","0","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.5 Treatment after Failure","2013Q3","Medicare Family Clinic","E7GAgQ3gL4v","tUiK0vIsDaX","0","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.4 Relapse cases registered","2013Q3","Medicare Family Clinic","E7GAgQ3gL4v","tUiK0vIsDaX","0","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.1 New TB cases sputum smear positive","2013Q4","Medicare Family Clinic","E7GAgQ3gL4v","tUiK0vIsDaX","0","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.3 New extra pulmonary TB cases registered","2013Q4","Medicare Family Clinic","E7GAgQ3gL4v","tUiK0vIsDaX","8","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.2 New TB cases Smear negative or not done","2013Q4","Medicare Family Clinic","E7GAgQ3gL4v","tUiK0vIsDaX","9","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.9 Other (outcome)","2013Q4","Medicare Family Clinic","E7GAgQ3gL4v","tUiK0vIsDaX","1","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.6 Treatment after Default","2013Q4","Medicare Family Clinic","E7GAgQ3gL4v","tUiK0vIsDaX","0","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.6 Treatment after Default","2010Q3","St Josephs HOSP","E7GAgQ3gL4v","tUiK0vIsDaX","0","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.5 Treatment after Failure","2010Q3","St Josephs HOSP","E7GAgQ3gL4v","tUiK0vIsDaX","0","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.4 Relapse cases registered","2010Q3","St Josephs HOSP","E7GAgQ3gL4v","tUiK0vIsDaX","0","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.1 New TB cases sputum smear positive","2010Q4","St Josephs HOSP","E7GAgQ3gL4v","tUiK0vIsDaX","2","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.3 New extra pulmonary TB cases registered","2010Q4","St Josephs HOSP","E7GAgQ3gL4v","tUiK0vIsDaX","24","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.2 New TB cases Smear negative or not done","2010Q4","St Josephs HOSP","E7GAgQ3gL4v","tUiK0vIsDaX","45","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.9 Other (outcome)","2010Q4","St Josephs HOSP","E7GAgQ3gL4v","tUiK0vIsDaX","8","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.6 Treatment after Default","2010Q4","St Josephs HOSP","E7GAgQ3gL4v","tUiK0vIsDaX","0","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.5 Treatment after Failure","2010Q4","St Josephs HOSP","E7GAgQ3gL4v","tUiK0vIsDaX","0","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.4 Relapse cases registered","2010Q4","St Josephs HOSP","E7GAgQ3gL4v","tUiK0vIsDaX","0","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.1 New TB cases sputum smear positive","2010Q1","Ntsekhe HOSP","E7GAgQ3gL4v","tUiK0vIsDaX","4","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.3 New extra pulmonary TB cases registered","2010Q1","Ntsekhe HOSP","E7GAgQ3gL4v","tUiK0vIsDaX","21","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.2 New TB cases Smear negative or not done","2010Q1","Ntsekhe HOSP","E7GAgQ3gL4v","tUiK0vIsDaX","41","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.9 Other (outcome)","2010Q1","Ntsekhe HOSP","E7GAgQ3gL4v","tUiK0vIsDaX","15","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.6 Treatment after Default","2010Q1","Ntsekhe HOSP","E7GAgQ3gL4v","tUiK0vIsDaX","0","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.5 Treatment after Failure","2010Q1","Ntsekhe HOSP","E7GAgQ3gL4v","tUiK0vIsDaX","0","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.4 Relapse cases registered","2010Q1","Ntsekhe HOSP","E7GAgQ3gL4v","tUiK0vIsDaX","2","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.1 New TB cases sputum smear positive","2010Q2","Ntsekhe HOSP","E7GAgQ3gL4v","tUiK0vIsDaX","3","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.3 New extra pulmonary TB cases registered","2010Q2","Ntsekhe HOSP","E7GAgQ3gL4v","tUiK0vIsDaX","9","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.2 New TB cases Smear negative or not done","2010Q2","Ntsekhe HOSP","E7GAgQ3gL4v","tUiK0vIsDaX","29","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.9 Other (outcome)","2010Q2","Ntsekhe HOSP","E7GAgQ3gL4v","tUiK0vIsDaX","6","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.6 Treatment after Default","2010Q2","Ntsekhe HOSP","E7GAgQ3gL4v","tUiK0vIsDaX","0","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"
"TB-3.5 Treatment after Failure","2010Q2","Ntsekhe HOSP","E7GAgQ3gL4v","tUiK0vIsDaX","0","TB_All_Notification_Cases (Excel)",2015/2/13 13:58:44,"","false"

Follow ups

  Thread Previous • Date Previous • • Thread Next