Heap errors running ZRS Patch Management reports

  • 7011379
  • 15-Nov-2012
  • 17-Sep-2013

Environment

Novell ZENworks Configuration Management 11.2

Situation

Running ZRS Patch Management reports may cause java heap errors.
 
ERROR:
 
WIS 10901
A database error occured. The database error text is: (CS) "Unexpected behavior : Java heap

Resolution

Workarounds:

Create custom report and view sql.  Use a sql tool to run the report and export as csv.

or
 
Make a custom report in the Custom Reports folder.  Edit that report and modify to add a filter to remove patches with status "Not Applicable" from the report.  If that does not resolve, the report can be targeted further by filtering on patch vendor, release date, specific patch, etc.  These reports will need to restrict the number of possible records returned.
 
Example:

 
 
Generate report:

 
 

Cause

This is caused by having too many records returned.   To confirm, copy the report to Custom Reports folder, edit the report query and view the sql.  Use a sql tool to run the same sql to confirm how many records are returned.