After updating ZRS to use 11.4.2 zrs-resource file, Ad Hoc ZPM reports may fail

  • 7017923
  • 05-Aug-2016
  • 05-Aug-2016

Environment

Novell ZENworks Configuration Management 11.4
Novell ZENworks Patch Management

Situation

ERROR when running AD Hoc report using measures (from jasperserver.log):

Caused by: com.jaspersoft.commons.dataset.DataSetException: Exception calling JRDataSource.next() for query select  top 1000 "PATCHSIGNATURE1"."name" as "PATCHSIGNATURE1_name", 
...
at com.jaspersoft.commons.semantic.dsimpl.JRQueryDataSet$JRDataSetIterator.next(JRQueryDataSet.java:395)
at com.jaspersoft.commons.datarator.CachedData.fetchData(CachedData.java:148)
... 126 more
...
Caused by: java.sql.SQLException: 'z_bo_binaryToHexString' is not a recognized built-in function name.

Resolution

Contact Micro Focus Customer Care ZENworks support for workaround.

Status

Reported to Engineering

Additional Information

https://bugzilla.novell.com/show_bug.cgi?id=986129