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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"

