ZENworks Diagnostic Center (ZDC) does not report on Audit Database correctly

  • 7016999
  • 17-Nov-2015
  • 31-May-2016

Environment

Novell ZENworks Configuration Management 11.3 Documentation
Novell ZENworks Configuration Management 11.3 ZENworks Diagnostic Center (ZDC)

Situation

  • Ran ZDC per the README
On Windows: 
zdc.bat verify -b

On Linux:
bash zdc verify -b

For example,
zdc.bat verify -b C:\zdc\data\baseline_11.3.2.zdc
  • ZDC Database Verifier shows multiple inconsistencies and errors for the Audit Database
    • Missing Tables
    • Missing Views
    • Missing Procedures
  • For a searchable list of possible errors, see Additional Information

Resolution

Refer to the documentation rather than the readme.

Verifying Audit Database

To verify the Audit Database schema in ZENworks 11 SP3 by using the ZDC tool:

On Windows: Run the zdc.bat verify -v auditdatabase -b <complete_path_of_the_ZDC_baseline_data_file> command.
On Linux: Run the ./zdc verify -v auditdatabase -b <complete_path_of_the_ZDC_baseline_data_file> command.

Audit and ZENworks databases cannot be verified by running the command in one instance. They need to be verified separately.


Cause

The README does not include the correct instructions for running ZDC against the Audit Database.

Additional Information

Any or all of the following may be listed as errors.

ERROR Missing Table 'AUDIT_EVENT_DEF' 
ERROR Missing Table 'CA_ADMIN' 
ERROR Missing Table 'CA_ADMINGRP' 
ERROR Missing Table 'CA_ADMINROLE' 
ERROR Missing Table 'CA_ADMINUSRGRP' 
ERROR Missing Table 'CA_AGENT_SETTING' 
ERROR Missing Table 'CA_AUDITERROR' 
ERROR Missing Table 'CA_BUNASSOC' 
ERROR Missing Table 'CA_BUNDLES' 
ERROR Missing Table 'CA_BUNFOLDER' 
ERROR Missing Table 'CA_BUNGROUP' 
ERROR Missing Table 'CA_CREDENTIALVAULT' 
ERROR Missing Table 'CA_CREDFOLDER' 
ERROR Missing Table 'CA_DASHBOARD' 
ERROR Missing Table 'CA_DEPLOYMENT' 
ERROR Missing Table 'CA_DEVFOLDER' 
ERROR Missing Table 'CA_DEVGROUP' 
ERROR Missing Table 'CA_DEVICE' 
ERROR Missing Table 'CA_DISCOVERY' 
ERROR Missing Table 'CA_FULLDISKENCRYPT' 
ERROR Missing Table 'CA_LOCASSOC' 
ERROR Missing Table 'CA_LOCATION' 
ERROR Missing Table 'CA_NETWORKENV' 
ERROR Missing Table 'CA_PATCHBUNDLE' 
ERROR Missing Table 'CA_PATCHSIGNATURE' 
ERROR Missing Table 'CA_POLASSOC' 
ERROR Missing Table 'CA_POLFOLDER' 
ERROR Missing Table 'CA_POLGROUP' 
ERROR Missing Table 'CA_POLICY' 
ERROR Missing Table 'CA_PRODUCTLICENSING' 
ERROR Missing Table 'CA_QUERYGROUP' 
ERROR Missing Table 'CA_QUICKTASK' 
ERROR Missing Table 'CA_REGFOLDER' 
ERROR Missing Table 'CA_REGKEY' 
ERROR Missing Table 'CA_REGRULE' 
ERROR Missing Table 'CA_RIGHTROLE' 
ERROR Missing Table 'CA_SERVER_SETTING' 
ERROR Missing Table 'CA_SHARINGSERVER' 
ERROR Missing Table 'CA_SU' 
ERROR Missing Table 'CA_SUBFOLDER' 
ERROR Missing Table 'CA_SUBSCRIPTIONS' 
ERROR Missing Table 'CA_SUSTAGE' 
ERROR Missing Table 'CA_USER' 
ERROR Missing Table 'CA_USERSOURCE' 
ERROR Missing Table 'CA_ZCCLOGIN' 
ERROR Missing Table 'CA_ZENSERVER' 
ERROR Missing Table 'CA_ZESM' 
ERROR Missing Table 'CA_ZONE' 
ERROR Missing Table 'CA_ZSERVER_LDAPSRCCONN_ASSOC' 
ERROR Missing Table 'CACHGS_ADMIN' 
ERROR Missing Table 'CACHGS_ADMINGRP' 
ERROR Missing Table 'CACHGS_ADMINROLE' 
ERROR Missing Table 'CACHGS_ADMINUSRGRP' 
ERROR Missing Table 'CACHGS_AGENT_SETTING' 
ERROR Missing Table 'CACHGS_BUNASSOC' 
ERROR Missing Table 'CACHGS_BUNDLES' 
ERROR Missing Table 'CACHGS_BUNFOLDER' 
ERROR Missing Table 'CACHGS_BUNGROUP' 
ERROR Missing Table 'CACHGS_CREDENTIALVAULT' 
ERROR Missing Table 'CACHGS_CREDFOLDER' 
ERROR Missing Table 'CACHGS_DEPLOYMENT' 
ERROR Missing Table 'CACHGS_DEVFOLDER' 
ERROR Missing Table 'CACHGS_DEVGROUP' 
ERROR Missing Table 'CACHGS_DEVICE' 
ERROR Missing Table 'CACHGS_DISCOVERY' 
ERROR Missing Table 'CACHGS_FULLDISKENCRYPT' 
ERROR Missing Table 'CACHGS_LOCASSOC' 
ERROR Missing Table 'CACHGS_LOCATION' 
ERROR Missing Table 'CACHGS_NETWORKENV' 
ERROR Missing Table 'CACHGS_PATCHBUNDLE' 
ERROR Missing Table 'CACHGS_PATCHSIGNATURE' 
ERROR Missing Table 'CACHGS_POLASSOC' 
ERROR Missing Table 'CACHGS_POLFOLDER' 
ERROR Missing Table 'CACHGS_POLGROUP' 
ERROR Missing Table 'CACHGS_POLICIES' 
ERROR Missing Table 'CACHGS_PRODUCTLICENSING' 
ERROR Missing Table 'CACHGS_QUERYGROUP' 
ERROR Missing Table 'CACHGS_REGFOLDER' 
ERROR Missing Table 'CACHGS_REGKEY' 
ERROR Missing Table 'CACHGS_REGRULE' 
ERROR Missing Table 'CACHGS_RIGHTROLE' 
ERROR Missing Table 'CACHGS_SERVER_SETTING' 
ERROR Missing Table 'CACHGS_SHARINGSERVER' 
ERROR Missing Table 'CACHGS_SU' 
ERROR Missing Table 'CACHGS_SUBFOLDER' 
ERROR Missing Table 'CACHGS_SUBSCRIPTIONS' 
ERROR Missing Table 'CACHGS_SUSTAGE' 
ERROR Missing Table 'CACHGS_USER' 
ERROR Missing Table 'CACHGS_USERSOURCE' 
ERROR Missing Table 'CACHGS_ZCCLOGIN' 
ERROR Missing Table 'CACHGS_ZENSERVER' 
ERROR Missing Table 'CACHGS_ZESM' 
ERROR Missing Table 'CACHGS_ZONE' 
ERROR Missing Table 'CALOB_ADMIN' 
ERROR Missing Table 'CALOB_ADMINGRP' 
ERROR Missing Table 'CALOB_ADMINROLE' 
ERROR Missing Table 'CALOB_ADMINUSRGRP' 
ERROR Missing Table 'CALOB_AGENT_SETTING' 
ERROR Missing Table 'CALOB_BUNASSOC' 
ERROR Missing Table 'CALOB_BUNDLES' 
ERROR Missing Table 'CALOB_BUNFOLDER' 
ERROR Missing Table 'CALOB_BUNGROUP' 
ERROR Missing Table 'CALOB_CREDENTIALVAULT' 
ERROR Missing Table 'CALOB_CREDFOLDER' 
ERROR Missing Table 'CALOB_DEPLOYMENT' 
ERROR Missing Table 'CALOB_DEVFOLDER' 
ERROR Missing Table 'CALOB_DEVGROUP' 
ERROR Missing Table 'CALOB_DEVICE' 
ERROR Missing Table 'CALOB_DISCOVERY' 
ERROR Missing Table 'CALOB_FULLDISKENCRYPT' 
ERROR Missing Table 'CALOB_LOCASSOC' 
ERROR Missing Table 'CALOB_LOCATION' 
ERROR Missing Table 'CALOB_NETWORKENV' 
ERROR Missing Table 'CALOB_PATCHBUNDLE' 
ERROR Missing Table 'CALOB_PATCHSIGNATURE' 
ERROR Missing Table 'CALOB_POLASSOC' 
ERROR Missing Table 'CALOB_POLFOLDER' 
ERROR Missing Table 'CALOB_POLGROUP' 
ERROR Missing Table 'CALOB_POLICIES' 
ERROR Missing Table 'CALOB_PRODUCTLICENSING' 
ERROR Missing Table 'CALOB_QUERYGROUP' 
ERROR Missing Table 'CALOB_REGFOLDER' 
ERROR Missing Table 'CALOB_REGKEY' 
ERROR Missing Table 'CALOB_REGRULE' 
ERROR Missing Table 'CALOB_RIGHTROLE' 
ERROR Missing Table 'CALOB_SERVER_SETTING' 
ERROR Missing Table 'CALOB_SHARINGSERVER' 
ERROR Missing Table 'CALOB_SU' 
ERROR Missing Table 'CALOB_SUBFOLDER' 
ERROR Missing Table 'CALOB_SUBSCRIPTIONS' 
ERROR Missing Table 'CALOB_SUSTAGE' 
ERROR Missing Table 'CALOB_USER' 
ERROR Missing Table 'CALOB_USERSOURCE' 
ERROR Missing Table 'CALOB_ZCCLOGIN' 
ERROR Missing Table 'CALOB_ZENSERVER' 
ERROR Missing Table 'CALOB_ZESM' 
ERROR Missing Table 'CALOB_ZONE' 
ERROR Missing Table 'CONFIGOBJ_REF' 
ERROR Missing Table 'DA_AUDITERROR' 
ERROR Missing Table 'DA_DASHBOARD' 
ERROR Missing Table 'DA_FILEACTDETAILS' 
ERROR Missing Table 'DA_FILEACTSUMMARY' 
ERROR Missing Table 'DA_LOCATIONNECHANGES' 
ERROR Missing Table 'DA_RM_AUTH_FAILURE' 
ERROR Missing Table 'DA_RM_AUTH_SUCCESS' 
ERROR Missing Table 'DA_RM_INTRDT_LCK' 
ERROR Missing Table 'DA_RM_INTRDT_RST' 
ERROR Missing Table 'DA_RMABNORMALTERMINATION' 
ERROR Missing Table 'DA_RMREMOTECONTROL' 
ERROR Missing Table 'DA_RMREMOTEDIAGNOSTICS' 
ERROR Missing Table 'DA_RMREMOTEEXECUTE' 
ERROR Missing Table 'DA_RMREMOTEFTP' 
ERROR Missing Table 'DA_RMREMOTEVIEW' 
ERROR Missing Table 'DA_USERLOGIN' 
ERROR Missing Table 'DA_ZESM_EFFECTIVEPOLICY' 
ERROR Missing Table 'DAACTN_FILEACTDETAILS' 
ERROR Missing Table 'DAACTN_FILEACTSUMMARY' 
ERROR Missing Table 'DAACTN_LOCATIONNECHANGES' 
ERROR Missing Table 'DAACTN_RM_AUTH_FAILURE' 
ERROR Missing Table 'DAACTN_RM_AUTH_SUCCESS' 
ERROR Missing Table 'DAACTN_RM_INTRDT_LCK' 
ERROR Missing Table 'DAACTN_RM_INTRDT_RST' 
ERROR Missing Table 'DAACTN_RMABNORMALTERMINATION' 
ERROR Missing Table 'DAACTN_RMREMOTECONTROL' 
ERROR Missing Table 'DAACTN_RMREMOTEDIAGNOSTICS' 
ERROR Missing Table 'DAACTN_RMREMOTEEXECUTE' 
ERROR Missing Table 'DAACTN_RMREMOTEFTP' 
ERROR Missing Table 'DAACTN_RMREMOTEVIEW' 
ERROR Missing Table 'DAACTN_USERLOGIN' 
ERROR Missing Table 'DAACTN_ZESM_EFFECTIVEPOLICY' 
ERROR Missing Table 'DAEP_BootLocation' 
ERROR Missing Table 'DAEP_FDE' 
ERROR Missing Table 'DAEP_FDEDriveToEncrypt' 
ERROR Missing Table 'DAEP_FDERebootControl' 
ERROR Missing Table 'DAEP_Firewall' 
ERROR Missing Table 'DAEP_FirewallSettingList' 
ERROR Missing Table 'DAEP_HardwareControl' 
ERROR Missing Table 'DAEP_Location' 
ERROR Missing Table 'DAEP_MergeList' 
ERROR Missing Table 'DAEP_Policy' 
ERROR Missing Table 'DAEP_USBControlList' 
ERROR Missing Table 'DAEP_VPNRule' 
ERROR Missing Table 'LOCALUSER_REF' 
ERROR Missing Table 'RM_FILES' 
ERROR Missing Table 'RM_RE_APPLICATION' 
ERROR Missing Table 'RM_RE_COMMANDS' 
ERROR Missing Table 'USERLOGIN_REF' 
ERROR Missing Table 'ZADMINISTRATOR_REF' 
ERROR Missing Table 'ZADMINISTRATORGROUP_REF' 
ERROR Missing Table 'ZADMINISTRATORUSERGROUP_REF' 
ERROR Missing Table 'zAuditPruningLog' 
ERROR Missing Table 'ZBUNDLE_REF' 
ERROR Missing Table 'ZBUNFOLDER_REF' 
ERROR Missing Table 'ZBUNGROUP_REF' 
ERROR Missing Table 'ZCREDENTIALVAULT_REF' 
ERROR Missing Table 'ZDEPLOYMENT_REF' 
ERROR Missing Table 'ZDEVFOLDER_REF' 
ERROR Missing Table 'ZDEVGROUP_REF' 
ERROR Missing Table 'ZDEVICE_REF' 
ERROR Missing Table 'ZDISCOVERYTASK_REF' 
ERROR Missing Table 'ZESMForeignKeyLists_Ref' 
ERROR Missing Table 'ZEXTERNALCREDENTIAL_REF' 
ERROR Missing Table 'ZEXTERNALCREDENTIALFOLDER_REF' 
ERROR Missing Table 'ZFOLDER_REF' 
ERROR Missing Table 'ZLDAPSOURCE_REF' 
ERROR Missing Table 'ZLDAPSOURCECONNECTION_REF' 
ERROR Missing Table 'ZLICENSEINFO_REF' 
ERROR Missing Table 'ZLOCATION_REF' 
ERROR Missing Table 'ZNWENV_REF' 
ERROR Missing Table 'ZOPAQUEDATA_REF' 
ERROR Missing Table 'ZPATCHBUNDLE_REF' 
ERROR Missing Table 'ZPATCHSIGNATURE_REF' 
ERROR Missing Table 'ZPOLFOLDER_REF' 
ERROR Missing Table 'ZPOLGROUP_REF' 
ERROR Missing Table 'ZPOLICY_REF' 
ERROR Missing Table 'ZPROCESS_REF' 
ERROR Missing Table 'ZQUERYGROUP_REF' 
ERROR Missing Table 'ZQUICKTASK_REF' 
ERROR Missing Table 'ZREGISTRATIONFOLDER_REF' 
ERROR Missing Table 'ZREGISTRATIONKEY_REF' 
ERROR Missing Table 'ZREGISTRATIONRULE_REF' 
ERROR Missing Table 'ZROLE_REF' 
ERROR Missing Table 'ZSERVER_REF' 
ERROR Missing Table 'ZSUBFOLDER_REF' 
ERROR Missing Table 'ZSUBSCRIPTION_REF' 
ERROR Missing Table 'ZSUSTAGE_REF' 
ERROR Missing Table 'ZSYSTEMSETTING_REF' 
ERROR Missing Table 'ZSYSTEMUPDATEEX_REF' 
ERROR Missing Table 'ZUSERASSIGNMENT_REF' 
ERROR Missing Table 'ZZENUSERGROUP_REF' 
ERROR Missing Table 'ZZONE_REF' 
ERROR Missing View 'VW_ALL_SUMMARY' 
ERROR Missing View 'VW_CA_DETAIL' 
ERROR Missing View 'VW_CA_SUMMARY' 
ERROR Missing View 'VW_DA_SUMMARY' 
ERROR Missing Procedure 'z_Audit_Pruning' 
ERROR Missing Procedure 'z_DashboardAuditEventPruning' 

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