Community Tip - Need to share some code when posting a question or reply? Make sure to use the "Insert code sample" menu option. Learn more! X
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.
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
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