Error trying to run a report from web console 'nc_workstation.AssetType' is invalid in the select list..

  • Document ID:3006432
  • Creation Date:12-Jun-2007
  • Modified Date:27-Apr-2012
    • Micro Focus Products:
      ZENworks Asset Management

Environment

Novell ZENworks 7 Asset Management - ZAM7
IR 12

Situation

In the webconsole reports tab an error occurs " Details: [Microsoft][ODBC SQL Server Driver][SQL Server]Column 'nc_workstation.AssetType' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause."

Resolution

Fixed in ZENWorks 7 Asset Management Interim Release 13 or newer
Interim Releases can be scheduled to run automatically or can be downloaded manually at https://download.novell.com. The Interim releases can be set up within the ZAM Manager for the Task server to check the site on a scheduled basis, and download and apply them automatically. Please refer to the Help Section details of how to set up automatic downloads if desired.

Each interim release is cumulative. If the Interim Release is not available due to a newer interim release being placed on the website, be assured that the code needed is in the later release.