DB2 - Problem description
Problem IT35195 | Status: Closed |
ERROR OCCURS WHEN BATCH INSERT CONTAINS REGULAR RECORDS FOLLOWEDBY RECORDS WITH READONLY COLUMN USING IBM ENTITY FRAMEWORK CORE | |
product: | |
DB2 CONNECT / DB2CONNCT / B50 - DB2 | |
Problem description: | |
User might face error when batch insert contains regular records followed by records with read-only column using IBM EntityFramework Core Provider. This usually occurs while inserting multiple records in batch for 2 or more tables, where at-least one table has read-only column. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * IBM Entity Framework Core using batch insert * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to IBM Entity Framework Core package version * * 3.1.0.400 or later, NuGet links are: * * https://www.nuget.org/packages/IBM.EntityFrameworkCore/3.1.0 * * .400 * * https://www.nuget.org/packages/IBM.EntityFrameworkCore-lnx/3 * * .1.0.400 * * https://www.nuget.org/packages/IBM.EntityFrameworkCore-osx/3 * * .1.0.400 * **************************************************************** | |
Local Fix: | |
Execute batch for each table separately. | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * IBM Entity Framework Core using batch insert * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to IBM Entity Framework Core package version * * 3.1.0.400 or later, NuGet links are: * * https://www.nuget.org/packages/IBM.EntityFrameworkCore/3.1.0 * * .400 * * https://www.nuget.org/packages/IBM.EntityFrameworkCore-lnx/3 * * .1.0.400 * * https://www.nuget.org/packages/IBM.EntityFrameworkCore-osx/3 * * .1.0.400 * **************************************************************** | |
Comment | |
Fixed in 11.5.5.0. Fix is available with IBM Entity Framework Core package version 3.1.0.400 or later releases. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 08.12.2020 23.12.2021 23.12.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |