Community Tip - Visit the PTCooler (the community lounge) to get to know your fellow community members and check out some of Dale's Friday Humor posts! X
Hi Craig,
I have the same problem even the command on the service.xml file is right. What may be the reason?
Thanks in advance.
localhost_access-log:
0:0:0:0:0:0:0:1 - - [17/Aug/2017:13:08:41 +0300] "GET /favicon.ico HTTP/1.1" 200 21630
0:0:0:0:0:0:0:1 - - [17/Aug/2017:13:08:44 +0300] "GET /Thingworx/Home HTTP/1.1" 401 -
0:0:0:0:0:0:0:1 - - [17/Aug/2017:13:08:44 +0300] "GET /favicon.ico HTTP/1.1" 200 21630
0:0:0:0:0:0:0:1 - - [17/Aug/2017:13:11:06 +0300] "GET /Thingworx/Composer/index.html HTTP/1.1" 401 -
server.xml: (file is attached)
<Connector port="8080" protocol="org.apache.coyote.http11.Http11NioProtocol"
connectionTimeout="20000"
redirectPort="8443" />
Message was edited by: Sushant Pandey branched from Thingworx first install
... reinstalled Tomcat but still the same...
0:0:0:0:0:0:0:1 - - [17/Aug/2017:18:09:44 +0300] "GET / HTTP/1.1" 200 11452
0:0:0:0:0:0:0:1 - admin [17/Aug/2017:18:09:46 +0300] "GET /manager/html HTTP/1.1" 200 14654
0:0:0:0:0:0:0:1 - - [17/Aug/2017:18:09:50 +0300] "GET /Thingworx/ HTTP/1.1" 200 315
0:0:0:0:0:0:0:1 - - [17/Aug/2017:18:09:50 +0300] "GET /Thingworx/Home HTTP/1.1" 401 -
<Connector port="80" protocol="org.apache.coyote.http11.Http11NioProtocol"
connectionTimeout="20000"
redirectPort="8443" />
Hi Ozgur Aslan,
Can you also please share the catalina.log?
Hi Yamini,
catalina.log is attached. Thanks in advance.
Hi Ozgur Aslan,
Thanks for providing the catalina.log. Can you also please share the below screenshot from your local instance:
Go to config Tomcat --> click Java
Thank you!
If you have Java Virtual Machine path as client
then I would suggest you to uninstall the existing Java and download the below highlighted version from Oracle website (http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html) and resinstall Java.
Hope this helps!
Hi Yamini Tella,
If there is no syntax error, I think I copied all lines right.
-Dcatalina.home=C:\Program Files (x86)\Apache Software Foundation\Tomcat 8.5
-Dcatalina.base=C:\Program Files (x86)\Apache Software Foundation\Tomcat 8.5
-Djava.io.tmpdir=C:\Program Files (x86)\Apache Software Foundation\Tomcat 8.5\temp
-Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
-Djava.util.logging.config.file=C:\Program Files (x86)\Apache Software Foundation\Tomcat 8.5\conf\logging.properties
-Dserver -Dd64
-XX:+UseG1GC
-Dfile.encoding=UTF-8
-Djava.library.path=C:\Program Files (x86)\Apache Software Foundation\Tomcat 8.5\webapps\Thingworx\WEB-INF\extensions
Please note that the path will be shown as client if JRE was installed without the JDK. Please uninstall tomcat, download and install JDK 8, then install the tomcat again to have the path automatically populated.
On a side note, it looks like you have 32-bit versions of both Java and Tomcat (atleast from your path). ThingWorx requires 64-bit versions for the both of them; so do install that instead and retry.
*Edit*
From your Catalina log, it looks like your OS is 32-bit Windows 10. ThingWorx requires a 64-bit OS/ architecture, so you would need to use a different server.
Hi All,
Thank you very much for all your support. Current status:
- I have Windows 10 64bit OS
- Uninstalled everything
- Installed jdk8 as Yamini told
- Installed Tomcat 64 bit version
- Installed PostgreSGL
- Deployed Thingworx
Result didn't change. Still trying to run "GET / HTTP/1.1"
Can there be a problem in my license file?
0:0:0:0:0:0:0:1 - - [17/Aug/2017:20:50:58 +0300] "GET / HTTP/1.1" 200 11452
0:0:0:0:0:0:0:1 - - [17/Aug/2017:21:11:56 +0300] "GET /manager/html HTTP/1.1" 401 2536
0:0:0:0:0:0:0:1 - admin [17/Aug/2017:21:12:01 +0300] "GET /manager/html HTTP/1.1" 200 14792
0:0:0:0:0:0:0:1 - admin [17/Aug/2017:21:13:34 +0300] "GET /manager/html HTTP/1.1" 200 14659
0:0:0:0:0:0:0:1 - - [17/Aug/2017:21:13:38 +0300] "GET /Thingworx/Home HTTP/1.1" 401 -
Could you please supply your ApplicationLog found in the ThingworxStorage/logs directory?
The platform is not connecting to your database:
2017-08-17 21:13:26.803+0300 [L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-2] *** Web Application STATE is being set to ERROR! ***
What is your Postgresql version? Have you run the DBsetup and SchemaSetup scripts? To verify, please open pgadmin III and expand your thingworx database to the tables level and see how many were created (should be around 57).
Also please attach your platform-settings.json
Hi Polina,
I'm using PostgreSQL 9.4.13.
Yes I ran DBSetup and SchemaSetup scripts. Please see the 58 tables created.
platform-settings.json file is attached.
Hi Ozgur Aslan,
Please provide full access to the user for /ThingworxPlatform, /ThingworxStorage and /ThingworxPostgrSQLStorage folders.
Hi Yamini,
All folders have full access.
I'm still suspicious about Tomcat - HTTP/1.1.
access log:
0:0:0:0:0:0:0:1 - - [17/Aug/2017:22:31:12 +0300] "GET /Thingworx/Home HTTP/1.1" 401 -
0:0:0:0:0:0:0:1 - - [17/Aug/2017:22:34:51 +0300] "GET /Thingworx/Composer/index.html HTTP/1.1" 401 -
Hi Ozgur Aslan,
Are you able to see the tomcat screen when you key in http://localhost address in the web-browser? If you were able to see that screen then Tomcat has installed successfully.
Also, does the password in platform.settings file match with the twadmin password?
Also, please make sure that you have license.bin file in /ThingworxPlatform folder and set the license path(C:\Program Files\Apache Software Foundation\Tomcat 8.0\webapps\Thingworx\WEB-INF\extensions) to the environment variables as shown below:
Also, verify that the PostgreSQL installtion/bin folder (C:\Program Files\PostgreSQL\9.4\bin) is added to the system path variable..
What if you swap the server.xml for the default one (without changing the protocol to org.apache.coyote.http11.Http11NioProtocol)?
Hi All,
1.Yes I can see even the Tomcat Manager screen.
2. The password in platform.settings file match with the twadmin password.
3. The license.bin file is in /ThingworxPlatform folder
4. The license path is added (C:\Program Files\Apache Software Foundation\Tomcat 8.5\webapps\Thingworx\WEB-INF\extensions) to the environment variables as Yamini told.
5. PostgreSQL installtion/bin folder (C:\Program Files\PostgreSQL\9.4\bin) was already added to the system path variable
6. I swapped the server.xml for the default one (without changing the protocol to org.apache.coyote.http11.Http11NioProtocol) but still the same message in access log.
Actually I'm out of solutions...
Hello,
Some colleagues of mine and I have been facing the same exact issues while trying to install Thingworx. We have done the same troubleshooting as outlined above and no solution has worked.
Hopefully the issue is resolved soon... any other suggestions would be much appreciated!
Have you previously installed another version of postgresql?
We can do a quick webex tomorrow.
Can you include me on the WebEx as well?
Hi Polina,
Yes I installed postgresql 9.4.9-1 for Thingworx 7.4 previously.
For Thingworx 8.0, I uninstalled it and installed 9.4.13-1 now.
A WebEx will be perfect. I'm in Istanbul/Turkey UTC+3:00 time zone. Anytime between10:00-17:00 would be fine. Thanks
You might have traces of an old installation in your system if uninstalled improperly. One way to check is to look for the registry entries. Since this is a new installation and there is no fear of data loss, I would do a clean install. Please refer to this blog on how to clean up your registry and fully remove postgresql. Ensuring PostgreSQL database is fully removed
Hi Polina,
I uninstalled everything and started to install from scratch. I used:
- Java: jdk-8u144-windows-x64.exe
- Tomcat: apache-tomcat-8.5.20.exe
- PostgreSQL: postgresql-9.4.13-1-windows-x64.exe
Tomcat is working, user "twadmin" is created in postgresql and "ThingworxPostgresqlStorage" folder is created with full access. Read only check can't be removed in Windows 10 (I don't know why)
When I want to run thingworxPostgresDBSetup.bat below issues occur:
1. "thingworx" tablespace is created but no thingworx database!
2. An empty "PG_9.4_201409291" folder is created in C:\ThingworxPostgresqlStorage
3. Below error message returns.
Problem solved!
I found out that the path for "ThingworxPostgresqlStorage" folder in the thingworxPostgresDBSetup.bat file needs to be edited according to the used drive (C,D...)
Sure, what timezone are you in?
I am in PST, so it may be hard to coordinate with Ozgur.
It seems like it may be a licensing error on my end...
I can have a separate session with you tomorrow as I'm out of the office right now. In the meantime, if you search the community for "licensing error in Windows", there should be a blog post authored by me. Please try applying that method (specifying the license path as an environment variable in system path *instead* of tomcat Java options).