Getting warning as Conversion error routine date_from_string

[Sridhar Sivakoti]

Hi,

I have developed a job(Seq file -> Transformer -> Oracle) form Seq file I am pulling the date column values(Some values are null also) which are Varchar data type and in transformer I am using the StringToDate function to convert these Varchar into Date type. When I am running this job I am getting the below warning.

APT_CombinedOperatorController,0: Conversion error calling conversion routine date_from_string data may have been lost

Please let me know what might be the reason and how we can eliminate this warning

Thanks in Advance

Regards
Sridhar

[ray.wurlod]

Start by disabling operator combination so you can determine precisely which operator is generating the error.

[dsedi]

Well..

you have to verify the contents of the particular field before perform the actual conversion.

you should do something like below

Code: Select all

If Trim(date column)='' then SetNull() else StringToDate(date column)

Edi