Hi All
The job was running fine in 7.5.1A. Now we are migrating the project to 8.5.
so our jobs are getting the below warnings.
"Conversion error calling conversion routine timestamp_from_ustring data may have been lost"
My source is database Oracle and we doing conversion in the transformer for timestamp conversion.
the code is like
If IsNotNull(lnk_InputIbsDDNS.AS_OF_DATE) then StringToTimestamp(lnk_InputIbsDDNS.AS_OF_DATE,'yyyy/mm/dd hh:nn:ss') Else NullToEmpty(lnk_InputIbsDDNS.AS_OF_DATE)
Please advise on this how to solve this issue.
Thanks in Advance.
Conversion error from varchar to Timestamp
Moderators: chulett, rschirm, roy
Re: Conversion error from varchar to Timestamp
You can search for timestamp_from_ustring data may have been lost
viewtopic.php?t=126084&highlight=timest ... +been+lost
These might help you.
DS User
viewtopic.php?t=126084&highlight=timest ... +been+lost
These might help you.
DS User
Hi Sura,
I tried that also but its not working in my case.
Here source is orace table, souce column data type is varchar 20 nullable yes.but table contain only date part( like 2011-04-20) .
the target table has date(timestamp format) and nullable no.
still i am getting the same error in transformer like "Conversion error calling conversion routine timestamp_from_ustring data may have been lost"
How to procede in this case.
I tried that also but its not working in my case.
Here source is orace table, souce column data type is varchar 20 nullable yes.but table contain only date part( like 2011-04-20) .
the target table has date(timestamp format) and nullable no.
still i am getting the same error in transformer like "Conversion error calling conversion routine timestamp_from_ustring data may have been lost"
How to procede in this case.