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 <[email protected]>
Verzonden: vrijdag 8 juni 2018 10:45:41
Aan: [email protected]
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 <[email protected]> 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
*****************************************
