This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Lansweeper Community
- Forums
- General Discussions
- Issue with Upgrade to 6.0.100
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Register to ask a question, start a topic or share an idea
Join the Community
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-17-2017 10:24 PM
I followed all of the steps for this upgrade exactly. I even made backup copies of all of the files. When my staff logged back in they noticed that everything had reverted back to 7/28/2017. I tried putting the backup of my database into place and got the same results. The file sizes and times for each of the files are exactly the same. What could have possibly happened? I have emailed this to support@lansweeper.com as well.
Solved! Go to Solution.
Labels:
- Labels:
-
General Discussion
1 ACCEPTED SOLUTION
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-20-2017 01:18 PM
Just to clarify: removal of data that cannot be explained through the database cleanup options found under Configuration\Server Options is, of course, not normal and something we take very seriously. From the thousands of customers we support we've had exactly 5 reports so far concerning unexplained data loss. In these 5 cases, the customers were using Microsoft's SQL Compact as their database server.
When previous cases were reported to us, we engaged with our developers to investigate the cause of the data loss. Given that this issue appears to be limited to SQL Compact, we strongly suspect at this point that it is related to the database server itself. The issue appears similar to a known SQL Compact bug reported by Microsoft itself in this article on the Microsoft website. Our developers will be integrating new SQL Compact DLL files (provided by Microsoft) into Lansweeper in one of our upcoming releases to hopefully prevent future data loss issues. The new DLL files won't be part of our very next release, as they need to be thoroughly tested, but we are moving them through the development chain as quickly as possible.
We sincerely apologize to the 5 customers who experienced this issue. Any case resulting in loss of data is one case too many. Without a database backup that still contains the missing data, there is no way for our support engineers to perform a restore, as scanned or help desk data is not sent back to our servers. I do want to emphasize for other customers though that this data loss issue appears to be extremely rare. It appears to be related to a third-party component, the SQL Compact database server, and occurs under very few SQL Compact installations. Lansweeper updates appear to be unrelated to the problem, as is illustrated by the fact that albrigtp's old database backups were already missing data.
If you do have concerns about possible future data loss, I would recommend moving your Lansweeper database to SQL Server by following this article in our online knowledge base, as albrigtp has done. We have had no reports of similar data loss occurring under the SQL Server database server.
When previous cases were reported to us, we engaged with our developers to investigate the cause of the data loss. Given that this issue appears to be limited to SQL Compact, we strongly suspect at this point that it is related to the database server itself. The issue appears similar to a known SQL Compact bug reported by Microsoft itself in this article on the Microsoft website. Our developers will be integrating new SQL Compact DLL files (provided by Microsoft) into Lansweeper in one of our upcoming releases to hopefully prevent future data loss issues. The new DLL files won't be part of our very next release, as they need to be thoroughly tested, but we are moving them through the development chain as quickly as possible.
We sincerely apologize to the 5 customers who experienced this issue. Any case resulting in loss of data is one case too many. Without a database backup that still contains the missing data, there is no way for our support engineers to perform a restore, as scanned or help desk data is not sent back to our servers. I do want to emphasize for other customers though that this data loss issue appears to be extremely rare. It appears to be related to a third-party component, the SQL Compact database server, and occurs under very few SQL Compact installations. Lansweeper updates appear to be unrelated to the problem, as is illustrated by the fact that albrigtp's old database backups were already missing data.
If you do have concerns about possible future data loss, I would recommend moving your Lansweeper database to SQL Server by following this article in our online knowledge base, as albrigtp has done. We have had no reports of similar data loss occurring under the SQL Server database server.
3 REPLIES 3
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-20-2017 01:18 PM
Just to clarify: removal of data that cannot be explained through the database cleanup options found under Configuration\Server Options is, of course, not normal and something we take very seriously. From the thousands of customers we support we've had exactly 5 reports so far concerning unexplained data loss. In these 5 cases, the customers were using Microsoft's SQL Compact as their database server.
When previous cases were reported to us, we engaged with our developers to investigate the cause of the data loss. Given that this issue appears to be limited to SQL Compact, we strongly suspect at this point that it is related to the database server itself. The issue appears similar to a known SQL Compact bug reported by Microsoft itself in this article on the Microsoft website. Our developers will be integrating new SQL Compact DLL files (provided by Microsoft) into Lansweeper in one of our upcoming releases to hopefully prevent future data loss issues. The new DLL files won't be part of our very next release, as they need to be thoroughly tested, but we are moving them through the development chain as quickly as possible.
We sincerely apologize to the 5 customers who experienced this issue. Any case resulting in loss of data is one case too many. Without a database backup that still contains the missing data, there is no way for our support engineers to perform a restore, as scanned or help desk data is not sent back to our servers. I do want to emphasize for other customers though that this data loss issue appears to be extremely rare. It appears to be related to a third-party component, the SQL Compact database server, and occurs under very few SQL Compact installations. Lansweeper updates appear to be unrelated to the problem, as is illustrated by the fact that albrigtp's old database backups were already missing data.
If you do have concerns about possible future data loss, I would recommend moving your Lansweeper database to SQL Server by following this article in our online knowledge base, as albrigtp has done. We have had no reports of similar data loss occurring under the SQL Server database server.
When previous cases were reported to us, we engaged with our developers to investigate the cause of the data loss. Given that this issue appears to be limited to SQL Compact, we strongly suspect at this point that it is related to the database server itself. The issue appears similar to a known SQL Compact bug reported by Microsoft itself in this article on the Microsoft website. Our developers will be integrating new SQL Compact DLL files (provided by Microsoft) into Lansweeper in one of our upcoming releases to hopefully prevent future data loss issues. The new DLL files won't be part of our very next release, as they need to be thoroughly tested, but we are moving them through the development chain as quickly as possible.
We sincerely apologize to the 5 customers who experienced this issue. Any case resulting in loss of data is one case too many. Without a database backup that still contains the missing data, there is no way for our support engineers to perform a restore, as scanned or help desk data is not sent back to our servers. I do want to emphasize for other customers though that this data loss issue appears to be extremely rare. It appears to be related to a third-party component, the SQL Compact database server, and occurs under very few SQL Compact installations. Lansweeper updates appear to be unrelated to the problem, as is illustrated by the fact that albrigtp's old database backups were already missing data.
If you do have concerns about possible future data loss, I would recommend moving your Lansweeper database to SQL Server by following this article in our online knowledge base, as albrigtp has done. We have had no reports of similar data loss occurring under the SQL Server database server.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-19-2017 07:07 PM
Support has said it was because I was using the compact .sdf file for the database instead of putting it on an actual sql database. I have migrated to sql now but I am going to lose data back to 7/28. Even backup files of the database that we had exported daily via .bat files were missing data back to 7/28. Really strange.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-19-2017 06:22 PM
Very strange; I can report that we did an upgrade to v. 6.0.100.75 and it all worked out; the OS where LAN Sweeper is running is 2008 R2
Thanks
~B
Thanks
~B
New to Lansweeper?
Try Lansweeper For Free
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now
Related Content
- On Prem - Dashboards Questions in General Discussions
- Network Discovery: IT Sensor Stops in General Discussions
- Understanding how cloud syncing works in General Discussions
- Lansweeper Service is Missing in General Discussions
- Is there a way to upgrade to the cloud without having our information stored worldwide? in Technical Troubleshooting
