Skip to main content
Announcements
UPGRADE ADVISORY for Qlik Replicate 2024.5: Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
C_Burton
Contributor
Contributor

Fractional second precision exceeds the scale specified in the parameter binding

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?

Labels (1)
1 Reply
Heinvandenheuvel
Specialist III
Specialist III

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.