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

Community Tip - Visit the PTCooler (the community lounge) to get to know your fellow community members and check out some of Dale's Friday Humor posts! X

Installing thingowrx 6.6 - HTTP Status 500 Java null pointer exception

spatel-21
1-Visitor

Installing thingowrx 6.6 - HTTP Status 500 Java null pointer exception

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.

5 REPLIES 5

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

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

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

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

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

Announcements


Top Tags