SMS Inventory Tool for HP ProLiant and Integrity Update User Guide

Errors and inconsistencies for compliance and requested status in Reports and the
DSUW
Issue: Compliant and Requested status in HP Reports show incorrect information because of NULL SMS
database entries. The incorrect status also reports in the DSUW. When an HP compliance report runs, a
list of software components displays with columns "Requested" and "Compliant," indicating the number of
non-compliant and compliant clients, respectively, for a particular software update. When you click an
entry in the first column to drill down for details, the next page reveals an inconsistent count of non-
compliant and compliant clients when compared to the previous page. This is also true for other reports.
If this issue occurs, the SMS database will show duplicate entries on the UpdateSummary table. One entry
is inserted by the sync tool and a second entry is inserted after the scan tool runs. The second entry
contains <NULL> for the Type field.
Workaround: Use the default values for database name, scan package name, and sync package
name during installation to ensure that SMS constructs the tables correctly.
Troubleshooting 72