ZDC reporting missing table(s) when installed to Oracle, but not if installed to Sybase.

  • 7006264
  • 13-Jun-2010
  • 27-Apr-2012

Environment

Novell ZENworks 10 Configuration Management with Support Pack 3 - 10.3
ZENworks Diagnostic Center (ZDC)
ZDC 10.3.0 template (zdc_zcm_10.3.0.zip)
Oracle

Situation

A new installation of ZCM 10.3 to an environment using Oracle for the database is reported by ZDC and the 10.3.0 .zdc template as missing table(s).
A new install to Sybase does not result in the ZDC reporting the same missing table(s).
No ZCM functionality seems affected.
No ZCM errors related to the missing tables found.

Resolution

 The ZDC reporting the missing verified temporary Oracle table(s) can be ignored.
 
This is fixed in version 10.3.2 - see KB 7007237 "ZENworks Configuration Management 10.3.2 - update information and list of fixes" which can be found at https://www.novell.com/support

Additional Information

This is a bug in ZDC as it included temporary Oracle tables in the schema while computing the database metadata.  The only temporary Oracle table(s) not part of the ZCM 10.3 database architecture reported to Novell:

Example:

Missing Table 'HT_LC_TALLYPRODUCT'
Detail:
Name: HT_LC_TALLYPRODUCT
Columns:
Name: ZUID, Size: 16, Type: VARBINARY, Nullable: false
 
Any other Oracle table reported missing should be considered non-temporary till verified being a temporary Oracle table.

Feedback service temporarily unavailable. For content questions or problems, please contact Support.