Return
-
Title
Error: USER.LOCATION column is only in first db -
Description
Unable and failed to upgrade existing K1000 System Management Appliance from version 7.0121306 to version 7.1.149.
The following update logs indicate the error messages:
[Tue May 9 14:44:35 SGT 2017] [notice] K1000 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.[Tue May 9 14:44:35 SGT 2017] [notice] Verifying that ORG2 Database matches expected schema...USER.LOCATION column is only in first dbThere were differences detected.second db: twofirst db: one[Tue May 9 14:44:35 SGT 2017] [notice] one is ORG1, two is /kbox/bin/kbserver/templates/factory_org.sql[Tue May 9 14:44:29 SGT 2017] [notice] Verifying that ORG1 Database matches expected schema...There are no differences detected.second db: twofirst db: one[Tue May 9 14:44:29 SGT 2017] [notice] one is AMS, two is /kbox/bin/kbserver/templates/factory_ams.sql[Tue May 9 14:44:28 SGT 2017] [notice] Verifying that AMS Database matches expected schema...There are no differences detected.second db: twofirst db: one[Tue May 9 14:44:28 SGT 2017] [notice] one is CATALOG, two is /kbox/bin/kbserver/templates/factory_catalog.sql[Tue May 9 14:44:27 SGT 2017] [notice] Verifying that CATALOG Database matches expected schema...There are no differences detected.second db: twofirst db: one -
Cause
This is a Known Issue and has been identified as K1-19402. -
Resolution
Please open a Support ticket with Quest KACE Technical Support and provide the logs mentioned above. -
Defect ID
K1-19402