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

Unable To Start thingworx 8.0

Highlighted

Unable To Start thingworx 8.0

Hello All, i have setup thing worx 8.0.1 on my local machine with pstgre 9.4.14, but I am having below application logs

2017-10-09 15:20:43.611+0530 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Managers...INITIALIZED

2017-10-09 15:20:43.614+0530 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Database initialization started...

2017-10-09 15:20:43.966+0530 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] System ownership locking started...

2017-10-09 15:20:44.024+0530 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] System ownership locking complete

2017-10-09 15:20:44.204+0530 [L: INFO] [O: c.t.p.p.d.PostgresModelDao] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Fetch Size Set - [5000]

2017-10-09 15:20:45.441+0530 [L: INFO] [O: c.t.c.Import] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] *** Importing entities

2017-10-09 15:20:45.527+0530 [L: INFO] [O: c.t.c.Import] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] *** Importing ModelTags

2017-10-09 15:20:45.528+0530 [L: INFO] [O: c.t.c.Import] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] *** Importing DataTags

2017-10-09 15:20:45.529+0530 [L: INFO] [O: c.t.c.Import] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] *** Importing Groups

2017-10-09 15:20:45.535+0530 [L: INFO] [O: c.t.c.Import] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] *** Importing Organizations

2017-10-09 15:20:45.738+0530 [L: ERROR] [O: c.t.c.Import] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Unable to process import

2017-10-09 15:20:45.763+0530 [L: ERROR] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] [message: Unable to decode avatar content: Can't create cache file!]

2017-10-09 15:20:45.770+0530 [L: INFO] [O: c.t.p.p.PersistenceProvider] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Connection ThingworxPersistenceProvider, type PostgresPersistenceProviderPackage stopped

2017-10-09 15:20:45.787+0530 [L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] [message: Unable to initialize and start system: Unable to decode avatar content: Can't create cache file!]

2017-10-09 15:20:45.788+0530 [L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] *** Web Application STATE is being set to ERROR! ***

2017-10-09 15:21:14.432+0530 [L: ERROR] [O: c.t.s.a.AuthenticationFilter] [I: ] [U: ] [S: ] [T: http-nio-8080-exec-1] Could not handle request

2017-10-09 15:30:30.398+0530 [L: ERROR] [O: c.t.s.a.AuthenticationFilter] [I: ] [U: ] [S: ] [T: http-nio-8080-exec-6] Could not handle request

13 REPLIES 13
Highlighted

Re: Unable To Start thingworx 8.0

Hi Shubham,

Is this the fresh installation or are you upgrading it to the 8.0.1 version?

Could you please share the PostgreSQL logs present in "<postgresql default-directory>/9.4/data/pg_log/"?

Highlighted

Re: Unable To Start thingworx 8.0

Which logs you are talking about as my Directory Structure looks like below:

Capture.PNGCapture1.PNG

Highlighted

Re: Unable To Start thingworx 8.0

Could you please open up pg admin III, go in the thingworx database and expand until you can see the number of tables created? How many are there?

Also, have you set full permissions on the ThingworxPostgresqlStorage and ThingworxPlatform folders?

Please attach your platform-settings.json.

Highlighted

Re: Unable To Start thingworx 8.0

Polina Osipova​ total number of tables are 58 , i have specified all the required permissions below is my platform.json file

{

"PersistenceProviderPackageConfigs": {

"PostgresPersistenceProviderPackage": {

"ConnectionInformation": {

"jdbcUrl": "jdbc:postgresql://localhost:5432/thingworx",

"password": "twadmin",

"username": "twadmin"

}

}

}

}

Highlighted

Re: Unable To Start thingworx 8.0

Just to make sure, this should be set to Full Control for both folders:

Is the password in the settings file correct? How did you deploy the Thingworx.war file, did you drop it in the webapps folder or uploaded through the browser?

Have you installed any other versions of postgresql on the same machine, previously?

Highlighted

Re: Unable To Start thingworx 8.0

Yes The Password in setting file are correct,Permissions are all OK, I deployed  war file by dropping in webapps folder.

No other version of PostgreSQL is there on machine, neither did I install any earlier.

Highlighted

Re: Unable To Start thingworx 8.0

What is your directory structure? ThingworxPlatform ThingworxPostgresqlStorage both need to be in the root of the same drive where Tomcat is installed, unless specified otherwise in the environment variables - which you also need to specify the Postgresql/bin path in.

Highlighted

Re: Unable To Start thingworx 8.0

Yep, The directory structure is correct, please refer application logs that may help you identify the issue,Also environment variables are set correctlyCapture.PNG

Highlighted

Re: Unable To Start thingworx 8.0

The case registries might be an issue here. The folder has to be called ThingworxPostgresqlStorage. At this point, I would delete this folder, create  a new one with a proper name, run the cleanup script and then run the twi setup scripts again.

Highlighted

Re: Unable To Start thingworx 8.0

tried ,That didn't help

Highlighted

Re: Unable To Start thingworx 8.0

Hello,

 

I know it's late for answers, but it may help others who are looking for this issue - it is frequently caused by old files in Tomcat's cache. So try to follow those steps:

1. Shutdown Tomcat

2. Remove ThingworxStorage and clean folders: work and temp from %TOMCAT_HOME%.

3. Start Tomcat.

 

Hope it helps anyone.

BR,

JK.

Highlighted

Re: Unable To Start thingworx 8.0

Hi Shubham,

Can you please explain or provide the steps you have followed to install PostgreSQL? By default when we install PostgreSQL the directory structure looks as follows:

Highlighted

Re: Unable To Start thingworx 8.0

I have used the GUI installer for PostgresSql downloaded from https://oscg-downloads.s3.amazonaws.com/packages/PostgreSQL-9.4.14-1-win64-

Announcements

Thingworx Navigate content has a new home! Click here to access the new Thingworx Navigate forum!