https://community.qlik.com/t5/Qlik-Replicate/Fractional-second-precision-exceeds-the-scale-specified-in-the/m-p/1885183#M1710 <P>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?</P> <P>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?</P> <P>I believe to have seen this error in the past when Replicate stumbled into completely invalid data and tried to interpret it as date.&nbsp; Can you determine/show date data examples from the source row(s) tripping this error?</P> <P>hth,</P> <P>Hein.</P> Tue, 25 Jan 2022 16:34:11 GMT Heinvandenheuvel 2022-01-25T16:34:11Z https://community.qlik.com/t5/Qlik-Replicate/Fractional-second-precision-exceeds-the-scale-specified-in-the/m-p/1885019#M1698 <P>Has anyone ever seen this specific error on a task?</P> <P>&nbsp;</P> <P>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.</P> <P>If so, how was it resolved?</P> Tue, 25 Jan 2022 13:11:30 GMT https://community.qlik.com/t5/Qlik-Replicate/Fractional-second-precision-exceeds-the-scale-specified-in-the/m-p/1885019#M1698 C_Burton 2022-01-25T13:11:30Z https://community.qlik.com/t5/Qlik-Replicate/Fractional-second-precision-exceeds-the-scale-specified-in-the/m-p/1885183#M1710 <P>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?</P> <P>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?</P> <P>I believe to have seen this error in the past when Replicate stumbled into completely invalid data and tried to interpret it as date.&nbsp; Can you determine/show date data examples from the source row(s) tripping this error?</P> <P>hth,</P> <P>Hein.</P> Tue, 25 Jan 2022 16:34:11 GMT https://community.qlik.com/t5/Qlik-Replicate/Fractional-second-precision-exceeds-the-scale-specified-in-the/m-p/1885183#M1710 Heinvandenheuvel 2022-01-25T16:34:11Z