Getting error at the end of system update in commerce 2005 related to sapProductIDAttributeHandler

[former_member704915]

Hello, Can anyone help me with this error which I am getting at the end of system update, generally during the "storing of audit reports" line

Oct 27, 2020 8:06:16 PM de.hybris.platform.jalo.AbstractSystemCreator logln INFO: ################ Storing Generic Audit Report configurations ... Oct 27, 2020 8:06:17 PM de.hybris.platform.hac.facade.HacInitUpdateFacade executeInitUpdate SEVERE: Failed to initialize de.hybris.platform.servicelayer.exceptions.SystemException: cannot find spring bean [sapProductIDAttributeHandler] configured for dynamic attribute [Product.sapProductID] from extension [sapmodel] at de.hybris.platform.servicelayer.internal.converter.impl.ItemModelConverter.assembleMetaInfo(ItemModelConverter.java:1610) at de.hybris.platform.servicelayer.internal.converter.impl.ItemModelConverter.getTypeMetaInfo(ItemModelConverter.java:378) at de.hybris.platform.servicelayer.internal.converter.impl.ItemModelConverter.getInfo(ItemModelConverter.java:401) at de.hybris.platform.servicelayer.type.impl.DefaultTypeService.hasAttribute(DefaultTypeService.java:638) at com.hybris.yps.typesystemcache.service.CachingTypeService.hasAttribute(CachingTypeService.java:605) at de.hybris.platform.audit.internal.config.validation.AuditReportConfigValidator.validateQualifier(AuditReportConfigValidator.java:220) at de.hybris.platform.audit.internal.config.validation.AuditReportConfigValidator.validateAtomicAttributes(AuditReportConfigValidator.java:113) at de.hybris.platform.audit.internal.config.validation.AuditReportConfigValidator.validateSubTypes(AuditReportConfigValidator.java:97) at de.hybris.platform.audit.internal.config.validation.AuditReportConfigValidator.markInvalidConfigurationFragments(AuditReportConfigValidator.java:41) at de.hybris.platform.audit.internal.config.XMLAuditReportConfigReader.fromXml(XMLAuditReportConfigReader.java:50)

[wlaschu]

as abhijit.gupta4 said you can delete it directly from the DB but this method is discouriged. It's always better to manipulate data via Backoffice or impex because it's easy to forget to remove some related records from another table.

So just check for AttributeDescriptor in Backoffice->types

[rainamdar21]

Thanks for detail sharing.

[rainamdar21]

Hello Abhijit

Are you able to resolve issue? If yes can you please tell me the steps.

I am also facing the same issue

Target exception: de.hybris.platform.servicelayer.exceptions.SystemException: cannot find spring bean [sapProductIDAttributeHandler] configured for dynamic attribute [Product.sapProductID] from extension [sapmodel]

Regards

Ruturaj

[former_member704915]

Hi rainamdar21

The issue here is that the attribute sapProductID has been removed from the items.xml file in Hybris 2005, but the entries in the attribute descriptor & attribute descriptor LP table in database will have to be manually deleted.

First check for the no. of rows :

select * from attributedescriptors where QualifierInternal = 'sapProductID' . You will definitely get no. of rows>0 as a result. Take a note or back up of the result set and make a list of the ITEMPK (XX, YY, ZZ)

Now, our task will be to delete the discrepancies in between the two tables (attribute descriptor & attribute descriptor LP table) . Use below query :

delete from attributedescriptors where QualifierInternal = 'sapProductID'

delete from ATTRIBUTEDESCRIPTORSLP where ITEMPK IN ('XX','YY','ZZ')

After this, restart the Hybris server and run system update and your issue must be gone by now 🙂

Thank you !