cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. X

Installing Thingworx 7.1, PostgreSQL 9.4, Oracle JDK 1.8, Tomcat 8.0.36, Linux Ubuntu - problem

Go to solution
jacekgra
12-Amethyst
12-Amethyst
‎Jul 18, 2016 08:53 AM
‎Jul 18, 2016 08:53 AM

Installing Thingworx 7.1, PostgreSQL 9.4, Oracle JDK 1.8, Tomcat 8.0.36, Linux Ubuntu - problem

I am trying to install TWX 7.1 with postgreSQL DB on separate server. I've managed to install it and run with Postgres 9.3 but I've realized that it is not supported (data sql schema was not loaded correctly) so I've installed 9.4 and started from scratch. Currently I am not able to start Thingworx from totally unknown problem.

platform-settings.json:

{
        "PersistenceProviderPackageConfigs": {
                "PostgresPersistenceProviderPackage": {
                        "ConnectionInformation": {
                                "jdbcUrl": "jdbc:postgresql://192.168.134.79:5432/thingworx",
                                "password": "password",
                                "username": "twadmin"
                        }
                }
        }
}

Catalina log:

18-Jul-2016 14:34:53.010 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version:        Apache Tomcat/8.0.36
18-Jul-2016 14:34:53.012 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built:          Jun 9 2016 13:55:50 UTC
18-Jul-2016 14:34:53.012 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server number:         8.0.36.0
18-Jul-2016 14:34:53.012 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name:               Linux
18-Jul-2016 14:34:53.012 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version:            3.13.0-92-generic
18-Jul-2016 14:34:53.012 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture:          amd64
18-Jul-2016 14:34:53.013 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home:             /usr/lib/jvm/jdk1.8.0_92/jre
18-Jul-2016 14:34:53.013 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version:           1.8.0_92-b14
18-Jul-2016 14:34:53.013 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor:            Oracle Corporation
18-Jul-2016 14:34:53.013 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE:         /opt/tomcat
18-Jul-2016 14:34:53.013 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME:         /opt/tomcat
18-Jul-2016 14:34:53.013 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=/opt/tomcat/conf/logging.properties
18-Jul-2016 14:34:53.014 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
18-Jul-2016 14:34:53.014 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djdk.tls.ephemeralDHKeySize=2048
18-Jul-2016 14:34:53.014 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.endorsed.dirs=/opt/tomcat/endorsed
18-Jul-2016 14:34:53.014 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=/opt/tomcat
18-Jul-2016 14:34:53.014 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=/opt/tomcat
18-Jul-2016 14:34:53.014 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=/opt/tomcat/temp
18-Jul-2016 14:34:53.015 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib
18-Jul-2016 14:34:53.190 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"]
18-Jul-2016 14:34:53.208 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
18-Jul-2016 14:34:53.212 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["ajp-nio-8009"]
18-Jul-2016 14:34:53.213 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
18-Jul-2016 14:34:53.214 INFO [main] org.apache.catalina.startup.Catalina.load Initialization processed in 665 ms
18-Jul-2016 14:34:53.246 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service Catalina
18-Jul-2016 14:34:53.247 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/8.0.36
18-Jul-2016 14:34:53.274 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR Deploying web application archive /opt/tomcat/webapps/Thingworx.war
18-Jul-2016 14:34:55.773 INFO [localhost-startStop-1] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
java.lang.Exception: Unable to initialize and start system: null
        at com.thingworx.system.ThingWorxServer.loadModel(ThingWorxServer.java:448)
        at com.thingworx.system.ThingWorxServer.doHA(ThingWorxServer.java:181)
        at com.thingworx.system.ThingWorxBootstrapper.contextInitialized(ThingWorxBootstrapper.java:124)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4842)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5303)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:940)
        at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1816)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        at java.util.concurrent.FutureTask.run(FutureTask.java:266)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at java.lang.Thread.run(Thread.java:745)
*** CRITICAL ERROR ON STARTUP: Unable to initialize and start system: null
*** Web Application STATE is being set to ERROR! ***

Application.log:

2016-07-18 14:34:56.545+0200 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] ThingWorx Version Information
2016-07-18 14:34:56.545+0200 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] ========================================
2016-07-18 14:34:56.545+0200 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] majorVersion = 7
2016-07-18 14:34:56.546+0200 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] minorVersion = 1
2016-07-18 14:34:56.546+0200 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] revision = 3
2016-07-18 14:34:56.546+0200 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] build = b14
2016-07-18 14:34:56.546+0200 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] schemaVersion = 911
2016-07-18 14:34:56.546+0200 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] ========================================
2016-07-18 14:34:56.546+0200 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] ========================================
2016-07-18 14:34:56.546+0200 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] ThingWorx System Environment Settings
2016-07-18 14:34:56.546+0200 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] ========================================
2016-07-18 14:34:56.546+0200 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] OS: Linux
2016-07-18 14:34:56.546+0200 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] OS arch: amd64
2016-07-18 14:34:56.546+0200 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] OS version: 3.13.0-92-generic
2016-07-18 14:34:56.547+0200 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Total Processors: 4
2016-07-18 14:34:56.547+0200 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Default encoding: UTF-8
2016-07-18 14:34:56.547+0200 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] JAVA vendor: Oracle Corporation
2016-07-18 14:34:56.547+0200 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] JAVA version: 1.8.0_92
2016-07-18 14:34:56.547+0200 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] JAVA install location: /usr/lib/jvm/jdk1.8.0_92/jre
2016-07-18 14:34:56.547+0200 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] JVM Max Memory: 1776 (MB)
2016-07-18 14:34:56.547+0200 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] ========================================
2016-07-18 14:34:56.547+0200 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] WebApp starting...
2016-07-18 14:34:56.800+0200 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] HA mode not enabled. Initializing and starting in standalone mode.
2016-07-18 14:34:56.801+0200 [L: INFO] [O: c.t.s.ThingWorxPersistenceHandler] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Default Persistence Provider Name = ThingworxPersistenceProvider
2016-07-18 14:34:56.801+0200 [L: INFO] [O: c.t.s.ThingWorxPersistenceHandler] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Default Persistence Provider Package Name = PostgresPersistenceProviderPackage
2016-07-18 14:34:56.813+0200 [L: INFO] [O: c.t.p.p.PostgresDatasource] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Reading configuration from configTableCol
2016-07-18 14:34:57.025+0200 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Managers...INITIALIZED
2016-07-18 14:34:57.028+0200 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Database initialization started...
2016-07-18 14:34:57.252+0200 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] System ownership locking started...
2016-07-18 14:34:57.258+0200 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] System ownership locking complete
2016-07-18 14:34:57.266+0200 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Database initialization complete
2016-07-18 14:34:57.270+0200 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Initializing Collections...
2016-07-18 14:34:57.289+0200 [L: INFO] [O: c.t.p.p.d.PostgresModelDao] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Fetch Size Set - [5000]
2016-07-18 14:34:57.714+0200 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Initializing Scheduler Engine...
2016-07-18 14:34:57.716+0200 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Initializing Entities...
2016-07-18 14:34:57.717+0200 [L: INFO] [O: c.t.s.m.BaseManager] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Initializing ModelTags...
2016-07-18 14:34:57.721+0200 [L: INFO] [O: c.t.s.m.BaseManager] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Initializing DataTags...
2016-07-18 14:34:57.727+0200 [L: INFO] [O: c.t.s.m.BaseManager] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Initializing Groups...
2016-07-18 14:34:57.727+0200 [L: INFO] [O: c.t.s.m.BaseManager] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Initializing Users...
2016-07-18 14:34:57.764+0200 [L: ERROR] [O: c.t.s.m.BaseManager] [I: ] [U: SuperUser] [S: ] [T: ForkJoinPool-1-worker-1] Unable To Initialize Entity System in Users: null
2016-07-18 14:34:57.766+0200 [L: ERROR] [O: c.t.s.m.BaseManager] [I: ] [U: SuperUser] [S: ] [T: ForkJoinPool-1-worker-2] Unable To Initialize Entity Administrator in Users: null
2016-07-18 14:34:57.766+0200 [L: ERROR] [O: c.t.s.m.BaseManager] [I: ] [U: SuperUser] [S: ] [T: ForkJoinPool-1-worker-2] Unable To Initialize Entity SuperUser in Users: null
2016-07-18 14:34:57.766+0200 [L: INFO] [O: c.t.s.m.BaseManager] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Initializing Organizations...
2016-07-18 14:34:57.767+0200 [L: INFO] [O: c.t.s.m.BaseManager] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Initializing Logs...
2016-07-18 14:34:57.767+0200 [L: INFO] [O: c.t.s.m.BaseManager] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Initializing DataShapes...
2016-07-18 14:34:57.767+0200 [L: INFO] [O: c.t.s.m.BaseManager] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Initializing ThingShapes...
2016-07-18 14:34:57.767+0200 [L: INFO] [O: c.t.s.m.BaseManager] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Initializing ThingPackages...
2016-07-18 14:34:57.767+0200 [L: INFO] [O: c.t.s.m.BaseManager] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Initializing ThingTemplates...
2016-07-18 14:34:57.767+0200 [L: INFO] [O: c.t.s.m.BaseManager] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Initializing DataAnalysisDefinitions...
2016-07-18 14:34:57.768+0200 [L: INFO] [O: c.t.s.m.BaseManager] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Initializing ApplicationKeys...
2016-07-18 14:34:57.768+0200 [L: INFO] [O: c.t.s.m.BaseManager] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Initializing Dashboards...
2016-07-18 14:34:57.768+0200 [L: INFO] [O: c.t.s.m.BaseManager] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Initializing LocalizationTables...
2016-07-18 14:34:57.768+0200 [L: INFO] [O: c.t.s.m.BaseManager] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Initializing StateDefinitions...
2016-07-18 14:34:57.768+0200 [L: INFO] [O: c.t.s.m.BaseManager] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Initializing StyleDefinitions...
2016-07-18 14:34:57.768+0200 [L: INFO] [O: c.t.s.m.BaseManager] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Initializing Widgets...
2016-07-18 14:34:57.769+0200 [L: INFO] [O: c.t.s.m.BaseManager] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Initializing Mashups...
2016-07-18 14:34:57.769+0200 [L: INFO] [O: c.t.s.m.BaseManager] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Initializing Menus...
2016-07-18 14:34:57.769+0200 [L: INFO] [O: c.t.s.m.BaseManager] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Initializing MediaEntities...
2016-07-18 14:34:57.769+0200 [L: INFO] [O: c.t.s.m.BaseManager] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Initializing Projects...
2016-07-18 14:34:57.769+0200 [L: INFO] [O: c.t.s.m.BaseManager] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Initializing Networks...
2016-07-18 14:34:57.770+0200 [L: INFO] [O: c.t.s.m.BaseManager] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Initializing ExtensionPackages...
2016-07-18 14:34:57.770+0200 [L: INFO] [O: c.t.s.m.BaseManager] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Initializing Authenticators...
2016-07-18 14:34:57.770+0200 [L: INFO] [O: c.t.s.m.BaseManager] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Initializing PersistenceProviderPackages...
2016-07-18 14:34:57.772+0200 [L: INFO] [O: c.t.s.m.BaseManager] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Initializing PersistenceProviders...
2016-07-18 14:34:57.802+0200 [L: INFO] [O: c.t.p.p.PostgresDatasource] [I: ] [U: SuperUser] [S: ] [T: ForkJoinPool-1-worker-1] Reading configuration from configTableCol
2016-07-18 14:34:57.836+0200 [L: INFO] [O: c.t.p.p.PersistenceProvider] [I: ] [U: SuperUser] [S: ] [T: ForkJoinPool-1-worker-1] Connection ThingworxPersistenceProvider, type PostgresPersistenceProviderPackage started
2016-07-18 14:34:57.841+0200 [L: INFO] [O: c.t.p.p.PersistenceProvider] [I: ] [U: SuperUser] [S: ] [T: ForkJoinPool-1-worker-1] PersistenceProvider - ThingworxPersistenceProvider - Data Processing (ValueStreamEntry) is starting 2016-07-18 14:34:57.845+0200 [L: INFO] [O: c.t.p.p.PersistenceProvider] [I: ] [U: SuperUser] [S: ] [T: ForkJoinPool-1-worker-1] PersistenceProvider - ThingworxPersistenceProvider - Data Processing (ValueStreamEntry) is started
2016-07-18 14:34:57.846+0200 [L: INFO] [O: c.t.p.p.PersistenceProvider] [I: ] [U: SuperUser] [S: ] [T: ForkJoinPool-1-worker-1] PersistenceProvider - ThingworxPersistenceProvider - Data Processing (StreamEntry) is starting
2016-07-18 14:34:57.851+0200 [L: INFO] [O: c.t.p.p.PersistenceProvider] [I: ] [U: SuperUser] [S: ] [T: ForkJoinPool-1-worker-1] PersistenceProvider - ThingworxPersistenceProvider - Data Processing (StreamEntry) is started
2016-07-18 14:34:57.851+0200 [L: INFO] [O: c.t.s.m.BaseManager] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Initializing DirectoryServices...
2016-07-18 14:34:57.852+0200 [L: INFO] [O: c.t.s.m.BaseManager] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Initializing Resources...
2016-07-18 14:34:57.852+0200 [L: INFO] [O: c.t.s.m.BaseManager] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Initializing ScriptFunctionLibraries...
2016-07-18 14:34:57.852+0200 [L: INFO] [O: c.t.s.m.BaseManager] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Initializing Subsystems...
2016-07-18 14:34:57.852+0200 [L: INFO] [O: c.t.s.m.BaseManager] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Initializing Things...
2016-07-18 14:34:57.852+0200 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Cleaning up legacy entities...
2016-07-18 14:34:57.852+0200 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Checking default permissions...
2016-07-18 14:34:57.859+0200 [L: ERROR] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1]
2016-07-18 14:34:57.860+0200 [L: INFO] [O: c.t.u.InheritableForkJoinPoolManager] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Called ShutdownNow Local ForkJoin Pool for localhost-startStop-1
2016-07-18 14:34:57.862+0200 [L: INFO] [O: c.t.u.InheritableForkJoinPoolManager] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Removed Local ForkJoin Pool for localhost-startStop-1
2016-07-18 14:34:57.879+0200 [L: INFO] [O: c.t.p.p.PersistenceProvider] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Connection ThingworxPersistenceProvider, type PostgresPersistenceProviderPackage stopped
2016-07-18 14:34:57.884+0200 [L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] [message: Unable to initialize and start system: null]
2016-07-18 14:34:57.885+0200 [L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] *** Web Application STATE is being set to ERROR! ***

Security log:

2016-07-18 14:34:57.904+0200 [L: ERROR] [O: S.c.t.s.a.AuthenticationFilter] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Could not load session timeout from database, using default: null

PgAdmin screenshot:

pgSQL.png

Any ideas what can be wrong? Anything else to check? I've restarted machines, make the whole procedure several times, always the same result.

Labels:
0 Kudos
Notify Moderator
ACCEPTED SOLUTION

Accepted Solutions
jacekgra
12-Amethyst
12-Amethyst
(To:jacekgra)
‎Jul 22, 2016 04:40 AM
‎Jul 22, 2016 04:40 AM

Issue solved. I've set up everything from scratch one more time following guide from:

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS230472&source=Case%20Viewer

The only difference was that during installation of postgres I've installed postgresql-contrib-9.4 this time (previously I did not install it). Maybe that was the issue.

Thanks everyone for helping me out solving the issue!

View solution in original post

Notify Moderator
12 REPLIES 12
supandey
19-Tanzanite
19-Tanzanite
(To:jacekgra)
‎Jul 18, 2016 09:11 AM
‎Jul 18, 2016 09:11 AM

Hi Jacek, is the JDK updated after it was first installed when configuring the ThingWorx and along with Apache Tomcat? Could you confirm if the path to the JDK bin is same as defined in the Apache Tomcat Config utility under the Java tab

I think i had the same issue as you having right now, because the path to the JDK changed when i updated the JDK. Since then I check the Use Default, instead of providing the JDK path under the JVM path and set JAVA_HOME in the Environment path.

0 Kudos
Notify Moderator
jacekgra
12-Amethyst
12-Amethyst
(To:supandey)
‎Jul 18, 2016 09:18 AM
‎Jul 18, 2016 09:18 AM

Hi Sushant, I am not using Windows nor I have any GUI for my system, but from the logs I can see that Tomcat is using my latest Java installed (however JRE, not JDK):

Java Home:             /usr/lib/jvm/jdk1.8.0_92/jre 
JVM Version:           1.8.0_92-b14  
JVM Vendor:            Oracle Corporation

Moreover, I was able to run Thingworx with the same Java and Tomcat settings but with Postgre 9.3.

It just stopped working when I switched to 9.4

0 Kudos
Notify Moderator
supandey
19-Tanzanite
19-Tanzanite
(To:jacekgra)
‎Jul 18, 2016 09:32 AM
‎Jul 18, 2016 09:32 AM

Jacek, (sorry i missed the Linux info) a second look to the logs seems to indicate if the issue is probably concerning the missing the rights under which you are running the application. Has there been any change concerning the user or the user rights?

Tried looking this issue over the community and found this Post which has a detailed step on installing Thingworx on Ubuntu 14.04.1

Hope this helps.

Sushant

0 Kudos
Notify Moderator
jacekgra
12-Amethyst
12-Amethyst
(To:supandey)
‎Jul 18, 2016 09:36 AM
‎Jul 18, 2016 09:36 AM

Thanks, but this article is obsolete and it does not referers to my configuration (external postgres instead of embedeed neo4j).

User rights are exactly the same.

0 Kudos
Notify Moderator
supandey
19-Tanzanite
19-Tanzanite
(To:jacekgra)
‎Jul 18, 2016 09:49 AM
‎Jul 18, 2016 09:49 AM

Jacek, which version of Ubuntu is it? BTW, just a small question concerning the platform-settings.json, is the password = "password" correct? Here's the reference document on Installing and configuring PostgreSQL for ThingWorx on Ubuntu

0 Kudos
Notify Moderator
jacekgra
12-Amethyst
12-Amethyst
(To:supandey)
‎Jul 18, 2016 09:58 AM
‎Jul 18, 2016 09:58 AM

My password is correct (i don't want to share my password on community ).

I've followed the same procedure as desribed in the document you've provided.

As I've already mentioned - I had this setup working but with different database cluster (9.3 instead of 9.4).

So it is related to the database itself.

0 Kudos
Notify Moderator
supandey
19-Tanzanite
19-Tanzanite
(To:jacekgra)
‎Jul 18, 2016 10:35 AM
‎Jul 18, 2016 10:35 AM

Just wanted to highlight, if the password is correct.

To me this still appear to be the configuration issue - username & password, url to the Postgresql 9.4 . Is the Postgresql instance and the TW both running on same machine?

0 Kudos
Notify Moderator
jacekgra
12-Amethyst
12-Amethyst
(To:supandey)
‎Jul 18, 2016 01:27 PM
‎Jul 18, 2016 01:27 PM

No, they are not (I have dedicated server for database, in the same network). I can access the postgres server with any other tool from any other host.

Moreover, just for test I've manually added users to the database and the Thingworx is seems to retireve them from the database during launch, but still it ends up with the error:

[L: ERROR] [O: c.t.s.m.BaseManager] [I: ] [U: SuperUser] [S: ] [T: ForkJoinPool-1-worker-2] Unable To Initialize Entity System in Users: null
[L: ERROR] [O: c.t.s.m.BaseManager] [I: ] [U: SuperUser] [S: ] [T: ForkJoinPool-1-worker-3] Unable To Initialize Entity wcadmin in Users: null
[L: ERROR] [O: c.t.s.m.BaseManager] [I: ] [U: SuperUser] [S: ] [T: ForkJoinPool-1-worker-1] Unable To Initialize Entity Administrator in Users: null
[L: ERROR] [O: c.t.s.m.BaseManager] [I: ] [U: SuperUser] [S: ] [T: ForkJoinPool-1-worker-3] Unable To Initialize Entity SuperUser in Users: null
[L: ERROR] [O: c.t.s.m.BaseManager] [I: ] [U: SuperUser] [S: ] [T: ForkJoinPool-1-worker-0] Unable To Initialize Entity test in Users: null

As you can see, there are two additional users during startup identified directly from the database (wcadmin and test) so Thingworx do connect with the database.

I will try to purge tomcat and set server environment one more time.

0 Kudos
Notify Moderator
Aanjan
12-Amethyst
12-Amethyst
(To:jacekgra)
‎Jul 18, 2016 04:53 PM
‎Jul 18, 2016 04:53 PM

Jacek, sorry to make you rehash things, but you do have a thingworx Tablespace in your PgAdmin, right? Since you have a dedicated server for Posgres, the platform-settings in your ThingworxPlatform folder points to the right server (and not localhost:5432), correct? Can you try switching the owner to twadmin (from postgres) for both thingworx Database and Tablespace?

0 Kudos
Notify Moderator
jacekgra
12-Amethyst
12-Amethyst
(To:Aanjan)
‎Jul 19, 2016 05:05 AM
‎Jul 19, 2016 05:05 AM

Hello Aanjan, I've just checked and both Database and Tablespace has owner: twadmin.

Platform settings points to correct server (I can even see list of users from the database during startup of Thingworx, but there is some null pointer and the launch is stopped).

0 Kudos
Notify Moderator
Aanjan
12-Amethyst
12-Amethyst
(To:jacekgra)
‎Jul 20, 2016 12:09 PM
‎Jul 20, 2016 12:09 PM

Looking at the Application logs, it seems to be failing specifically with the Users Entity. Can you try pointing it to a different instance where you have just the default postgres and the twadmin user?

0 Kudos
Notify Moderator
jacekgra
12-Amethyst
12-Amethyst
(To:jacekgra)
‎Jul 22, 2016 04:40 AM
‎Jul 22, 2016 04:40 AM

Issue solved. I've set up everything from scratch one more time following guide from:

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS230472&source=Case%20Viewer

The only difference was that during installation of postgres I've installed postgresql-contrib-9.4 this time (previously I did not install it). Maybe that was the issue.

Thanks everyone for helping me out solving the issue!

Notify Moderator
Announcements


Contact Community Management
Top Tags