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
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


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]


HP Client Manager Report Pack 6.2.1007


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


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

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

Legacy ID


Article URL

Terms of use for this information are found in Legal Notices