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

Issue

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

displays in data loader or when testing an SQL for a metric / record.

 

Cause

Data type of date field mismatched.

 

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.

 

Level of Complexity 

Moderate

 

Applies to  

Product	Version	Build	Environment	Hardware
Insight	5.x 6.x

 

 

Article # 3040397