KNOWN ISSUE: Total Memory reports return SQL Error "'Arithmetic overflow error converting expression to data type int''

Article:TECH39584  |  Created: 2008-03-07  |  Updated: 2008-04-29  |  Article URL http://www.symantec.com/docs/TECH39584
NOTE: If you are experiencing this particular known issue, we recommend that you Subscribe to receive email notification each time this article is updated. Subscribers will be the first to learn about any releases, status changes, workarounds or decisions made.
Article Type
Technical Solution


Issue



Executing the HP Client Manager "Managed Computers by Total Memory" and "Managed Computers by Total Memory (Count)" reports produces the following SQL Error:

Sql error in query. Error: System.Data.SqlClient.SqlError: Arithmetic overflow error converting expression to data type int.Sql CommandText: -- MAX ROWCOUNT SET ROWCOUNT 50000 -- SELECT i.[Name], SUM(CAST(mem.Capacity AS int) / 1048576) AS 'Total Memory' FROM Inv_AeX_AC_Identification i JOIN Inv_HPCMS_WMI_Win32_PhysicalMemory mem ON i.[_ResourceGuid] = mem.[_ResourceGuid] GROUP BY i.[Name] ORDER BY SUM(CAST(mem.Capacity AS int) / 1048576), i.[Name]


Environment



HP Client Manager Report Pack 6.2.1007

Cause



Both reports are not able to take into account HP hardware with 2 GB dimms. 


Solution



To work around this problem, follow these steps:
  1. Download the modified HP Client Manager reports to the right and save on the Notification Server.
  2. In the Console, browse to Reports > By Solution > HP Client Manager > HP Client Inventory.
  3. Right-click HP Client Inventory folder and click Import.
  4. In the new window, browse to the modified report and click Open.

You will need to repeat step 3 and select the second report. The new reports will appear in the navigation pane as soon as the import is complete.


Supplemental Materials

SourceDEFECT
ValueLB 67843
DescriptionLogged in Littlebuggy (Altiris - Lindon, Plymouth) database

Legacy ID



40800


Article URL http://www.symantec.com/docs/TECH39584


Terms of use for this information are found in Legal Notices