ERROR 401

[rkrick]

dears,

We have recently set up a PTC Thingworx instance on an Azure VM.

Since this morning we cannot access the platform anymore.

in a previous post, I found we might be able to solve this by using a backup of the database (we are using an H2 database) and put it in C:\ThingworxStorage\database. 

however, the backup is from 5 days ago, which means we will lose a lot of progress. is there any other way?

kind regards

Rémi

[Constantine · Accepted solution]

Hello @rkrick,

We had this situation in the past, and the only thing that worked for us was restoring from backups (luckily, ThingWorx takes them daily by default). Also, we noticed that in some cases multiple server restarts (5 -- 10 times) somehow helped.

I would suggest you to open a Tech Support case, they may be able to restore some data. As far as I know, PTC doesn't publically provide any tools to restore H2 content.

Also, I know it's too late, but don't use H2 for anything but trivial demos or tests. Configuring a Postgres instance will take you 30 minutes, but will be much much more reliable. Finally, export your work regularly and store it in a source control repository (e.g. Git). A reasonable practice is pushing your code to Git 2 -- 3 times per day.

Regards,
Constantine

[rkrick]

Hi Constantine,

Thanks a lot for the quick response.

Restarting several times worked in the end, so I'm happy I can continue.

I will take your remarks into account and take necessary actions.

kind regards

Rémi