6.1.251 update failed citing database differences

Just tried to update our SDA from 6.0.425 to 6.1.251 and it failed. Something about the database schema checks returning differences.

I've logged a call with Quest. Just frustrating because this was a planned change that was scheduled during the weekend when Quest support doesn't work.

Here are the relevant log entries":


[Sat May 18 17:31:36 BST 2019] [notice] K2000 Server Update Canceled, failed database schema checks, see previous lines for specific errors, contact KACE Support at https://support.quest.com/contact-support to upgrade properly.

IM_LOG_IMAGE_CAPTURE.IM_SYSTEM_IMAGE_ID[Default] is:'0' should be: ''



IM_LOG_IMAGE_CAPTURE.IM_SYSTEM_IMAGE_ID[Type] is:'bigint(20) unsigned' should be: ''

There were differences detected.

second db: two

first db: one

[Sat May 18 17:31:36 BST 2019] [notice] one is KBDB, two is /kbox/sql/factory.sql

[Sat May 18 17:30:31 BST 2019] [notice] Verifying that KBDB Database matches expected schema...

[Sat May 18 17:29:46 BST 2019] [notice] XXX===========================================================================

[Sat May 18 17:29:46 BST 2019] [notice] XXX Begin K2000 Server Update to 6.1.251 from 6.0.425


Anyone seen this before? If anyone knows how to fix this without support, please let me know. T.I.A.

Not sure if it's related, but we do have some Mac system image entries in the system which refuse to delete. They were created on an RSA and when I try to delete them there I get the "Oops!" error screen. I think I might need to kill that RSA and replace it.

0 Comments   [ + ] Show comments

Answers (2)

Answer Summary:
Posted by: Nico_K 4 years ago
Red Belt

contact Support. You can also prepare by creating a tether.
Settings | Support | Tether

Could it be that your appliance has crashed since the 6.0 update?

To solve it without support:
1. export all of your packages
2. setup a new appliance (6.1 is fully fine!)
3. import the exported packages

  • Thank you for your reply.

    I don't think it has crashed. The only problem we've had is the faulty Mac system images which won't delete. I just tried replacing the RSA with the issue but the SDA still won't delete the erroneous system images.

    I might wait for support because we have 27 RSA's and I would need to re-link them. I've kicked-off a package export to prepare anyway. - mcnaugha 4 years ago
    • this could be linked, since the database which holds the imaging info is affected (and I seen database corruptions only with crashed servers, where the backend file system is affected too) - Nico_K 4 years ago
Posted by: mcnaugha 4 years ago
Senior Yellow Belt

Top Answer

Quest Support was able to repair the database. Although I believe it took 12hrs total work time.

We have been upgrading our SDA for about a decade. Somewhere along the line something messed up the database. The issue is usually caused by importing packages from an older version but I did not make that mistake. Last import was from v4.1.x to v4.1.x. Then updated with each new release as they came along. Everything seemed fine until 6.1.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login


This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ