|
Problem IT31045
|
Status: Closed |
BULKCOPY ERROR WHILE CHAIN INITIALIZATION WITH NULL VALUE FOR DECIMAL COLUMNS ( Will fix in .NET Core 3 package (1H2020))
|
| product: |
DB2 CONNECT / DB2CONNCT / B10 - DB2 |
| Problem description: |
DB2 .NET Core 2 package throwing the following exception
+Row: 16001; Message: [IBM] CLI0111E Numeric value out of range.
SQLSTATE=22003; Source: IBM.Data.DB2. when 16K multiples of
chain is ending and we get NULL value to derive the data type
when source is DataTableState |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* 2 *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* The issue fixed in IBM Data Server Provider for .NET Core *
* version 3.1 package *
**************************************************************** |
| Local Fix: |
NA |
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* 2 *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* The issue fixed in IBM Data Server Provider for .NET Core *
* version 3.1 package *
**************************************************************** |
| Comment |
+Description: Db2 .NET Core 2 package throwing the following
exception
+Row: 16001; Message: [IBM] CLI0111E Numeric value out of range.
SQLSTATE=22003; Source: IBM.Data.DB2. when 16K multiples of
chain is ending and we get NULL value to derive the data type
when source is DataTableState
There are two possible solutions, one is to rectify the current
logic in native layer as we are not changing the SQL statement
there is no need to derive the type of columns after each chain
end.
We need to enhance NULL value conditional checks for Decimal
columns. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 22.11.2019
08.07.2020
08.07.2020 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
