<html><body>
<p><font size="2" face="sans-serif">Software Use Analysis 9.1 patch 2</font><br>
<br>
<font size="2" face="sans-serif">IBM is pleased to announce that patch 2 for IBM Endpoint Manager for Software Use Analysis 9.1 is available.</font><br>
<font size="2" face="sans-serif">Site version updated: 22</font><br>
<br>
<font size="2" face="sans-serif">This readme file provides information about patch 2 for Software Use Analysis 9.1. Review this file thoroughly before you install or use the patch.</font><br>
<br>
<br>
<table class="table" width="100%" border="1">
<tr valign="top"><td id="d67e58" class="entry" width="7%" valign="bottom">
<ul style="padding-left: 4pt"><font size="2" face="sans-serif">APAR</font></ul>
</td><td id="d67e60" class="entry" width="37%" valign="bottom"><div align="center"><font size="2" face="sans-serif">Symptoms</font></div></td><td id="d67e62" class="entry" width="51%" valign="bottom"><div align="center"><font size="2" face="sans-serif">Behavior after applying the patch</font></div></td><td id="d67e64" class="entry" width="6%" valign="bottom"><div align="center"><font size="2" face="sans-serif">Available since</font></div></td></tr>
<tr valign="top"><td class="entry" width="7%">
<ul style="padding-left: 4pt"><font size="2" face="sans-serif">IV59196</font></ul>
</td><td class="entry" width="37%">
<ul style="padding-left: 4pt"><font size="2" face="sans-serif">When you open the Computers report, you see the date of the latest import of the scan data for each computer. However, when you open the details for a single computer, there is no date in the Latest Scan Import section.</font></ul>
</td><td class="entry" width="51%">
<ul style="padding-left: 4pt"><font size="2" face="sans-serif">The date of the last import of scan data is visible both on the Computers panel and on the details page for a single computer. </font></ul>
</td><td class="entry" width="6%"><div align="center"><font size="2" face="sans-serif">Patch 2</font></div></td></tr>
<tr valign="top"><td class="entry" width="7%">
<ul style="padding-left: 4pt"><font size="2" face="sans-serif">IV59260</font></ul>
</td><td class="entry" width="37%">
<ul style="padding-left: 4pt"><font size="2" face="sans-serif">All virtual machines have the </font><font size="2" face="sans-serif"><i>No VM Manager Data</i></font><font size="2" face="sans-serif"> status.</font></ul>
</td><td class="entry" width="51%">
<ul style="padding-left: 4pt"><font size="2" face="sans-serif">The problem occurs when you move the VM Manager Tool from the Endpoint Manager server to the BESRelay server. After you install the patch, VM manager data is gathered the virtual machines.</font></ul>
</td><td class="entry" width="6%"><div align="center"><font size="2" face="sans-serif">Patch 2</font></div></td></tr>
<tr valign="top"><td class="entry" width="7%">
<ul style="padding-left: 4pt"><font size="2" face="sans-serif">IV59559</font></ul>
</td><td class="entry" width="37%">
<ul style="padding-left: 4pt"><font size="2" face="sans-serif">Import of the data fails and the following entry is written in the import log:</font><br>
<font size="2" face="sans-serif">ERROR: Sequel::DatabaseError: NativeException:<br>
com.ibm.db2.jcc.am.SqlDataException: Value "514832613 "<br>
is too long. SQLCODE=-433, SQLSTATE=22001, DRIVER=3.64.104</font></ul>
</td><td class="entry" width="51%">
<ul style="padding-left: 4pt"><font size="2" face="sans-serif">The problem occurs because the sequence number is too long. After you install the patch, sequence numbers that are too long are properly handled.</font></ul>
</td><td class="entry" width="6%"><div align="center"><font size="2" face="sans-serif">Patch 2</font></div></td></tr>
<tr valign="top"><td class="entry" width="7%">
<ul style="padding-left: 4pt"><font size="2" face="sans-serif">IV59904</font></ul>
</td><td class="entry" width="37%">
<ul style="padding-left: 4pt"><font size="2" face="sans-serif">Import of the data fails and the following entry is written in the import log:</font><br>
<font size="2" face="sans-serif">ERROR: Sequel::DatabaseError: NativeException: <br>
com.ibm.db2.jcc.am.SqlException: An error occurred in <br>
a triggered SQL statement in trigger "DBO.DATASOURCE_G".</font></ul>
</td><td class="entry" width="51%">
<ul style="padding-left: 4pt"><font size="2" face="sans-serif">The problem occurs when a computer is inserted, updated, or deleted a few times in the same sequence. After you install the patch, computers whose membership is altered multiple times in one sequence are properly handled.</font></ul>
</td><td class="entry" width="6%"><div align="center"><font size="2" face="sans-serif">Patch 2</font></div></td></tr>
<tr valign="top"><td class="entry" width="7%">
<ul style="padding-left: 4pt"><font size="2" face="sans-serif">IV60004</font></ul>
</td><td class="entry" width="37%">
<ul style="padding-left: 4pt"><font size="2" face="sans-serif">Import of the data fails and the following entry is written in the import logs: </font><br>
<font size="2" face="sans-serif">ERROR: Sequel::DatabaseError: NativeException: <br>
com.ibm.db2.jcc.am.BatchUpdateException <br>
[jcc][t4][102][10040][3.64.104]<br>
Batch failure. The batch was submitted but at least one<br>
exception occurred on an individual member of the batch.<br>
Use getNextException() to retrieve the exceptions <br>
for specific batch elements. ERRORCODE=-4229, SQLSTATE=null.</font></ul>
</td><td class="entry" width="51%">
<ul style="padding-left: 4pt"><font size="2" face="sans-serif">The problem occurs because a registry entry is too long to be inserted into the database column. After you install the patch, names of registries that are too long are modified to fit into the table column.</font></ul>
</td><td class="entry" width="6%"><div align="center"><font size="2" face="sans-serif">Patch 2</font></div></td></tr>
<tr valign="top"><td class="entry" width="7%">
<ul style="padding-left: 4pt"><font size="2" face="sans-serif">IV60056</font></ul>
</td><td class="entry" width="37%">
<ul style="padding-left: 4pt"><font size="2" face="sans-serif">Import log contains entries that include the following message:</font><br>
<font size="2" face="sans-serif">Cause was: undefined method `[]` for nil:NIlClass</font></ul>
</td><td class="entry" width="51%">
<ul style="padding-left: 4pt"><font size="2" face="sans-serif">The uninformative log entry is substituted with information that a UNIX package fact was skipped because it contained an empty value. </font></ul>
</td><td class="entry" width="6%"><div align="center"><font size="2" face="sans-serif">Patch 2</font></div></td></tr>
<tr valign="top"><td class="entry" width="7%">
<ul style="padding-left: 4pt"><font size="2" face="sans-serif">IV60188</font></ul>
</td><td class="entry" width="37%">
<ul style="padding-left: 4pt"><font size="2" face="sans-serif">Import of the data hangs at 98%. </font></ul>
</td><td class="entry" width="51%">
<ul style="padding-left: 4pt"><font size="2" face="sans-serif">The problem occurs because BIOS serial numbers are not unique. After you install the patch, uniqueness of serial numbers is checked during each import. If a value from BIOS was already encountered for a different system that is processed during the import, subsequent systems have their unique agent IDs appended to the serial number from BIOS. This solution allows for completing the data import. However, on the subsequent imports, the serial numbers might be processes in a different order and the agent ID might be appended to a different serial number. It might lead to data inconsistence. After you install the patch, the import finishes. However, you must ensure that unique IDs are assigned BIOS serial numbers.</font></ul>
</td><td class="entry" width="6%"><div align="center"><font size="2" face="sans-serif">Patch 2</font></div></td></tr>
<tr valign="top"><td class="entry" width="7%">
<ul style="padding-left: 4pt"><font size="2" face="sans-serif">IV60780</font></ul>
</td><td class="entry" width="37%">
<ul style="padding-left: 4pt"><font size="2" face="sans-serif">Scan data is not imported to Software Use Analysis.</font></ul>
</td><td class="entry" width="51%">
<ul style="padding-left: 4pt"><font size="2" face="sans-serif">The problem occurs because the URL for downloading scan files from the Endpoint Manager server contains duplicated slashes. After you install the patch, the duplicated slashes are removed and scan data is properly downloaded.</font></ul>
</td><td class="entry" width="6%"><div align="center"><font size="2" face="sans-serif">Patch 2</font></div></td></tr>
</table>
<br>
<font size="2" face="sans-serif">Installing the patch</font>
<p><font size="2" face="sans-serif">To obtain the upgrade installer, log in to the Endpoint Manager console, and click Sites > External Sites > IBM Endpoint Manager for Software Use Analysis v9 > Upgrade to Software Use Analysis 9.1-20140604-1739.</font>
<p><font size="2" face="sans-serif">To obtain a fresh installer for Software Use Analysis that already contains the fixes that are introduced in the patch, log in to the Endpoint Manager console, and click Sites > External Sites > IBM Endpoint Manager for Software Use Analysis v9 > Dashboards > Software Use Analysis 9.0.</font>
<p>
<p><font size="2" face="sans-serif">IEM Software Use Analysis Team</font>
<p><font size="3" color="#19A9F3" face="serif">_________________________________________________________</font><font size="1" color="#808080" face="Arial"><b><br>
</b></font><font size="1" face="sans-serif">Charlie Crawford</font><br>
<font size="1" face="Arial">TAD4D/LMT L3 Team Lead - U.S. & Canada</font><font size="1" color="#808080" face="Arial"><br>
</font><font size="1" face="sans-serif">Advisory Software Engineer</font><font size="1" color="#808080" face="Arial"><br>
</font><font size="1" face="sans-serif">IBM Software | Cloud and Smarter Infrastructure</font><font size="1" color="#808080" face="Arial"><br>
</font><font size="1" face="sans-serif">t: (720)395-8247<br>
e: ccraw@us.ibm.com</font><font size="1" color="#0000FF" face="Arial"><u><br>
</u></font><a href="http://www.ibm.com/software/tivoli" target="_new"><font size="1" color="#0000FF" face="Arial"><u>Cloud & Smarter Infrastructure</u></font></a><font size="1" color="#808080" face="Arial"><br>
</font><font size="1" color="#0000FF" face="Arial"><u><br>
</u></font><a href="http://www.ibm.com/software/tivoli" target="_new"><img src="cid:1__=0ABBF665DFCAD5A38f9e8a93df938@us.ibm.com" width="550" height="85" border="0"></a></body></html>