cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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

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

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

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

thingworxPostgresDBsetup.bat file creates thingworx database and tablespace. So no need of creating them manually. Please let me know if they are not created automatically after running those .bat files.

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

Thanks Yamini but I can't run those .bat files, I begin with the :

- thingworxPostgresDBSetup.bat :

-- I have give all rights to twadmin, see image joined,

-- I have add the line with twadmin in the .bat :

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 twadmin –l C:\ThingworxPostgresqlStorage

pause

See file joined

-- and I obtained password authenticatin erro, see file joined at the execution

thanks for your help

Isabelle

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

Hi Isabelle,

Please make sure that you are using the postgres super-user password (created while installing PostgreSQL) when prompted to enter the password. To find the postgres user password:

  • Open the pgadmin3 tool
  • Click on the Login Roles
  • Select postgres user and view the password you have set for this user.

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

ok it is better indeed but issue for DB doesn't exist

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

Here are the steps I need you to follow:

  • Please run the thingworxPostgresDBCleanup script file.
  • Delete thingworx tablespace, if it exists.
  • Run the DBsetup and schemaSetup files.

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

run the thingworxPostgresDBCleanup script file. : the DB thingwors doesn't exist

The thingworx tablespace doesn't exist

Run the DBsetup : same thing

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

Try updating the Tablespace Location value in the PostgresDBSetup.bat file to the corresponding location. For example, if you've created directory in C drive then update it as C:\ThingworxPostgresqlStorage .

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

Also ensure the ThingworxPostgresStorage folder has permission set to Full control.