I use PutFile following ConvertAvroToJSON to check the content of ConvertAvroToJSON's output.
From: Li, Peng Sent: Saturday, 10. September 2016 16:00 To: '[email protected]' <[email protected]> Subject: Re: Re: PutSQL error sql.arg3.value cannot convert to timestamp Hi Bryan, In provenance the attribute sql.args.3.value was given as "2016-04" and sql.args.3.type was given as "93". But as already said in previous mail, i checked the content of the output of ConvertAvroToJSON and "2016-04-29 00:00:00.0" was given there, so I think this value was given to the following ConvertJSONToSQL processor. Perhaps it has nothing to do with format "yyyy-MM-dd HH:mm:ss.SSS" but something else? Thanks Peng -----Original Message----- On Fri, 09 Sep 2016 12:06:35 GMT Bryan Bende [email protected]<mailto:[email protected]<mailto:[email protected]%3cmailto:[email protected]>> wrote: Hi Peng, In the stack trace it looks like it thinks the value of sql.args.3.value is "2016-04" rather than "2016-04-29 00:00:00.000". Can you double check the value of sql.args.3.value? You can look at the flow file in provenance and look at the attributes.
