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