DSXchange

Posted: **Wed Jan 18, 2012 3:58 pm**

I am getting this error. I have not found any entry for such. Has anyone come across this type of error before and if so, how to resolve it?
DB2_TISUITE_WORK,0: Invalid timestamp value in setOutputFieldAsTimeStamp() for field '184' in output dataset '0'. Time stamp string = 0000-00-00 00:00:00.000000, format string = %yyyy-%mm-%dd %hh:%nn:%ss.6.

Posted: **Wed Jan 18, 2012 4:31 pm**

For a start, 0000-00-00 00:00:00 is not a valid timestamp so that may be the cause

Posted: **Wed Jan 18, 2012 5:10 pm**

I trust it may be Data issue / Format mismatch.

What is your source and how the data is for this column?

DS User

Posted: **Wed Jan 18, 2012 5:29 pm**

Kryt0n wrote:For a start, 0000-00-00 00:00:00 is not a valid timestamp so that may be the cause

This.

Posted: **Fri Jan 20, 2012 10:00 am**

I don't know what has fixed the issue, but now its not coming after I changed the prefetch rows to a smaller value of 100 from 2000.

DSXchange

Timestamp format error

Timestamp format error

Re: Timestamp format error