<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 12 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">Content provider shows ‘Unknown’. It looks like there is a new key for the SLES 12 packages and the database does not have the provider_id updated.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">rhnschema=# select * from rhnPackageKey where key_id='70af9e8139db7c82';<o:p></o:p></p>
<p class="MsoNormal"> id | key_id | key_type_id | provider_id | created | modified<o:p></o:p></p>
<p class="MsoNormal">------+------------------+-------------+-------------+-------------------------------+-------------------------------<o:p></o:p></p>
<p class="MsoNormal">8071 | 70af9e8139db7c82 | 100 | | 2015-02-06 12:26:24.177063-05 | 2015-02-06 12:26:24.177063-05<o:p></o:p></p>
<p class="MsoNormal">(1 row)<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I assume the provider_id should be set to “104” (SUSE).<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">rhnschema=# select * from rhnPackageProvider;<o:p></o:p></p>
<p class="MsoNormal">id | name | created | modified<o:p></o:p></p>
<p class="MsoNormal">-----+------------------+-------------------------------+-------------------------------<o:p></o:p></p>
<p class="MsoNormal">100 | Red Hat Inc. | 2013-10-04 09:03:54.363614-04 | 2013-10-04 09:03:54.363614-04<o:p></o:p></p>
<p class="MsoNormal">101 | Fedora | 2013-10-04 09:03:54.364624-04 | 2013-10-04 09:03:54.364624-04<o:p></o:p></p>
<p class="MsoNormal">102 | CentOS | 2013-10-04 09:03:54.36832-04 | 2013-10-04 09:03:54.36832-04<o:p></o:p></p>
<p class="MsoNormal">103 | Scientific Linux | 2013-10-04 09:03:54.370044-04 | 2013-10-04 09:03:54.370044-04<o:p></o:p></p>
<p class="MsoNormal">104 | SUSE | 2013-10-04 09:03:54.370795-04 | 2013-10-04 09:03:54.370795-04<o:p></o:p></p>
<p class="MsoNormal">105 | Oracle Inc. | 2013-10-04 09:03:54.371497-04 | 2013-10-04 09:03:54.371497-04<o:p></o:p></p>
<p class="MsoNormal">106 | Spacewalk | 2013-10-04 09:03:54.37216-04 | 2013-10-04 09:03:54.37216-04<o:p></o:p></p>
<p class="MsoNormal">107 | EPEL | 2013-10-04 09:03:54.372829-04 | 2013-10-04 09:03:54.372829-04<o:p></o:p></p>
<p class="MsoNormal">108 | Novell Inc. | 2013-10-04 09:03:54.373591-04 | 2013-10-04 09:03:54.373591-04<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Chris Will<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>
<BR>
<html>
<p>The information contained in this communication is highly confidential and is intended solely for the use of the individual(s) to whom this communication is directed. If you are not the intended recipient, you are hereby notified that any viewing, copying, disclosure or distribution of this information is prohibited. Please notify the sender, by electronic mail or telephone, of any unintended receipt and delete the original message without making any copies.</p>
<p>Blue Cross Blue Shield of Michigan and Blue Care Network of Michigan are nonprofit corporations and independent licensees of the Blue Cross and Blue Shield Association.</p>
</html>