Skip to main content
1-Visitor
August 22, 2017
Question

where I could find thingworx.war release 8 for training ?

  • August 22, 2017
  • 13 replies
  • 35168 views

Hello

I just want to download the thingworx.war release 8 for training, but I can't find it on the download site. I could find thingworx docker installer, utilities, platform postgress .... but not simply the .war

    13 replies

    5-Regular Member
    August 22, 2017

    Isabelle Missaire​ : The .war file will be inside the ThingWorx Platform .zip file. If you have the platform postgres zip file then unzip it do get the Thingworx.war file.

    -Durgesh

    imissaire1-VisitorAuthor
    1-Visitor
    August 23, 2017

    Thank you Durgesh, Indeed I can find it.

    Another question please, when I deploy it on tomcat application, I had an issue around innaccebility site and I'm wondering if I miss the steps to fill "in the java Options field, type the appropriat java options, as described in the wiki" because I have not found the wiki. (extract from ThingWorx installation prerequisites (for all platforms document).

    So I have not modified tomcat properties java and  I have :

    -Dcatalina.home=C:\Tomcat

    -Dcatalina.base=C:\Tomcat

    -Djava.io.tmpdir=C:\Tomcat\temp

    -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager

    -Djava.util.logging.config.file=C:\Tomcat\conf\logging.properties

    Moreover, I want to use tomcat 8.xx with java 1.7.xx : it is indicated as compatible.

    Apache Tomcat/8.5.201.7.0_09-b05

    thank you for your help

    13-Aquamarine
    August 23, 2017

    http://support.ptc.com/WCMS/files/173115/en/Installing_ThingWorx_8.0_1.3_.pdf

    Please follow Tomcat configuration from the ThingWorx 8 installation guide starting page 5.

    Go to Start->Configure Tomcat->Java Tab

    And add the following lines

    -Dserver -Dd64

    -XX:+UseG1GC

    -Dfile.encoding=UTF-8

    -Djava.library.path=C:\Program Files\Apache Software Foundation\Tomcat 8.0\webapps\Thingworx\WEB-INF\extensions (please make sure you specify your path to the Tomcat->)

    And, we recommend using jdk 1.8 . Please refer to the Thingworx 8 System Requirement document before you proceed with the installation.

    http://support.ptc.com/WCMS/files/173114/en/ThingWorx_Core_8.0_System_Requirements_1.pdf

     

    imissaire1-VisitorAuthor
    1-Visitor
    August 24, 2017

    I added also rights to login and the login is ok now but I have : the database "thingworx" doesn't exist

    imissaire1-VisitorAuthor
    1-Visitor
    August 24, 2017

    and if it is an issue with 9.6, I will fully remove 9.6 and install 9.4 instead. I'am waiting / database thinhworx doesn't exist error

    13-Aquamarine
    August 24, 2017

    You could try deleting "PG_9.####" folder in ThingworxPostgresqlStorage and running the bat files again for the error.

    imissaire1-VisitorAuthor
    1-Visitor
    August 25, 2017

    I have full rights  and always same pb

    13-Aquamarine
    August 25, 2017

    Is your ThingworxPostgresStorage folder empty?

    imissaire1-VisitorAuthor
    1-Visitor
    August 29, 2017

    Hello

    I have installed PostgreSQL 9.4 instead of 9.6

    In the installation guide, I execute the thingworxPostgresDBSetup.bat where I have added "To set up the database and tablespace with a default PostgreSQL installation that has a PostgreSQLdatabase anda PostgreSQLuser name,enter:thingworxpostgresDBSetup –a postgres –u <PostgreSQL user role name>–l C:

    \ThingworxPostgresqlStorage  where <PostgreSQL userrole name>is the user role name that you entered in previous steps.

    -->

    REM Run psql

    psql.exe -q -h %server% -d postgres -U %adminusername% -p %port% -v database=%database% -v tablespace=%tablespace% -v username=%thingworxusername% -v tablespace_location=%tablespace_location% -f ./thingworx-database-setup.sql

    thingworxpostgresDBSetup –a postgres –u adminPGSQL –l C:\ThingworxPostgresqlStorage 

    pause

    but I have an issue about psql.exe :

    Do you know why please ?

    Thank you

    Isabelle

    17-Peridot
    August 29, 2017

    Hi Isabelle,

    Could you please verify that the PostgreSQL installation/bin folder(C:\Program Files\PostgreSQL\9.4\bin) is added to the system path variable.

    imissaire1-VisitorAuthor
    1-Visitor
    August 30, 2017

    Hello, I have updated my installation environement with all your help notes and thank you to everybody.

    but always white page for thingwoarx application

    Application logs indicates : 017-08-30 12:14:28.909+0200 [L: ERROR] [O: c.t.s.a.AuthenticationFilter] [I: ] [U: ] [S: ] [T: http-nio-80-exec-86] Could not handle request

    Thanks

    Isabelle

    17-Peridot
    August 30, 2017

    Hi Isabelle,

    Could you please verify if the platform-settings.json file has the correct password (password created in the pgadmin3 tool) for the twadmin user.

    imissaire1-VisitorAuthor
    1-Visitor
    August 30, 2017

    I have "password": "password", in the file and I set this password agin in pgadmin for twadmin. I stop the application thingworx in tomcat, then I start it again and always nothing. I join traces : last sotp 15h22 : 0-Aug-2017 15:22:03.104 INFOS [http-nio-80-exec-84] org.apache.catalina.util.LifecycleBase.stop The stop() method was called on component [StandardEngine[Catalina].StandardHost[localhost].StandardContext[/Thingworx]] after stop() had already been called. The second call will be ignored.

    and application.logs

    Thank you

    imissaire1-VisitorAuthor
    1-Visitor
    August 30, 2017

    I have not twadmin like you but my adminPGSQL, created during installation : page 10, 3-b :

    b.Select NewObject>New Login Role. On the Propertiestab, in theRole namefield, enter the <PostgreSQL user role name>for PostgreSQL administration

    I have modifed the platform-settings.json : "username": "adminPGSQL" ... but same thing

    How can I change the thingworx in pgadmin to put twadmin like you ? bes=cause I use this adminPGSQL in . DBsetup and Schemasetup . bat

    and why create the 3-b ?

    imissaire1-VisitorAuthor
    1-Visitor
    August 30, 2017

    I have "2017-08-30 16:56:09 CEST FATAL:  authentification par mot de passe échouée pour l'utilisateur  « twadmin »"

    --> 2 admin twadmin configured and my adminPGSQL created as asked by the installation but I think we don't need it ?

    13-Aquamarine
    August 30, 2017

    Yes , you don't need it, just keep the postgres and twadmin users. Give the twadmin credentials in platform-settings.json.

    13-Aquamarine
    August 30, 2017

    Did you make any changes to the thingworxPostgresDBSetup.bat file?  Can you share the first few line from your bat file?

    SET server=localhost

    SET port=5432

    SET database=thingworx

    SET tablespace=thingworx

    SET tablespace_location=C:\ThingworxPostgresqlStorage

    SET adminusername=postgres

    SET thingworxusername=twadmin

    imissaire1-VisitorAuthor
    1-Visitor
    August 30, 2017

    SO I have delete the table thingworx in pgadmin, my user adminPGSQL, I have modify again . bat and settings, and I have launch .bat

    imissaire1-VisitorAuthor
    1-Visitor
    August 30, 2017

    and I have also put password for posgress password to launch .bat

    imissaire1-VisitorAuthor
    1-Visitor
    August 30, 2017

    WhenI have installed Postgress, I have chossen a password, and it is not password as for postgres and twadmin. Is is the problem:

    017-08-30 17:24:58 CEST FATAL:  authentification par mot de passe échouée pour l'utilisateur  « twadmin »

    2017-08-30 17:24:58 CEST DÉTAIL:  La connexion correspond à la ligne 80 du pg_hba.conf : « host    all             all             127.0.0.1/32            md5 »

    13-Aquamarine
    August 30, 2017

    Yes, When you install Postgres, you will be prompted to enter the password. This is the password for the postgres user .You need to give that password when you run the thingworxPostgresDBSetup.bat .

    And when you run the thingworxPostgresSchemaSetup.bat , you will be prompted to enter the password of twadmin. So here , you need to enter the password you gave while creating twadmin in the pgAdmin tool.

    imissaire1-VisitorAuthor
    1-Visitor
    August 30, 2017

    - I have update my platform-settings.json with only the postgres persistence provider package

    - I didn't create twadmin (neither postgres), it was already created. I updated rights to all for both.

    Always the same error : 2017-08-30 18:39:45.896+0200 [L: ERROR] [O: c.t.s.a.AuthenticationFilter] [I: ] [U: ] [S: ] [T: http-nio-80-exec-142] Could not handle request

    and :

    2017-08-30 18:39:27 CEST FATAL:  authentification par mot de passe échouée pour l'utilisateur  « twadmin »

    2017-08-30 18:39:27 CEST DÉTAIL:  La connexion correspond à la ligne 80 du pg_hba.conf : « host    all            all            127.0.0.1/32            md5 »

    it is very difficult to install such application

    13-Aquamarine
    August 30, 2017

    Hi Isabelle,

    I'm sorry that you are facing all these issues .

    1) Could you please try removing the MSSql Persistence Provider package too, from the platform-settings.json?

    2) Then run the thingworxPostgresDBCleanup script file.

    3) Now delete the PG_9.4 folder in your ThingworxPostgresqlStorage .

    4) And finally run the thingworxPostgresDBSetup.bat . Let me know if the thingworx database gets created.