Hi Calle, The key words to look for in the Tomcat log is "Caused by"
In this case, as Lars says, the storedby string is too long: Caused by: org.postgresql.util. PSQLException: ERROR: value too long for type character varying(31) On Fri, Feb 13, 2015 at 1:31 PM, Calle Hedberg <[email protected]> wrote: > 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: [email protected] > > Skype: calle_hedberg > > ******************************************* > > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- Knut Staring Dept. of Informatics, University of Oslo Norway: +4791880522 Skype: knutstar http://dhis2.org
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
