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