Issue while connecting to Thingworx 6.5

I installed Thingworx 6.5 as per the installation document. However, when I start Tomcat after deploying the war file, I get the following error

"com.thingworx.common.exceptions.ModelAccessException: ERROR: relation "root_entity_collection" does not exist Position: 24"

I saw some posts related to the same and I corrected the postgresql.conf file as well

I also ensured that the thingworx folders are in the root folder (C Drive) with all access.

I also ensured that the modelproviderconfig.json is configured properly (the password is the same in the database as well in the json file)

I have attached my catalina and thingworx logs as well. Please let me know what could be the issue here.

5-Regular Member

Sriram, can you try running the schema scripts again? Do you have a thingworx database and tablespace?

Author

1-Visitor

I'll try running the schema. Yes, I verified that the Database and the tables are created.

5-Regular Member

Can you try deploying a different version of ThingWorx? Is this the base 6.5 version or is it a specific patch? (6.5.1, 6.5.2 etc)

Sign up