AnsweredAssumed Answered

date parsing error while using bcp to create/import a data

Question asked by jason.caruso407553 on Jun 11, 2018
Latest reply on Jun 14, 2018 by Adam Arrowsmith


After mapping import data from a flat file (profile as a tab delimited) to an XML profile, which was create via an import process from the bcp connector shape. While testing my process, i hit a failure when i hit the bcp shape which is centered around XML and not being able to parse the datefield. if i remove that mapping the upload process works correctly.

Date from shape:   <Date_crt>2018-06-12 01:14:17.642</Date_crt>


Date format in the XML profile: yyyy-MM-dd HH:mm:ss.SSS --> I have also tried the Boomi standard format as well.


Error msg: Test execution of Connect bcp test upload completed with errors. Embedded message: Error parsing XML stream.; Caused by: Unparseable date: "2018-06-12 01:14:17.642"


Failure message from BCP connector shape: Failed processing input BD:2018.06.11_379030384:0


Based on all the documentation that i have read I don't know what i am doing wrong.

Adam Arrowsmith -- do you happen to have any ideas?#