HP SIM 6.2 : Retrieve from mib variable list is blank

[OlivierV]

Hello All.

I want to define a new netapp system type. When I select the menu 'Retrieve from Mib', then the netapp.mib file, the 'Mib variable name' list is blank. Same for Rfc1213.mib.

I deleted the mib from Sim, recompiled the MIB files, reimported the CFG files, same issue. The test server which is also a 6.2 server, is ok. Netapp.mib is version 2.0.2.

Netapp trap management is ok.

How to resolve this ?

Thank you.

[OlivierV]

Hello.

I found where the problem is.

I compared with my SIM test server and used SQL manager to get in the MIB tables.

dbo.MibItems contains all the OIDs registered by SIM. The column Mib_File_Id references the MIB file ID from which the OIDs where imported.

This ID is contained in two other tables  : dbo.mibfiles and dbo.mibfilesEx. These two tables make the match between this ID and the mib file name

In my case (rfc1213 and netapp.mib, but I found others), the Mib_File_Id in MibItems and the one in Mibfiles and MibFilesEx where not matching.

Example : rfc1213.mib was registered with the ID 353 because I removed and imported it several times, but all the OIDs belonging to this MIB where using Mib_File_Id 1. I think SIM 'forgot' to remove the OIDs when I removed the MIB. When reimporting it, the OID where already present so it didn't reimport the OIDs with the new Id

So I hacked the database and changed the MIB id in MibFiles and MibFilesEx (easier and faster than changing all the IODs), get back to the Manage System Types, and it worked.

I don't think this will affect the traps management but I would appreciate if someone in this forum could give me his feeling about all this and if the changes I made can create troubles.

Regards.

[T.James]

I'm having the same issue as you are except on Linux HP SIM 6.3

I did the same thing by opening the database, searching for mibfiles.mib_file=foo.mib and noting the mib_file_id then searching for that ID in the mibfilesex and mibitems tables.  Found the exact same thing.  The mib_file_id of a bunch of stuff was incorrect.  I changed the records within mibitems rather than the other two and my problem has not been fixed.  I have quite a few mib's that are blank in the "Trap Name" dropdown on the SNMP Trap Settings page.  I did not have this issue on 6.1 or 6.2.  This is  a fresh install of 6.3 on a new OS installation. (SLES 11 SP1)

Any other ideas as to how to fix this?  I'd rather not have to manually find and fix all the inconsistancies in the database.

[T.James]

An update to my issue.

I have not managed to resolve my issue however, I have found this has been a problem for quite some time.

http://h30499.www3.hp.com/t5/ITRC-HP-Systems-Insight-Manager/Importing-MIBs-in-HPSIM-not-working-properly/m-p/3297641#M3372

I have tried reinstalling the OS and app, muiltiple times.  Using the following conditions

SLES 11SP1 - HP SIM 6.3

SLES 11SP1 - HP SIM 6.2

SLES 11SP1 - HP SIM 6.0

SLES 10 SP3 - HP SIM 6.3

None of these have worked.  Out of the box, after the first login, the Trap Name field under multiple mibs is not filled.

I tried the above solution and was not successful.  My mib_file_id values were consistant across the three tables. 

Does anyone else have any idea about how to fix this?