Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. X
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.
Solved! Go to Solution.
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
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
Hi polina this has been worked... Thanks a lot