Re: Installing thingowrx 6.5 - HTTP Status 500 Jav...

spatel-21 · ‎Aug 03, 2016

Hello,

While installing thingworx with postgres, I'm getting HTTP status 500 error. I tried going through application logs, it says some issue with password.

I've modified the 'modelproviderconfig.json' file with necessary changes.

Username : defaultValue - thingowrx changed to : twadmin

Password : defaultValue was not there so added it.

ThingworxPlatform and postgres both are in same drive.

PS : I've attached the application log.

mhollenbach · ‎Aug 03, 2016

Siddharth,

The error about the password is probably just a side effect of the first few errors, but make sure that the fieldDefinition for the "password" field is of "baseType" PASSWORD.

It appears thought that you are not able to create a connection with the underlying database.

2016-08-03 14:12:04.698+0530 [L: ERROR] [O: c.t.p.p.PostgresModelExceptionTranslator] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-2] [message: Connections could not be acquired from the underlying database!]

2016-08-03 14:12:04.721+0530 [L: ERROR] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-2] [message: Connections could not be acquired from the underlying database!]

2016-08-03 14:12:04.735+0530 [L: ERROR] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-2] [message: Unable to initialize and start system: Connections could not be acquired from the underlying database!]

Make sure that the jdbcUrl is accurately pointing to the port you are hosting the PostgreSQL DB at. I would also just double check that your PostgreSQL DB is running and there are no issues there.

Meghan

spatel-21 · ‎Aug 03, 2016

Hi Meghan,

Thanks for your reply.

jdbcUrl : "jdbc:postgresql://localhost:5432/thingworx?currentSchema=mySchema"

Yes postgres is running at port 5432

postgres details:

db name : thingworx

schema ; mySchema

tablespace : pg_default

owner : twadmin

- Siddharth

spatel-21 · ‎Aug 04, 2016

Hi Meghan,

I did reinstallation after that I'm new error.

ERROR: relation "root_entity_collection" does not exist

I've asked another question for that.

ERROR: relation "root_entity_collection" does not exist : Installing 6.6

Can you please take a look?

Best Regards

Siddharth

SajidPatel · ‎Aug 03, 2016

Your issue may be similar to -- Thingworx 6.6 PostgreSQL connection error

spatel-21 · ‎Aug 04, 2016

Hi Sajid,

I did reinstallation as per changes mentioned in this link after that I'm new error.