Skip to main content
1-Visitor
August 3, 2016
Question

Installing thingowrx 6.6 - HTTP Status 500 Java null pointer exception

  • August 3, 2016
  • 2 replies
  • 2914 views

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.

2 replies

5-Regular Member
August 3, 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-211-VisitorAuthor
1-Visitor
August 3, 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

12-Amethyst
August 3, 2016

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

spatel-211-VisitorAuthor
1-Visitor
August 4, 2016

Hi Sajid,

I did reinstallation  as per changes mentioned in this link 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

Best Regards

Siddharth