Solved

datediff function resulted in an overflow

  • 28 February 2023
  • 3 replies
  • 170 views

Hi,

I am using the ODX server to get data from the SQL server database.

After executing the transfer task, I am getting the below error.

Any idea how to solve this?

“System.Data.SqlClient.SqlException (0x80131904): The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large. Try to use datediff with a less precise datepart.System.Data.SqlClient.SqlException (0x80131904): The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large. Try to use datediff with a less precise datepart.”

icon

Best answer by Christian Hauggaard 1 March 2023, 09:20

View original

3 replies

Userlevel 3
Badge +3

Which version of ODX and SQL Provider are you using ?

Have you defined incremental load on a date type column ?

Can you use a Query Table with an explicit SQL statement to extract rows from this table ?

Userlevel 6
Badge +5

Hi @sguntupalli, another alternative is to use data type override feature to bring in the date column as text and then later on convert it back to a date

 

Userlevel 6
Badge +5

Hi @sguntupalli did you manage to resolve the error? If so can you please help us by selecting and marking a best answer

Reply