INVALID_PRIMARY_KEY : DataHub Composition for Product after migrated from 5.6 to 6.1

[Former Member]

Hi All,

We have migrated from datagub 5.6 to 6.1.I have added the necessary jars like saperpproduct-canonical-6.1.0.2-RC1.jar,saperpproduct-raw-6.1.0.2-RC1.jar,saperpproduct-target-6.1.0.2-RC1.jar,product-canonical-6.1.0.2-RC1.jar I'm testing the PRODUCT master data (MATMAS) in Hybris using DataHub. It is failing in the Composition phase with error INVALID_PRIMARY_KEY for CanonicalCtgGenericVariantProduct. Below is the trace from datahub.log [http-bio-8080-exec-3] [2016-10-03 11:37:35,221] [DEBUG] [org.hibernate.internal.util.EntityPrinter] com.hybris.datahub.domain.jpa.entities.ManagedCanonicalItemEntity{modifiedTime=2016-10-03 11:36:52.0, itemType=CanonicalCtgGenericVariantProduct, creationTime=2016-10-03 11:36:52.0, dataPool=com.hybris.datahub.runtime.domain.jpa.entities.DataHubPoolEntity#0, rawItemEntities=[com.hybris.datahub.domain.jpa.entities.ManagedRawItemEntity#5], compositionAction=com.hybris.datahub.runtime.domain.jpa.entities.CompositionActionEntity#1, version=0, integrationKey=, typeCode=ManagedCanonicalItemEntity, id=1, publicationStatusEntities=[], compositionStatusDetail=INVALID_PRIMARY_KEY, tenant=null, properties={CanonicalCtgGenericVariantProduct_baseProductID=null, CanonicalCtgGenericVariantProduct_distributionChannel=null, CanonicalCtgGenericVariantProduct_unit=EA, CanonicalCtgGenericVariantProduct_aliasProductNumbers=1A3884,CP14, CanonicalCtgGenericVariantProduct_productID=001A3884, CanonicalCtgGenericVariantProduct_sapAction=null, CanonicalCtgGenericVariantProduct_salesOrganization=null}, status=ERROR} [http-bio-8080-exec-3] [2016-10-03 11:37:35,221] [DEBUG] [org.hibernate.internal.util.EntityPrinter] com.hybris.datahub.runtime.domain.jpa.entities.CompositionActionEntity{modifiedTime=2016-10-03 11:36:52.0, creationTime=2016-10-03 11:36:51.0, pool=com.hybris.datahub.runtime.domain.jpa.entities.DataHubPoolEntity#0, count=15, startTime=2016-10-03 11:36:51.0, id=1, endTime=2016-10-03 11:36:52.0, tenant=null, status=COMPLETE_W_ERRORS, typeCode=CompositionAction}

Thanks Deba

[former_member224482]

All attributes marked at primaryKey in CanonicalCtgGenericVariantProduct must have a non-null value.

Either filter out the invalid raw items populating the CanonicalCtgGenericVariantProduct or write the proper transformations to process the raw items.

[Former Member]

Hi Robin,

The same iDoc is working fine for 5.6 DataHub instance it's falling for 6.1DataHub. And my guess is may be because in 5.6 we don't have creationSystem for CanonicalProductSales.And with 6.1 the integration key is the combination of the productId and creationSystem.Even though in my iDoc EQACLNT300

here is the integrationKey created : EQACLNT300|001A3884|2100_99

Do i need to add the creationSystem attribute in my canonical-datahub-exetnsion.xml ?Pl suggest.

Thanks Deba