Community Tip - You can Bookmark boards, posts or articles that you'd like to access again easily! X
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
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/"?
Which logs you are talking about as my Directory Structure looks like below:
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.
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"
}
}
}
}
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?
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.
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.
Yep, The directory structure is correct, please refer application logs that may help you identify the issue,Also environment variables are set correctly
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.
tried ,That didn't help
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.
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:
I have used the GUI installer for PostgresSql downloaded from https://oscg-downloads.s3.amazonaws.com/packages/PostgreSQL-9.4.14-1-win64-