Guys, Thanks for rapid response - I obviously saw the "caused by" too, but could not figure out what was too long (stored by not specified). I had no idea that stored by had been limited to 31 characters (the username in users table is e.g. 255 characters).
You learn something every day.... :-) Regards Calle On 13 February 2015 at 15:03, Knut Staring <[email protected]> wrote: > 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 > -- ******************************************* 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
