ERROR [22008] [IBM][CLI Driver] CLI0114E Datetime field overflow. SQLState=22008
Article # 3040397 - Page views: 86
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 |