Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Has anyone ever seen this specific error on a task?
RetCode: SQL_ERROR SqlState: 22008 NativeError: 0 Message: [Microsoft][SQL Server Native Client 11.0]Datetime field overflow. Fractional second precision exceeds the scale specified in the parameter binding.
If so, how was it resolved?
Can you provide a little more context on the error message? Source or target? Did you investigate the query leading to the error. Perhaps you can find it in the log just above the error message when you increase the logging level for the component reporting the error (target_apply? source_capture?) to trace or if tht does not help to verbose?
What is the source datatype and what it the target datatype and replicate transformation (if any) for the column with the problem? Maybe it needs a transformation to an explicit precision?
I believe to have seen this error in the past when Replicate stumbled into completely invalid data and tried to interpret it as date. Can you determine/show date data examples from the source row(s) tripping this error?
hth,
Hein.