cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

While updating Thingworx from 7.1 to 7.3, got error when executing sh thingworxPostgresSchemaUpdate7.1-to-7.2.sh

SOLVED
Highlighted
Level 1

While updating Thingworx from 7.1 to 7.3, got error when executing sh thingworxPostgresSchemaUpdate7.1-to-7.2.sh

Error while executing sh thingworxPostgresSchemaUpdate7.1-to-7.2.sh:-

psql:./thingworx-update-model-data-7.1-to-7.2.sql:7: ERROR:  duplicate key value violates unique constraint "user_model_properties_pkey"

Kindly update if someone get the same error.

1 ACCEPTED SOLUTION

Accepted Solutions

Re: While updating Thingworx from 7.1 to 7.3, got error when executing sh thingworxPostgresSchemaUpdate7.1-to-7.2.sh

Have you downloaded the latest 7.2 version?  This seems like an issue in which "#" were placed in user names.

Try running the following query in pgadmin/psql - DELETE FROM user_model_properties WHERE entity_name LIKE '%#User

2 REPLIES 2

Re: While updating Thingworx from 7.1 to 7.3, got error when executing sh thingworxPostgresSchemaUpdate7.1-to-7.2.sh

Have you downloaded the latest 7.2 version?  This seems like an issue in which "#" were placed in user names.

Try running the following query in pgadmin/psql - DELETE FROM user_model_properties WHERE entity_name LIKE '%#User

Re: While updating Thingworx from 7.1 to 7.3, got error when executing sh thingworxPostgresSchemaUpdate7.1-to-7.2.sh

Hi polina this has been worked... Thanks a lot