Missing hosts with long names in VISUAL Message Center Dashboards
Number
325
Date
17 June 2011
Product
Dashboards
Question
Why do Dashboards only show one host when I have two or more hosts with long and similar names?
Answer
This problem only occurs when using SQL Server, when you have two or more hosts that start with the same 50 characters, because they are stored as the same host in the database.
Workaround
To fix the issue you need to alter the HOSTUUID column of the table T04STATHOSTINFO to change the data type from varchar(50) to varchar(500). To do so, you need first to drop the primary key, then change the data type and finally, re-add a primary key to the HOSTUUID column.
To drop the primary key you need to find the name of the primary key constraint. It is automatically generated by SQL Server and takes the form of PK__T04STATH__xxxxxxxxxxx and then execute the following command with the proper constraint name
ALTER TABLE T04STATHOSTINFO DROP CONSTRAINT PK__T04STATH__104ACD6F257187A8
To change the column you need to execute the following command:
ALTER TABLE T04STATHOSTINFO alter column HOSTUUID VARCHAR(450) NOT NULL
To add the primary key again:
ALTER TABLE T04STATHOSTINFO ADD PRIMARY KEY(HOSTUUID)
StorageModule.dll 1.6.4.34 solves the problem on new installations, but for older installations you need to do the change manually.
