cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
1070
Views
0
Helpful
5
Replies

VSOM Health Dashboard Icon MySQL fix

Cory Blackman
Level 1
Level 1

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.

5 Replies 5

etijburg
Level 4
Level 4

Can you provide the symtoms that this fixed?

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.

What version did you upgrade from and too?

Typically, 6.0.x to 6.3.1, but it may happen on any version upgrade faik.

michaew3
Level 1
Level 1

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


					
				
			
			
				
			
			
				
			
			
			
			
			
			
		
Getting Started

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: