Conversion error for time stamp field in transformer stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Developer9
Premium Member
Premium Member
Posts: 187
Joined: Thu Apr 14, 2011 5:10 pm

Conversion error for time stamp field in transformer stage

Post by Developer9 »

Hi All,


I have a few time stamp fields in transformer stage I am defaulting to Blanks ('') because I do not have source data but these fields are needed as an input for funnel operation .

Also I am converting few timestamp fields to string (vachar) using below derivation

Code: Select all

If IsNull(lnk_records.DATE) Then '' 
Else
If IsValidTimestamp(lnk_records.DATE)  
Then 
DateToString(TimestampToDate(lnk_records.DATE),"%mm/%dd/%yyyy") 
Else ''
I am getting below error with job success run

Code: Select all

xfm_mapping: Conversion error calling conversion routine timestamp_from_ustring data may have been lost
I tried to ran job with several attempts with adding /removing column by column to figure out the issue but issue still exist.

Please give me some tips on How to identify the field having the issue ?

Thanks
Post Reply