ERROR [22008] [IBM][CLI Driver] CLI0114E Datetime field overflow. SQLState=22008

Question / Problem: 

"ERROR [22008] [IBM][CLI Driver] CLI0114E Datetime field overflow. SQLState=22008" displays in data loader or when testing an SQL for a metric / record.

Answer / Solution: 

This error may occur if the data source is a mainframe DB2 database. DB2's date data types differ from SQL Server's date types. In this case, the issue is likely caused when a DB2 date field (no time) is mapped to a SQL Server's Date field (which stores date and time) causing the overflow error.

As a workaround, when setting  your From and To date parameters, use midnight (00:00:00:0000) but that may restrict your range depending on your requirements.

Applies to: