cancel
Showing results for 
Search instead for 
Did you mean: 

Integration Key generation for canonical item CanonicalItem is not getting generated

Former Member
0 Kudos

Hi Experts,
I am trying to setup data hub and wanted to test it. I followed the the steps mentioned in the wiki and I am getting the following error and I don't have clue what was causing the issue. I have tried to import Apparel test data as described in.

https://help.hybris.com/6.0.0/hcd/574d6afad6e64fd3bb1828abfb865cd5.html

INFO | jvm 1 | srvmain | 2016/05/17 14:20:22.716 | 2016-05-17 14:20:22,658 [DEBUG] [c.h.d.c.i.CompositionChainRunnerStrategy] Integration Key generation for canonical item CanonicalItem{id='null', integrationKey='null', status=ERROR, dataPool='DataHubPoolEntity{id=0, name=GLOBAL}', fields='{identifier=M34704, manufacturerAID=null, productID=null, isConfigurable=null, manufacturerName=, blockedFrom=null, numberContentUnits=null, creationSystem=null, creationDate=null, division=null, unit=pieces, baseDescription=null, ean=null, GTIN=null, blocked=null, baseProductID=null, name=null, category=[100, tshirts], baseName={de=Herren T-Shirt Playboard Raster SS, en=T-Shirt Men Playboard Raster SS}}'} failed. INFO | jvm 1 | srvmain | 2016/05/17 14:20:22.718 | 2016-05-17 14:20:22,659 [DEBUG] [c.h.d.c.i.CompositionChainRunnerStrategy] Integration Key generation for canonical item CanonicalItem{id='null', integrationKey='null', status=ERROR, dataPool='DataHubPoolEntity{id=0, name=GLOBAL}', fields='{identifier=95385, manufacturerAID=null, productID=null, isConfigurable=null, manufacturerName=, blockedFrom=null, numberContentUnits=null, creationSystem=null, creationDate=null, division=null, baseDescription={en=Everyday riders make sacrifices like living in a laundry room or }, unit=pieces, ean=null, GTIN=null, blocked=null, baseProductID=null, name=null, category=[190100], baseName={de=Andover Jacke}}'} failed. INFO | jvm 1 | srvmain | 2016/05/17 14:20:22.718 | 2016-05-17 14:20:22,659 [DEBUG] [c.h.d.c.i.CompositionChainRunnerStrategy] Integration Key generation for canonical item CanonicalItem{id='null', integrationKey='null', status=ERROR, dataPool='DataHubPoolEntity{id=0, name=GLOBAL}', fields='{identifier=M25687, manufacturerAID=null, productID=null, isConfigurable=null, manufacturerName=, blockedFrom=null, numberContentUnits=null, creationSystem=null, creationDate=null, division=null, unit=pieces, baseDescription=null, ean=null, GTIN=null, blocked=null, baseProductID=null, name=null, category=[100, tshirts], baseName={de=Herren T-Shirt Playboard Skull SS, en=T-Shirt Men Playboard Skull SS}}'} failed. INFO | jvm 1 | srvmain | 2016/05/17 14:20:22.818 | 2016-05-17 14:20:22,727 [DEBUG] [c.h.d.c.i.CompositionChainRunnerStrategy] Integration Key generation for canonical item CanonicalItem{id='null', integrationKey='null', status=ERROR, dataPool='DataHubPoolEntity{id=0, name=GLOBAL}', fields='{identifier=null, product=M34704, size=null, styleDescription=null, style=null, SKU=null}'} failed. INFO | jvm 1 | srvmain | 2016/05/17 14:20:22.818 | 2016-05-17 14:20:22,727 [DEBUG] [c.h.d.c.i.CompositionChainRunnerStrategy] Integration Key generation for canonical item CanonicalItem{id='null', integrationKey='null', status=ERROR, dataPool='DataHubPoolEntity{id=0, name=GLOBAL}', fields='{identifier=M28323, manufacturerAID=null, productID=null, isConfigurable=null, manufacturerName=, blockedFrom=null, numberContentUnits=null, creationSystem=null, creationDate=null, division=null, baseDescription={en=Features:

+ suede an canvas upper with classic action stripe
}, unit=pieces, ean=null, GTIN=null, blocked=null, baseProductID=null, name=null, category=[2625, 270000], baseName={en=Sneakers Vans Old Skool}}'} failed. INFO | jvm 1 | srvmain | 2016/05/17 14:20:22.818 | 2016-05-17 14:20:22,752 [DEBUG] [c.h.d.c.i.CompositionChainRunnerStrategy] Integration Key generation for canonical item CanonicalItem{id='null', integrationKey='null', status=ERROR, dataPool='DataHubPoolEntity{id=0, name=GLOBAL}', fields='{identifier=M35364, manufacturerAID=null, productID=null, isConfigurable=null, manufacturerName=***, blockedFrom=null, numberContentUnits=null, creationSystem=null, creationDate=null, division=null, unit=pieces, baseDescription=null, ean=null, GTIN=null, blocked=null, baseProductID=null, name=null, category=null, baseName={de=Herren T-Shirt Playboard Logo, en=T-Shirt Men Playboard Logo}}'} failed.

former_member224482
Active Contributor
0 Kudos

Which field of your canonical item is the primaryKey ?
What is the transformation for this primaryKey field ?

Former Member
0 Kudos

Thanks Robin for your response,

I am trying to test the data hub for the Apparel store with predefined pcm-apparel-*-6.0.0.0-RC12.jars

below field identifier is defined as primary key

         <type>CanonicalProduct</type>
         <description>Canonical representation of apparel product</description>
         <status>ACTIVE</status>
         <attributes>
             <attribute>
                 <name>identifier</name>
                 <model>
                     <localizable>false</localizable>
                     <collection>false</collection>
                     <type>String</type>
                     <primaryKey>true</primaryKey>
                 </model>
             </attribute>

The sourceId defined in the raw product is the transformation to canonical Item attribute identifier.

 <canonicalItems>
     <item>
         <type>CanonicalProduct</type>
         <attributes>
             <attribute>
                 <name>identifier</name>
                 <transformations>
                     <transformation>
                         <rawSource>RawProduct</rawSource>
                         <expression>sourceId</expression>
                     </transformation>
                 </transformations>
             </attribute>
         

Accepted Solutions (0)

Answers (5)

Answers (5)

former_member224482
Active Contributor
0 Kudos

The SAP Integration cannot co-exists with the pcm example.
Both scenario are deployable in a mutually exclusive way.

To be clear, if you see both pcm*.d sap*.jar on the Data Hub, something is wrong.

Former Member
0 Kudos

Thanks Robin,

Gave a shot to your suggestion. but getting same error. If i created a B2B storefront, which example jars i should use? I havnt found any PCM-Powertools*.jar.

Can this be a reason for null integration key?

Thanks in advance.

former_member224482
Active Contributor
0 Kudos

Unfortunately, I have never used/deployed the pcm examples.

Former Member
0 Kudos

:):P:P:P:P:)

Former Member
0 Kudos

Hi Palla,

How did you resolved the issue?

Thnks in advance

Former Member
0 Kudos

Hi ,

Sorry for the late response, I haven't resolved the issue and is still living with the issue. Also awaiting to hear anwer from hybris experts.

Thanks, Palla

former_member224482
Active Contributor
0 Kudos

As I've already answered, remove either the SAP extensions or the PCM examples. Both cannot co-exists on the same Data Hub.

Former Member
0 Kudos

Hi Robin,

Thanks for your response. I have removed all the sap jars from the data hub lib folder and tried again to import the csv data and got the same error see below:

 INFO   | jvm 1    | srvmain | 2016/06/15 15:38:01.431 | 2016-06-15 15:38:01,423 [DEBUG] [c.h.d.c.i.CompositionChainRunnerStrategy] Integration Key generation for canonical item CanonicalItem{id='null', integrationKey='null', status=ERROR, dataPool='DataHubPoolEntity{id=0, name=GLOBAL}', fields='{identifier=null, product=Z25687, size=null, styleDescription=null, style=null, SKU=null}'} failed.

former_member224482
Active Contributor
0 Kudos

I am not familiar with the PCM scenario, but from what I see the primaryKey is identifier mapped from sourceId of RawProduct. From the error, the sourceId was not provided, only the field product had the value Z25687.

Former Member
0 Kudos

May I know which file is going to be updated? I get the same error. Below is more info from my side.

I get the same error when we try test product import through REST API as per guide mentioned. Same error when we try to push material from SAP. However customer replication works fine.

We will look forward to file to be updated.

Thanks.

Former Member
0 Kudos

Hi Palla,

I believe the error in Load has been corrected. The https://help.hybris.com/6.0.0/hcd/574d6afad6e64fd3bb1828abfb865cd5.html file will be updated Friday, and you should be able to see the new content by Saturday afternoon regardless of where you live.

Regards Bob

Former Member
0 Kudos

Hi Bob,

May I know whether the changes for Testing Data Load (https://help.hybris.com/6.0.0/hcd/574d6afad6e64fd3bb1828abfb865cd5.html) have been published or not. I just tried loading the data today, data taken from the above link and still getting the Integration Key as null.

Thanks, Palla

rafal_gdowski
Active Contributor
0 Kudos

Palla,

You are not doing anything wrong. Looks like the collection in the document has an error in it (intentionally or not). I will bring this to the attention of the Tech Writer team.

Former Member
0 Kudos

Hi Rafal, would you be able to provide your comment on my question mentioned below. I think I have the same issue as above. Your input would be great help. Thanks Rafal.

https://answers.sap.com/questions/12758401/hybris-60-data-hub-issue-failed-to-create-target-i.html

Former Member
0 Kudos

Hi Rafal,

I couldn't see any change in the document wiki and is still living with the same issue. Could you please let me know when can I expect the resolution for it?

Thanks Palla

Former Member
0 Kudos

Hi Palla,

There was a purposeful error in the data file. It was there to illustrate how Data Hub handled such situations. I fixed it.

I looked at the error content you received, and it does not look like anything associated with the data file. Would you please refer to Robin Venzina's comment at the bottom of this thread. It may be what you are looking for.

Technical Writer