Skip to main content
1-Visitor
May 12, 2020
Solved

ERROR 401

  • May 12, 2020
  • 2 replies
  • 1173 views

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

Best answer by Constantine

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

2 replies

18-Opal
May 12, 2020

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

rkrick1-VisitorAuthor
1-Visitor
May 12, 2020

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