Tuesday, December 26, 2017

SCUP 2011 Import: Exception: An error occurred while updating the entries. See the inner exception for details. Updates Publisher xx/xx/xxxx x:xx:xx AM 13 (0x000D)

I was getting error message while updating Dell updates using SCUP 2011


    Import: Skipped import due to no change in creation date for update 56c63df6-5267-44ca-b7d9-78c22b2e9843, title: Intel Unite Protected Guest Access  Plugin Application,3.2.82.42,A00 Updates Publisher 12/26/2017 9:49:19 AM 13 (0x000D)
    Import: Processing XML for package 0dc345fb-52fe-4380-8565-11758a02e64d, length 7397 characters. Updates Publisher 12/26/2017 9:49:19 AM 13 (0x000D)
    Import: Skipped import due to no change in creation date for update 0dc345fb-52fe-4380-8565-11758a02e64d, title: Intel Unite Hub Application Installer,3.1.45.26,A00 Updates Publisher 12/26/2017 9:49:19 AM 13 (0x000D)
    Import: Processing XML for package 56e205cf-16dc-4b63-81d1-a3b748a89c86, length 7364 characters. Updates Publisher 12/26/2017 9:49:19 AM 13 (0x000D)
    Import: Skipped import due to no change in creation date for update 56e205cf-16dc-4b63-81d1-a3b748a89c86, title: Intel Unite Client Application Installer,3.1.45.26,A00 Updates Publisher 12/26/2017 9:49:19 AM 13 (0x000D)
    Import: Processing XML for package 4eaf38b8-b3d8-4596-a6ed-3dd3be80a8d4, length 7525 characters. Updates Publisher 12/26/2017 9:49:19 AM 13 (0x000D)
    Import: Importing new update 4eaf38b8-b3d8-4596-a6ed-3dd3be80a8d4, title: Intel Unite Add-In for Microsoft Outlook,3.2.82.42,A00 Updates Publisher 12/26/2017 9:49:19 AM 13 (0x000D)
    Import: Exception: An error occurred while updating the entries. See the inner exception for details. Updates Publisher 12/26/2017 9:49:19 AM 13 (0x000D)

    Import: Processing XML for package 388a5fae-a141-46d1-8968-6c15501a6a7d, length 7671 characters. Updates Publisher 12/26/2017 9:49:19 AM 13 (0x000D)
    Import: Importing new update 388a5fae-a141-46d1-8968-6c15501a6a7d, title: Intel Unite Plugin for Telemetry for Business Installer,3.2.82.42,A00 Updates Publisher 12/26/2017 9:49:19 AM 13 (0x000D)
    Import: Exception: An error occurred while updating the entries. See the inner exception for details. Updates Publisher 12/26/2017 9:49:19 AM 13 (0x000D)

    Import: Processing XML for package 08cc667b-043d-4afc-89a5-1700560bbbbf, length 4434 characters. Updates Publisher 12/26/2017 9:49:19 AM 13 (0x000D)
    Import: Skipped import due to no change in creation date for update 08cc667b-043d-4afc-89a5-1700560bbbbf, title: Dell OptiPlex 7050 System BIOS,1.6.5 Updates Publisher 12/26/2017 9:49:19 AM 13 (0x000D)

I had 27 of Import: Exception: An error occurred while updating the entries errors and I was scratching my head on this for a few days.
I found a similar problem on https://community.spiceworks.com/topic/1751827-service-pack-3-for-sql-server-2012-breaks-scup-2011-any-suggestions
and
https://social.technet.microsoft.com/Forums/en-US/e8267fe0-9c39-4fdc-8bdc-6b4b471b2e96/scup-fails-importing-of-updates?forum=ConfigMgrCompliance

But I use SQL 2008 so it was not the case.

To fix this problem, there are two options:

1, Get list of all failed updates and delete them individually from the Dell updates, and reimport.

If you miss any failed updates, you will still get the same error!. Delete them all and close SCUP 2011 and open again, and reimport the catalog.

2. Delete the "Dell" folder on the "Updates" and import Dell catalog again.
Warning: You will lose your all of your local information such as "Date Published", "Expired" and "Date Modified" information, if you expired or published and updates.

To delete the "Dell" folder on Updates:
Make a backup of your SCUP DB first (simply do copy and paste of the DB),  SCUP -> Updates -> Overview -> All Software Updates -> Dell. Highlight the "Dell", right click, and delete.