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

ERROR 401

SOLVED
rkrick
Guest

ERROR 401

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

1 ACCEPTED SOLUTION

Accepted Solutions

Re: ERROR 401

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

View solution in original post

2 REPLIES 2

Re: ERROR 401

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

View solution in original post

Re: ERROR 401

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

Announcements

Check out the upcoming Expert Session: Understanding ThingWorx Navigate Licensing in Community "Customer Events" section.