Skip to Content
0
Former Member
Mar 20, 2015 at 10:56 AM

Data Hub 5.5 installation issue with DB with COLLATION CASE INSENSITIVE

399 Views

I'm trying to install Data Hub 5.5 with MS SQL Server 2014 with COLLATION SQL_Latin1_General_CP1_CI_AS but DH give me this error:

com.hybris.datahub.extension.load.ExtensionImportException: Failed to create attribute com.hybris.datahub.dto.extension.RawItems$Item$Attributes$Attribute@9cda7 2e for raw type RawHybrisCustomer … Caused by: java.lang.IllegalArgumentException: Property Name cannot be changed

So RawHybrisCustomer metadata and others can't be imported (RawCustomer, RawSapErpConsumerReplicationNotification, RawHybrisB2BCustomer).

The same error if I use MySQL with latin1_general_ci COLLATE.

If I set CASE SENSITIVE as COLLATION it seems work for both MS SQL Server and MySQL, but I don't known potential side effects with this option. I don't know if with this configuration data exchange works... Also with OOTB embedded HDBSQL it seems work.

Have you any suggestions?

Thks