Customers may experience the following error when importing a .csx file:

, the operation fails with the following database uniqueness error:

Duplicate entry 'DomainType?CC5FC0E2-F3D7-4F8B-B351-295BC94805B3-VAR ENERGI' for key 'BC_DOMAINID.DOMAINTYPE_OID'

The underlying exception is:

java.sql.SQLIntegrityConstraintViolationException

This issue can be caused by the target MySQL 8 database using an accent-insensitive collation, which caused two genuinely distinct business identifiers to be treated as the same.

all platforms using MySQL Server as a database

When creating the BC and BCCE schemas, use the following character set and collation:

CREATE SCHEMA `bcce17` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_as_ci ;

This will allow the successful import of the .csx file.

Customer may experience CSX file import failures when migrating to newer versions of BusinessConnect and BusinessConnect Container Edition.  This article describes how to resolve the issue.