topic Re: HP SIM 6.2 "The collection is empty." in All System Tab in Server Management - Systems Insight Manager

HP SIM 6.2 "The collection is empty." in All System Tab

Suyash14 — Thu, 28 Jul 2011 20:55:50 GMT

Hi, I am using HP System Insight Manager v.6.2, yesterday all was fine with with receiving alerts and viewing all events & systems. Today I am not recieving any alerts from HP SIM and when I try to view all systems I just get a message that the collection list is empty. They are showing on "All Servers" tab. Please could someone offer some assistance as I have been looking for answers the entire day.

Re: HP SIM 6.2 "The collection is empty." in All System Tab

thwe16 — Wed, 21 Sep 2011 06:17:53 GMT

Hello,

i have the same issue, do you now have a solution for this issue?

Thanks.

Re: HP SIM 6.2 "The collection is empty." in All System Tab

TheFabSan — Tue, 04 Oct 2011 14:04:18 GMT

same here, upgraded from 6.2 to 6.3 and using sql express. the servers come up in the search box but the not showing up in the main window. has anyone found a resolution?

Re: HP SIM 6.2 "The collection is empty." in All System Tab

the_bunch — Wed, 05 Oct 2011 13:41:17 GMT

Hi,

I had the same problem with my Windows 6.2 CMS. All working fine then one day logged in to find the Systems and Events came back as collections empty. After spending several hours trying to figure out what was wrong, discovered that the data disc of our CMS server had become full. This was to do with the SQL database backups not being purged so we had a lot of SQL backups going back months. Once the old ones were purged and the CMS rebooted, everything was working fine!

Regards

Steve

Re: HP SIM 6.2 "The collection is empty." in All System Tab

TheFabSan — Thu, 06 Oct 2011 18:13:24 GMT

space on the partitions looks fine. i remember having an issue with sql previously. logging into the insight page was OK. but when th sql was out of space no systems came up even when searching.

this is different, no systems show up on the collections (main window) but show up in the search field. I even ran a discovery. i have a ticket with HP. will post the results.

Fix: HP SIM 6.2 "The collection is empty." in All System Tab

BSaunders_UK — Thu, 13 Oct 2011 14:20:06 GMT

Hey All

So I've found a solution to this on my server (after spending a long time with HP Support who weren't very much help to be honest.)

When i looked through the mx.log file on the server as I tried to view a collection, I noticed a database error pointing to a missing view in the database called cwStatusView. This view was missing from my database (On a clean install mind-you!) and was causing all of the Collections to appear empty. I spent a while wondering how to recreate the view and eventually found an old backup of a SIM 6.1 database with the view specification in it. I re-created the view in my new database and it sprang to life, my collections are re-populated.

The SELECT statement which makes up the cwStatusView is:

SELECT

DeviceKey, StatusValue AS cwStatus FROM deviceStatusValue JOIN deviceStatusSources on deviceStatusValue.StatusSourceId = deviceStatusSources.StatusSourceId where StatusSourceName =N'hp.isee.entitlement'

I hope this helps someone else. If not then take a look in the mx.log file, it's a bit verbose but it helped me.

Brendan

Re: Fix: HP SIM 6.2 "The collection is empty." in All System Tab

NL19796 — Wed, 29 Feb 2012 09:03:58 GMT

I had a similar issue, after upgrading HP SIM 6.2 to 6.3, All HP Service Events showed an empty screen.

Try this:

Click on Customize... under System and Event Collections

In the right pane, select Events from the dropdown box.

Expand the tree to make All HP Service Events visible, select it with the radiobutton in front of it.

Click Edit.

You now see the selection "where event category is equal to" and then a box showing "HP ServiceEv"

Now the value in this last box is the problem.

Change it to "HP Service Events" (omitting the double quotes) and click the Save button.

Confirm that you really want this, and once more click Ok.

Done!

Re: Fix: HP SIM 6.2 "The collection is empty." in All System Tab

AVP01 — Fri, 01 Mar 2013 15:48:36 GMT

Thanks Brendan,,,,The "cwStatusView" was the fix for me. This worked on an HP SIM enviornment that had been upgraded from 5.2 originally, to 6.3 and then 7.1 running in SQL2008 enviornment.

Thanks again for a great find !!!

Kudos

Re: Fix: HP SIM 6.2 "The collection is empty." in All System Tab

Glyn Pollington — Thu, 30 May 2013 08:38:39 GMT

I would add that I have just had exactly the same issue. The scenario was a new virtualised install of SIM 6.2 and mximport from the old SIM 6.2 server. The all systems collection was empty, but custome collections were there and it was possible to drill down from events to system pages.

We checked the DB and compared to the source server's DB and found the cwstatusview view was missing. Recreated it in SQL management studio and the views all came back.

Re: Fix: HP SIM 6.2 "The collection is empty." in All System Tab

DeepBlueSomethi — Thu, 22 Aug 2013 14:49:32 GMT

Thanks! I had the same problem after moving HP SIM 7.2 to another system. Great work!