If you have any other Administrator user then you can reset the Password using that user.
If you have setup Organization and Administrator is part of it then you can use reset password option there to reset the Password.
If none of the above is true then we can check with R&D for changes in Database (Only for Postgresql DB) (not preferred as PTC does not support changes to the Database directly).
For Administrator password only with Thingworx Postgresql - Yes there is a way to reset.
Though this is not officially recommended by ThingWorx, this should work (like a hack) in resetting the password. Follow the below steps:
Step-1: In a temporary postgresql server, deploy thingworx database using the thingworx Install scripts (provided in the distribution package). This would create a database with default user-passwords. Now, you can take a backup of user_model table (pgadmin would be easy for a specific table backup). Modify the backup sql file - if needed you can delete the COPY commands for 'System' and 'SuperUser' rows. Save the file.
Step-2: If you have access to the actual Postgresql database server, you can navigate through 'thingworx' database -> user_model table and delete a row with name as 'administrator' (make sure to use a sql query to delete the row). And now import/restore the sql file obtained in step-1. This would add a row in 'user_model' table with default Administrator user and password.
Let me know if that works.
Hi Ankit Gupta i have recovered that project as we have backup but i have tried the api process also.
When i try to send post request to admin user it requires authentication of admin.
So, this won't work if we don't have extra admin user.