Skip to main content
P
PG_CG8-Gravel
8-Gravel
August 25, 2025
Solved

ThingWorx Upgrade from 9.6.1 to 9.7,2

  • August 25, 2025
  • 2 replies
  • 779 views

Getting below error:

2025-08-25 13:35:43.313+0000 [L: ERROR] [O: c.t.p.m.PrincipalMigrator] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] ERROR: permission denied for table group_members_model
2025-08-25 13:35:43.314+0000 [L: ERROR] [O: c.t.p.m.PrincipalMigrator] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] org.postgresql.util.PSQLException: ERROR: permission denied for table group_members_model

 

I had executed update_postgres.sh.

Best answer by Rocko

Wrong user used for DB connection, or the tables were initially created with a different user. Check table ownership.

2 replies

Rocko
Rocko19-TanzaniteAnswer
19-Tanzanite
August 26, 2025

Wrong user used for DB connection, or the tables were initially created with a different user. Check table ownership.

    C
    CharlesJiCommunity Manager
    Support
    September 2, 2025

    Hi @PG_CG,

    It appears there is a response that answers your question. For the benefit of other Community Members who may have the same question, it would be great if you could designate it as the Accepted Solution.

    In the event that this response did not answer your question, please post your current status so that we can continue to support.

    Thanks for using the PTC Community!

    Regards,
    Charles

    Terms & ConditionsAccessibility statement