Hi Claus,
I'm using camel version 2.28 with Spring Boot 1.5.10.RELEASE Stacktrace: 2018-06-08 10:04:09,976 ERROR [Camel (camel-1) thread #1 - file://data/output/2018/05-mei/Prophet] org.apache.camel.processor.DefaultErrorHandler - - - Failed delivery for (MessageId: ID-LP0641-62840-1528445046486-0-375 on ExchangeId: ID-LP0641-62840-1528445046486-0-378). Exhausted after delivery attempt: 1 caught: org.apache.camel.component.file.GenericFileOperationFailedException: Cannot store file: data\output\2018\05-mei\Prophet\sorted\PRD_Base_shortest_HELICA.rpt Message History --------------------------------------------------------------------------------------------------------------------------------------- RouteId ProcessorId Processor Elapsed (ms) [route2 ] [route2 ] [file://data/output/2018/05-mei/Prophet?filterFile=%24%7Bfile%3Asize%7D+%3C+600] [ 8] [route2 ] [log4 ] [log ] [ 0] [route2 ] [sort1 ] [sort[{tokenize(simple{Simple: ${body}}, )}] ] [ 1] [route2 ] [to8 ] [file:data/output/2018/05-mei/Prophet/sorted?fileExist=Append ] [ 5] Stacktrace --------------------------------------------------------------------------------------------------------------------------------------- org.apache.camel.component.file.GenericFileOperationFailedException: Cannot store file: data\output\2018\05-mei\Prophet\sorted\PRD_Base_shortest_HELICA.rpt at org.apache.camel.component.file.FileOperations.storeFile(FileOperations.java:346) at org.apache.camel.component.file.GenericFileProducer.writeFile(GenericFileProducer.java:277) at org.apache.camel.component.file.GenericFileProducer.processExchange(GenericFileProducer.java:165) at org.apache.camel.component.file.GenericFileProducer.process(GenericFileProducer.java:79) at org.apache.camel.util.AsyncProcessorConverterHelper$ProcessorToAsyncProcessorBridge.process(AsyncProcessorConverterHelper.java:61) at org.apache.camel.processor.SendProcessor.process(SendProcessor.java:145) at org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:77) at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:542) at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:197) at org.apache.camel.processor.Pipeline.process(Pipeline.java:120) at org.apache.camel.processor.Pipeline.process(Pipeline.java:83) at org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:197) at org.apache.camel.component.file.GenericFileConsumer.processExchange(GenericFileConsumer.java:460) at org.apache.camel.component.file.GenericFileConsumer.processBatch(GenericFileConsumer.java:227) at org.apache.camel.component.file.GenericFileConsumer.poll(GenericFileConsumer.java:191) at org.apache.camel.impl.ScheduledPollConsumer.doRun(ScheduledPollConsumer.java:175) at org.apache.camel.impl.ScheduledPollConsumer.run(ScheduledPollConsumer.java:102) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.runAndReset(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(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.apache.camel.InvalidPayloadException: No body available of type: java.io.InputStream but has value: [!1,SPCODE,MP_Product_KEY,MP_Weight,MP_Policy_ID,MP_Policy_Number,MP_Status_KEY,MP_Policy_Start_DT,MP_Policy_End_DT,MP_Premium_End_DT,MP_Premium_FRQ,MP_Date_Of_Birth_1st_DT,MP_Gender_1st_KEY,MP_Age_Corr_1st_MNTHS,MP_Insured_1st_ID,MP_Interest_PRC,MP_Benefits_Bas_FRQ,MP_Benefits_Exp_FRQ,MP_Benefits_Bas,MP_Benefits_Exp,MP_Benefits_Prf,MP_Benefits_Terminal_Withdrawn,MP_Prem_Gross_Rgl_Sum_Paid,MP_Prem_Gross_Rgl,MP_Prem_Net_Bas_Rgl,MP_Prem_Net_Exp_Rgl,MP_Prem_Load_Ini_Rgl,MP_Prem_Load_Coll_Rgl,MP_Prem_Load_Term_Rgl,MP_Prem_Load_Solv_Rgl,MP_Prem_Load_Disc_Rgl,MP_Prem_Net_Bas_Corr_Rgl,MP_Prem_Gross_Sgl_Sum_Paid,MP_Prem_Gross_Sgl,MP_Prem_Net_Bas_Sgl,MP_Prem_Net_Exp_Sgl,MP_Prem_Load_Ini_Sgl,MP_Prem_Load_Coll_Sgl,MP_Prem_Load_Term_Sgl,MP_Prem_Load_Solv_Sgl,MP_Premiums_Paid_Known_YN,MP_Keuzerecht_KEY,MP_Ledenvoordeel_PRC,MP_Action_Code_KEY,MP_Status_Current_DT ] of type: java.util.ArrayList on: PRD_Base_shortest_HELICA.rpt. Caused by: Error during type conversion from type: java.lang.String to the required type: java.io.InputStream with value !1,SPCODE,MP_Product_KEY,MP_Weight,MP_Policy_ID,MP_Policy_Number,MP_Status_KEY,MP_Policy_Start_DT,MP_Policy_End_DT,MP_Premium_End_DT,MP_Premium_FRQ,MP_Date_Of_Birth_1st_DT,MP_Gender_1st_KEY,MP_Age_Corr_1st_MNTHS,MP_Insured_1st_ID,MP_Interest_PRC,MP_Benefits_Bas_FRQ,MP_Benefits_Exp_FRQ,MP_Benefits_Bas,MP_Benefits_Exp,MP_Benefits_Prf,MP_Benefits_Terminal_Withdrawn,MP_Prem_Gross_Rgl_Sum_Paid,MP_Prem_Gross_Rgl,MP_Prem_Net_Bas_Rgl,MP_Prem_Net_Exp_Rgl,MP_Prem_Load_Ini_Rgl,MP_Prem_Load_Coll_Rgl,MP_Prem_Load_Term_Rgl,MP_Prem_Load_Solv_Rgl,MP_Prem_Load_Disc_Rgl,MP_Prem_Net_Bas_Corr_Rgl,MP_Prem_Gross_Sgl_Sum_Paid,MP_Prem_Gross_Sgl,MP_Prem_Net_Bas_Sgl,MP_Prem_Net_Exp_Sgl,MP_Prem_Load_Ini_Sgl,MP_Prem_Load_Coll_Sgl,MP_Prem_Load_Term_Sgl,MP_Prem_Load_Solv_Sgl,MP_Premiums_Paid_Known_YN,MP_Keuzerecht_KEY,MP_Ledenvoordeel_PRC,MP_Action_Code_KEY,MP_Status_Current_DT due Failed to convert from type [java.util.ArrayList<?>] to type [java.io.InputStream] for value '[!1,SPCODE,MP_Product_KEY,MP_Weight,MP_Policy_ID,MP_Policy_Number,MP_Status_KEY,MP_Policy_Start_DT,MP_Policy_End_DT,MP_Premium_End_DT,MP_Premium_FRQ,MP_Date_Of_Birth_1st_DT,MP_Gender_1st_KEY,MP_Age_Corr_1st_MNTHS,MP_Insured_1st_ID,MP_Interest_PRC,MP_Benefits_Bas_FRQ,MP_Benefits_Exp_FRQ,MP_Benefits_Bas,MP_Benefits_Exp,MP_Benefits_Prf,MP_Benefits_Terminal_Withdrawn,MP_Prem_Gross_Rgl_Sum_Paid,MP_Prem_Gross_Rgl,MP_Prem_Net_Bas_Rgl,MP_Prem_Net_Exp_Rgl,MP_Prem_Load_Ini_Rgl,MP_Prem_Load_Coll_Rgl,MP_Prem_Load_Term_Rgl,MP_Prem_Load_Solv_Rgl,MP_Prem_Load_Disc_Rgl,MP_Prem_Net_Bas_Corr_Rgl,MP_Prem_Gross_Sgl_Sum_Paid,MP_Prem_Gross_Sgl,MP_Prem_Net_Bas_Sgl,MP_Prem_Net_Exp_Sgl,MP_Prem_Load_Ini_Sgl,MP_Prem_Load_Coll_Sgl,MP_Prem_Load_Term_Sgl,MP_Prem_Load_Solv_Sgl,MP_Premiums_Paid_Known_YN,MP_Keuzerecht_KEY,MP_Ledenvoordeel_PRC,MP_Action_Code_KEY,MP_Status_Current_DT ]'; nested exception is org.springframework.core.convert.ConverterNotFoundException: No converter found capable of converting from type [java.lang.String] to type [java.io.InputStream]. Exchange[ID-LP0641-62840-1528445046486-0-378]. Caused by: [org.apache.camel.TypeConversionException - Error during type conversion from type: java.lang.String to the required type: java.io.InputStream with value !1,SPCODE,MP_Product_KEY,MP_Weight,MP_Policy_ID,MP_Policy_Number,MP_Status_KEY,MP_Policy_Start_DT,MP_Policy_End_DT,MP_Premium_End_DT,MP_Premium_FRQ,MP_Date_Of_Birth_1st_DT,MP_Gender_1st_KEY,MP_Age_Corr_1st_MNTHS,MP_Insured_1st_ID,MP_Interest_PRC,MP_Benefits_Bas_FRQ,MP_Benefits_Exp_FRQ,MP_Benefits_Bas,MP_Benefits_Exp,MP_Benefits_Prf,MP_Benefits_Terminal_Withdrawn,MP_Prem_Gross_Rgl_Sum_Paid,MP_Prem_Gross_Rgl,MP_Prem_Net_Bas_Rgl,MP_Prem_Net_Exp_Rgl,MP_Prem_Load_Ini_Rgl,MP_Prem_Load_Coll_Rgl,MP_Prem_Load_Term_Rgl,MP_Prem_Load_Solv_Rgl,MP_Prem_Load_Disc_Rgl,MP_Prem_Net_Bas_Corr_Rgl,MP_Prem_Gross_Sgl_Sum_Paid,MP_Prem_Gross_Sgl,MP_Prem_Net_Bas_Sgl,MP_Prem_Net_Exp_Sgl,MP_Prem_Load_Ini_Sgl,MP_Prem_Load_Coll_Sgl,MP_Prem_Load_Term_Sgl,MP_Prem_Load_Solv_Sgl,MP_Premiums_Paid_Known_YN,MP_Keuzerecht_KEY,MP_Ledenvoordeel_PRC,MP_Action_Code_KEY,MP_Status_Current_DT due Failed to convert from type [java.util.ArrayList<?>] to type [java.io.InputStream] for value '[!1,SPCODE,MP_Product_KEY,MP_Weight,MP_Policy_ID,MP_Policy_Number,MP_Status_KEY,MP_Policy_Start_DT,MP_Policy_End_DT,MP_Premium_End_DT,MP_Premium_FRQ,MP_Date_Of_Birth_1st_DT,MP_Gender_1st_KEY,MP_Age_Corr_1st_MNTHS,MP_Insured_1st_ID,MP_Interest_PRC,MP_Benefits_Bas_FRQ,MP_Benefits_Exp_FRQ,MP_Benefits_Bas,MP_Benefits_Exp,MP_Benefits_Prf,MP_Benefits_Terminal_Withdrawn,MP_Prem_Gross_Rgl_Sum_Paid,MP_Prem_Gross_Rgl,MP_Prem_Net_Bas_Rgl,MP_Prem_Net_Exp_Rgl,MP_Prem_Load_Ini_Rgl,MP_Prem_Load_Coll_Rgl,MP_Prem_Load_Term_Rgl,MP_Prem_Load_Solv_Rgl,MP_Prem_Load_Disc_Rgl,MP_Prem_Net_Bas_Corr_Rgl,MP_Prem_Gross_Sgl_Sum_Paid,MP_Prem_Gross_Sgl,MP_Prem_Net_Bas_Sgl,MP_Prem_Net_Exp_Sgl,MP_Prem_Load_Ini_Sgl,MP_Prem_Load_Coll_Sgl,MP_Prem_Load_Term_Sgl,MP_Prem_Load_Solv_Sgl,MP_Premiums_Paid_Known_YN,MP_Keuzerecht_KEY,MP_Ledenvoordeel_PRC,MP_Action_Code_KEY,MP_Status_Current_DT ]'; nested exception is org.springframework.core.convert.ConverterNotFoundException: No converter found capable of converting from type [java.lang.String] to type [java.io.InputStream]] at org.apache.camel.impl.MessageSupport.getMandatoryBody(MessageSupport.java:107) at org.apache.camel.component.file.FileOperations.storeFile(FileOperations.java:325) ... 23 common frames omitted ________________________________ Van: Claus Ibsen <claus.ib...@gmail.com> Verzonden: vrijdag 8 juni 2018 10:45:41 Aan: users@camel.apache.org Onderwerp: Re: InvalidPayloadException when sorting lines in a csv file Hi What version of Camel do you use? And frankly Camel ought to be able to write a String body to a file, so that is a bit surprising. Maybe you can post your stacktrace for us to look at? On Fri, Jun 8, 2018 at 10:14 AM, Ivana Cace <ivana.c...@yarden.nl> wrote: > Hi, > > > I'm trying to sort a csv file, but when I try to write the file i get a > InvalidPayloadException due to "Error during type conversion from type: > java.lang.String to the required type: java.io.InputStream". > > > Here is the route: > > > from("file:path?filterFile=${file:size} < 6000") > .sort(body().tokenize("\n"), new ColumnSortComperator(1, ',')) > .to("file:path/sorted?fileExist=Append") > .end(); > > As far as i understand, the tokenizer outputs String, but to write the line > to the file i need a Inputstream. > How do i make a Inputstream from the sorted lines? > Is the only way to implement a processor that stuffs the lines + line endings > into the exchange body? > > > thanks in advance, > > > Ivana > > > ***************************************** De informatie verzonden in deze > e-mail (inclusief bijlagen) kan vertrouwelijk van aard zijn en is uitsluitend > bestemd voor de geadresseerde(n). Indien deze e-mail niet voor u bestemd is, > verzoeken wij u vriendelijk het bericht te retourneren en vervolgens te > vernietigen. Yarden doet er alles aan om ervoor te zorgen dat verzonden > e-mailberichten vrij zijn van virussen, maar kan dit niet garanderen. Yarden > Holding B.V., statutair gevestigd te Almere, Handelsregisternummer 34155452 > Yarden Uitvaartfaciliteiten B.V., statutair gevestigd te Almere, > Handelsregisternummer 30104432 Yarden Uitvaartzorg B.V., statutair gevestigd > te Almere, Handelsregisternummer 04050164 Yarden Uitvaartverzekeringen N.V., > statutair gevestigd te Almere, Handelsregisternummer 33244450 > ***************************************** -- Claus Ibsen ----------------- http://davsclaus.com @davsclaus Camel in Action 2: https://www.manning.com/ibsen2 ______________________________________________________________________ This email has been scanned by the Symantec Email Security.cloud service. For more information please visit http://www.symanteccloud.com ______________________________________________________________________ ***************************************** De informatie verzonden in deze e-mail (inclusief bijlagen) kan vertrouwelijk van aard zijn en is uitsluitend bestemd voor de geadresseerde(n). Indien deze e-mail niet voor u bestemd is, verzoeken wij u vriendelijk het bericht te retourneren en vervolgens te vernietigen. Yarden doet er alles aan om ervoor te zorgen dat verzonden e-mailberichten vrij zijn van virussen, maar kan dit niet garanderen. Yarden Holding B.V., statutair gevestigd te Almere, Handelsregisternummer 34155452 Yarden Uitvaartfaciliteiten B.V., statutair gevestigd te Almere, Handelsregisternummer 30104432 Yarden Uitvaartzorg B.V., statutair gevestigd te Almere, Handelsregisternummer 04050164 Yarden Uitvaartverzekeringen N.V., statutair gevestigd te Almere, Handelsregisternummer 33244450 *****************************************