This post is more than 5 years old
2 Intern
•
131 Posts
0
9743
February 2nd, 2018 13:00
OME and client update catalog
Summary page under Manage\System Update says catalog is inaccessible. The source is pointing to http://downloads.dell.com/catalog/catalog.cab. This however WILL NOT let me change the source to either another site or point to a catalog.cab or .xml file say from something like the latest SUU v17.12.00
Dell OM Essentials ver is 2.2 looking to migrate to 2.4 but wanted to get this resolved first. I believe this may have something to do with possibly a stale service account within SQL?
does anyone know how to re-authenticated OM Essentials to use different credentials possibly?
Or does anyone else have any other ideas?
No Events found!
Yellow Boy
2 Intern
•
131 Posts
0
February 15th, 2018 20:00
After a few weeks and working with Dell finally figured out the download issue. Even though we were no longer using a proxy, and the proxy setting was not selected to use a proxy, it still had a proxy server listed due to DB. Because that field was populated with a proxy name it was not allowing us to download the latest CAB file for the system update:
Thanks to Eric and Daniel with Dell for assistance
DELL-Shivendra K
2 Intern
•
685 Posts
0
February 5th, 2018 01:00
Hi, thanks for the query.
Only OME Administrators are allowed to change the catalog source. Please make sure you have those permissions granted.
To login using different credentials, hover the user name on top right corner and then click Sign in as Different User menu option.
Yellow Boy
2 Intern
•
131 Posts
0
February 5th, 2018 05:00
I verified that account is in that group. I can't even point to a local CAB file to import as import does nothing nor does it allow me to change the option on how to import. IF this is a SQL issue what should I look at within the SQL DB tables related to system update?
Yellow Boy
2 Intern
•
131 Posts
0
February 5th, 2018 09:00
Also ran a repair on Dell OM 2.2 but no help. I wanted to get this resolved PRIOR to upgrading Dell OM Essentials to 2.3 or 2.4.
DELL-Shivendra K
2 Intern
•
685 Posts
0
February 5th, 2018 22:00
I don't think this is related to SQL. If that would be the case, OME itself will throw errors on launching.
Possible to share some screenshots of error that you see?
Yellow Boy
2 Intern
•
131 Posts
0
February 6th, 2018 12:00
Here is the event log that is captured related to the import:
Dell OpenManage log event viewer Event ID 0:
System.Security.Cryptography.CryptographicException: Key not valid for use in specified state.
at System.Security.Cryptography.ProtectedData.Unprotect(Byte[] encryptedData, Byte[] optionalEntropy, DataProtectionScope scope)
at A.c3f6724f85deaf67a5932628dca681c0c.c17222b93791db353f4ae06d578280405(Byte[] c1294a7195eed9778fbdf778993e8d000, DataProtectionScope c81fb2d3fb24753c9e2676df7a943ab0e, String cc7e8cc7e143fbc74b4e881ed30e69f58)
at A.cc05337312f1a362d780b710509b5b376.c4d77c5d1b307242e0f24aa6c661118dd(Binary c1294a7195eed9778fbdf778993e8d000, String cc7e8cc7e143fbc74b4e881ed30e69f58)
at Dell.OME.TaskManager.ImportCatalogTask.c1666f5c9f9981d365b851985ba2cbfde()
at SmartConsole.Service.DataService.ImportCatalogTaskRun(ImportCatalogTask task)
Yellow Boy
2 Intern
•
131 Posts
0
February 6th, 2018 20:00
https://www.dell.com/community/Dell-OpenManage-Essentials/OME-Issues/m-p/4014237
I ran the following which the SQL DB is hosted on remote server. After running this query I now have Source: Catalog is inaccessible (same as before), Get the latest is greyed out (same as before), and Select a catalog source from use an online source selection is now blank. I tried using the SUU cabinet file but still nothing imports.
I also noticed Dell Solutions in OM Essentials - Inventory Collector component shows version as 15.6.200 with action as greyed out but says Up-To-Date. In the "C:\Program Files\Dell\SysMgt\Essentials\bin" folder I see invCol64.exe & invcol.exe which says version is 16.05.200 (BLD_697).
I copied over my old SystemUpdate folder as there was NO systemupdate folder earlier (C:\Program Files\Dell\SysMgt\Essentials\SystemUpdate). This had all my previous updates that I was deploying along with the last .cab file downloaded from system update.
Used 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
DELL-Shivendra K
2 Intern
•
685 Posts
0
February 6th, 2018 21:00
I suggest you to get in touch with Dell Support for resolution of this problem. They can take a closer look at your setup and provide help.
Yellow Boy
2 Intern
•
131 Posts
0
February 7th, 2018 14:00
well I updated today to OME 2.3 and my options to download from are back however the download still doesn't take place and I keep seeing those crypto issues related when you initiate a download be it local cab or remote
I had a similar issue years ago and Dell worked with me which appeared to have been a issue with a stale service account within SQL. I think the resolution was to install SQL express on the OME server, restore the remote SQL db locally, was then able to run FTP catalog update, and then pointed back to the remote SQL DB.
I don't recall all the correct syntax to do this OR if there is another option withing SQL DB to look at...any tips/suggestions?