Datetime field overflow

arnie_nits · Post by **arnie_nits** » Mon Aug 24, 2009 8:16 am

Hi,
I am getting this err:
Load_IPNA_Sample_insert..Transformer_36: [DataDirect][ODBC SQL Server Driver]Datetime field overflow.

Please explain what might have caused it.....I checked several times but unable to figure....especially when more that half of the records got inserted with the same kind data....(I got two timestamp fields, one from the source and the other I have hardcoded some default value)

Thanks
Arnie.

chulett · Post by **chulett** » Mon Aug 24, 2009 8:52 am

Check the records that did not get inserted, see what the timestamps look like on those records. Use a reject link to capture them if need be, write the timestamp to a varchar there.

arnie_nits · Post by **arnie_nits** » Mon Aug 24, 2009 10:07 am

Thanks for the reply....

what I observed is very starnge...

2008-09-04 07:57:00.00 is getting converted to 2008-09-04 07:57:00.000000......althougt there were no transformations involved...just straight moved in the transformer.....

Thanks
Arnie

chulett · Post by **chulett** » Mon Aug 24, 2009 10:32 am

SQL Server includes milliseconds from what little I know. What is the actual target data type for that field in the table itself?

arnie_nits · Post by **arnie_nits** » Mon Aug 24, 2009 12:19 pm

data type is Timestamp 23,3......

any way to remove the millisecs....?? But the target is seq file here (intermediate job),so I guess the millisecs getting added in the transformer...

chulett · Post by **chulett** » Mon Aug 24, 2009 12:29 pm

You should be able to match that in the job, I believe, that or trim off the 'extra' milliseconds. 2008-09-04 07:57:00.000 would not overflow.