Skip to main content
T
tyadav1-Visitor
1-Visitor
October 29, 2017
Solved

Unable to start ThingWorx composer

  • October 29, 2017
  • 3 replies
  • 21420 views

Hi,

I am installing the Thingworx 8.1 following the instructions provided in the installation guide and I am unable to run the Thingworx composer. Based on the feedback from previous discussions here, I even downgraded the Tomcat to version8.0.33 but still I am not able to run Thingworx.

During the Tomcat installation, I have kept the port number as 80 (as suggested in the manual) and the Thingworx.war file is copied and pasted in the webapps folder of Tomcat.

Any suggestions on how can I proceed further with the installation and get the Thingworx composer up and running?

Thanks!

               Just for further info, I have reinstalled the Tomcat version with Tomcat 8.0.44 (as stated in the manual) and I am keeping the Tomcat port as 8080 and it is working as I did a localhost:8080 check, however I am still unable to launch the Thingworx. even when I tried launching it as localhost:8080/Thingworx.

The Jre version which I am using is jre1.8.0_151

Please see the attached pictures for more details and just for the convenience I am also attaching the Tomcat logs and Thingworx logs.

Thanks!

Best answer by visla

Hello everyone!

Just to close this thread:

- Tushar created Case 13908122

- During a WebEx we have reviewed his installation:

# Fresh new ThingWorx 8.1 installation with MSSQL

Using a simplified version of platform-settings.json was showing errors in ApplicationLog related to system_version and system_ownership --> something was wrong with database configuration.

As it is a new installation, we cleaned up the thingworx database and schema to create it from scratch following the documentation.

Additionally, while having Tomcat stopped, we removed Thingworx.war, we deleted ThingWorxStorage and <tomcat install_dir>/webapps/thingworx to also start from scratch the ThingWorx installation. We placed the downloaded Thingworx.war under <tomcat install_dir>/webapps and the downloaded platform-settings.json under /ThingWorx/Platform (with modified db user and password).

Starting again Tomcat worked, ThingWorx could startup... but then we were facing License Issues that we could solve following the KCS Articles:

https://www.ptc.com/en/support/article?n=CS271439

https://www.ptc.com/en/support/article?n=CS274132

Finally, ThingWorx started up and Tushar could log in

Good luck in your Master Thesis, Tushar!

Best Regards,

Vanessa

3 replies

S
supandey5-Regular Member
5-Regular Member
October 30, 2017

Hi Tushar, the issue appears to be with the persistence provider. Are you using MsSQL? If yes could you check if the platform-settings.json is correctly configured with right instance / username & password?

This is noted in the application log  [message: Failed to create com.thingworx.persistence.mssql.MssqlPersistenceProviderPackage.  Cause was due to 'null']

T
tyadav1-VisitorAuthor
1-Visitor
October 30, 2017

Hi Sushant Pandey

Do you mean the highlighted portion in the platform-settings.json file? I am using the username and pw for the 'sa' acccount for the MsSQL server 2016.

UPDATE. Hi Sushant Pandey

I after rechecking the steps from the guide, I found out that my JDBC jar file was not in the Tomcat\lib folder, which I corrected. Now I am able to see a blank screen but still can't see the Thingworx composer loading in. Please find the screenshot in the attachment. I am also attaching the application log and tomcat log file for your reference.

T
tyadav1-VisitorAuthor
1-Visitor
October 30, 2017

Hi Sushant Pandey​

Do you mean the highlighted portion in the platform-settings.json file? I am using the username and pw for the 'sa' acccount for the MsSQL server 2016.

UPDATE. Hi Sushant Pandey​

I after rechecking the steps from the guide, I found out that my JDBC jar file was not in the Tomcat\lib folder, which I corrected. Now I am able to see a blank screen but still can't see the Thingworx composer loading in. Please find the screenshot in the attachment. I am also attaching the application log and tomcat log file for your reference.

TW_4.png

P
posipova20-Turquoise
20-Turquoise
October 30, 2017

2017-10-30 20:53:06.411+0100 [L: ERROR] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] [message: Connections could not be acquired from the underlying database!]

Please reformat your  platform-settings.json file to match the following (with the licensing string per the 8.1 installation guide at the end):

{

"PersistenceProviderPackageConfigs": {

"MssqlPersistenceProviderPackage": {

"ConnectionInformation": {

    "driverClass": "com.microsoft.sqlserver.jdbc.SQLServerDriver",

"jdbcUrl": "jdbc:sqlserver://localhost:1433;databaseName=thingworx;applicationName=Thingworx;",

"password": "ts",

"username": "twadmin"

}

}

}

}

T
tyadav1-VisitorAuthor
1-Visitor
October 31, 2017

Hi Polina,

Thanks for your reply. As per your suggestion, I have tried incorporating your code in the platform-settings.json file but unfortunately it is not working. I tried various ways by formatting and reformatting the json file (once with only the persistance package block, the next time with the entire settings given in the installation guide pdf alongwith the licenscing settings etc. but unfortunately, nothing works)., at some instances I was getting the blank screen like before, whereas at others I was getting a 404 error.

I have installed the ThingworxPlatform folder in the same drive where Tomcat is installed (following the instruction in the guide, which said 'root' where Tomcat was installed)

Maybe I am not writing/formatting something in the correct way as I am pretty new to programming and Thingworx in particular, so it would be a great help if you could give a sample of how the basic(operational) final platform-settings.json file should look like so I can made the relevant changes and get the platform going on.

Again for your reference, I am attaching the Application and Catalina logs.

Thanks!

V
visla14-AlexandriteAnswer
14-Alexandrite
December 1, 2017

Hello everyone!

Just to close this thread:

- Tushar created Case 13908122

- During a WebEx we have reviewed his installation:

# Fresh new ThingWorx 8.1 installation with MSSQL

Using a simplified version of platform-settings.json was showing errors in ApplicationLog related to system_version and system_ownership --> something was wrong with database configuration.

As it is a new installation, we cleaned up the thingworx database and schema to create it from scratch following the documentation.

Additionally, while having Tomcat stopped, we removed Thingworx.war, we deleted ThingWorxStorage and <tomcat install_dir>/webapps/thingworx to also start from scratch the ThingWorx installation. We placed the downloaded Thingworx.war under <tomcat install_dir>/webapps and the downloaded platform-settings.json under /ThingWorx/Platform (with modified db user and password).

Starting again Tomcat worked, ThingWorx could startup... but then we were facing License Issues that we could solve following the KCS Articles:

https://www.ptc.com/en/support/article?n=CS271439

https://www.ptc.com/en/support/article?n=CS274132

Finally, ThingWorx started up and Tushar could log in

Good luck in your Master Thesis, Tushar!

Best Regards,

Vanessa

    P
    posipova20-Turquoise
    20-Turquoise
    December 1, 2017

    Great job! Thank you for updating the thread.

    Terms & ConditionsCookie settingsAccessibility statement