Unsolved

This post is more than 5 years old

2 Intern

 • 

294 Posts

40344

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!

2 Intern

 • 

294 Posts

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?

Community Manager

 • 

711 Posts

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

Community Manager

 • 

711 Posts

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

Community Manager

 • 

711 Posts

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

2 Intern

 • 

294 Posts

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.  

4 Apprentice

 • 

2.8K Posts

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

Community Manager

 • 

711 Posts

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

2 Intern

 • 

294 Posts

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.

Community Manager

 • 

711 Posts

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

Community Manager

 • 

711 Posts

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

2 Intern

 • 

294 Posts

August 28th, 2012 11:00

Thank you Abhijit.

Unfortunately, I still receive the same error message.  

2 Intern

 • 

294 Posts

August 29th, 2012 06:00

Thank you Abhijit.

Yes, I didn't import catalogs from SUU, but I did use repository manager to import the catalog.cab file.  Yes, I also ran the script.

I have deleted all of the devices and tried to re-import the catalog.cab file via the repository manager and the error still showed up.

Community Manager

 • 

711 Posts

August 29th, 2012 08:00

Thanks for the updates. The earlier script only targeted catalog data from ftp catalog. As you have also used the import from repository manager option that data was not cleared by the script.

Here is the updated script which will clear data for all catalog sources. You can try this and reimport the catalog. If you still see the error after this, the only way would be to open a support ticket and let them investigate further.

1.Back up the database to make sure if something goes wrong we don’t make the matter worst

2.Open the SQL Server Management studio connect to OMEssentials database and execute the script below.

USE OMEssentials

GO

Delete from Catalog.Manifest

GO

3.Try import catalog from ftp again

Regards

Abhijit

2 Intern

 • 

294 Posts

August 29th, 2012 10:00

Thank you Abhijit.

Unfortunately, it did not work.  

Community Manager

 • 

711 Posts

August 29th, 2012 10:00

Thanks for the updates. I think the only way remaining now is to open the support ticket and have them investigate further. Here is the number 800-945-3355

Regards

Abhijit

No Events found!

Top