Unable to create Custom Reports based on Serial Ports

  • 3008301
  • 06-Jul-2006
  • 27-Apr-2012

Environment


Novell ZENworks Asset Management 7 - ZAM7

Situation

Creating a custom report based on Serial Ports results in the following error message:

ERROR: [Microsoft][ODBC SQL Driver][SQL Server]Invalid Object Name'nc_serport'

Resolution

Fixed in rtrlet.war in zam700sp1p6.exe or newer. This patch can be found at the Novell Product Updates https://support.novell.com/filefinder

Additional Information

Steps to Duplicate

1) Open the Web Console.
2) Create a Custom Hardware Report.
3) Type is Hardware Component and Focus is Serial Port.
4) Keep the default Columns and Criteria.
5) Save the Report and Run it.

Root Cause

The table within the ZENworks Asset Management Database is called NC_SerialPort