Environment
Novell ZENworks Configuration Management 11.4
Novell ZENworks Patch Management
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 EngineeringAdditional Information
https://bugzilla.novell.com/show_bug.cgi?id=986129