Article - CS408659

Unable to start Tomcat with error "Table [BasicSettings] does not have a field named [MaxSearchItems]"

Modified: 10-Jan-2024   


Applies To

  • ThingWorx Platform 9.3 F000

Description

  • Unable to start Tomcat with error "Table [BasicSettings] does not have a field named [MaxSearchItems]" in Tomcat logs
  • Unable to start ThingWorx server after putting new license
  • Refer to Tomcat localhost log for more information
  • ERROR in ch.qos.logback.core.joran.spi.Interpreter@3:88 - RuntimeException in Action for tag [contextListener] com.thingworx.exceptions.ConfigurationException: java.lang.Exception: Table [BasicSettings] does not have a field named [MaxSearchItems]
    	at com.thingworx.exceptions.ConfigurationException: java.lang.Exception: Table [BasicSettings] does not have a field named [MaxSearchItems]
    	at 	at com.thingworx.system.configuration.PlatformSettings.getInstance(PlatformSettings.java:3390)
    	at 	at com.thingworx.logging.LogbackUtilities.loadLogbackConfiguration(LogbackUtilities.java:54)
    	at 	at com.thingworx.logging.LogUtilities.initializeLoggerContext(LogUtilities.java:440)
    	at 	at com.thingworx.logging.LogbackCustomLoggerContextListener.start(LogbackCustomLoggerContextListener.java:23)
    	at 	at ch.qos.logback.classic.joran.action.LoggerContextListenerAction.end(LoggerContextListenerAction.java:70)
    	at 	at ch.qos.logback.core.joran.spi.Interpreter.callEndAction(Interpreter.java:309)
    	at 	at ch.qos.logback.core.joran.spi.Interpreter.endElement(Interpreter.java:193)
    	at 	at ch.qos.logback.core.joran.spi.Interpreter.endElement(Interpreter.java:179)
    	at 	at ch.qos.logback.core.joran.spi.EventPlayer.play(EventPlayer.java:62)
    	at 	at ch.qos.logback.core.joran.GenericConfigurator.doConfigure(GenericConfigurator.java:165)
    	at 	at ch.qos.logback.core.joran.GenericConfigurator.doConfigure(GenericConfigurator.java:152)
    	at 	at ch.qos.logback.core.joran.GenericConfigurator.doConfigure(GenericConfigurator.java:110)
    	at 	at ch.qos.logback.core.joran.GenericConfigurator.doConfigure(GenericConfigurator.java:53)
    	at 	at ch.qos.logback.classic.util.ContextInitializer.configureByResource(ContextInitializer.java:75)
    	at 	at ch.qos.logback.classic.util.ContextInitializer.autoConfig(ContextInitializer.java:150)
    	at 	at org.slf4j.impl.StaticLoggerBinder.init(StaticLoggerBinder.java:84)
    	at 	at org.slf4j.impl.StaticLoggerBinder.<clinit>(StaticLoggerBinder.java:55)
    	at 	at org.slf4j.LoggerFactory.bind(LoggerFactory.java:150)
    	at 	at org.slf4j.LoggerFactory.performInitialization(LoggerFactory.java:124)
    	at 	at org.slf4j.LoggerFactory.getILoggerFactory(LoggerFactory.java:417)
    	at 	at ch.qos.logback.classic.util.StatusViaSLF4JLoggerFactory.addStatus(StatusViaSLF4JLoggerFactory.java:32)
    	at 	at ch.qos.logback.classic.util.StatusViaSLF4JLoggerFactory.addInfo(StatusViaSLF4JLoggerFactory.java:20)
    	at 	at ch.qos.logback.classic.servlet.LogbackServletContainerInitializer.onStartup(LogbackServletContainerInitializer.java:26)
    	at 	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5219)
    	at 	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    	at 	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:726)
    	at 	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:698)
    	at 	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:696)
    	at 	at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1024)
    	at 	at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1911)
    	at 	at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
    	at 	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
    	at 	at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    	at 	at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:118)
    	at 	at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:825)
    	at 	at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:475)
    	at 	at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1618)
    	at 	at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:319)
    	at 	at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:123)
    	at 	at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:423)
    	at 	at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:366)
    	at 	at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:946)
    	at 	at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:835)
    	at 	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    	at 	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1396)
    	at 	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1386)
    	at 	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
    	at 	at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    	at 	at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:140)
    	at 	at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:919)
    	at 	at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:263)
    	at 	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    	at 	at org.apache.catalina.core.StandardService.startInternal(StandardService.java:432)
    	at 	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    	at 	at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:927)
    	at 	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    	at 	at org.apache.catalina.startup.Catalina.start(Catalina.java:772)
    	at 	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    	at 	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    	at 	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    	at 	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    	at 	at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:345)
    	at 	at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:476)
    Caused by: java.lang.Exception: Table [BasicSettings] does not have a field named [MaxSearchItems]
    	at 	at com.thingworx.types.collections.ConfigurationTableCollection.setValue(ConfigurationTableCollection.java:172)
    	at 	at com.thingworx.types.collections.ConfigurationTableCollection.setValues(ConfigurationTableCollection.java:232)
    	at 	at com.thingworx.types.collections.ConfigurationTableCollection.setValues(ConfigurationTableCollection.java:202)
    	at 	at com.thingworx.system.configuration.PlatformSettings.<init>(PlatformSettings.java:2212)
    	at 	at com.thingworx.system.configuration.PlatformSettings.getInstance(PlatformSettings.java:3381)
    	at 	... 62 common frames omitted

     
This is a printer-friendly version of Article 408659 and may be out of date. For the latest version click CS408659