datetime2 vs datetime

[Former Member]

I just migrated from DS 3.2 to DS 4.2. In my preliminary testing, I came across the following error:

ODBC data source <server name> error message fro operation <SQLExecute>:<[Microsoft][SQL Server Native Client11.0] Datetime field overflow. Fractional second precision exceeds the sacale specified in the parameter binding>

This job was running fine with 3.2 using SQL Server 2008 R2 and somehow, it failed here with 4.2 and SQL Server 2008 R2 with a SQL Server Native Client 11 Driver.

Could anyone help me out or at least let me what was done wrong (I did not change anything as of yet).

Thanks all.

Adam

[Former Member]

There is an open ADAPT related to this. With new Data Services it considers the 6 digit fraction. You can try using the SQL Server Driver provided by Microsoft over the SQL Native Client.

The ADAPT says it is resolved in 4.1 SP2. Could you please check this SAP Note : 1875836

Thank You

Ganesh Sampath

[Former Member]

There are two datetime2(7) columns in the source table and there are two equivalent datetime columns in the target table and I think this is what the above error message was referring to...

[Former Member]

The error message says datetime field overflow, which means the value size is more than the field length. There is always a problem in datatime conversion with the SQL server. What you could try is a cast() function to convert it in DI before loading.