04-21-2011 08:44 PM
I've had to do this several times now, so i thought i put it on the forum:
1st run this command:
mysql -p bas -e "ALTER table bas_users ADD COLUMN managed TINYINT(1) UNSIGNED DEFAULT 0 NOT NULL;"
A second issue may also cause this error message once the above issue has been fixed. If the date the logged in user was created is zero ("0000-00-00") then the same error message will be displayed.
mysql -p bas -e "update bas_users set created = now() where created = 0;"
Your comments/corrections are welcome, thanks to Cisco support on this fix.
04-22-2011 05:52 AM
Can you provide the symtoms that this fixed?
04-22-2011 06:56 AM
It's an obvious symptomology in that there are no displayed dashboard icons in the Health Dashboard webpage, depending on the IE browser version & settings, it may appear as red X's in image place holders rather than the dashboard icons themselves. It's a bug related to the MySQL database not being updated correctly from older versions to new.
04-23-2011 01:14 PM
What version did you upgrade from and too?
04-25-2011 11:18 AM
Typically, 6.0.x to 6.3.1, but it may happen on any version upgrade faik.
04-25-2011 11:47 AM
CSCti55060 was created to resolve:
Issue: The VSOM Health Dashboard fails to load any information or icons, with the message "Server Error: No message found under code 'system_error' for locale 'null'" and the message in the vsom_be.log "ERROR: Value '0000-00-00' can not be represented as java.sql.Timestamp". This can be caused when the VSOM user has a 0 value for the date the user was 'created'.
Fix: Set the 'created' date to a valid date. The following command can be run from the VSOM command-line to fix the 'created' date for all users where it is currently set to 0: # mysql -p bas -e "update bas_users set created = now() where created = 0;"
CSCti14403 was created to reslove:
Symptom: The VSOM Health Dashboard loads with the error "Server Error: No message found under code 'system_error' for locale 'null'" and does not populate with any system health data. Conditions: A VSOM system installed prior to version 4.1.0 and upgraded to version 6.3.0. Workaround: This is resolved by updating the database with the missing table. To do this: 1) Stop the VSM software: # /etc/init.d/cisco stop 2) Use the MySQL command-line program to create the missing table with the following commands on the VSOM server command-line as the user 'root': # mysql -p bas -e "ALTER table bas_users ADD COLUMN managed TINYINT(1) UNSIGNED DEFAULT 0 NOT NULL;" 3) Start the VSM software: # /etc/init.d/cisco start
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: