UNSOLVED

dajonx

updated

14 years ago

D

dajonx

2 Intern

294 Posts

0

40368

August 28th, 2012 08:00

OME Issues

Good morning,

I am using OME to monitor our servers.  However, OME is not recognizing one server and a virtual machine.  It has a purple question mark next to them.  Is there a way to resolve this? 

Also, when I go to System Update and click on Get the Latest, it errors out.  The error message is as follows:

Import Dell Version Control Catalog for System Update failed with exception: Error: 50000, Procedure: usp_ErrorLog_Insert, Message: Error: 2627, Procedure: usp_PackageCategory_Insert, Message: Violation of PRIMARY KEY constraint 'PK_PackageCategory'. Cannot insert duplicate key in object 'Catalog.PackageCategory'.  The duplicate key value is (PC).

Any help is greatly appreciated!

  • dajonx

    2 Intern

    294 Posts

    1438

    0

    Posted August 28th, 2012 08:00

    Thank you, Abhijit.

    Where can I access the troubleshooting tool?  I am using SNMP protocol.  The physical server has OpenManage Server Administrator Version 7.1.0 installed.  

    I thought OME supported VMs (Microsoft Virtualization category under Devices).  Ok, thank you.

    The OME server does have access to the Internet.  Do I need to make an exception under Internet Options?

  • DELL-Abhijit P

    Community Manager

    711 Posts

    1438

    0

    Posted August 28th, 2012 08:00

    Hi,

    Thanks for your post.

    OME does not support classification of VMs. The VMs will be classified as unknowns in the OME device tree. For the physical server, you can try using troubleshooting tool for the protocol you are using for discovery and it will help you isolate the problem in connectivity/credentials. Another thing to check would be, if you have OpenManage Server Administrator installed on that server.

    Regarding the import catalog, I assume you are pointing at the default Dell FTP catalog. You can verify if you have internet access and if you need proxy, you have entered those credentials in the preferences tab.

    Regards

    Abhijit

  • DELL-Abhijit P

    Community Manager

    711 Posts

    1438

    0

    Posted August 28th, 2012 09:00

    Thanks for the updates. Can you try running the import catalog task again after deleting the devices under unknown group?

    Regards

    Abhijit

  • DELL-Abhijit P

    Community Manager

    711 Posts

    1438

    0

    Posted August 28th, 2012 09:00

    It is possible that the discovered VMs inventory may be interfering with the catlog import task. Is it possible for you to delete the devices under unknown group and then run the catalog import task?

    Regards

    Abhijit

  • dajonx

    2 Intern

    294 Posts

    1438

    0

    Posted August 28th, 2012 09:00

    Thank you Rob and Abhijit.

    I have found the issue in the physical server (misspelled public) and now it works fine.  

    Oh I see.  Thank you for the clarification.

    Yes, I have done what you instructed by downloading the .cab file and importing it.  It now says "Current catalog version is the latest".  However, in the Task Execution History, I still get the same error as mentioned above.  

  • DELL-Rob C

    4 Apprentice

    2843 Posts

    1438

    0

    Posted August 28th, 2012 09:00

    The TS tool is on the desktop of your OME server.  We install it by default.

    There is a preferences screen in OME where you can enter proxy information.

    Good luck,

    Rob

  • DELL-Abhijit P

    Community Manager

    711 Posts

    1438

    0

    Posted August 28th, 2012 09:00

    Hi,

    Thanks for the updates.

    Troubleshooting tool is installed with OME. You can find the shortcut to launch the tool on the desktop or in the Start menu under Dell->Troubleshooting Tool. For SNMP, the community name is case sensitive. You can check the name specified in the discovery wizard and the one specified on the target server under SNMP service. The First Time Setup Tutorial located under Tutorials Menu will guide you through the steps for SNMP discovery.

    OME supports discovery and classification of physical servers(hosts) running the VMs. This includes classic ESX/ESXi/Microsoft Hyper V servers but it doesn't support classification of the VMs running on those servers. The inventory of these physical servers will show the list of VMs running on those servers.

    Are you able to download ftp.dell.com/.../catalog.cab using the browser on the same server? If so, you can try downloading that file and use Manage->System Update->Select a Catalog Source option and point to that downloaded catalog to import.

    Regards

    Abhijit

  • dajonx

    2 Intern

    294 Posts

    1438

    0

    Posted August 28th, 2012 09:00

    Thank you Abhijit.

    I have deleted the unknown devices and tried reimporting the .cab file.  The error message still came up again.

  • DELL-Abhijit P

    Community Manager

    711 Posts

    1438

    0

    Posted August 28th, 2012 11:00

    Thanks for the update.

    It does look like data issue. _Only_ do this process if you are familiar with SQL server management studio and comfortable with executing SQL scripts. You can try clearing old catalog data from the database.

    1. Back up the database

    2. Use SQL Server Management Studio to connect to the OMEssentials database and execute the script below.

    USE OMEssentials

    GO

    Delete from Catalog.Manifest where SourceId = 1

    GO

    3.Try import catalog from ftp again

    Otherwise you can open a support ticket and they can help you with the necessary steps. Here is the number 800-945-3355

    Regards

    Abhijit

  • DELL-Abhijit P

    Community Manager

    711 Posts

    479

    0

    Posted August 28th, 2012 11:00

    Thanks for the update. I'm assuming you had only used FTP as the catalog source and have not imported catalogs from SUU or repository manager as a source. I'm also assuming that you ran the script and still see the same error.

    In that case there is one last thing you can try before calling in support. If possible you can try deleting all the discovered devices and then run the catalog import. You can re-run the discovery and inventory to get the devices back in the tree.

    Regards

    Abhijit