SAP Knowledge Base Article - Public

2253566 - Exception errors when SKU is removed from item

Symptom

Trying to add catalog to Schedule offering throws an error

Environment

SuccessFactors Learning

Reproducing the Issue

Scenario 1:

1) Create an ITEM1 and remove SKU ID from summary tab
2) Go to Item > Catalog tab and try adding an CAT1 catalog to item.
System throws error message.

Error

Please report the following error to your system administrator:

com.plateausystems.elms.util.helper.ElmsCreateException: SQLException - CatalogServiceImpl.createCatalogItemPrices failed:
	at com.plateausystems.elms.framework.financial.impl.CatalogServiceImpl.createCatalogItemPrices(CatalogServiceImpl.java:1644)
	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 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.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
	at com.sun.proxy.$Proxy292.createCatalogItemPrices(Unknown Source)
	at com.plateausystems.elms.client.struts.component.AddComponentCatalogsAction.run(AddComponentCatalogsAction.java:215)
	at com.plateausystems.elms.client.struts.BaseActionDelegate.invokeValidateAndRun(BaseActionDelegate.java:69)
	at com.plateausystems.elms.client.struts.TMSDelegatingTilesRequestProcessor.processActionPerform(TMSDelegatingTilesRequestProcessor.java:130)
	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:644)
	at com.plateau.foundation.struts1.action.PlateauActionServlet.service(PlateauActionServlet.java:751)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:725)
	at com.plateau.common.springweb.api.ServletToBeanProxy.service(ServletToBeanProxy.java:83)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:725)
	at com.plateau.foundation.servlet.TenantAwareDelegatingServlet.service(TenantAwareDelegatingServlet.java:95)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.plateausystems.elms.framework.usagestatistics.client.CollectUsageStatisticsFilter.internalDoFilter(CollectUsageStatisticsFilter.java:104)
	at com.plateau.common.webtoolkit.api.servlet.PlateauAbstractFilter.doFilter(PlateauAbstractFilter.java:113)
	at com.plateau.foundation.servlet.TenantAwareDelegatingFilter.doFilter(TenantAwareDelegatingFilter.java:87)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	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:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.plateausystems.elms.client.servlet.EnsureSearchContextFilter.internalDoFilter(EnsureSearchContextFilter.java:127)
	at com.plateau.common.webtoolkit.api.servlet.PlateauAbstractFilter.doFilter(PlateauAbstractFilter.java:113)
	at com.plateau.foundation.servlet.TenantAwareDelegatingFilter.doFilter(TenantAwareDelegatingFilter.java:87)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	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:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.plateausystems.elms.framework.csrfguard.LmsCsrfGuardFilter.doFilter(LmsCsrfGuardFilter.java:97)
	at com.plateau.foundation.servlet.TenantAwareDelegatingFilter.doFilter(TenantAwareDelegatingFilter.java:87)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.plateau.common.webtoolkit.api.servlet.PlateauAbstractFilter.doFilter(PlateauAbstractFilter.java:117)
	at com.plateau.foundation.servlet.TenantAwareDelegatingFilter.doFilter(TenantAwareDelegatingFilter.java:87)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.plateausystems.elms.client.servlet.CheckAdminLogonFilter.doFilter(CheckAdminLogonFilter.java:126)
	at com.plateau.foundation.servlet.TenantAwareDelegatingFilter.doFilter(TenantAwareDelegatingFilter.java:87)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	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 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.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.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:381)
	at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187)
	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.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.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 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.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:381)
	at com.plateau.common.webtoolkit.api.servlet.PlateauAbstractFilter.doFilter(PlateauAbstractFilter.java:117)
	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:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.plateausystems.elms.client.servlet.CheckOtherLogonFilter.doFilter(CheckOtherLogonFilter.java:121)
	at com.plateau.foundation.servlet.TenantAwareDelegatingFilter.doFilter(TenantAwareDelegatingFilter.java:87)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	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:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.plateau.common.webtoolkit.servlet.EncodingFilter.doFilter(EncodingFilter.java:297)
	at com.plateau.foundation.servlet.TenantAwareDelegatingFilter.doFilter(TenantAwareDelegatingFilter.java:87)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	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:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.plateau.foundation.servlet.JdbcResourceMonitorServletFilter.doFilter(JdbcResourceMonitorServletFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.plateausystems.elms.util.helper.test.automation.PlateauTestFilter.doFilter(PlateauTestFilter.java:114)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.plateausystems.elms.client.servlet.ResponseHeaderFilter.doFilter(ResponseHeaderFilter.java:234)
	at com.plateau.foundation.servlet.TenantAwareDelegatingFilter.doFilter(TenantAwareDelegatingFilter.java:87)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.plateau.common.webtoolkit.servlet.RequestLogger.doFilter(RequestLogger.java:187)
	at com.plateau.foundation.servlet.TenantAwareDelegatingFilter.doFilter(TenantAwareDelegatingFilter.java:87)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.plateau.common.webtoolkit.servlet.RequestInfo.doFilter(RequestInfo.java:77)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	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:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	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:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.plateau.common.webtoolkit.servlet.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:99)
	at com.plateau.foundation.servlet.TenantAwareDelegatingFilter.doFilter(TenantAwareDelegatingFilter.java:87)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.plateau.foundation.servlet.PlateauFoundationSetupHandler.doFilter(PlateauFoundationSetupHandler.java:390)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
	at org.apache.catalina.session.FoundationSessionManagerValve.invoke(FoundationSessionManagerValve.java:47)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:136)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
	at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:676)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:610)
	at org.apache.catalina.valves.StuckThreadDetectionValve.invoke(StuckThreadDetectionValve.java:208)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:526)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1078)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:655)
	at org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:222)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1566)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1523)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:812)
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("FR_IS_NEW_T1"."PA_CATALOG_ITEM_PRICE"."SKU")

	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
	at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1044)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
	at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3665)
	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1352)
	at sun.reflect.GeneratedMethodAccessor67.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:230)
	at oracle.ucp.jdbc.proxy.PreparedStatementProxyFactory.invoke(PreparedStatementProxyFactory.java:124)
	at com.sun.proxy.$Proxy95.executeUpdate(Unknown Source)
	at com.plateau.common.db.api.AbstractPreparedStatementWrapper.executeUpdate(AbstractPreparedStatementWrapper.java:81)
	at sun.reflect.GeneratedMethodAccessor67.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:67)
	at com.plateau.common.db.api.InterruptibleJdbcObjectProxyFactory$InterruptibleJdbcObjectProxy.invoke(InterruptibleJdbcObjectProxyFactory.java:155)
	at com.sun.proxy.$Proxy98.executeUpdate(Unknown Source)
	at com.plateausystems.elms.framework.financial.helper.CatalogDAOImpl.createCatalogItemPrices(CatalogDAOImpl.java:3271)
	at com.plateausystems.elms.framework.financial.impl.CatalogServiceImpl.createCatalogItemPrices(CatalogServiceImpl.java:1636)
	... 187 more



Scenario 2:

1) After Scenario 1, create a scheduled offering ID: SO1 (Segment date should be in the past)
2) Add back SKU ID in the item summary tab
3) Add catalog CAT1 item > Catalog tab [Catalog is added successfully]
4) Go to Scheduled offering and try to add CAT1 throws following exception error message.

Error

Please report the following error to your system administrator:

com.plateausystems.elms.util.helper.ElmsFinderException: Error Occured at getMaterialInventoryScheduleVO
	at com.plateausystems.elms.framework.financial.impl.MasterInventoryServiceImpl.getMasterInventoryScheduleVO(MasterInventoryServiceImpl.java:449)
	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 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.framework.localization.DataLocalizationInterceptor.invoke(DataLocalizationInterceptor.java:72)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	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.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
	at com.sun.proxy.$Proxy232.getMasterInventoryScheduleVO(Unknown Source)
	at com.plateausystems.elms.client.struts.scheduleinstance.EditCatalogAction.run(EditCatalogAction.java:129)
	at com.plateausystems.elms.client.struts.BaseActionDelegate.invokeValidateAndRun(BaseActionDelegate.java:69)
	at com.plateausystems.elms.client.struts.TMSDelegatingTilesRequestProcessor.processActionPerform(TMSDelegatingTilesRequestProcessor.java:130)
	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:644)
	at com.plateau.foundation.struts1.action.PlateauActionServlet.service(PlateauActionServlet.java:751)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:725)
	at com.plateau.common.springweb.api.ServletToBeanProxy.service(ServletToBeanProxy.java:83)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:725)
	at com.plateau.foundation.servlet.TenantAwareDelegatingServlet.service(TenantAwareDelegatingServlet.java:95)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.plateausystems.elms.framework.usagestatistics.client.CollectUsageStatisticsFilter.internalDoFilter(CollectUsageStatisticsFilter.java:104)
	at com.plateau.common.webtoolkit.api.servlet.PlateauAbstractFilter.doFilter(PlateauAbstractFilter.java:113)
	at com.plateau.foundation.servlet.TenantAwareDelegatingFilter.doFilter(TenantAwareDelegatingFilter.java:87)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	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:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.plateausystems.elms.client.servlet.EnsureSearchContextFilter.internalDoFilter(EnsureSearchContextFilter.java:127)
	at com.plateau.common.webtoolkit.api.servlet.PlateauAbstractFilter.doFilter(PlateauAbstractFilter.java:113)
	at com.plateau.foundation.servlet.TenantAwareDelegatingFilter.doFilter(TenantAwareDelegatingFilter.java:87)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	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:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.plateausystems.elms.framework.csrfguard.LmsCsrfGuardFilter.doFilter(LmsCsrfGuardFilter.java:97)
	at com.plateau.foundation.servlet.TenantAwareDelegatingFilter.doFilter(TenantAwareDelegatingFilter.java:87)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.plateau.common.webtoolkit.api.servlet.PlateauAbstractFilter.doFilter(PlateauAbstractFilter.java:117)
	at com.plateau.foundation.servlet.TenantAwareDelegatingFilter.doFilter(TenantAwareDelegatingFilter.java:87)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.plateausystems.elms.client.servlet.CheckAdminLogonFilter.doFilter(CheckAdminLogonFilter.java:126)
	at com.plateau.foundation.servlet.TenantAwareDelegatingFilter.doFilter(TenantAwareDelegatingFilter.java:87)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	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 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.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.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:381)
	at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187)
	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.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.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 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.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:381)
	at com.plateau.common.webtoolkit.api.servlet.PlateauAbstractFilter.doFilter(PlateauAbstractFilter.java:117)
	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:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.plateausystems.elms.client.servlet.CheckOtherLogonFilter.doFilter(CheckOtherLogonFilter.java:121)
	at com.plateau.foundation.servlet.TenantAwareDelegatingFilter.doFilter(TenantAwareDelegatingFilter.java:87)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	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:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.plateau.common.webtoolkit.servlet.EncodingFilter.doFilter(EncodingFilter.java:297)
	at com.plateau.foundation.servlet.TenantAwareDelegatingFilter.doFilter(TenantAwareDelegatingFilter.java:87)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	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:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.plateau.foundation.servlet.JdbcResourceMonitorServletFilter.doFilter(JdbcResourceMonitorServletFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.plateausystems.elms.util.helper.test.automation.PlateauTestFilter.doFilter(PlateauTestFilter.java:114)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.plateausystems.elms.client.servlet.ResponseHeaderFilter.doFilter(ResponseHeaderFilter.java:234)
	at com.plateau.foundation.servlet.TenantAwareDelegatingFilter.doFilter(TenantAwareDelegatingFilter.java:87)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.plateau.common.webtoolkit.servlet.RequestLogger.doFilter(RequestLogger.java:187)
	at com.plateau.foundation.servlet.TenantAwareDelegatingFilter.doFilter(TenantAwareDelegatingFilter.java:87)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.plateau.common.webtoolkit.servlet.RequestInfo.doFilter(RequestInfo.java:77)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	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:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	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:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.plateau.common.webtoolkit.servlet.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:99)
	at com.plateau.foundation.servlet.TenantAwareDelegatingFilter.doFilter(TenantAwareDelegatingFilter.java:87)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.plateau.foundation.servlet.PlateauFoundationSetupHandler.doFilter(PlateauFoundationSetupHandler.java:390)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
	at org.apache.catalina.session.FoundationSessionManagerValve.invoke(FoundationSessionManagerValve.java:47)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:136)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
	at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:676)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:610)
	at org.apache.catalina.valves.StuckThreadDetectionValve.invoke(StuckThreadDetectionValve.java:208)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:526)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1078)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:655)
	at org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:222)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1566)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1523)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:812)
Caused by: com.plateausystems.elms.util.helper.ElmsNoRecordFoundException: Record Not Found
	at com.plateausystems.elms.framework.financial.impl.MasterInventoryServiceImpl.getMasterInventoryScheduleVO(MasterInventoryServiceImpl.java:447)
	... 185 more

 

Cause

This has been identified as a Product defect only a defect because it is returning an exception rather than being handled.

The solution is to catch the error and return text indicating that operation cannot be completed. There are no functional changes that should or can be done. Seeing this error is actually the result of the admin misconfiguring their catalog items.

They should not be removing the sku and as the admin would have performed the steps mentioned in the section of Reproducing the issue, the exception stack is thrown to the user rather than a suitable error message 

Resolution

The concern has been raised with the development team of the product and they will fix this by handling the Exception and displaying a suitable sanitized error to the user interface. As there are no functional changes that need to be done or this is not impacting any functionality, the development team had prioritized this as a low priority defect and will be addressed after critical defects of the product have been fixed.

 

Keywords

Error when adding catalog to Schedule offering, SKU , KBA , LOD-SF-LMS , SuccessFactors Learning , Problem

Product

SAP SuccessFactors Learning 1511 ; SuccessFactors Learning 1405 ; SuccessFactors Learning 1408 ; SuccessFactors Learning 1508