Errors with Inv_OS_TimeZone data class when WMI does not have Caption/Description.
After running Hardware Inventory policy on workstation, customer sees the following error in log files and no information appears on Inv_OS_TimeZone for workstation.:
Bad dataloader data : A 'Replace row (rRow)' has been ignored due to missing non-null fields for data class Inv_OS_Timezone (OS Timezone (55c5f30e-b1e8-46ff-802a-1e3dcd9b0da9)) and resource frxpw133, Deleted: FRXPW133 (2d16b327-04dd-478e-9a94-dc9cf5550df1)
Description: AddRow: couldn't add row.
( Exception Details: System.Data.NoNullAllowedException: Column 'Standard Caption' does not allow nulls.
The issue is only with Non-English (French, Swedish) Windows (XP SP3). I have seen the same errors in NS logs in other customers as well (Swedish), so this is not an isolated incident.
Excerpt from the specific Inventory NSE:
<row c0="60" c1="-60" c2="Paris, Madrid" c4="Paris, Madrid" hash="1B2M2Y8AsgTpgAmY7PhCfg=="/>
This data class needs C5 column (Caption, non-Null). As this information is most likely from WMI, I asked customer to get the WMI information on Time Zone - WMI information from customer's problematic computer (3 computers with issue were checked):
WMI information from machine lacks both Description and Caption values, one of these is used for C5 column by Inventory plug-in.
This issue is resolved in the Maintenance Release 4 for the Software Management Solution.
Please review the Altiris™ IT Management Suite 7.0 MR4 from Symantec™ Release Notes for additional details.
Inventory Solution 7.0 SP2