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
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.