SAPProductIDDataConversion error after 6.6 upgrade

[nkjahan1388]

Seeing the below error post 6.6 upgrade.

WARNING: Missing SAPProductIDDataConversion customizing, using default value INFO | jvm 1 | main | 2018/02/23 18:31:25.955 | de.hybris.platform.servicelayer.exceptions.ModelNotFoundException: No result for the given example [SAPProductIDDataConversionModel ()] was found. Searched with these attributes: {conversionID=MATCONV} INFO | jvm 1 | main | 2018/02/23 18:31:25.986 | at de.hybris.platform.servicelayer.internal.model.impl.DefaultItemModelSearchStrategy.getModelByExample(DefaultItemModelSearchStrategy.java:63) INFO | jvm 1 | main | 2018/02/23 18:31:26.027 | at de.hybris.platform.servicelayer.search.impl.DefaultFlexibleSearchService.getModelByExample(DefaultFlexibleSearchService.java:95) INFO | jvm 1 | main | 2018/02/23 18:31:26.038 | at de.hybris.platform.sap.sapmodel.daos.ProductIDAttributeHandler.convertID(ProductIDAttributeHandler.java:43) INFO | jvm 1 | main | 2018/02/23 18:31:26.086 | at com.alcon.sapmodel.daos.AlconProductIDAttributeHandler.get(AlconProductIDAttributeHandler.java:26) INFO | jvm 1 | main | 2018/02/23 18:31:26.146 | at de.hybris.platform.sap.sapmodel.daos.ProductIDAttributeHandler.get(ProductIDAttributeHandler.java:1) INFO | jvm 1 | main | 2018/02/23 18:31:26.151 | at de.hybris.platform.servicelayer.internal.model.attribute.impl.DefaultDynamicAttributesProvider.get(DefaultDynamicAttributesProvider.java:45) INFO | jvm 1 | main | 2018/02/23 18:31:26.177 | at de.hybris.platform.servicelayer.model.ItemModelContextImpl.getDynamicValue(ItemModelContextImpl.java:351) INFO | jvm 1 | main | 2018/02/23 18:31:26.213 | at de.hybris.platform.core.model.product.ProductModel.getSapProductID(ProductModel.java:1383) INFO | jvm 1 | main | 2018/02/23 18:31:26.264 | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) INFO | jvm 1 | main | 2018/02/23 18:31:26.269 | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) INFO | jvm 1 | main | 2018/02/23 18:31:26.306 | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) INFO | jvm 1 | main | 2018/02/23 18:31:26.349 | at java.lang.reflect.Method.invoke(Method.java:498) INFO | jvm 1 | main | 2018/02/23 18:31:26.354 | at org.springframework.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:216) INFO | jvm 1 | main | 2018/02/23 18:31:26.366 | at de.hybris.platform.servicelayer.internal.converter.impl.ItemModelConverter.invokeMethod(ItemModelConverter.java:1300) INFO | jvm 1 | main | 2018/02/23 18:31:26.404 | at de.hybris.platform.servicelayer.internal.converter.impl.ItemModelConverter.invokeMethod(ItemModelConverter.java:1293) INFO | jvm 1 | main | 2018/02/23 18:31:26.488 | at de.hybris.platform.servicelayer.internal.converter.impl.ItemModelConverter.getLocalizedAttributeValue(ItemModelConverter.java:1084) INFO | jvm 1 | main | 2018/02/23 18:31:26.548 | at de.hybris.platform.servicelayer.internal.converter.impl.ItemModelConverter.getAttributeValue(ItemModelConverter.java:1035) INFO | jvm 1 | main | 2018/02/23 18:31:26.603 | at de.hybris.platform.servicelayer.internal.model.impl.DefaultModelService.getAttributeValue(DefaultModelService.java:322) INFO | jvm 1 | main | 2018/02/23 18:31:26.615 | at de.hybris.platform.servicelayer.hmc.ServicelayerHMCHelper.getSingleValueAttribute(ServicelayerHMCHelper.java:120) INFO | jvm 1 | main | 2018/02/23 18:31:26.618 | at de.hybris.platform.servicelayer.hmc.ServicelayerHMCLoadAction.loadAttributeValue(ServicelayerHMCLoadAction.java:62) INFO | jvm 1 | main | 2018/02/23 18:31:26.672 | at de.hybris.platform.hmc.util.visitor.InitialValueVisitor.readValue(InitialValueVisitor.java:109) INFO | jvm 1 | main | 2018/02/23 18:31:26.709 | at de.hybris.platform.hmc.util.visitor.InitialValueVisitor.visit(InitialValueVisitor.java:73) INFO | jvm 1 | main | 2018/02/23 18:31:26.717 | at de.hybris.platform.hmc.util.visitor.ChipVisitor.inviteInternal(ChipVisitor.java:72) INFO | jvm 1 | main | 2018/02/23 18:31:26.729 | at de.hybris.platform.hmc.util.visitor.ChipVisitor.inviteInternal(ChipVisitor.java:75) INFO | jvm 1 | main | 2018/02/23 18:31:26.782 | at de.hybris.platform.hmc.util.visitor.ChipVisitor.inviteInternal(ChipVisitor.java:75) INFO | jvm 1 | main | 2018/02/23 18:31:26.904 | at de.hybris.platform.hmc.util.visitor.ChipVisitor.inviteInternal(ChipVisitor.java:75) INFO | jvm 1 | main | 2018/02/23 18:31:26.955 | at de.hybris.platform.hmc.util.visitor.ChipVisitor.invite(ChipVisitor.java:63) INFO | jvm 1 | main | 2018/02/23 18:31:27.017 | at de.hybris.platform.hmc.ItemChip.readInitialValues(ItemChip.java:334) INFO | jvm 1 | main | 2018/02/23 18:31:27.060 | at de.hybris.platform.hmc.ItemChip.initialize(ItemChip.java:321)

Seems to be from OTB class. Executing the following impex resolved it but want to know the root cause and impact. Any thoughts?

INSERT_UPDATE SAPProductIDDataConversion;conversionID[unique=true];matnrLength;displayLeadingZeros;displayLexicographic;mask ;MATCONV;18;false;fa

[nicolabeghin]

Any hint on this? We're experiencing the same issue, but can't find any impex with INSERT_UPDATE of such type SAPProductIDDataConversion

[Former Member]

Try the below impex INSERT_UPDATE SAPProductIDDataConversion;conversionID[unique=true];matnrLength;displayLeadingZeros;displayLexicographic;mask ;MATCONV;18;false;false;;

[nicolabeghin]

thanks I saw the impex in your previous reply, but I would like to understand why something so basic wasn't imported/is not available as an OOTB impex in order to understand if bigger issues could arise in the future

[VinayKumarS]

actually this is coming from customizing.impex file which is generated from SAP. So it is not coming out of the box.

[nicolabeghin]

Thanks @Sam that makes a lot of sense. We've always dealt with SAP ERP projects but this is a SAP CRM one and the customizing.impex is generated in a different way, maybe that's the reason. BTW I'm pretty sure I never saw this error in the past in any other project with SAP integration before importing the customizing.impex, do you have any idea if something changed in this regard?

[nicolabeghin]

[update] with CRM integration you have multiple impex to export from SAP, correct parameterization of the second one did the trick and exported the SAPProductIDDataConversion bit

[VinayKumarS]

I think you must be working on SAP Integration with hybris the respective extension is not added and updated with your hybris. This perticular model is in hybris\bin\ext-integration\sap\core\sapmodel extension. Please check your exensions. Then it will create SAPProductIDDataConversion table. Then you can insert the data.