Start a Conversation

Unsolved

Closed

H

1 Rookie

 • 

2 Posts

1298

March 10th, 2023 16:00

Dell OME 2.5 - Import Catalog for System Update fails

Import Dell EMC Version Control Catalog (Default) for System Update from http://downloads.dell.com/catalog/catalog.cab failed.Exception message: Error: 50000, Procedure: usp_ErrorLog_Insert, Message: Error: 515, Procedure: usp_Package_Insert, Message: Cannot insert the value NULL into column 'VendorVersionRank', table 'OMEssentials.Catalog.Package'; column does not allow nulls. INSERT fails.Checking identity information: current identity value '1320'.DBCC execution completed. If DBCC printed error messages, contact your system administrator.Checking identity information: current identity value '4967'.DBCC execution completed. If DBCC printed error messages, contact your system administrator.Checking identity information: current identity value '4139'.DBCC execution completed. If DBCC printed error messages, contact your system administrator.. Please enable/verify proxy settings if required.

Moderator

 • 

4.1K Posts

March 12th, 2023 17:00

Hello thanks for choosing Dell. Would this help? https://dell.to/3ZJ3M3m

1 Rookie

 • 

2 Posts

March 12th, 2023 20:00

That does not apply in this situation. The file is able to be downloaded but fails to import. I have also tried importing directly from the file after downloading it manually. This system was just recently upgraded from OME version 2.2.

Moderator

 • 

4.1K Posts

March 12th, 2023 22:00

Hello at this point this would be best looked at by OME expert. By using this link you can have an official ticket with us. https://dell.to/3JzrfOU Sorry I couldn't be of help this time.

131 Posts

March 15th, 2023 08:00

I'm having similar issue please advise:  Seems like something in the SQL DB for catalog is off.

Import Dell EMC Version Control Catalog (Default) for System Update from https://downloads.dell.com/catalog/catalog.cab failed.Exception message: Error: 50000, Procedure: usp_ErrorLog_Insert, Message: Error: 515, Procedure: usp_Package_Insert, Message: Cannot insert the value NULL into column 'VendorVersionRank', table 'OMEssentials.Catalog.Package'; column does not allow nulls. INSERT fails.Checking identity information: current identity value '23048'.DBCC execution completed. If DBCC printed error messages, contact your system administrator.Checking identity information: current identity value '91462'.DBCC execution completed. If DBCC printed error messages, contact your system administrator.Checking identity information: current identity value '111586'.DBCC execution completed. If DBCC printed error messages, contact your system administrator.. Please enable/verify proxy settings if required.

1 Message

March 24th, 2023 05:00

Estamos com o mesmo problema reportado:

Import Dell EMC Version Control Catalog (Default) for System Update from https://downloads.dell.com/catalog/catalog.cab failed.Exception message: Error: 50000, Procedure: usp_ErrorLog_Insert, Message: Error: 515, Procedure: usp_Package_Insert, Message: Cannot insert the value NULL into column 'VendorVersionRank', table 'OMEssentials.Catalog.Package'; column does not allow nulls. INSERT fails.Checking identity information: current identity value '2864'.DBCC execution completed. If DBCC printed error messages, contact your system administrator.Checking identity information: current identity value '7178'.DBCC execution completed. If DBCC printed error messages, contact your system administrator.Checking identity information: current identity value '12803'.DBCC execution completed. If DBCC printed error messages, contact your system administrator.. Please enable/verify proxy settings if required.

Moderator

 • 

4.1K Posts

March 26th, 2023 23:00

Hello, as of now I haven't heard anything regarding this. I will look into this but this may take time. I ask for your kind patience and in the meantime as I have suggested to another user, you can also raise an official ticket:  https://dell.to/3ZnXDZw Wish you a good one.

Moderator

 • 

4.1K Posts

March 28th, 2023 20:00

Hello folks,

Our Official recommendation is for customers to migrate to OM Enterprise (appliance version) 
As you should be aware, OM Essentials is currently in an EOL state and is no longer available for download from our Support Portal. OpenManage Essentials version 2.5 is the final release and will not support current or future PowerEdge servers and no further product enhancements will be added. Dell EMC recommends migration to OpenManage Enterprise for management of your Dell EMC devices.

Refer to the KB article below

Support for OpenManage Essential

May 1st, 2023 02:00

If you really-really-really want to stay with OM Essentials instead of OM Enterprise, here is a hack to get importing firmware/driver updates running again (no guarantee).

Our OM Essentials database is running on an external MSSQL server.

Be sure to have a proper recent backup of you database before altering it!!

Using SQLServer Management Studio, first change this global setting: Tools -> Options -> Designers -> Tabel and Database Designers -> uncheck "Prevent saving changes that require table recreation". Then the Catalog.Package table can be changed by modifying VendorVersionRank set to "allow Nulls".

Surely this also can be done on the CLI

For now this works again at our site, but to be hounest, OMEssentials (and Silverlight) is an old product which should be replaced for a newer/(better?) version

131 Posts

June 29th, 2023 06:00

Still didn't fix my issue

No Events found!

Top