Data Hub VErsion 5.5.0.1 Problem with MS SQL/SAP-Customer Extension

[Former Member]

Hi everyone,

it seems there is an existing problem with the SAP-Customer Extension in Version 5.5.0.1. in conncetion with MS SQL.

Exception which occured is:

 17:24:47.688 [ERROR] [com.hybris.datahub.extension.load.impl.DefaultExtensionLoaderService] Could not load extension com.hybris.datahub.extension.load.ExtensionImportException: Failed to create attribute com.hybris.datahub.dto.extension.RawItems$Item$Attributes$Attribute@610dbe3f for raw type RawHybrisCustomer ....
 Caused by: java.lang.IllegalArgumentException: Property Name cannot be changed at com.google.common.base.Preconditions.checkArgument(Preconditions.java:125) ~[guava-17.0.jar:na] at com.hybris.kernel.services.metadata.impl.DefaultMetadataService.setPropertyDefinition(DefaultMetadataService.java:89) ~[kernel-service-5.5.0.1-RC2.jar:na]

Quick and Dirty Fix for me was to remove all occurence of RawHybrisCustomer and RawHybrisB2BCustomer because we do not need them in our use-case (no User-Replication hybris-> SAP) So it seems it is just an issue with the SAP-Customer Extension not a general one. On the other hand with HSQL there are no problems at all...

Is anyone having the same issues?

[former_member224482]

There is an attribute "name" and another attribute "Name". The properties are case sensitive while the DB is case insensitive.

Please read the following thread : https://answers.sap.com/questions/12752949/data-hub-55-installation-issue-with-db-with-collat.html

[Former Member]

Hi Robin, the DB indeed is case insensitive, when i switch that to case sensitiv the Data Hub starts but i get SQL-Errors during Data-Import -> I already read the thread you mentioned -> that is my point i am using 5.5.0.1 for the datahub and we have the same issue here.

BR Dennis

[Former Member]

It looks like the SAP-Customer Extension tries to modify a SchemalessAttribute in the kernel metadata service which is not allowed.

But maybe the reason behind is that you have some violated database state which contains invalid schemaless attribute definitions for RawHybrisCustomers

[Former Member]

Hi Matthias, thank you for your answer -> i already dropped the hole DB and created a new one but it makes no difference.

Cause of the problem could be a failure in how the schema is created by the data hub for MS-SQL.

Do you have a running data hub with MS-SQL?