Long Description in Custom Report Breaks Web Console Reporting

  • 7000248
  • 30-Apr-2008
  • 27-Apr-2012

Environment

Novell ZENworks 7.5 Asset Management - ZAM7.5
Oracle 10.2

Situation

When a ZAM administrator modifies (or adds) a report with a discription bigger than 4000 characters it is not possible to view or run inventory reports.

The following error is seen:

"...
The data you requested is not available.

Details: [Oracle][ODBC][Ora]ORA-22835: Buffer too small for CLOB to CHAR or
BLOB to RAW conversion (actual: 8271, maximum: 4000)
..."

Resolution

Fixed in ZENworks Asset Management 7.5 Interim Release 12 or newer

Interim Releases can be scheduled to run automatically or can be downloaded manually at Novell Downloads 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 Interim Release xx 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.