SAP Knowledge Base Article - Preview

2793162 - Error message = SQLException- addComponentTrainingEvent: Could not add Component Training event due to SQLException LMS

Symptom

Record Learning Event causes SQLException Error.

Error

An application error has occurred. Please try again.

No search results were found based on this error code.

If you have further questions or issues regarding this error, please provide the error details below to your support group.

Error message = SQLException- addComponentTrainingEvent: Could not add Component Training event due to SQLException.<br>Ticket No = 87012675<br>ErrorFingerprint [exceptionRootCauseTag=f67869c2a3951c1e3f777fe60106982dc0b71fd2, exceptionStackTraceTag=ea07d098a63256a39d0577d25e8ef2997b9fc086]<br>Timestamp = 2019-04-08T19:47:11.152+0000<br>Stack trace = com.plateausystems.elms.util.helper.ElmsCreateException: SQLException- addComponentTrainingEvent: Could not add Component Training event due to SQLException.at com.plateausystems.elms.bo.trainingevent.impl.TrainingEventServiceImpl.addLearningComponentTrainingEvent(TrainingEventServiceImpl.java:338)at com.plateausystems.elms.bo.trainingevent.impl.TrainingEventServiceImpl.addComponentTrainingEvent(TrainingEventServiceImpl.java:273)at com.plateau.sfintegration.impl.trainingevent.CDPTrainingEventServiceImpl.addComponentTrainingEventForCDP(CDPTrainingEventServiceImpl.java:399)at com.plateau.sfintegration.impl.trainingevent.CDPTrainingEventServiceImpl.addComponentTrainingEvent(CDPTrainingEventServiceImpl.java:152)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)at java.lang.reflect.Method.invoke(Method.java:606)at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)at com.plateausystems.elms.framework.perfmonitor.impl.ServicePerformanceMonitorInterceptor.invoke(ServicePerformanceMonitorInterceptor.java:41)at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)at com.plateausystems.elms.framework.usagestatistics.impl.UsageStatisticsInterceptor.invoke(UsageStatisticsInterceptor.java:73)at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)at com.plateausystems.elms.framework.authorization.impl.ServiceAuthorizationInterceptor.invoke(ServiceAuthorizationInterceptor.java:127)at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)at com.plateausystems.elms.util.helper.LastUpdateUserInterceptor.invoke(LastUpdateUserInterceptor.java:49)at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)at com.plateausystems.elms.framework.localization.DataLocalizationInterceptor.invoke(DataLocalizationInterceptor.java:72)at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)at com.sun.proxy.$Proxy199.addComponentTrainingEvent(Unknown Source)at com.plateausystems.elms.client.struts.threeclickprocesses.RecordLearningEventCreateEventsAction.addComponentBasedLearningEvents(RecordLearningEventCreateEventsAction.java:208)at com.plateausystems.elms.client.struts.threeclickprocesses.RecordLearningEventCreateEventsAction.run(RecordLearningEventCreateEventsAction.java:130)at com.plateausystems.elms.client.struts.threeclickprocesses.RecordLearningEventCreateEventsAction$$FastClassByCGLIB$$a5edeb19.invoke(<generated>)at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:688)at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:621)at com.plateausystems.elms.client.struts.threeclickprocesses.RecordLearningEventCreateEventsAction$$EnhancerByCGLIB$$7656da4d.run(<generated>)at com.plateausystems.elms.client.struts.StatefulBaseActionDelegate.invoke(StatefulBaseActionDelegate.java:520)at com.plateausystems.elms.client.struts.TMSDelegatingTilesRequestProcessor.processActionPerform(TMSDelegatingTilesRequestProcessor.java:136)at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:275)at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)at com.plateau.foundation.struts1.action.PlateauActionServlet.service(PlateauActionServlet.java:820)at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)at org.apache.struts.action.ActionServlet.service(ActionServlet.java)at com.plateau.foundation.struts1.action.PlateauActionServlet.service(PlateauActionServlet.java)at com.plateau.common.springweb.api.ServletToBeanProxy.service(ServletToBeanProxy.java:83)at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)at com.plateau.common.springweb.api.ServletToBeanProxy.service(ServletToBeanProxy.java)at com.plateau.foundation.servlet.TenantAwareDelegatingServlet.service(TenantAwareDelegatingServlet.java:95)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)at com.plateau.common.webtoolkit.servlet.ExpiresFilter.doFilter(ExpiresFilter.java:372)at com.plateausystems.elms.client.servlet.CachingFilter.doFilter(CachingFilter.java:46)at com.plateau.foundation.servlet.TenantAwareDelegatingFilter.doFilter(TenantAwareDelegatingFilter.java:87)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)at com.plateau.foundation.servlet.PlateauFoundationSetupHandler.doFilter(PlateauFoundationSetupHandler.java:482)at com.plateausystems.elms.framework.bootstrap.TMSPlateauFoundationSetupHandler.doFilter(TMSPlateauFoundationSetupHandler.java)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:728)at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:470)at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:395)at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:316)at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069)at org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:274)at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:455)at org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:320)at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)at com.plateau.foundation.struts1.action.PlateauActionServlet.service(PlateauActionServlet.java:820)at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)at org.apache.struts.action.ActionServlet.service(ActionServlet.java)at com.plateau.foundation.struts1.action.PlateauActionServlet.service(PlateauActionServlet.java)at com.plateau.common.springweb.api.ServletToBeanProxy.service(ServletToBeanProxy.java:83)at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)at com.plateau.common.springweb.api.ServletToBeanProxy.service(ServletToBeanProxy.java)at com.plateau.foundation.servlet.TenantAwareDelegatingServlet.service(TenantAwareDelegatingServlet.java:95)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)at com.plateausystems.elms.framework.throttling.APIThrottlingFilter.internalDoFilter(APIThrottlingFilter.java:142)at com.plateau.common.webtoolkit.api.servlet.PlateauAbstractFilter.doFilter(PlateauAbstractFilter.java:113)at com.plateausystems.elms.framework.throttling.APIThrottlingFilter.doFilter(APIThrottlingFilter.java)at com.plateau.foundation.servlet.TenantAwareDelegatingFilter.doFilter(TenantAwareDelegatingFilter.java:87)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)at com.plateausystems.elms.framework.usagestatistics.client.CollectUsageStatisticsFilter.internalDoFilter(CollectUsageStatisticsFilter.java:110)at com.plateau.common.webtoolkit.api.servlet.PlateauAbstractFilter.doFilter(PlateauAbstractFilter.java:113)at com.plateausystems.elms.framework.usagestatistics.client.CollectUsageStatisticsFilter.doFilter(CollectUsageStatisticsFilter.java)at com.plateau.foundation.servlet.TenantAwareDelegatingFilter.doFilter(TenantAwareDelegatingFilter.java:87)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)at com.plateausystems.elms.client.servlet.MondrianInitFilter.doFilter(MondrianInitFilter.java:60)at com.plateau.foundation.servlet.TenantAwareDelegatingFilter.doFilter(TenantAwareDelegatingFilter.java:87)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)at com.plateausystems.elms.client.servlet.EnsureSearchContextFilter.internalDoFilter(EnsureSearchContextFilter.java:130)at com.plateau.common.webtoolkit.api.servlet.PlateauAbstractFilter.doFilter(PlateauAbstractFilter.java:113)at com.plateausystems.elms.client.servlet.EnsureSearchContextFilter.doFilter(EnsureSearchContextFilter.java)at com.plateau.foundation.servlet.TenantAwareDelegatingFilter.doFilter(TenantAwareDelegatingFilter.java:87)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)at com.plateau.common.websecurity.impl.servlet.StrutsParamFilter.doFilter(StrutsParamFilter.java:59)at com.plateau.foundation.servlet.TenantAwareDelegatingFilter.doFilter(TenantAwareDelegatingFilter.java:87)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)at com.plateausystems.elms.framework.csrfguard.LmsCsrfGuardFilter.doFilter(LmsCsrfGuardFilter.java:104)at com.plateau.foundation.servlet.TenantAwareDelegatingFilter.doFilter(TenantAwareDelegatingFilter.java:87)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)at com.plateau.common.webtoolkit.api.servlet.PlateauAbstractFilter.doFilter(PlateauAbstractFilter.java:117)at com.plateau.common.websecurity.impl.servlet.XSSScanFilter.doFilter(XSSScanFilter.java)at com.plateausystems.elms.client.servlet.XssFilter.doFilter(XssFilter.java)at com.plateau.foundation.servlet.TenantAwareDelegatingFilter.doFilter(TenantAwareDelegatingFilter.java:87)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)at com.successfactors.perflog.ui.PerfLogBaseFilter.doFilter(PerfLogBaseFilter.java:175)at com.plateau.foundation.servlet.TenantAwareDelegatingFilter.doFilter(TenantAwareDelegatingFilter.java:87)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)at com.plateausystems.elms.client.servlet.CheckAdminLogonFilter.doFilter(CheckAdminLogonFilter.java:132)at com.plateau.foundation.servlet.TenantAwareDelegatingFilter.doFilter(TenantAwareDelegatingFilter.java:87)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:369)at org.springframework.security.oauth2.consumer.OAuth2ClientContextFilter.doFilter(OAuth2ClientContextFilter.java:79)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:381)at org.springframework.security.oauth2.consumer.OAuth2ClientContextFilter.doFilter(OAuth2ClientContextFilter.java:79)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:381)at org.springframework.security.oauth2.provider.OAuth2ProtectedResourceFilter.doFilter(OAuth2ProtectedResourceFilter.java:46)at com.plateausystems.elms.framework.oauth2.provider.impl.PlateauOAuth2ProtectedResourceFilter.doFilter(PlateauOAuth2ProtectedResourceFilter.java)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:381)at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187)at org.springframework.security.oauth2.provider.OAuth2AuthorizationFilter.doFilter(OAuth2AuthorizationFilter.java)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:381)at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187)at org.springframework.security.oauth2.provider.verification.VerificationCodeFilter.doFilter(VerificationCodeFilter.java:105)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:381)at org.springframework.security.oauth2.provider.OAuth2ExceptionHandlerFilter.doFilter(OAuth2ExceptionHandlerFilter.java:36)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:381)at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:97)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:381)at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187)at org.springframework.security.web.authentication.UsernamePasswordAuthenticationFilter.doFilter(UsernamePasswordAuthenticationFilter.java)at com.plateau.common.security.impl.authentication.PlateauAuthenticationProcessingFilter.doFilter(PlateauAuthenticationProcessingFilter.java)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:381)at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187)at org.springframework.security.web.authentication.UsernamePasswordAuthenticationFilter.doFilter(UsernamePasswordAuthenticationFilter.java)at com.plateau.common.security.impl.authentication.PlateauAuthenticationProcessingFilter.doFilter(PlateauAuthenticationProcessingFilter.java)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:381)at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187)at org.springframework.security.web.authentication.UsernamePasswordAuthenticationFilter.doFilter(UsernamePasswordAuthenticationFilter.java)at com.plateau.common.security.impl.authentication.PlateauAuthenticationProcessingFilter.doFilter(PlateauAuthenticationProcessingFilter.java)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:381)at org.springframework.security.saml.SAMLLogoutProcessingFilter.doFilterHttp(SAMLLogoutProcessingFilter.java:192)at org.springframework.security.saml.SAMLLogoutProcessingFilter.doFilter(SAMLLogoutProcessingFilter.java:92)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:381)at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187)at org.springframework.security.saml.SAMLProcessingFilter.doFilter(SAMLProcessingFilter.java)at com.plateausystems.elms.framework.sso.impl.saml.MultiAppDispatchSAMLProcessingFilter.doFilter(MultiAppDispatchSAMLProcessingFilter.java)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:381)at org.springframework.security.saml.SAMLEntryPoint.doFilterHttp(SAMLEntryPoint.java:101)at org.springframework.security.saml.SecurityFilter.doFilter(SecurityFilter.java:53)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:381)at org.springframework.security.saml.metadata.MetadataDisplayFilter.doFilterHttp(MetadataDisplayFilter.java:90)at org.springframework.security.saml.SecurityFilter.doFilter(SecurityFilter.java:53)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:381)at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:381)at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:381)at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187)at com.plateausystems.elms.framework.sso.impl.oauthtoken.LearnerOAuthTokenAuthenticationProcessingFilter.doFilter(LearnerOAuthTokenAuthenticationProcessingFilter.java)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:381)at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187)at com.plateausystems.elms.framework.sso.impl.oauthtoken.LearnerOAuthTokenAuthenticationProcessingFilter.doFilter(LearnerOAuthTokenAuthenticationProcessingFilter.java)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:381)at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:79)at org.springframework.security.web.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:381)at com.plateau.common.webtoolkit.api.servlet.PlateauAbstractFilter.doFilter(PlateauAbstractFilter.java:117)at com.plateau.common.websecurity.impl.servlet.XSSScanFilter.doFilter(XSSScanFilter.java)at com.plateausystems.elms.client.servlet.XssFilter.doFilter(XssFilter.java)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:381)at org.springframework.security.oauth2.provider.verification.BasicUserApprovalFilter.doFilter(BasicUserApprovalFilter.java:41)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:381)at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:168)at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)at com.plateausystems.elms.client.servlet.SecurityFilterToBeanProxy.doFilter(SecurityFilterToBeanProxy.java:82)at com.plateau.foundation.servlet.TenantAwareDelegatingFilter.doFilter(TenantAwareDelegatingFilter.java:87)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)at com.plateausystems.elms.client.servlet.CheckOtherLogonFilter.doFilter(CheckOtherLogonFilter.java:129)at com.plateau.foundation.servlet.TenantAwareDelegatingFilter.doFilter(TenantAwareDelegatingFilter.java:87)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)at com.plateausystems.elms.client.servlet.ContentServletCheckLogonFilter.doFilter(ContentServletCheckLogonFilter.java:95)at com.plateau.foundation.servlet.TenantAwareDelegatingFilter.doFilter(TenantAwareDelegatingFilter.java:87)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)at com.plateau.common.webtoolkit.servlet.EncodingFilter.doFilter(EncodingFilter.java:297)at com.plateau.common.webtoolkit.servlet.GZIPEncodingFilter.doFilter(GZIPEncodingFilter.java)at com.plateau.foundation.servlet.TenantAwareDelegatingFilter.doFilter(TenantAwareDelegatingFilter.java:87)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)at com.plateau.common.webtoolkit.servlet.ExpiresFilter.doFilter(ExpiresFilter.java:520)at com.plateausystems.elms.client.servlet.CachingFilter.doFilter(CachingFilter.java:46)at com.plateau.foundation.servlet.TenantAwareDelegatingFilter.doFilter(TenantAwareDelegatingFilter.java:87)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)at com.plateau.foundation.servlet.JdbcResourceMonitorServletFilter.doFilter(JdbcResourceMonitorServletFilter.java:116)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)at com.plateausystems.elms.util.helper.test.automation.PlateauTestFilter.doFilter(PlateauTestFilter.java:122)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)at com.plateausystems.elms.client.servlet.ResponseHeaderFilter.doFilter(ResponseHeaderFilter.java:382)at com.plateau.foundation.servlet.TenantAwareDelegatingFilter.doFilter(TenantAwareDelegatingFilter.java:87)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)at com.plateau.common.webtoolkit.servlet.RequestLogger.doFilter(RequestLogger.java:193)at com.plateau.foundation.servlet.TenantAwareDelegatingFilter.doFilter(TenantAwareDelegatingFilter.java:87)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)at com.plateau.common.webtoolkit.servlet.RequestInfo.doFilter(RequestInfo.java:77)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)at com.plateausystems.elms.client.servlet.AlternativeSessionFilter.doFilter(AlternativeSessionFilter.java:78)at com.plateau.foundation.servlet.TenantAwareDelegatingFilter.doFilter(TenantAwareDelegatingFilter.java:87)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:83)at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)at com.plateau.foundation.servlet.TenantAwareDelegatingFilter.doFilter(TenantAwareDelegatingFilter.java:87)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)at com.plateau.foundation.servlet.PlateauFoundationSetupHandler.doFilter(PlateauFoundationSetupHandler.java:482)at com.plateausystems.elms.framework.bootstrap.TMSPlateauFoundationSetupHandler.doFilter(TMSPlateauFoundationSetupHandler.java)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:496)at org.apache.catalina.session.FoundationSessionManagerValve.invoke(FoundationSessionManagerValve.java:47)at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:677)at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650)at org.apache.catalina.valves.StuckThreadDetectionValve.invoke(StuckThreadDetectionValve.java:206)at org.apache.catalina.valves.SetCharacterEncodingValve.invoke(SetCharacterEncodingValve.java:37)at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803)at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790)at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459)at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1152)at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:622)at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)at java.lang.Thread.run(Thread.java:807)at org.apache.tomcat.util.threads.TaskThread.run(TaskThread.java) Caused by: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [1300]: fetch returns more than requested number of rows: search table error: "****_*RO*_TM*"."PKG_LEARNINGHST_FULL_PROCESS_CPNT_EVTHST": line 1305 col 13 (at pos 61947): [1300] (range 3) fetch returns more than requested number of rows exception: fetch returns more than requested number of rows: search table error: "*****_*RO*_TM*"."PKG_QUESTIONNAIRESURVEY_INITIATE_SURVEY_PROCESS": line 72 col 3 (at pos 2778): [1300](range 3) fetch returns more than requested number of rows exception: fetch returns more than requested number of rowsat com.sap.db.jdbc.exceptions.SQLExceptionSapDB._newInstance(SQLExceptionSapDB.java:191)at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.newInstance(SQLExceptionSapDB.java:42)at com.sap.db.jdbc.packet.HReplyPacket._buildExceptionChain(HReplyPacket.java:976)at com.sap.db.jdbc.packet.HReplyPacket.getSQLExceptionChain(HReplyPacket.java:157)at com.sap.db.jdbc.packet.HPartInfo.getSQLExceptionChain(HPartInfo.java:39)at com.sap.db.jdbc.ConnectionSapDB._receive(ConnectionSapDB.java:3467)at com.sap.db.jdbc.ConnectionSapDB.exchange(ConnectionSapDB.java:1562)at com.sap.db.jdbc.PreparedStatementSapDB._execute(PreparedStatementSapDB.java:2909)at com.sap.db.jdbc.PreparedStatementSapDB._execute(PreparedStatementSapDB.java:1911)at com.sap.db.jdbc.PreparedStatementSapDB._executeUpdate(PreparedStatementSapDB.java:1900)at com.sap.db.jdbc.PreparedStatementSapDB.executeUpdate(PreparedStatementSapDB.java:528)at com.sap.db.jdbc.CallableStatementSapDB.executeUpdate(CallableStatementSapDB.java)at com.sap.db.jdbc.HanaCallableStatement.executeUpdate(HanaCallableStatement.java)at sun.reflect.GeneratedMethodAccessor78.invoke(Unknown Source)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)at java.lang.reflect.Method.invoke(Method.java:606)at oracle.ucp.jdbc.proxy.StatementProxyFactory.invoke(StatementProxyFactory.java:272)at oracle.ucp.jdbc.proxy.PreparedStatementProxyFactory.invoke(PreparedStatementProxyFactory.java:138)at oracle.ucp.jdbc.proxy.CallableStatementProxyFactory.invoke(CallableStatementProxyFactory.java:104)at com.sun.proxy.$Proxy405.executeUpdate(Unknown Source)at sun.reflect.GeneratedMethodAccessor78.invoke(Unknown Source)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)at java.lang.reflect.Method.invoke(Method.java:606)at com.plateau.foundation.jdbc.StatementPerfMonitorInvocationHandler.invoke(StatementPerfMonitorInvocationHandler.java:146)at com.sun.proxy.$Proxy406.executeUpdate(Unknown Source)at sun.reflect.GeneratedMethodAccessor78.invoke(Unknown Source)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)at java.lang.reflect.Method.invoke(Method.java:606)at com.plateau.common.core.api.InterruptibleInvocationHandler.invoke(InterruptibleInvocationHandler.java:71)at com.plateau.common.db.api.InterruptibleJdbcObjectProxyFactory$InterruptibleJdbcObjectProxy.invoke(InterruptibleJdbcObjectProxyFactory.java:155)at com.sun.proxy.$Proxy407.executeUpdate(Unknown Source)at com.plateausystems.elms.bo.trainingevent.helper.TrainingEventDAOImpl.executeComponentTrainingProcedure(TrainingEventDAOImpl.java:354)at com.plateausystems.elms.bo.trainingevent.impl.TrainingEventServiceImpl.addLearningComponentTrainingEvent(TrainingEventServiceImpl.java:332)... 270 more


Read more...

Environment

Successfactors Learning Management System (LMS)

Keywords

SQLException; addComponentTrainingEvent; Questionnaire Survey , KBA , LOD-SF-LMS-ADM , Admin Tools , 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.