TimeStamp

[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

[salil]

Could u tell us what's ur input and what manipulations were u attempting which resulted in the error???

[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?

[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

[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")

[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.

[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?

[gshivnani]

Thanks Arnd,

It is a String Type "Varchar".

[ArndW]

And what is the format of this Varchar? Is it YYY-MM-DD?

[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

[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.

[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