ORA-00907 error occurs when running a custom report

  • 7012072
  • 03-Apr-2013
  • 30-Oct-2013


Novell ZENworks Configuration Management 11.2.3 Inventory
Oracle Database


When running a custom report in ZCC, the following error may occur:
The data you requested is not available.
Details: ORA-00907: missing right parenthesis


This is fixed in version 11.2.4 - see KB 7012027 "ZENworks Configuration Management 11.2.4 - update information and list of fixes" which can be found at https://support.microfocus.com/kb/doc.php?id=7012027

Workaround: if it is not possible to upgrade to ZCM11.2.4 at this time, in the interim, Novell has made a Patch available for testing, in the form of a Field Test File (FTF): it can be obtained at https://download.novell.com/Download?buildid=hGn-vRec0UY~ as "ZCM 11.2.3a fix for six reporting problems". This Patch should only be applied if the symptoms above are being experienced, and are causing problems.

This Patch has had limited testing, and should not be used in a production system without first being checked in a test environment. Some Patches have specific requirements for deployment, it is very important to follow any instructions in the readme at the download site. Please report any problems encountered when using this Patch, by using the feedback link on this TID.