Since the error message includes the Pentaho application it could be that Pentaho is causing the error. You could attempt to import a single entry directly to the DMT form to isolate the error.
-----Original Message----- From: Boyd, Rebecca <boy...@wfu.edu> To: arslist <arslist@ARSLIST.ORG> Sent: Fri, Feb 21, 2014 4:12 pm Subject: DMT and extra Zeros ** Hello everyone, I am trying to load incidents using the HPD_LoadHelpDesk tab of the Transactional_Incident spreadsheet. The job is erroring out on the Load step because it can’t convert a date. The date looks correct on the spreadsheet, but when Remedy reports the error, it always reports an extra zero for the seconds. 2014/01/02 00:00:00.00 – Spreadsheet data 2014/01/02 00:00:00.000 – Remedy error I have typed the date in fresh. I've changed the date & time. I've re-formatted the cell. I've created new jobs every time only to get the same 'ol error message. 8.1 Clean Install, Oracle 11g Here’s a truncated version of the error message: 2014/02/21 15:36:17 - Transactional_Incident - Start of job execution 2014/02/21 15:36:17 - Convert Dates.0 - ERROR (version 4.1.0, build 1 from 2012-11-06 13.20.53) : Unexpected error : 2014/02/21 15:36:17 - Convert Dates.0 - ERROR (version 4.1.0, build 1 from 2012-11-06 13.20.53) : org.pentaho.di.core.exception.KettleValueException: 2014/02/21 15:36:17 - Convert Dates.0 - ERROR (version 4.1.0, build 1 from 2012-11-06 13.20.53) : Reported Date String : couldn't convert string [2014/01/02 00:00:00.000] to a date using format [MM/dd/yyyy HH:mm:ss] 2014/02/21 15:36:17 - Transactional_Incident - Transactional_Incident 2014/02/21 15:36:17 - Transactional_Incident - ERROR (version 4.1.0, build 1 from 2012-11-06 13.20.53) : Errors detected! 2014/02/21 15:36:18 - Transactional_Incident - Job execution finished -- Rebecca Boyd Application Administrator Wake Forest University _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"