Thingworx Platform Server 9.5: root_entity_collection doesnot exist

[AA_10925426]

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 

Also am able to query root_entity_collection table:

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

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 ?

[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

[vnamboodheri]

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.