Skip to main content
A
achaube1-Visitor
1-Visitor
August 17, 2017
Solved

Thingworx platform postgreSQL 8.0.2 installation

  • August 17, 2017
  • 3 replies
  • 2819 views

Hello ,

I have installed Thingworx 8.0.2 as per the installation guide and used psotgresql database but while launching the application i am getting a white screen ,below is the attached application logs .

can any body guide for a solution for the same.

I have given all the necessary permission to the thingworx storage folders adn also verfied the postgresql tables as suggested in some of the post on the community .

Kind Regards,

Amar.

Best answer by posipova

[I: ] [U: SuperUser] [S: ] [T: http-nio-8080-exec-9] [message: Connections could not be acquired from the underlying database!]

Indicates your platform cannot speak to the database. What is your Postgresql version? How many tables were created?

Could you please attach your platform-settings.json?

3 replies

P
posipova20-TurquoiseAnswer
20-Turquoise
August 17, 2017

[I: ] [U: SuperUser] [S: ] [T: http-nio-8080-exec-9] [message: Connections could not be acquired from the underlying database!]

Indicates your platform cannot speak to the database. What is your Postgresql version? How many tables were created?

Could you please attach your platform-settings.json?

J
jdass13-Aquamarine
13-Aquamarine
August 17, 2017

Also , check if the location of ThingworxStorage and ThingworxBackupStorage has been moved from the default location C:\ . If so, then the location needs to be mentioned in the platfom-settings.json file . For example:

"PlatformSettingsConfig": {

  "BasicSettings": {

   "BackupStorage": "D:\\ThingworxBackupStorage",

   "Storage": "D:\\ThingworxStorage"

  }

},

A
achaube1-VisitorAuthor
1-Visitor
August 18, 2017

Hello ,

        Thanks for replying .

1.My PostgreSQL version is 9.4 attaching the screenshots for the same in below attached file .

2.About the platform.settings i have tried changing the password with 'password ' and with 'admin1234' which is my postgres password while installing PostgreSQL

3.The location of my Thingworx storage and ThingworxbackupStorage is same which is in C:\ ,but i have installed PostgreSQL in another drive and also specified the location in the environment variable 'THINGWORX_PLATFROM_SETTINGS'.

Kind Regards ,

Amar.

P
posipova20-Turquoise
20-Turquoise
August 18, 2017

If you open your browser developer tools, can you see if there are any errors in the network activity when trying to load ThingWorx? The environment variable should specify the ThingworxPlatform folder location

A
achaube1-VisitorAuthor
1-Visitor
August 18, 2017

Hello ,

          When i changed my Password in platform.settings.json to twadmin password and it sloved the error.

Thanks for all your help .

Kind Regards,

Amar.

Terms & ConditionsAccessibility statement