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"

Reply via email to