Page 1 of 1
TimeStamp
Posted: Thu Nov 10, 2005 7:44 am
by gshivnani
Hi All,
getting this error for Time stamp. CAn any one help in this
ValidateAndSplit,3: Invalid value for this date type: **********.
Invalid value for this date type: **********.
Invalid value for this date type: **********.
Gul
Re: TimeStamp
Posted: Thu Nov 10, 2005 8:04 am
by salil
Could u tell us what's ur input and what manipulations were u attempting which resulted in the error???
Posted: Thu Nov 10, 2005 8:05 am
by ArndW
Gul,
lots of people here could help if we knew more. You are seeing and showing us the text representation of an invalid TimeStamp value. What is the last stage where the TimeStamp was (verifiably) correct and what did you do to it thereafter?
Posted: Thu Nov 10, 2005 8:10 am
by gshivnani
Thanks for the reply:
This is what i am giving in my target output field
Derivation :
"TimestampFromDateTime(StringToDate(JoinCombine_Master_Ref.TrailerTimeStamp,"%yyyy-%mm-%dd"), StringToTime("00:00:00","%hh:%nn:%ss")) "
Column Name:
SRC_PROCESS_DTTM
On Compiling getting this error
Posted: Thu Nov 10, 2005 8:17 am
by ArndW
If JoinCombine_Master_Ref.TrailerTimeStamp is a string datatype with the YYYY-MM-DD format, then I recommend using the simpler
Code: Select all
StringToTimestamp(JoinCombine_Master_Ref.TrailerTimeStamp:" 00:00:00","%yyyy-%mm-%dd %hh:%nn:%ss")
Posted: Thu Nov 10, 2005 8:30 am
by gshivnani
Arnd,
used the suggested code. The Job Failed and got Aborted. with these fatal Errors..
Target_Database,3: Failure during execution of operator logic.
Target_Database,3: Input 0 consumed 0 records.
Target_Database,3: Fatal Error: Invalid time
node_node4: Player 14 terminated unexpectedly.
Posted: Thu Nov 10, 2005 8:37 am
by ArndW
And what have you tested, gshivnani?
I trust you didn't post first before trying to localize the problem.
I just wrote a short job, column generator creating a varchar(32) string with the constant value "2005-10-01" and a transform stage using the StringToTimestamp conversion and it worked.
As I indirectly asked in the previous post, is your JoinCombine_Master_Ref.TrailerTimeStamp column a string type?
Posted: Thu Nov 10, 2005 9:08 am
by gshivnani
Thanks Arnd,
It is a String Type "Varchar".
Posted: Thu Nov 10, 2005 9:10 am
by ArndW
And what is the format of this Varchar? Is it YYY-MM-DD?
Posted: Thu Nov 10, 2005 9:13 am
by gshivnani
Thanks for Reply It is in this format:
Derivation :
"TimestampFromDateTime(StringToDate(JoinCombine_Master_Ref.TrailerTimeStamp,"%yyyy-%mm-%dd"), StringToTime("00:00:00","%hh:%nn:%ss")) "
Column Name:
SRC_PROCESS_DTTM
Posted: Thu Nov 10, 2005 9:37 am
by ArndW
You already posted the format you thought it was in, but I asked what the data for this column actually contains. If it contains any format except YYYY-MM-DD in your varchar (even extraneous spaces count against you) then you are going to get an error.
Posted: Fri Nov 11, 2005 3:04 am
by richdhan
Hi Shivani,
These kind of issues occur for one of the 2 reasons
1. Invalid Data
2. Invalid Format used in the transformer function.
Pls provide sample input data as you have already provided the derivation.
--Rich