Skip to main content
A
AA_109254261-Visitor
1-Visitor
June 7, 2024
Solved

Thingworx Platform Server 9.5: root_entity_collection doesnot exist

  • June 7, 2024
  • 2 replies
  • 866 views

I am configuring Thingworx 9.5 in our linux box.

I have created twx_db database using the thingworxPostgresDBSetup.sh and thingworxPostgresSchemaSetup.sh. Databases are created successfully. And have used twx_web as the user for this database.

 

Am able to connect to this database using 

 

AA_10925426_0-1717747492355.png

 

Also am able to query root_entity_collection table:

AA_10925426_1-1717747562391.png

 

 

But when I start my thingworx server, with below configuration.

AA_10925426_2-1717747793947.png

 

But I get the error :

 

2024-06-07 07:40:16.522+0000 [L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: SuperUser] [S: ] [P: twx0] [T: main] Configuration setting ContentTypeSettings.supportedMediaEntityContentTypes cannot be null
2024-06-07 07:40:21.945+0000 [L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: SuperUser] [S: ] [P: twx0] [T: main] ERROR: relation "root_entity_collection" does not exist_ Position: 24
2024-06-07 07:40:21.945+0000 [L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: SuperUser] [S: ] [P: twx0] [T: main] !!!!! Error loading model
2024-06-07 07:40:21.961+0000 [L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: SuperUser] [S: ] [P: twx0] [T: main] *** CRITICAL ERROR ON STARTUP: ERROR: relation "root_entity_collection" does not exist_ Position: 24
2024-06-07 07:40:21.961+0000 [L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: SuperUser] [S: ] [P: twx0] [T: main] *** Web Application STATE is being set to ERROR! ***

 

What am I missing here ?

Best answer by Rocko

Are you connecting to the right database (dev1pgtwx_web vs dev1pgtwx)?

Could also be a namespace thing with RDS. Try to remove currentschema, or put it as a default to the user in PG.

 

There are also multiple articles on PTC support and in the community on "relation root_entity_collection does not exist":

https://www.ptc.com/en/support/article/CS324004

https://www.ptc.com/en/support/article/CS223903

https://www.ptc.com/en/support/article/CS230085

 

https://community.ptc.com/t5/ThingWorx-Developers/Installing-Thingworx-6-6-Error-relation-quot-root-entity/m-p/520176#M15528%3Fsource=search

https://community.ptc.com/t5/ThingWorx-Developers/Postgres-Error-root-entity-collection-does-not-exist/m-p/522400#M17333%3Fsource=search

 

2 replies

Rocko
Rocko19-TanzaniteAnswer
19-Tanzanite
June 7, 2024

Are you connecting to the right database (dev1pgtwx_web vs dev1pgtwx)?

Could also be a namespace thing with RDS. Try to remove currentschema, or put it as a default to the user in PG.

 

There are also multiple articles on PTC support and in the community on "relation root_entity_collection does not exist":

https://www.ptc.com/en/support/article/CS324004

https://www.ptc.com/en/support/article/CS223903

https://www.ptc.com/en/support/article/CS230085

 

https://community.ptc.com/t5/ThingWorx-Developers/Installing-Thingworx-6-6-Error-relation-quot-root-entity/m-p/520176#M15528%3Fsource=search

https://community.ptc.com/t5/ThingWorx-Developers/Postgres-Error-root-entity-collection-does-not-exist/m-p/522400#M17333%3Fsource=search

 

V
vnamboodheriCommunity Manager
Community Moderator
June 13, 2024

Hi @AA_10925426, 

I wanted to let you know that there is response to your topic.

If you are in a position to respond to this question, that would be great. It will help you to get answer to your question.

Or if it answers your question, please mark it as "accepted solution". This will surely help other users who may have a similar question.

Thanks for using the PTC Community,

Regards,

Community Moderation Team.

Terms & ConditionsCookie settingsAccessibility statement