none
Failed to set Subscriptions on the WSUS Server. Error:(-2147467259)Unspecified error RRS feed

  • Question

  • Recently restored SCCM 2012 SP1 from Sever 2008 R2, to Server 2012 R2. I had Updates Publisher installed on old 2008 Server with Firefox and Chrome imported into Configuration Manager. Since I have upgraded I am no longer able to sync updates with Microsoft. WCM.log says:

    Category Product:44048288-2aac-b2b5-3730-fc020622ea05 (Firefox) not found on WSUS

    Category Product:cc5cb1bb-6b87-94ae-f96a-f758195112a7 (Chrome) not found on WSUS

    Subscription contains categories unknown to WSUS.

    Failed to set Subscriptions on the WSUS Server. Error:(-2147467259)Unspecified error

    STATMSG: ID=6603 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_WSUS_CONFIGURATION_MANAGER" SYS=wdlsccmpri.aarcorp.com SITE=AAR PID=2788 TID=4668 GMTDATE=Mon Feb 17 18:22:43.654 2014 ISTR0="wdlsccmpri.aarcorp.com" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=

    I have gone to deselect these products from syncing in Administration> Site > Configure Site Components >Software Update Point Products Tab.  They are not there. Any help on getting SCCM to sync updates would be greatly appreciated.

    Monday, February 17, 2014 6:30 PM

Answers

  • PROBLEM

    =========

    Unable to sync after moving the Primary site server to different OS.

     

    CAUSE

    =======

    Issues with the product and classification setup in the SUP after the restore.

     

    RESOLUTION

    ===========

    1. Ran below query to check if we have reference to Firefox and Chrome categories in the database.

     

    QUERY:

     

    select CategoryInstance_UniqueID, CategoryInstanceName

    from fn_ListUpdateCategoryInstances(9) cat

    where cat.AllowSubscription=1 and cat.IsSubscribed=1 and cat.IsParentSubscribed=0

    order by cat.CategoryInstance_UniqueID

     

    RESULT:  [Along with other products we found Chrome and Firefox]

    Product:44048288-2aac-b2b5-3730-fc020622ea05  Firefox

    Product:cc5cb1bb-6b87-94ae-f96a-f758195112a7 Chrome

     

    1. Ran Select Query

     

    select * from CI_CategoryInstances where categoryinstanceid in

    (select categoryinstanceid  from CI_LocalizedCategoryInstances where LocaleID = 9 and CategoryInstanceName = 'Firefox'or

    CategoryInstanceName = 'Chrome')

     

    RESULT:

    CategoryInstanceID CategoryInstance_UniqueID CategoryTypeName DateLastModified SourceSite ParentCategoryInstanceID IsDeleted rowversion

    16777523 Product:cc5cb1bb-6b87-94ae-f96a-f758195112a7 Product 2013-11-27 21:05:23.000 AAR 16777522 0 0x0000000006B08673

    16777549 Product:44048288-2aac-b2b5-3730-fc020622ea05 Product 2013-11-27 21:05:23.000 AAR 16777536 0 0x0000000006B08676

     

    1. Ran Select Query

     

    select * from CI_LocalizedCategoryInstances where LocaleID = 9 and CategoryInstanceName = 'Firefox'or

    CategoryInstanceName = 'Chrome'

     

    RESULT:

    CategoryInstanceID LocaleID CategoryInstanceName rowversion

    16777523 9 Chrome 0x0000000006B08674

    16777549 9 Firefox 0x0000000006B08677

     

    1. We did find Chrome and Firefox items in the database.
    2. We need to delete these items in the database.
    3. We used below queries to delete the reference from the database.

     

    delete from CI_CategoryInstances where categoryinstanceid in

    (select categoryinstanceid  from CI_LocalizedCategoryInstances where LocaleID = 9 and CategoryInstanceName = 'Firefox'or

    CategoryInstanceName = 'Chrome')

     

    delete from CI_LocalizedCategoryInstances where LocaleID = 9 and CategoryInstanceName = 'Firefox'or

    CategoryInstanceName = 'Chrome'

     

    After deleting performed Scheduled Sync. Was successful

    • Marked as answer by Joseph Camaci Monday, March 3, 2014 3:48 PM
    Monday, March 3, 2014 3:48 PM

All replies

  • On the Software Update Point Component properties look at the top:

    Locally Published packages - any there? Uncheck them and try the sync again.



    Gerry Hampson | Blog: www.gerryhampsoncm.blogspot.ie | LinkedIn: Gerry Hampson | Twitter: @gerryhampson

    Monday, February 17, 2014 6:45 PM
  • I was having errors with Adobe and deselected that, which eliminated those errors, but still having the issue with Chrome and Firefox.

    Those options are not there.



    Tuesday, February 18, 2014 7:04 PM
  • I'm cleaning up old post, did you figure this out, if so how?

    http://www.enhansoft.com/

    Saturday, March 1, 2014 3:57 PM
    Moderator
  • PROBLEM

    =========

    Unable to sync after moving the Primary site server to different OS.

     

    CAUSE

    =======

    Issues with the product and classification setup in the SUP after the restore.

     

    RESOLUTION

    ===========

    1. Ran below query to check if we have reference to Firefox and Chrome categories in the database.

     

    QUERY:

     

    select CategoryInstance_UniqueID, CategoryInstanceName

    from fn_ListUpdateCategoryInstances(9) cat

    where cat.AllowSubscription=1 and cat.IsSubscribed=1 and cat.IsParentSubscribed=0

    order by cat.CategoryInstance_UniqueID

     

    RESULT:  [Along with other products we found Chrome and Firefox]

    Product:44048288-2aac-b2b5-3730-fc020622ea05  Firefox

    Product:cc5cb1bb-6b87-94ae-f96a-f758195112a7 Chrome

     

    1. Ran Select Query

     

    select * from CI_CategoryInstances where categoryinstanceid in

    (select categoryinstanceid  from CI_LocalizedCategoryInstances where LocaleID = 9 and CategoryInstanceName = 'Firefox'or

    CategoryInstanceName = 'Chrome')

     

    RESULT:

    CategoryInstanceID CategoryInstance_UniqueID CategoryTypeName DateLastModified SourceSite ParentCategoryInstanceID IsDeleted rowversion

    16777523 Product:cc5cb1bb-6b87-94ae-f96a-f758195112a7 Product 2013-11-27 21:05:23.000 AAR 16777522 0 0x0000000006B08673

    16777549 Product:44048288-2aac-b2b5-3730-fc020622ea05 Product 2013-11-27 21:05:23.000 AAR 16777536 0 0x0000000006B08676

     

    1. Ran Select Query

     

    select * from CI_LocalizedCategoryInstances where LocaleID = 9 and CategoryInstanceName = 'Firefox'or

    CategoryInstanceName = 'Chrome'

     

    RESULT:

    CategoryInstanceID LocaleID CategoryInstanceName rowversion

    16777523 9 Chrome 0x0000000006B08674

    16777549 9 Firefox 0x0000000006B08677

     

    1. We did find Chrome and Firefox items in the database.
    2. We need to delete these items in the database.
    3. We used below queries to delete the reference from the database.

     

    delete from CI_CategoryInstances where categoryinstanceid in

    (select categoryinstanceid  from CI_LocalizedCategoryInstances where LocaleID = 9 and CategoryInstanceName = 'Firefox'or

    CategoryInstanceName = 'Chrome')

     

    delete from CI_LocalizedCategoryInstances where LocaleID = 9 and CategoryInstanceName = 'Firefox'or

    CategoryInstanceName = 'Chrome'

     

    After deleting performed Scheduled Sync. Was successful

    • Marked as answer by Joseph Camaci Monday, March 3, 2014 3:48 PM
    Monday, March 3, 2014 3:48 PM
  • Keep in mind that it is completely unsupported to delete anything from the CM12 database without contact CSS for support. Only they can make that suggestion.

    http://www.enhansoft.com/

    Monday, March 3, 2014 4:24 PM
    Moderator
  • Had similar issue with Adobe products showing up. This was super helpful and seems to have resolved my issue as well. Thanks for the answer.

    Joshua Castro

    Wednesday, June 15, 2016 9:35 PM
  • Thank you very much.

    Fixed my issue as well.

    Cheers Adrian


    Cheers

    Adrian Keller

    Senior Systems Engineer / Consultant

    Twitter:   LinkedIn:   XING:

    Note: Posts are provided "AS IS" without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.

    Thursday, March 16, 2017 12:21 PM
  • Sir, you have saved my bacon.  My component statuses have never been so green.  If I could give you 1000 points, I would.  Thank you, thank you, thank you!


    Thursday, February 15, 2018 6:29 PM