36 Replies Latest reply on Jul 21, 2017 3:03 AM by aadiwilaga RSS
    atsarev Explorer

    Thingworx: Status 401 or white screen

    Good afternoon!

    Installed on my computer Thingworx 8.0


    Windows 10

    Tomcat 8.0.44

    Postgresql 9.4.12

    Java: jdk-8u131-windows-x64


    Installation conducted on video instructions
    As a result, I received a screen with an error.
    I reinstalled many times, including instructions.
    Tried to install:

    3.JPG
    At startup either a white screen or an error 401.

    1.JPG

    I tried with versions 7.x - the same result

    I ask for your help.

    Thanks for every answer.

      • Re: Thingworx: Status 401 or white screen
        polinao Collaborator

        What  does your platform-settings.json look like? Where is your ThingworxPlatform folder located?

         

        If you open your pgadmin III and expand the thingworx database all the way, how many tables are you seeing?

          • Re: Thingworx: Status 401 or white screen
            atsarev Explorer

            1. platform-settings.json

            2.JPG

            2. C:\ThingworxPlatform

            All applications are on drive C
            Tomchat and PostgraSK in the folder C: \ Program Files

            3. pgadmin III

            7.JPG

              • Re: Thingworx: Status 401 or white screen
                polinao Collaborator

                Could you please supply your tomcat configuration too, particularly this line?

                 

                 

                Another thing to verify is that the folders ThingworxPostgresqlStorage and ThingworxPlatform both have permissions set on Everyone Full Control:

                 

                  • Re: Thingworx: Status 401 or white screen
                    atsarev Explorer

                    tomcat configuration

                    8.JPG

                    I gave full access to the folders


                    9.JPG

                    • Re: Thingworx: Status 401 or white screen
                      brucehul Apprentice

                      The ThingworxStorage/logs/ApplicationLog.log may have more information about your problem. I have encountered a couple of times with late 7.x and 8.x versions that get errors in ApplicationLog.log and do not show any indication of a problem in the tomcat logs. Since you are getting the 401 error, then Tomcat is up and running. That should mean that whatever the problem is, it should be getting logged to ApplicationLog.log. There is also the possibility that SecurityLog.log and CommunicationLog.log have errors, but it is less likely.

                        • Re: Thingworx: Status 401 or white screen
                          atsarev Explorer

                          ApplicationLog.log

                          10.JPG

                          SecurityLog.log

                          11.JPG

                          I`m not understand...

                          • Re: Thingworx: Status 401 or white screen
                            atsarev Explorer

                            Tell me please, what do the commands in tomcat mean?:

                             

                            -Dserver -Dd64

                            -XX:+UseG1GC

                            -Dfile.encoding=UTF-8

                              • Re: Thingworx: Status 401 or white screen
                                polinao Collaborator

                                The settings do with the memory and enconding, they are necessary but would not be causing your problem.

                                 

                                Can you try a different port number for tomcat? Are your tomcat settings default or did you add any authenticators?

                                Is there any error in the tomcat/logs catalina.out log?

                                  • Re: Thingworx: Status 401 or white screen
                                    atsarev Explorer

                                    Tried another port - the same result.

                                    Installed by default.

                                    In a log file in a folder tomcat of errors it did not find out.

                                    Successfully installed thingworx version 7.1, but also when upgrading version 8.1 did not start.

                                      • Re: Thingworx: Status 401 or white screen
                                        brucehul Apprentice

                                        If tomcat 8 is actually crashing once you have the Thingworx.war file in webapps, it is probably something to do with the license.bin file in ThingworxPlatform. But that usually shows up in one of the logs under ThingworxStorage/logs. The 8.x licensing also requires an additional line in the tomcat java startup parameters:

                                         

                                        -Djava.library.path=[path to tomcat]\webapps\Thingworx\WEB-INF\extensions

                                         

                                        Make sure the tomcat installation is working in the first place. Remove Thingworx.war and the thingworx directory from the webapps directory and try to start tomcat again. Fix any issues you find without the Thingworx webapp being present, then add Thingworx.war back into webapps. If it crashes, there will be some indication of why the crash is happening in the ThingworxStorage/logs directory (at least that's what I've seen with 8.0 so far). You will not see any indication of errors in any of the standard tomcat logs if licensing is the issue.

                                          • Re: Thingworx: Status 401 or white screen
                                            atsarev Explorer

                                            Bruse, Most likely you are right.

                                            I added my line "-Djava.library.path=C:\Apache Software Foundation\Tomcat 8.0\webapps\Thingworx\WEB-INF\extensions"

                                            I deleted the file ".war" version 7.1, the Tomcat started fine, then I copied the file ".war" version 8.1

                                            I got the license file again (".bin"), copied it to :C:\ThingworxPlatform" and renamed it "license.bin".

                                            The result is a white screen at startup Thingworx.

                                             

                                            13.JPG

                                             

                                            14.JPG

                                            If this is the case in the license file, what should I do?

                            • Re: Thingworx: Status 401 or white screen
                              ytella Explorer

                              Hi Andrey, Could you please ensure that there is only one Thingworx folder under Tomcat/Webapps. Renamed previous folder might also cause the problem.

                              • Re: Thingworx: Status 401 or white screen
                                rupadhyay-2 Explorer

                                Is Thingworx and DB on  same server .

                                Is database server accessible . Can you share your platform setting.json file.

                                • Re: Thingworx: Status 401 or white screen
                                  aadiwilaga Newbie

                                  Same with me here,  (not answer only to share)

                                  I have fully completed the Installation step in installation document for TW 8.0 and also TW 7.4 (plus video) in my fresh machine with windows 7. and when reaching the step to launch, go to

                                  localhost/Thingworx

                                  in my browser (Chrome 59, Firefox 54, IE 11) only get redirected to localhost/Thingworx/home with blank white screen.

                                   

                                  Here my specification:

                                  - Windows 7 (16GB ram / i7)

                                  - Java JDK/JRE 1.8 build 131

                                  - Apache Tomcat/9.0.0.M22 (tried with 8.5 got the same result)

                                  - PostgreSQL 9.4.12

                                  - Thingworx Platform Postgres 8-0-1_SP1 (tried with 7.4 got the same result)

                                  (all in 1 machine)

                                   

                                  Here my Tomcat setting:

                                  installation wizard with:

                                  -HTTP/1.1 connection port 80

                                  adding java options:

                                  -Dserver -Dd64

                                  -XX:+UseG1GC

                                  -Dfile.encoding=UTF-8

                                  -Djava.library.path=C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\Thingworx\WEB-INF\extensions

                                  modification in file server.xml :

                                  <Connector port="80" protocol="org.apache.coyote.http11.Http11NioProtocol"

                                                connectionTimeout="20000"

                                                redirectPort="8443"

                                    />

                                    

                                  adding line in file context.xml :

                                  <Context>

                                  .

                                  .

                                  <Resources

                                  cacheMaxSize="501200"

                                  cacheObjectMaxSize="2048"

                                  cacheTtl="60000"/>

                                  </Context>

                                    


                                  Here my postgreSQL (pgAdmin3) setting:

                                  add C:\Program Files\PostgreSQL\9.4\bin to my environtment variable

                                  create folder C:\ThingworxPostgresqlStorage

                                  run this script to set database :

                                  thingworxpostgresDBSetup -h localhost -p 5432 -d thingworx -t thingworx -a postgres -u twadmin -l C:\ThingworxPostgresqlStorage

                                  run this script to set schema :

                                   

                                  thingworxPostgresSchemaSetup -h localhost -p 5432 -d thingworx -s public -u twadmin -o data

                                   

                                  Configuring file platform-settings.json like this :

                                  {

                                    "PersistenceProviderPackageConfigs": {

                                        "PostgresPersistenceProviderPackage": {

                                          "ConnectionInformation": {

                                          "jdbcUrl": "jdbc:postgresql://localhost:5432/Thingworx",

                                          "password": "twadminpass",

                                          "username": "twadmin"

                                          }

                                        }

                                    }

                                  }

                                  and put json file above in C:/ThingworxPlatform

                                  then the last step is deploying thingworx.war file with apache server GUI (success with some tweaking in around maxpostinglimit)

                                  here all the picture:

                                  tomcat setting

                                  Tomat.png

                                  postgreSQL

                                  pgadmin.png

                                  folder :

                                  folder.png

                                  Tomcat server localhost :

                                  server.png

                                  and here the log (Applicationlog) :

                                  2017-07-18 15:40:55.403+0700 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-9] ========================================

                                  2017-07-18 15:40:55.404+0700 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-9] ThingWorx Version Information

                                  2017-07-18 15:40:55.404+0700 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-9] ========================================

                                  2017-07-18 15:40:55.406+0700 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-9] majorVersion = 8

                                  2017-07-18 15:40:55.406+0700 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-9] minorVersion = 0

                                  2017-07-18 15:40:55.406+0700 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-9] revision = 1

                                  2017-07-18 15:40:55.406+0700 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-9] build = b39

                                  2017-07-18 15:40:55.407+0700 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-9] schemaVersion = 1000

                                  2017-07-18 15:40:55.408+0700 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-9] ========================================

                                  2017-07-18 15:40:55.408+0700 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-9] ========================================

                                  2017-07-18 15:40:55.408+0700 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-9] ThingWorx System Environment Settings

                                  2017-07-18 15:40:55.408+0700 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-9] ========================================

                                  2017-07-18 15:40:55.408+0700 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-9] OS: Windows 7

                                  2017-07-18 15:40:55.408+0700 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-9] OS arch: amd64

                                  2017-07-18 15:40:55.408+0700 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-9] OS version: 6.1

                                  2017-07-18 15:40:55.410+0700 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-9] Total Processors: 8

                                  2017-07-18 15:40:55.410+0700 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-9] Default encoding: UTF-8

                                  2017-07-18 15:40:55.410+0700 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-9] JAVA vendor: Oracle Corporation

                                  2017-07-18 15:40:55.410+0700 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-9] JAVA version: 1.8.0_131

                                  2017-07-18 15:40:55.410+0700 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-9] JAVA install location: C:\Program Files\Java\jre1.8.0_131

                                  2017-07-18 15:40:55.410+0700 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-9] JVM Max Memory: 4072 (MB)

                                  2017-07-18 15:40:55.410+0700 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-9] ========================================

                                  2017-07-18 15:40:55.410+0700 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-9] WebApp starting...

                                  2017-07-18 15:40:55.745+0700 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-9] HA mode not enabled. Initializing and starting in standalone mode.

                                  2017-07-18 15:40:55.746+0700 [L: INFO] [O: c.t.s.ThingWorxPersistenceHandler] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-9] Default Persistence Provider Name = ThingworxPersistenceProvider

                                  2017-07-18 15:40:55.746+0700 [L: INFO] [O: c.t.s.ThingWorxPersistenceHandler] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-9] Default Persistence Provider Package Name = PostgresPersistenceProviderPackage

                                  2017-07-18 15:40:55.755+0700 [L: INFO] [O: c.t.p.p.PostgresDatasource] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-9] Reading configuration from configTableCol

                                  2017-07-18 15:40:55.978+0700 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-9] Managers...INITIALIZED

                                  2017-07-18 15:40:55.981+0700 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-9] Database initialization started...

                                  2017-07-18 15:41:26.398+0700 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: SuperUser] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->1hge1iz9pnjm6g61ngzq4t|a6b6c9e]-HelperThread-#1] com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@34a6964b -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (3). Last acquisition attempt exception:

                                  2017-07-18 15:41:26.399+0700 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: SuperUser] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->1hge1iz9pnjm6g61ngzq4t|a6b6c9e]-HelperThread-#1] Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@d22ce38 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.

                                  2017-07-18 15:41:26.399+0700 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: SuperUser] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->1hge1iz9pnjm6g61ngzq4t|a6b6c9e]-HelperThread-#2] com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@23cf9c7b -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (3). Last acquisition attempt exception:

                                  2017-07-18 15:41:26.403+0700 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: SuperUser] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->1hge1iz9pnjm6g61ngzq4t|a6b6c9e]-HelperThread-#2] Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@d22ce38 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.

                                  2017-07-18 15:41:26.406+0700 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: SuperUser] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->1hge1iz9pnjm6g61ngzq4t|a6b6c9e]-HelperThread-#5] com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@41754979 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (3). Last acquisition attempt exception:

                                  2017-07-18 15:41:26.406+0700 [L: ERROR] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-9] [message: Connections could not be acquired from the underlying database!]

                                  2017-07-18 15:41:26.406+0700 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: SuperUser] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->1hge1iz9pnjm6g61ngzq4t|a6b6c9e]-HelperThread-#5] Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@d22ce38 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.

                                  2017-07-18 15:41:26.411+0700 [L: INFO] [O: c.t.p.p.PersistenceProvider] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-9] Connection ThingworxPersistenceProvider, type PostgresPersistenceProviderPackage stopped

                                  2017-07-18 15:41:26.411+0700 [L: WARN] [O: c.t.p.p.PersistenceProvider] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-9] Could not find persistenceProviderPackage PostgresPersistenceProviderPackage and thus could not stop data processing

                                  2017-07-18 15:41:26.413+0700 [L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-9] [message: Unable to initialize and start system: Connections could not be acquired from the underlying database!]

                                  2017-07-18 15:41:26.413+0700 [L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-9] *** Web Application STATE is being set to ERROR! ***

                                  2017-07-18 15:41:26.422+0700 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: SuperUser] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->1hge1iz9pnjm6g61ngzq4t|a6b6c9e]-HelperThread-#0] com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@625ac15d -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (3). Last acquisition attempt exception:

                                  2017-07-18 15:41:26.422+0700 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: SuperUser] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->1hge1iz9pnjm6g61ngzq4t|a6b6c9e]-HelperThread-#0] Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@d22ce38 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.

                                  2017-07-18 15:41:26.428+0700 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: SuperUser] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->1hge1iz9pnjm6g61ngzq4t|a6b6c9e]-HelperThread-#6] com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@624e1793 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (3). Last acquisition attempt exception:

                                  2017-07-18 15:41:26.429+0700 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: SuperUser] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->1hge1iz9pnjm6g61ngzq4t|a6b6c9e]-HelperThread-#6] Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@d22ce38 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.

                                  2017-07-18 15:42:10.050+0700 [L: ERROR] [O: c.t.s.a.AuthenticationFilter] [I: ] [U: ] [S: ] [T: http-nio-80-exec-12] Could not handle request

                                  2017-07-18 15:57:56.022+0700 [L: ERROR] [O: c.t.s.a.AuthenticationFilter] [I: ] [U: ] [S: ] [T: http-nio-80-exec-14] Could not handle request

                                  2017-07-18 15:58:15.163+0700 [L: ERROR] [O: c.t.s.a.AuthenticationFilter] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-16] Could not handle request

                                  2017-07-18 15:59:32.865+0700 [L: ERROR] [O: c.t.s.a.AuthenticationFilter] [I: ] [U: ] [S: ] [T: http-nio-80-exec-11] Could not handle request

                                  this :

                                  2017-07-18 15:39:12.143+0700 [L: ERROR] [O: S.c.t.s.a.AuthenticationFilter] [I: ] [U: ] [S: ] [T: http-nio-80-exec-4] Could not handle request

                                  2017-07-18 15:39:19.515+0700 [L: ERROR] [O: S.c.t.s.a.AuthenticationFilter] [I: ] [U: ] [S: ] [T: http-nio-80-exec-6] Could not handle request

                                  2017-07-18 15:40:08.154+0700 [L: ERROR] [O: S.c.t.s.a.AuthenticationFilter] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-3] Could not handle request

                                  2017-07-18 15:41:26.439+0700 [L: INFO] [O: S.c.t.s.a.s.SSOContext] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-9] SSOContext created...

                                  2017-07-18 15:41:26.516+0700 [L: ERROR] [O: S.c.t.s.a.AuthenticationFilter] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-9] Could not load session timeout from database, using default: null

                                  2017-07-18 15:41:26.523+0700 [L: INFO] [O: S.c.t.s.s.SCIMProvider] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-9] Initializing SCIMProvider servlet...

                                  2017-07-18 15:41:26.524+0700 [L: ERROR] [O: S.c.t.s.s.SCIMProvider] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-9] SCIMProvider initialization failure.  Thingworx Server is not running

                                  2017-07-18 15:42:10.048+0700 [L: ERROR] [O: S.c.t.s.a.AuthenticationFilter] [I: ] [U: ] [S: ] [T: http-nio-80-exec-12] Could not handle request

                                  2017-07-18 15:57:56.022+0700 [L: ERROR] [O: S.c.t.s.a.AuthenticationFilter] [I: ] [U: ] [S: ] [T: http-nio-80-exec-14] Could not handle request

                                  2017-07-18 15:58:15.161+0700 [L: ERROR] [O: S.c.t.s.a.AuthenticationFilter] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-16] Could not handle request

                                  2017-07-18 15:59:32.864+0700 [L: ERROR] [O: S.c.t.s.a.AuthenticationFilter] [I: ] [U: ] [S: ] [T: http-nio-80-exec-11] Could not handle request

                                  thats is, really needed guidance here, i have tried every possible configuration i know, but had same result and sometimes even worse .

                                    • Re: Thingworx: Status 401 or white screen
                                      polinao Collaborator

                                      Please try with tomcat 8.0.44.

                                      Also try leaving this default

                                      <Connector port="80" protocol="HTTP/1.1"

                                                     connectionTimeout="20000"

                                                     redirectPort="8443" />

                                       

                                       

                                      Have you checked browser dev tools for errors when loading Thingworx?

                                        • Re: Thingworx: Status 401 or white screen
                                          atsarev Explorer

                                          I have all the settings equal to that of Anugrah.

                                          I tried HTTP / 1.1 - it did not help.

                                          I had another idea - if I change the password for the twadmin in the file platform-settings.json, then the tomcat will not start.

                                          (Which was specified when the user was created twadmin in PostgreSQL)

                                           

                                          For example, 12345678 or another.

                                           

                                          {

                                          "PersistenceProviderPackageConfigs": {

                                          "PostgresPersistenceProviderPackage": {

                                          "ConnectionInformation": {

                                          "jdbcUrl": "jdbc:postgresql://localhost:5432/thingworx",

                                          "password": "12345678",

                                          "username": "twadmin"

                                          }

                                          }

                                          }

                                          }

                                           

                                          And if I leave "password" by default, it does not start Thingworx.

                                          log:

                                          Снимок4.JPG

                                          If I specify in the platform-settings.json the login and password from tomcat - the error is the same.

                                          What login and password do I need to specify in this file?

                                          Checked on:

                                          Снимок5.JPG

                                            • Re: Thingworx: Status 401 or white screen
                                              polinao Collaborator

                                              Please open your browser developer tools and note your network activity.

                                              • Re: Thingworx: Status 401 or white screen
                                                aadiwilaga Newbie

                                                Hi andrey,

                                                 

                                                just curious how about you edit 'T' letter with Uppercase in the json file:

                                                 

                                                "jdbcUrl": "jdbc:postgresql://localhost:5432/thingworx",

                                                 

                                                to

                                                 

                                                "jdbcUrl": "jdbc:postgresql://localhost:5432/Thingworx",

                                                 

                                                for me it success to make tomcat running stable (it stopping automatically soon after starting, before) the deploy the TWX and i reach white screen now

                                                  • Re: Thingworx: Status 401 or white screen
                                                    atsarev Explorer

                                                    Hi Anugrah             

                                                    Thanks for the advice!
                                                    The letter "T" in the register depends on the name of the database.
                                                    At me it is written with a small letter (thingworx)
                                                    When changing a letter, I have an error in my logs about the fact that there is no such database.
                                                    So it did not help me.

                                                    I do not understand why, when I write the correct login and password in the file "platform-settings.json", the tomcat will not start

                                                      • Re: Thingworx: Status 401 or white screen
                                                        polinao Collaborator

                                                        Likely due to it trying to connect to the db and failing. At this point, I would run the DB cleanup script and then re-run DB Setup and Schema setup scripts. Please ensure no errors occur (ideally, you'll be prompted to enter password during the first setup script and see nothing else, and enter password a couple of times for the second script).

                                                        You may also add this for the license: 7.4 Thingworx does not launch due to license error in Windows

                                                        • Re: Thingworx: Status 401 or white screen
                                                          aadiwilaga Newbie

                                                          Hi Andrey,

                                                           

                                                          firstly, I apologize if my advice leads you to another trouble with tomcat server stopping (it's happened with me when I switch the 'T', tomcat stopped soon after I started, even when I have switched back to original). I get ride the problem with undeploy the thingworx.war, delete the folder ThingworxStorage, and ThingworxBackupStorage (also keysession in folder ThingworxPlatform if using thingworx 8.0). You can start again the tomcat. and then re-deploy the thingworx.war

                                                           

                                                          second, my problem now Solved, and I can open the composer. So I would thanks to you for your answer 'the register depends on the name of the database' , because it reminds me of the database problem (from Ravi answer above, 'Your database is not running or is not installed properly . It's the issue with DB for sure.') and I think this all caused by same problem 'Database'. In my case, I'm using:

                                                          "jdbcUrl": "jdbc:postgresql://localhost:5432/Thingworx",

                                                          an Uppercase T of Thingworx in file platform-settings.json, although my database and my tablespace using lowercase 't'. and everything is working except the result is a white blank screen, it is strange since you must have the consistency between database and platform-settings.json. I remember before that I have trouble when creating the database using the script, i make several attempts with inconsistency database name (Thingworx/thingworx), so I think somehow it must be the culprit, maybe Postgres have some memory reside and I didn't do the database deleting clean.


                                                          so this is my step:

                                                          1. I undeploy the thingworx.war (using Tomcat management or just deleting Thingworx folder and Thingworx.war inside <tomcat path>/webapps).

                                                          2. I delete the database using script:

                                                          thingworxPostgresDBCleanup -h localhost -p 5432 -d thingworx -t thingworx -a postgres -b postgres

                                                             

                                                              (make sure u doing it with administrator, for me using cmd terminal and go to the folder where the .bat file placed)

                                                          3. I modify the <PGDATA>/pg_hba.conf (where <PGDATA>  for me C:\Program Files\PostgreSQL\9.4\data ) so the file is like this :

                                                          # TYPE  DATABASE        USER            ADDRESS                METHOD

                                                           

                                                           

                                                          # IPv4 local connections:

                                                          host    all            all            127.0.0.1/32            trust

                                                          # IPv6 local connections:

                                                          host    all            all            ::1/128                trust

                                                          # Allow replication connections from localhost, by a user with the

                                                          # replication privilege.

                                                          #host    replication    postgres        127.0.0.1/32            md5

                                                          #host    replication    postgres        ::1/128                md5

                                                              (warning this causing security problem since we modify METHOD from md5 to trust, I recommend this step ONLY for testing in isolated machine/network. and please try to switches back to md5 after making sure this step is not the problem cause)

                                                          4. re-creating database

                                                          thingworxpostgresDBSetup -h localhost -p 5432 -d thingworx -t thingworx -a postgres -u twadmin -l C:\ThingworxPostgresqlStorage

                                                             

                                                          5. creating scheme

                                                          thingworxPostgresSchemaSetup -h localhost -p 5432 -d thingworx -s public -u twadmin -o all

                                                          6. put platform-settings.json in the <root>\ThingworxPlatform folder. (after setting to proper configuration)

                                                          7. deploy Thingworx.war

                                                          8. open go to <servername>/Thingworx in a Web browser. hope it works.