error while integrating with hybris marketing recommendations

[pachoudhary1]

Hi Team,

I am getting following error while integrating with Hybris Marketing. Please let me know if anyone know the resolution.

Caused by: RfcException raised by system [HYB|USSLTCSNL1286]: message: A row already exists with this key return code: RFC_SYS_EXCEPTION (3) error group: 104 key: RFC_ERROR_SYSTEM_FAILURE message class: 00 message type: X message number: 341 message parameter 0: ITAB_DUPLICATE_KEY at com.sap.conn.rfc.engine.RfcIoOpenCntl.RfcReceive(RfcIoOpenCntl.java:2041) at com.sap.conn.jco.rt.MiddlewareJavaRfc$JavaRfcClient.execute(MiddlewareJavaRfc.java:2032) ... 13 more Caused by: com.sap.conn.rfc.exceptions.RfcGetException: A row already exists with this key at com.sap.conn.rfc.engine.RfcImp.ab_rfcerror(RfcImp.java:1176) at com.sap.conn.rfc.engine.RfcGet.ab_rfcget(RfcGet.java:120) at com.sap.conn.rfc.engine.RfcRcv.ab_rfcreceive(RfcRcv.java:36) at com.sap.conn.rfc.engine.RfcIoOpenCntl.RfcReceive(RfcIoOpenCntl.java:1983) ... 14 more ERROR [hybrisHTTP26] [ProductRecommendationManagerCEI] Cannot retrieve product recommendations from yMarketing java.util.concurrent.ExecutionException: de.hybris.platform.sap.core.common.exceptions.CoreBaseRuntimeException: Backend System Failure Exception: A row already exists with this key occurs. (Group: JCO_ERROR_SYSTEM_FAILURE)

Regards, Pankaj

[former_member224482]

Login into system HYB|USSLTCSNL1286 and use transaction ST22 to look at ABAP dumps.

[Former Member]

Even am facing the same issue . If someone has found the solution do post ur solution.

Below is my error log

java.util.concurrent.TimeoutException at java.util.concurrent.FutureTask.get(Unknown Source) ~[?:1.8.0_131] at com.sap.hybris.reco.be.impl.ProductRecommendationManagerCEI.storeFutureInSession(ProductRecommendationManagerCEI.java:246) [classes/:?] at com.sap.hybris.reco.be.impl.ProductRecommendationManagerCEI.prefetchRecommendations(ProductRecommendationManagerCEI.java:219) [classes/:?] at com.sap.hybris.reco.be.impl.ProductRecommendationManagerCEI.prefetchRecommendationsByModelType(ProductRecommendationManagerCEI.java:199) [classes/:?] at com.sap.hybris.reco.be.impl.ProductRecommendationManagerCEI.prefetchRecommendations(ProductRecommendationManagerCEI.java:183) [classes/:?] at com.sap.hybris.reco.bo.impl.ProductRecommendationManagerBOImpl.prefetchRecommendations(ProductRecommendationManagerBOImpl.java:88) [classes/:?] at com.sap.hybris.reco.addon.facade.impl.DefaultProductRecommendationManagerFacade.prefetchRecommendationsForAllComponents(DefaultProductRecommendationManagerFacade.java:257) [classes/:?] at com.sap.hybris.reco.addon.controller.CMSSAPRecommendationComponentController.fillModel(CMSSAPRecommendationComponentController.java:80) [CMSSAPRecommendationComponentController.class:?] at com.sap.hybris.reco.addon.controller.CMSSAPRecommendationComponentController.fillModel(CMSSAPRecommendationComponentController.java:1) [CMSSAPRecommendationComponentController.class:?] at de.hybris.platform.addonsupport.controllers.cms.AbstractCMSAddOnComponentController.handleComponent(AbstractCMSAddOnComponentController.java:122) [classes/:?] at de.hybris.platform.addonsupport.controllers.cms.AbstractCMSAddOnComponentController.handleGet(AbstractCMSAddOnComponentController.java:77) [classes/:?] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_131] at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[?:1.8.0_131] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:1.8.0_131] at java.lang.reflect.Method.invoke(Unknown Source) ~[?:1.8.0_131] at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221) [spring-web-4.1.7.RELEASE.jar:4.1.7.RELEASE] at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137) [spring-web-4.1.7.RELEASE.jar:4.1.7.RELEASE] at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110) [spring-webmvc-4.1.7.RELEASE.jar:4.1.7.RELEASE] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:776) [spring-webmvc-4.1.7.RELEASE.jar:4.1.7.RELEASE] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:705) [spring-webmvc-4.1.7.RELEASE.jar:4.1.7.RELEASE] at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85) [spring-webmvc-4.1.7.RELEASE.jar:4.1.7.RELEASE] at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959) [spring-webmvc-4.1.7.RELEASE.jar:4.1.7.RELEASE] at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893) [spring-webmvc-4.1.7.RELEASE.jar:4.1.7.RELEASE] at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:967) [spring-webmvc-4.1.7.RELEASE.jar:4.1.7.RELEASE] at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:858) [spring-webmvc-4.1.7.RELEASE.jar:4.1.7.RELEASE] at javax.servlet.http.HttpServlet.service(HttpServlet.java:620) [servlet-api.jar:?] at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:843) [spring-webmvc-4.1.7.RELEASE.jar:4.1.7.RELEASE]

[former_member224482]

Upgrade to a more recent release. I strongly recommend release 6.5.
All code related to concurrent.FutureTask & prefetchRecommendations has been removed from product recommendation.