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

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...

Product

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-COM-CPS-COR , CPS Core (SAP Hybris) , Problem

About this page

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

Search for additional results

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