5 Replies Latest reply on Dec 7, 2016 8:45 AM by rdavidson

    In OemCatalog.zip, in  detectableProducts.xml , SP mapping is missing for sp id 5124 against affectedProduct ids 8803 and 8804, also sp id 5126 against affectedProduct ids 8813 and 8814.

    rmethwan Rookie

      In OemCatalog.zip, in detectableProducts.xml, service pack mapping is missing for some affected product for SQL SERVER 2014.

       

      To understand this please find below findings. Refer patch ids 95604,  95605, 95606 and 95607 in bulletinMetaData.xml.

      These all patch ids belongs to bulletin id="MS16-136" which is released 8th NOV 2016.

       

      In patch id 95604 and 95606, I can see below entry:

      <affectedProduct id="8813" fixedInServicePack="0">

                      <servicePack id="5126" dependencyId="581" />

      </affectedProduct>

      <affectedProduct id="8814" fixedInServicePack="0">

                      <servicePack id="5126" dependencyId="581" />

      </affectedProduct>

       

      And in patch id 95605 and 95607, I can see below entry:

      <affectedProduct id="8803" fixedInServicePack="0">

                      <servicePack id="5124" dependencyId="581" />

      </affectedProduct>

      <affectedProduct id="8804" fixedInServicePack="0">

                      <servicePack id="5124" dependencyId="581" />

      </affectedProduct>

       

      But when I am going to find sp id 5124 against affectedProduct ids 8803 and 8804, also sp id 5126 against affectedProduct ids 8813 and 8814 in detectableProducts.xml, then I didn’t get this mapping. I can see below entries there:

       

      <product id="8803" name="SQL Server 2014 Reporting Services" vendorId="1" categoryId="4" category="SQL Server" latestSpId="4851"

                lifeCycleUrl="http://support.microsoft.com/lifecycle/?p1=17645">

                <sp id="4851" name="Gold" ordinal="0" endOfLife="2016-07-12" />

      </product>

      <product id="8804" name="SQL Server 2014 Analysis Services" vendorId="1" categoryId="4" category="SQL Server" latestSpId="4851"

                lifeCycleUrl="http://support.microsoft.com/lifecycle/?p1=17645">

                <sp id="4851" name="Gold" ordinal="0" endOfLife="2016-07-12" />

      </product>

      <product id="8813" name="SQL Server 2014 Reporting Services x64" vendorId="1" categoryId="4" category="SQL Server" latestSpId="4853"

                lifeCycleUrl="http://support.microsoft.com/lifecycle/?p1=17645">

                 <sp id="4853" name="Gold" ordinal="0" endOfLife="2016-07-12" />

      </product>

      <product id="8814" name="SQL Server 2014 Analysis Services x64" vendorId="1" categoryId="4" category="SQL Server" latestSpId="4853"

                lifeCycleUrl="http://support.microsoft.com/lifecycle/?p1=17645">

                <sp id="4853" name="Gold" ordinal="0" endOfLife="2016-07-12" />

      </product>

       

      So overall I wanted to raise that mapping is missing in detectableProducts.xml for sp id 5124 against affectedProduct ids 8803 and 8804, also sp id 5126 against affectedProduct ids 8813 and 8814.Can you please take this on priority as its impacting many our customers.