SAP Knowledge Base Article - Preview

2071582 - Data truncation: Out of range value for column 'p_numbervalue', while saving ProductFeature string value as an "Exponential Number"

Symptom

  • ProductFeature value isn't saved in product.
  • Following exception thrown :

ERROR [hybrisHTTP14] [ServicelayerHMCSaveAction] Exception occured during save process! de.hybris.platform.jalo.JaloSystemException: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range v
alue for column 'p_numbervalue' at row 1[HY--1]
de.hybris.platform.jalo.JaloSystemException: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'p_numbervalue' at row 1[HY--1]
        at de.hybris.platform.persistence.GenericItemEJBImpl.createGenericItem(GenericItemEJBImpl.java:128)
        at de.hybris.platform.jalo.GenericItem.createItem(GenericItem.java:88)
        at de.hybris.platform.catalog.jalo.ProductFeature.createItem(ProductFeature.java:83)
        at de.hybris.platform.jalo.Item.newInstanceInternal(Item.java:3915)
        at de.hybris.platform.jalo.Item.access$7(Item.java:3856)
        at de.hybris.platform.jalo.Item$19.execute(Item.java:3834)
        at de.hybris.platform.tx.Transaction.execute(Transaction.java:1194)
        at de.hybris.platform.tx.Transaction.execute(Transaction.java:1159)
        at de.hybris.platform.jalo.Item.newInstance(Item.java:3829)
        at de.hybris.platform.jalo.type.ComposedType.newInstance(ComposedType.java:1340)
        at de.hybris.platform.catalog.jalo.GeneratedCatalogManager.createProductFeature(GeneratedCatalogManager.java:1676)
        at de.hybris.platform.catalog.jalo.GeneratedCatalogManager.createProductFeature(GeneratedCatalogManager.java:1694)
        at de.hybris.platform.catalog.jalo.classification.util.FeatureValue.writeToDatabase(FeatureValue.java:148)
        at de.hybris.platform.catalog.jalo.classification.util.Feature.writeToDatabase(Feature.java:971)
        at de.hybris.platform.catalog.jalo.classification.util.FeatureContainer.writeToDatabase_Impl(FeatureContainer.java:1590)
        at de.hybris.platform.catalog.jalo.classification.util.FeatureContainer.writeToDatabase(FeatureContainer.java:1569)
        at de.hybris.platform.catalog.jalo.classification.util.FeatureContainer.store(FeatureContainer.java:462)
        at de.hybris.platform.catalog.hmc.ClassificationAttributeChip.save(ClassificationAttributeChip.java:305)
        at de.hybris.platform.catalog.hmc.ClassificationEditorChip.save(ClassificationEditorChip.java:244)
        at de.hybris.platform.hmc.util.action.GenericItemSaveAction.saveSpecialEditors(GenericItemSaveAction.java:222)
        at de.hybris.platform.servicelayer.hmc.ServicelayerHMCSaveAction.save(ServicelayerHMCSaveAction.java:216)
        at de.hybris.platform.hmc.util.action.SaveAction.perform(SaveAction.java:185)
        at de.hybris.platform.hmc.generic.GenericItemChip.performSave(GenericItemChip.java:1198)
        at de.hybris.platform.hmc.generic.GenericItemChip.performSave(GenericItemChip.java:1174)
        at de.hybris.platform.hmc.generic.organizer.OrganizerItemChip.performSave(OrganizerItemChip.java:216)
        at de.hybris.platform.hmc.ItemChip.save(ItemChip.java:224)
        at de.hybris.platform.hmc.ItemChip.processEvents(ItemChip.java:377)
        at de.hybris.platform.hmc.generic.organizer.OrganizerItemChip.processEvents(OrganizerItemChip.java:250)
        at de.hybris.platform.hmc.AbstractToolbarChip.processEvents(AbstractToolbarChip.java:116)
        at de.hybris.platform.hmc.AbstractToolbarActionChip.processEvents(AbstractToolbarActionChip.java:135)
        at de.hybris.platform.hmc.webchips.DisplayState.dispatchEvents(DisplayState.java:634)
        at de.hybris.platform.hmc.webchips.DisplayState.extractEventsFromParameters(DisplayState.java:443)
        at de.hybris.platform.hmc.webchips.DisplayState.processEvents(DisplayState.java:354)
        at de.hybris.platform.hmc.webchips.MasterServlet.process(MasterServlet.java:193)
        at de.hybris.platform.hmc.webchips.MasterServlet.doPost(MasterServlet.java:83)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
        at de.hybris.platform.servicelayer.web.AbstractPlatformFilterChain$InternalFilterChain.doFilter(AbstractPlatformFilterChain.java:256)
        at de.hybris.platform.servicelayer.web.AbstractPlatformFilterChain$StatisticsGatewayFilter.doFilter(AbstractPlatformFilterChain.java:345)
        at de.hybris.platform.servicelayer.web.AbstractPlatformFilterChain$InternalFilterChain.doFilter(AbstractPlatformFilterChain.java:226)
        at de.hybris.platform.servicelayer.web.SecureMediaFilter.doFilter(SecureMediaFilter.java:97)
        at de.hybris.platform.servicelayer.web.AbstractPlatformFilterChain$InternalFilterChain.doFilter(AbstractPlatformFilterChain.java:226)
        at de.hybris.platform.servicelayer.web.DynamicCatalogVersionActivationFilter.doFilter(DynamicCatalogVersionActivationFilter.java:93)
        at de.hybris.platform.servicelayer.web.AbstractPlatformFilterChain$InternalFilterChain.doFilter(AbstractPlatformFilterChain.java:226)
        at de.hybris.platform.servicelayer.web.DataSourceSwitchingFilter.doFilter(DataSourceSwitchingFilter.java:73)
        at de.hybris.platform.servicelayer.web.AbstractPlatformFilterChain$InternalFilterChain.doFilter(AbstractPlatformFilterChain.java:226)
        at de.hybris.platform.servicelayer.web.SessionFilter.doFilter(SessionFilter.java:73)
        at de.hybris.platform.servicelayer.web.AbstractPlatformFilterChain$InternalFilterChain.doFilter(AbstractPlatformFilterChain.java:226)
        at de.hybris.platform.servicelayer.web.RedirectWhenSystemIsNotInitializedFilter.doFilter(RedirectWhenSystemIsNotInitializedFilter.java:104)
        at de.hybris.platform.servicelayer.web.AbstractPlatformFilterChain$InternalFilterChain.doFilter(AbstractPlatformFilterChain.java:226)
        at de.hybris.platform.servicelayer.web.DynamicTenantSwitchingFilter.doFilterInternal(DynamicTenantSwitchingFilter.java:88)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
        at de.hybris.platform.servicelayer.web.AbstractPlatformFilterChain$InternalFilterChain.doFilter(AbstractPlatformFilterChain.java:226)
        at de.hybris.platform.servicelayer.web.Log4JFilter.doFilter(Log4JFilter.java:47)
        at de.hybris.platform.servicelayer.web.AbstractPlatformFilterChain$InternalFilterChain.doFilter(AbstractPlatformFilterChain.java:226)
        at de.hybris.platform.servicelayer.web.AbstractPlatformFilterChain.doFilterInternal(AbstractPlatformFilterChain.java:156)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
        at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)
        at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
        at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
        at de.hybris.platform.servicelayer.web.XSSFilter.doFilter(XSSFilter.java:230)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
        at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
        at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:313)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)


Read more...

Environment

  •  SAP Commerce
  • SAP Commerce Cloud

Product

SAP Commerce Cloud 2211 ; SAP hybris Commerce Suite 5.2 ; hybris Commerce Suite 4.5 ; hybris Commerce Suite 4.6 ; hybris Commerce Suite 4.7 ; hybris Commerce Suite 4.8 ; hybris Commerce Suite 5.0 ; hybris Commerce Suite 5.1

Keywords

data truncation, classification class, classification attribute, product feature, Exponential Number, conversion. , KBA , CEC-SCC-CDM-CKP-COR , Core , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.