14 Replies Latest reply on Nov 15, 2017 2:53 AM by tyadav RSS
    tyadav Newbie

    Unable to start ThingWorx composer

    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!

      • Re: Unable to start ThingWorx composer
        supandey Collaborator

        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']

        • Re: Unable to start ThingWorx composer
          tyadav Newbie

          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

            • Re: Unable to start ThingWorx composer
              polinao Ninja

              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"

              }

              }

              }

              }

                • Re: Unable to start ThingWorx composer
                  tyadav Newbie

                  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!

                    • Re: Unable to start ThingWorx composer
                      jdass Apprentice

                      Hi Tushar ,

                       

                      This is the basic format of platform-settings.json for Thingworx 8.1

                       

                      {
                      "PersistenceProviderPackageConfigs": {
                        "MssqlPersistenceProviderPackage": {
                         "ConnectionInformation": {
                          "driverClass": "com.microsoft.sqlserver.jdbc.SQLServerDriver",
                          "jdbcUrl": "jdbc:sqlserver://localhost:1433;databaseName=thingworx;applicationName=Thingworx;",
                          "password": "*******",
                          "username": "twadmin"
                         }
                        }
                      },
                      "PlatformSettingsConfig": {
                        "LicensingConnectionSettings": {
                         "username": "*******",
                         "password": "*******",
                         "activationIds": "########,########,########"

                        }
                      }
                      }

                        • Re: Unable to start ThingWorx composer
                          tyadav Newbie

                          Hi Janet,

                           

                          Thanks for letting me know the correct format for the platform-settings.json file (I was trying in the similar format earlier).

                           

                          Unfortunately, I am still not able to launch the Thingworx composer. The application log points out an error that 'Could not handle request' However when I further added the stream processor settings etc. in the file, it started displaying the HTTP status 404 error citing the resources are not available.

                           

                          Any idea what might be causing this and how to resolve this?

                           

                          I am attaching the application log as well for your reference as well as the two screenshots at various instances

                           

                          Thanks!