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.