Return
-
Title
Inventory Time and Date with Negative Values Errors. -
Description
K1000 System Management Appliance is acting strangely with all the Time and along with other Errors while displaying negative seconds numbers like -6226229 seconds ago along the Last Inventory tab of the devices Inventory page -
Cause
There was error during the upgrade of K1000 System Management Appliance to version 7.1.149 and the upgrade process stalled which didn't complete and the current version is still on the former version of 7.0.121306
Below are the logs that indicate the Upgrade was stalled with Errors and not completing the entire upgrade processes:[Thu Apr 27 16:13:50 AEST 2017] [kbin:signature] 270da069b8d22ec45a51db68dfb1dc272de991e67f5b95dfe5fec42b6392
86347b6c7f43208e204097c42f10e9e9659048ea07d68f460bb73d660ee614645ea7
[Thu Apr 27 16:13:53 AEST 2017] [kbin:apply] k1000_server_7.1.149.kbin
[Thu Apr 27 16:14:09 AEST 2017] [notice] kbox_upgrade:: NOTICE: Running script to clean up questionable views in the database
[Thu Apr 27 16:14:10 AEST 2017] [notice] kbox_upgrade:: NOTICE: Running kbox_upgrade.php part 1
[Thu Apr 27 16:14:10 AEST 2017] [notice] Begin K1000 Server Update to 7.1.149 from 7.0.121306
[Thu Apr 27 16:14:10 AEST 2017] [notice] Verifying that KBSYS Database matches expected schema...
[Thu Apr 27 16:14:14 AEST 2017] [notice] one is KBSYS, two is /kbox/bin/kbserver/templates/factory_sys.sql
[Thu Apr 27 16:14:14 AEST 2017] [notice] Verifying that CATALOG Database matches expected schema...
[Thu Apr 27 16:14:14 AEST 2017] [notice] Verifying that AMS Database matches expected schema...
-
Resolution
Restore from previous last known good K1000 System Management Appliance Backups
How to: Restoring the appliance > Restore the appliance from backups (229569)