One of the techs here tried to empty the inventory in spiceworks. The idea was to empty the inventory and then re-scan the network. Unfortunately during the delete it looks like spiceworks had a hiccup. When we try to view all inventory we get “hmm, there was a problem loading this data. Please try again.”

If we select a subset of all inventory (say all servers) we can see the servers okay. It looks like part of the inventory became corrupt during the attempted delete.

Any thoughts on what we should do next?

2 Spice ups

Do you have a backup of your SW database? Restore A Backup

If not, try to install SW over the top.

You might like to try this: Integrity check the Spiceworks SQLite database

Any major actions like this integrity check, databse edits and/or mass deletes should always be preceeded by backing up Spiceworks.

If the integrity check doesn’t help and you have a backup taken recently then bytesnake’s idea will probably be best, then after that let us know if there are still problems.

I’ll give it the integrity check a try and let you know how it goes!

Thanks for the suggestions.

I’ve been having the same problem with my inventory lately. I ran the integrity check and it came up saying “Not OK”. What’s the next step to making it OK??

I ran the data integrity check and I am gett “Not OK” as well. I am going to try to do in install over the existing spiceworks install.

Is their anyway to backup just the tickets and settings?

I did an upgrade to the newest version after the Not OK result. That didn’t seem to help any. To the best of my knowledge, Spiceworks stores everything into one database, so your tickets, settings, and inventory are all in one database.