![Wink :wink:](./images/smilies/icon_wink.gif)
Teradata TPUMP Invalid Timestamp error
Moderators: chulett, rschirm, roy
Teradata TPUMP Invalid Timestamp error
After concatenating 2 string fields a date field:time field:('00') to a StageVariable, then a StringtoTimestamp conversion, we received the Invalid timestamp error when loading in TD using Tpump. The TD TimeStamp field is defined with a TimeStamp(0) therefore mille-seconds not used and Nulls Yes. In Peek the input fields and the svTimestamp fields all look good. The data is coming from a COBOL extract and all fields are loaded this was verified on the COBOl side as well. So if anybody has any idea why we are getting this invalid timestamp error would be greatly appreciated. Our developer is on the brink of pulling out his last strand of hair. ![Wink :wink:](./images/smilies/icon_wink.gif)
![Wink :wink:](./images/smilies/icon_wink.gif)
Charlie
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Verify the output of the stage variable. For example, did you need the third element to be ".00" rather than "00"? Did you need a space between the date portion and the time portion?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Thanks for the reply Ray. The third portion is :00, no mille-secs and there is a delimeter to allow for the date/time space. The developer said he changed the Display on the TD Column tab to equal the column length field and it he can load to TD without any invalid timestamp error.
I haven't had a chance to test this solution, since the Display shouldn't have an impact on writing to TD.
![Question :?:](./images/smilies/icon_question.gif)
I haven't had a chance to test this solution, since the Display shouldn't have an impact on writing to TD.
Charlie
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: