Hybris V1811 ECC V6.X DataHub
We have a set of product master idocs - what we are noticing is that the characteristic value is causing errors and as such not being replicated to hybris as a value
So we have a Segment like the following :
Segment :
<E1CAWNM SEGMENT="1">
<MSGFN>004</MSGFN>
<ATZHL>0004</ATZHL>
<ATWRT>P</ATWRT>
<ATFLV>0.000000000000000E+00</ATFLV>
<ATFLB>0.000000000000000E+00</ATFLB>
<ATCOD>1</ATCOD>
<TXTNR>0000</TXTNR>
<DATUV>00000000</DATUV>
<ATZHH>0000</ATZHH>
<ATTLV>0.000000000000000E+00</ATTLV>
<ATTLB>0.000000000000000E+00</ATTLB>
<ATINC>0.000000000000000E+00</ATINC>
As you can see we have a ATWRT with a value of P
So in the product target mapping we have the following OOTB
<attribute>
<name>defaultAttributeValues</name>
<collection>true</collection>
<transformationExpression>resolve('CanonicalAttribute').attributeValueID?.!['ERP_CLASSIFICATION_' + #root.categoryType + ':ERP_IMPORT:' + #root.attributeID + '_' + #this]</transformationExpression>
<exportCode>defaultAttributeValues(systemVersion(catalog(id),version),code)</exportCode>
</attribute>
Then we see the following error
<errorData>
<canonicalItemId>127</canonicalItemId>
<integrationKey>WTEBP_COMP|WTEB_PUNCHING|001</integrationKey>
<itemType>CanonicalAttributeCategoryRelation</itemType>
<code>REFERENCE_VIOLATION</code>
<message>
column 3: cannot resolve value 'ERP_CLASSIFICATION_001:ERP_IMPORT:WTEBP_COMP_P,ERP_CLASSIFICATION_001:ERP_IMPORT:WTEBP_COMP_S,ERP_CLASSIFICATION_001:ERP_IMPORT:WTEBP_COMP_D,ERP_CLASSIFICATION_001:ERP_IMPORT:WTEBP_COMP_G,ERP_CLASSIFICATION_001:ERP_IMPORT:WTEBP_COMP_PH,ERP_CLASSIFICATION_001:ERP_IMPORT:WTEBP_COMP_GA,ERP_CLASSIFICATION_001:ERP_IMPORT:WTEBP_COMP_PGA' for attribute 'defaultAttributeValues'
</message>
</errorData>