cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

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

SOLVED
Highlighted
Newbie

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

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

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

12 REPLIES 12
Highlighted

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

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.

Highlighted

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

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

Highlighted

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

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

Highlighted

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

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.

Highlighted

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

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

Highlighted

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

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.

Highlighted

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

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?

Highlighted

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

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.

Highlighted

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

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?

Highlighted

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

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).

Highlighted

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

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?

Highlighted

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

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

Announcements

Thingworx Navigate content has a new home! Click here to access the new Thingworx Navigate forum!