HCL Commerce Version 9.1.12.0 or later

Troubleshooting: Unable to approve seller registration

When attempting to approve a new seller registration using the Approve Registration button within the Approvals tool, the seller is reported as an existing seller.

Problem

When attempting to approve a new seller registration using the Approve Registration button within the Approvals tool, the seller is reported as an existing seller. You can observe trace log contents similar to the following: 
com.ibm.commerce.exception.ECSystemException: Command not found: "SendMarketingTriggers".
    at com.ibm.commerce.command.CommandFactory.locateCommandEntry(CommandFactory.java:558)
    at com.ibm.commerce.component.BaseComponentImpl.executeCommand(BaseComponentImpl.java:216)
    at com.ibm.commerce.component.WebAdapterComponentImpl.executeCommand(WebAdapterComponentImpl.java:46)
    at com.ibm.commerce.component.objimpl.WebAdapterServiceBeanBase.executeCommand(WebAdapterServiceBeanBase.java:43)
    at com.ibm.commerce.component.objects.EJSLocalNSLWebAdapterService_bd9a6c99.executeCommand(EJSLocalNSLWebAdapterService_bd9a6c99.java)
    at com.ibm.commerce.scheduler.SchedulerJob.process(SchedulerJob.java:591)
    at com.ibm.commerce.scheduler.SchedulerSecurityPriviledgedAction.run(SchedulerSecurityPriviledgedAction.java:59)
    at com.ibm.commerce.scheduler.SchedulerJob.run(SchedulerJob.java:1134)
    at com.hcl.commerce.threadmanagement.internal.BaseWork.run(BaseWork.java:106)
    at javax.enterprise.concurrent.ManagedExecutors$RunnableAdapter.run(ManagedExecutors.java:211)
    at com.ibm.ws.asynchbeans.SubmittedTask.run(SubmittedTask.java:711)
    at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1909)

End of exception traces.

[3/16/23 0:30:00:349 EDT] 000075cb CommerceSrvr  E com.ibm.commerce.scheduler.SchedulerJob process CMN0409E: The following error occurred during processing: "
Correlation Identity: -448e8a6c:186e0ccba92:-7e8c
Additional Data: 
    null
Current exception:
Message:
   _ERR_CMD_CMD_NOT_FOUND
Stack trace:
com.ibm.commerce.exception.ECSystemException: Command not found: "SaveMarketingStatistics".
    at com.ibm.commerce.command.CommandFactory.locateCommandEntry(CommandFactory.java:558)
    at com.ibm.commerce.component.BaseComponentImpl.executeCommand(BaseComponentImpl.java:216)
    at com.ibm.commerce.component.WebAdapterComponentImpl.executeCommand(WebAdapterComponentImpl.java:46)
    at com.ibm.commerce.component.objimpl.WebAdapterServiceBeanBase.executeCommand(WebAdapterServiceBeanBase.java:43)
    at com.ibm.commerce.component.objects.EJSLocalNSLWebAdapterService_bd9a6c99.executeCommand(EJSLocalNSLWebAdapterService_bd9a6c99.java)
    at com.ibm.commerce.scheduler.SchedulerJob.process(SchedulerJob.java:591)
    at com.ibm.commerce.scheduler.SchedulerSecurityPriviledgedAction.run(SchedulerSecurityPriviledgedAction.java:59)
    at com.ibm.commerce.scheduler.SchedulerJob.run(SchedulerJob.java:1134)
    at com.hcl.commerce.threadmanagement.internal.BaseWork.run(BaseWork.java:106)
    at javax.enterprise.concurrent.ManagedExecutors$RunnableAdapter.run(ManagedExecutors.java:211)
    at com.ibm.ws.asynchbeans.SubmittedTask.run(SubmittedTask.java:711)
    at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1909)

End of exception traces.
". 
Correlation Identity: -448e8a6c:186e0ccba92:-7e8c
Additional Data: 
    null
Current exception:
Message:
   _ERR_CMD_CMD_NOT_FOUND
Stack trace:
com.ibm.commerce.exception.ECSystemException: Command not found: "SaveMarketingStatistics".
    at com.ibm.commerce.command.CommandFactory.locateCommandEntry(CommandFactory.java:558)
    at com.ibm.commerce.component.BaseComponentImpl.executeCommand(BaseComponentImpl.java:216)
    at com.ibm.commerce.component.WebAdapterComponentImpl.executeCommand(WebAdapterComponentImpl.java:46)
    at com.ibm.commerce.component.objimpl.WebAdapterServiceBeanBase.executeCommand(WebAdapterServiceBeanBase.java:43)
    at com.ibm.commerce.component.objects.EJSLocalNSLWebAdapterService_bd9a6c99.executeCommand(EJSLocalNSLWebAdapterService_bd9a6c99.java)
    at com.ibm.commerce.scheduler.SchedulerJob.process(SchedulerJob.java:591)
    at com.ibm.commerce.scheduler.SchedulerSecurityPriviledgedAction.run(SchedulerSecurityPriviledgedAction.java:59)
    at com.ibm.commerce.scheduler.SchedulerJob.run(SchedulerJob.java:1134)
    at com.hcl.commerce.threadmanagement.internal.BaseWork.run(BaseWork.java:106)
    at javax.enterprise.concurrent.ManagedExecutors$RunnableAdapter.run(ManagedExecutors.java:211)
    at com.ibm.ws.asynchbeans.SubmittedTask.run(SubmittedTask.java:711)
    at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1909)

End of exception traces.

[3/16/23 0:31:56:065 EDT] 00003f67 SystemErr     R 131913384 [WebContainer : 6] INFO org.apache.wink.server.internal.RequestProcessor - *The following error occurred during the invocation of the handlers chain: WebApplicationException (401 - Unauthorized) with message 'null' while processing GET request sent to https://localhost/wcs/resources/store/1/databean?profileName=IBM_Store_Details&jspStoreDir=AuroraStorefrontAssetStore&langId=-1&responseFormat=json*
[3/16/23 0:32:29:889 EDT] 00000054 CommerceSrvr  I com.ibm.commerce.member.facade.server.commands.LTPAAuthenticationServiceCmdImpl validateParameters The command cannot be completed because the parameter "LTPAToken" was not specified.
[3/16/23 0:32:29:889 EDT] 00000054 ExtendedInfo  I   CWXFR9010I: Extended information : [componentId=com.ibm.commerce.member] 
[3/16/23 0:32:29:954 EDT] 00000054 BusinessObjec I com.ibm.commerce.foundation.client.facade.bod.servlet.spring.BusinessObjectDocumentController getFailedForward(HttpServletRequest,HttpServletResponse,AbstractBusinessObjectDocumentException) 2160: The command cannot be completed because the parameter "LTPAToken" was not specified.
[3/16/23 0:33:37:068 EDT] 00000b10 BusinessExcep E   CNTR0020E: EJB threw an unexpected (non-declared) exception during invocation of method "processCatalogFilter" on bean "BeanId(WC#Catalog-Server.jar#Catalog, null)". Exception data: java.lang.NoClassDefFoundError: com/ibm/commerce/foundation/common/util/logging/LoggingFileHandler$1
    at com.ibm.commerce.foundation.common.util.logging.LoggingFileHandler.publish(LoggingFileHandler.java:141)
    at java.util.logging.Logger.log(Logger.java:749)
    at com.ibm.ws.logging.WsLogger.deliverOrBuffer(WsLogger.java:416)
    at com.ibm.ws.logging.WsLogger.log(WsLogger.java:394)
    at com.ibm.ws.logging.WsLogger.logp(WsLogger.java:599)
    at com.ibm.commerce.catalog.facade.server.helpers.SearchUpdateHelper.invalidateCacheForStoreHeader(SearchUpdateHelper.java:4749)
    at com.ibm.commerce.catalog.facade.server.event.consumer.CatalogFilterEventConsumer.performInvalidation(CatalogFilterEventConsumer.java:264)
    at com.ibm.commerce.catalog.facade.server.event.consumer.CatalogFilterEventConsumer.processEvent(CatalogFilterEventConsumer.java:128)
    at com.ibm.commerce.foundation.internal.common.event.core.CommonEventProcessor.raiseEvent(CommonEventProcessor.java:152)
    at com.ibm.commerce.foundation.internal.common.event.emitter.CommonEventEmitter.sendEvent(CommonEventEmitter.java:68)
    at com.ibm.commerce.foundation.internal.common.event.core.CommonEvent.completeEvent(CommonEvent.java:371)
    at com.ibm.commerce.catalog.facade.server.commands.ProcessCatalogFilterCmdImpl.sendCatalogFilterEvent(ProcessCatalogFilterCmdImpl.java:104)
    at com.ibm.commerce.catalog.facade.server.commands.ProcessCatalogFilterCmdImpl.buildAcknowledgeBusinessObjectDocument(ProcessCatalogFilterCmdImpl.java:80)
    at com.ibm.commerce.foundation.server.command.bod.AbstractProcessBusinessObjectDocumentCmdImpl.performAction(AbstractProcessBusinessObjectDocumentCmdImpl.java:618)
    at com.ibm.commerce.foundation.server.command.bod.AbstractActionBusinessObjectDocumentCmdImpl.performExecute(AbstractActionBusinessObjectDocumentCmdImpl.java:146)
    at com.ibm.commerce.foundation.server.command.bod.BusinessObjectCommandTargetImpl.executeCommand(BusinessObjectCommandTargetImpl.java:116)
    at com.ibm.websphere.command.TargetableCommandImpl.execute(TargetableCommandImpl.java:139)
    at com.ibm.websphere.command.CacheableCommandImpl.execute(CacheableCommandImpl.java:139)
    at com.ibm.commerce.command.MeasuredCacheableCommandImpl.execute(MeasuredCacheableCommandImpl.java:69)
    at com.ibm.commerce.foundation.server.command.bod.BusinessObjectDocumentProcessor.processBusinessObjectDocument(BusinessObjectDocumentProcessor.java:276)
    at com.ibm.commerce.catalog.facade.server.CatalogFacadeImpl.processCatalogFilter(CatalogFacadeImpl.java:361)
    at com.ibm.commerce.catalog.facade.server.EJSLocalNSLCatalog_01190320.processCatalogFilter(EJSLocalNSLCatalog_01190320.java)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:90)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
    at java.lang.reflect.Method.invoke(Method.java:508)
    at com.ibm.commerce.foundation.internal.client.services.invocation.impl.NoInterfaceEJBInvocationBindingImpl.invoke(NoInterfaceEJBInvocationBindingImpl.java:225)
    at com.ibm.commerce.foundation.internal.client.services.invocation.InvocationService.invoke(InvocationService.java:113)
    at com.ibm.commerce.foundation.client.facade.bod.AbstractBusinessObjectDocumentFacadeClient.internalSendBusinessObjectDocument(AbstractBusinessObjectDocumentFacadeClient.java:818)
    at com.ibm.commerce.foundation.client.facade.bod.AbstractBusinessObjectDocumentFacadeClient.sendBusinessObjectDocument(AbstractBusinessObjectDocumentFacadeClient.java:529)
    at com.ibm.commerce.catalog.facade.client.AbstractCatalogFacadeClient.processCatalogFilter(AbstractCatalogFacadeClient.java:1913)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:90)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
    at java.lang.reflect.Method.invoke(Method.java:508)
    at com.ibm.commerce.rest.bod.AbstractBodMappingFlow.execute(AbstractBodMappingFlow.java:897)
    at com.ibm.commerce.rest.bod.AbstractBodMappingResource.post(AbstractBodMappingResource.java:347)
    at com.ibm.commerce.rest.bod.AbstractBodMappingResource.post(AbstractBodMappingResource.java:281)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:90)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
    at java.lang.reflect.Method.invoke(Method.java:508)
    at org.apache.wink.server.internal.handlers.InvokeMethodHandler.handleRequest(InvokeMethodHandler.java:63)
    at org.apache.wink.server.handlers.AbstractHandler.handleRequest(AbstractHandler.java:33)
    at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:26)
    at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:22)
    at org.apache.wink.server.handlers.AbstractHandlersChain.doChain(AbstractHandlersChain.java:63)
    at com.ibm.commerce.foundation.rest.handlers.MergeCustomRequestHandler.handleRequest(MergeCustomRequestHandler.java:147)
    at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:26)
    at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:22)
    at org.apache.wink.server.handlers.AbstractHandlersChain.doChain(AbstractHandlersChain.java:63)
    at com.ibm.commerce.foundation.rest.handlers.WhiteListProtectionRequestHandler.handleRequest(WhiteListProtectionRequestHandler.java:121)
    at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:26)
    at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:22)
    at org.apache.wink.server.handlers.AbstractHandlersChain.doChain(AbstractHandlersChain.java:63)
    at com.ibm.commerce.foundation.rest.handlers.CrossSiteScriptingRequestHandler.handleRequest(CrossSiteScriptingRequestHandler.java:131)
    at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:26)
    at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:22)
    at org.apache.wink.server.handlers.AbstractHandlersChain.doChain(AbstractHandlersChain.java:63)
    at com.ibm.commerce.foundation.rest.handlers.LegacyAuthHandler.handleRequest(LegacyAuthHandler.java:66)
    at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:26)
    at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:22)
    at org.apache.wink.server.handlers.AbstractHandlersChain.doChain(AbstractHandlersChain.java:63)
    at com.ibm.commerce.foundation.rest.handlers.BcsHandler.handleRequest(BcsHandler.java:233)
    at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:26)
    at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:22)
    at org.apache.wink.server.handlers.AbstractHandlersChain.doChain(AbstractHandlersChain.java:63)
    at com.ibm.commerce.foundation.rest.handlers.JwtBearerAuthHandler.handleRequest(JwtBearerAuthHandler.java:234)
    at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:26)
    at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:22)
    at org.apache.wink.server.handlers.AbstractHandlersChain.doChain(AbstractHandlersChain.java:63)
    at com.ibm.commerce.foundation.rest.handlers.AuthTypeHandler.handleRequest(AuthTypeHandler.java:111)
    at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:26)
    at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:22)
    at org.apache.wink.server.handlers.AbstractHandlersChain.doChain(AbstractHandlersChain.java:63)
    at com.ibm.commerce.foundation.rest.handlers.BusinessContextRequestHandler.handleRequest(BusinessContextRequestHandler.java:490)
    at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:26)
    at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:22)
    at org.apache.wink.server.handlers.AbstractHandlersChain.doChain(AbstractHandlersChain.java:63)
    at com.ibm.commerce.foundation.rest.handlers.RequestPerformanceMeasurementHandler.handleRequest(RequestPerformanceMeasurementHandler.java:99)
    at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:26)
    at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:22)
    at org.apache.wink.server.handlers.AbstractHandlersChain.doChain(AbstractHandlersChain.java:63)
    at com.ibm.commerce.foundation.rest.handlers.MessageContextLocalBindingRequestHandler.handleRequest(MessageContextLocalBindingRequestHandler.java:85)
    at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:26)
    at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:22)
    at org.apache.wink.server.handlers.AbstractHandlersChain.doChain(AbstractHandlersChain.java:63)
    at org.apache.wink.server.internal.handlers.CreateInvocationParametersHandler.handleRequest(CreateInvocationParametersHandler.java:54)
    at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:26)
    at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:22)
    at org.apache.wink.server.handlers.AbstractHandlersChain.doChain(AbstractHandlersChain.java:63)
    at org.apache.wink.server.internal.handlers.FindResourceMethodHandler.handleResourceMethod(FindResourceMethodHandler.java:151)
    at org.apache.wink.server.internal.handlers.FindResourceMethodHandler.handleRequest(FindResourceMethodHandler.java:65)
    at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:26)
    at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:22)
    at org.apache.wink.server.handlers.AbstractHandlersChain.doChain(AbstractHandlersChain.java:63)
    at org.apache.wink.server.internal.handlers.FindRootResourceHandler.handleRequest(FindRootResourceHandler.java:95)
    at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:26)
    at org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:22)
    at org.apache.wink.server.handlers.AbstractHandlersChain.doChain(AbstractHandlersChain.java:63)
    at org.apache.wink.server.internal.handlers.HeadMethodHandler.handleRequest(HeadMethodHandler.java:53)

Solution

You can resolve this issue in one of two ways:
  • Change the name of the Seller. The request can then be approved as expected.
  • Republish the HCL Commerce project on your test server after running the setdbtype command. The request can then be approved as expected.