Issues with ECC Characteristic Values not being replicated to hybris

[d_j_boyd]

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>
 

[Slava]

It feels like the target item is successfully created and published. However the item represented by the value for attribute defaultAttributeValues cannot be resolved during the impex import in the ECP. Perhaps, the problem is in the value containing :, which has a special meaning inside impex and needs to be escaped. Or the value is messed up. In any case, I'm not an expert in this particular business case but it feels like that transformation SpEL expression needs adjustment.