Environment
Novell ZENworks 10 Configuration Management with Support Pack 3 Appliance - 10.3 Appliance
Novell ZENworks 10 Configuration Management - ZENworks Diagnostic Center
Situation
ZDC being run against ZCM 10.3.x appliance.
ZENworks Database Verifier
All required tables are found in the database.
Following mismatches were found in tables' structures.
| Severity | Description |
|---|---|
| ERROR | Mismatch in table 'LC_License' structure. Object type: [Column] , Object name:[CalculatedIndex]Expected: [Name: CalculatedIndex, Size: 7, Type: REAL, Nullable: false]Found: [Name: CalculatedIndex, Size: 15, Type: DOUBLE, Nullable: false] |
| ERROR | Mismatch in table 'LC_License' structure. Object type: [Column] , Object name:[ManualIndex]Expected: [Name: ManualIndex, Size: 7, Type: REAL, Nullable: false]Found: [Name: ManualIndex, Size: 15, Type: DOUBLE, Nullable: false] |
| ERROR | Mismatch in table 'NC_CPU' structure. Object type: [Column] , Object name:[Speed]Expected: [Name: Speed, Size: 7, Type: REAL, Nullable: true]Found: [Name: Speed, Size: 15, Type: DOUBLE, Nullable: true] |
| ERROR | Mismatch in table 'NC_Disk' structure. Object type: [Column] , Object name:[RawTotalSpace]Expected: [Name: RawTotalSpace, Size: 7, Type: REAL, Nullable: true]Found: [Name: RawTotalSpace, Size: 15, Type: DOUBLE, Nullable: true] |
| ERROR | Mismatch in table 'NC_Floppy' structure. Object type: [Column] , Object name:[Capacity]Expected: [Name: Capacity, Size: 7, Type: REAL, Nullable: true]Found: [Name: Capacity, Size: 15, Type: DOUBLE, Nullable: true] |
| ERROR | Mismatch in table 'NC_LDAPImportMappings' structure. Object type: [Trigger] , Object name:[tg_NC_LDAPImportMappings_del]Expected: [Name: tg_NC_LDAPImportMappings_del, Table: NC_LDAPImportMappings, Definition hash: f4e4617]Found: [Name: tg_NC_LDAPImportMappings_del, Table: NC_LDAPImportMappings, Definition hash: f37a475f] |
| ERROR | Mismatch in table 'NC_LDAPImportTask' structure. Object type: [Trigger] , Object name:[tg_NC_LDAPImportTask_del]Expected: [Name: tg_NC_LDAPImportTask_del, Table: NC_LDAPImportTask, Definition hash: cf1d42bf]Found: [Name: tg_NC_LDAPImportTask_del, Table: NC_LDAPImportTask, Definition hash: a9344407] |
| ERROR | Mismatch in table 'NC_LogicalDrive' structure. Object type: [Column] , Object name:[AvailableSpace]Expected: [Name: AvailableSpace, Size: 7, Type: REAL, Nullable: true]Found: [Name: AvailableSpace, Size: 15, Type: DOUBLE, Nullable: true] |
| ERROR | Mismatch in table 'NC_LogicalDrive' structure. Object type: [Column] , Object name:[TotalSpace]Expected: [Name: TotalSpace, Size: 7, Type: REAL, Nullable: true]Found: [Name: TotalSpace, Size: 15, Type: DOUBLE, Nullable: true] |
| ERROR | Mismatch in table 'NC_Monitor' structure. Object type: [Column] , Object name:[DiagonalSize]Expected: [Name: DiagonalSize, Size: 7, Type: REAL, Nullable: true]Found: [Name: DiagonalSize, Size: 15, Type: DOUBLE, Nullable: true] |
| ERROR | Mismatch in table 'NC_Product' structure. Object type: [Trigger] , Object name:[tg_NCProduct_del]Expected: [Name: tg_NCProduct_del, Table: NC_Product, Definition hash: 77f149a5]Found: [Name: tg_NCProduct_del, Table: NC_Product, Definition hash: 66b04aed] |
| ERROR | Mismatch in table 'NC_Product' structure. Object type: [Trigger] , Object name:[tg_NCProduct_ins_LocalProduct]Expected: [Name: tg_NCProduct_ins_LocalProduct, Table: NC_Product, Definition hash: dcded722]Found: [Name: tg_NCProduct_ins_LocalProduct, Table: NC_Product, Definition hash: 76c5d86a] |
| ERROR | Mismatch in table 'NC_Product' structure. Object type: [Trigger] , Object name:[tg_NCProduct_Ins_Upd]Expected: [Name: tg_NCProduct_Ins_Upd, Table: NC_Product, Definition hash: d8184f6d]Found: [Name: tg_NCProduct_Ins_Upd, Table: NC_Product, Definition hash: 15ae50b5] |
| ERROR | Mismatch in table 'NC_Product' structure. Object type: [Trigger] , Object name:[tg_NCProduct_upd_LocalProduct]Expected: [Name: tg_NCProduct_upd_LocalProduct, Table: NC_Product, Definition hash: b86d4f8f]Found: [Name: tg_NCProduct_upd_LocalProduct, Table: NC_Product, Definition hash: 941d50d7] |
| ERROR | Mismatch in table 'NC_Workstation' structure. Object type: [Column] , Object name:[TotalHardDiskSpace]Expected: [Name: TotalHardDiskSpace, Size: 7, Type: REAL, Nullable: true]Found: [Name: TotalHardDiskSpace, Size: 15, Type: DOUBLE, Nullable: true] |
| ERROR | Mismatch in table 'NC_Workstation' structure. Object type: [Column] , Object name:[FreeHardDiskSpace]Expected: [Name: FreeHardDiskSpace, Size: 7, Type: REAL, Nullable: true]Found: [Name: FreeHardDiskSpace, Size: 15, Type: DOUBLE, Nullable: true] |
| ERROR | Mismatch in table 'NC_Workstation' structure. Object type: [Column] , Object name:[CPUSpeed]Expected: [Name: CPUSpeed, Size: 7, Type: REAL, Nullable: true]Found: [Name: CPUSpeed, Size: 15, Type: DOUBLE, Nullable: true] |
| ERROR | Mismatch in table 'NC_Workstation' structure. Object type: [Trigger] , Object name:[tg_NC_Workstation_del_setnull]Expected: [Name: tg_NC_Workstation_del_setnull, Table: NC_Workstation, Definition hash: ec85c79]Found: [Name: tg_NC_Workstation_del_setnull, Table: NC_Workstation, Definition hash: 34925dc1] |
| ERROR | Mismatch in table 'PATCHPACKAGE' structure. Object type: [Column] , Object name:[flagBits]Expected: [Name: flagBits, Size: 19, Type: NUMERIC, Nullable: true]Found: [Name: flagBits, Size: 19, Type: NUMERIC, Nullable: false] |
| ERROR | Mismatch in table 'zAdministrator' structure. Object type: [Trigger] , Object name:[tg_zAdministrator_del]Expected: [Name: tg_zAdministrator_del, Table: zAdministrator, Definition hash: 27b84237]Found: [Name: tg_zAdministrator_del, Table: zAdministrator, Definition hash: fd1c437f] |
| ERROR | Mismatch in table 'zDeployment' structure. Object type: [Trigger] , Object name:[tg_zDeployment_del]Expected: [Name: tg_zDeployment_del, Table: zDeployment, Definition hash: 90ed3fb7]Found: [Name: tg_zDeployment_del, Table: zDeployment, Definition hash: 5ec840ff] |
| ERROR | Mismatch in table 'zDevice' structure. Object type: [Trigger] , Object name:[tg_IsRetired_Ins_Upd]Expected: [Name: tg_IsRetired_Ins_Upd, Table: zDevice, Definition hash: 5e61ed8]Found: [Name: tg_IsRetired_Ins_Upd, Table: zDevice, Definition hash: ede2020] |
| ERROR | Mismatch in table 'zDiscoveryTask' structure. Object type: [Trigger] , Object name:[tg_zDiscoveryTask_del]Expected: [Name: tg_zDiscoveryTask_del, Table: zDiscoveryTask, Definition hash: 140e420b]Found: [Name: tg_zDiscoveryTask_del, Table: zDiscoveryTask, Definition hash: e9304353] |
| ERROR | Mismatch in table 'zProxy' structure. Object type: [Trigger] , Object name:[tg_zProxy_del]Expected: [Name: tg_zProxy_del, Table: zProxy, Definition hash: 1f9a3bb9]Found: [Name: tg_zProxy_del, Table: zProxy, Definition hash: e1013d01] |
| ERROR | Mismatch in table 'zReference' structure. Object type: [Trigger] , Object name:[tg_zReference_del]Expected: [Name: tg_zReference_del, Table: zReference, Definition hash: e8cb3e93]Found: [Name: tg_zReference_del, Table: zReference, Definition hash: b3a83fdb] |
| ERROR | Mismatch in table 'zSourceFolder' structure. Object type: [Trigger] , Object name:[tg_zSourceFolder_del]Expected: [Name: tg_zSourceFolder_del, Table: zSourceFolder, Definition hash: 7926410f]Found: [Name: tg_zSourceFolder_del, Table: zSourceFolder, Definition hash: 4b954257] |
All required database Procedures/Views are present in the database.
Following mismatches were found in database Procedures/Views.
| Severity | Description |
|---|---|
| ERROR | Mismatch in View 'ConsumerHierarchies' structure. Expected: [Name: ConsumerHierarchies, Definition hash: 6e8db351]Found: [Name: ConsumerHierarchies, Definition hash: 86bbbd91] |
| ERROR | Mismatch in View 'DeploymentStatusView' structure. Expected: [Name: DeploymentStatusView, Definition hash: c3c77b06]Found: [Name: DeploymentStatusView, Definition hash: c55d868e] |
| ERROR | Mismatch in View 'DeviceParentFolders' structure. Expected: [Name: DeviceParentFolders, Definition hash: d22dcd9a]Found: [Name: DeviceParentFolders, Definition hash: aeb0d172] |
| ERROR | Mismatch in View 'EventParam' structure. Expected: [Name: EventParam, Definition hash: 146dc0d9]Found: [Name: EventParam, Definition hash: 9cebc889] |
| ERROR | Mismatch in View 'LC_CountDPforStandardsView' structure. Expected: [Name: LC_CountDPforStandardsView, Definition hash: 41428fb0]Found: [Name: LC_CountDPforStandardsView, Definition hash: c74b9388] |
| ERROR | Mismatch in View 'ParentFolders' structure. Expected: [Name: ParentFolders, Definition hash: 8a23cbc2]Found: [Name: ParentFolders, Definition hash: fe06d0e2] |
| ERROR | Mismatch in View 'zAssignableContentSyncState' structure. Expected: [Name: zAssignableContentSyncState, Definition hash: 6a1a2e54]Found: [Name: zAssignableContentSyncState, Definition hash: 6457374c] |
| ERROR | Mismatch in Procedure 'adjustVersion' structure. Expected: [Name: adjustVersion, Definition hash: 3332cef6]Found: [Name: adjustVersion, Definition hash: 1a20d03e] |
| ERROR | Mismatch in Procedure 'binaryToHexString' structure. Expected: [Name: binaryToHexString, Definition hash: 9131f1c7]Found: [Name: binaryToHexString, Definition hash: c8d7f30f] |
| ERROR | Mismatch in Procedure 'createLocalCTPZENObject' structure. Expected: [Name: createLocalCTPZENObject, Definition hash: c431d2dd]Found: [Name: createLocalCTPZENObject, Definition hash: 8720d425] |
| ERROR | Mismatch in Procedure 'createQualifiedProductNameString' structure. Expected: [Name: createQualifiedProductNameString, Definition hash: 97b74788]Found: [Name: createQualifiedProductNameString, Definition hash: 90e84988] |
| ERROR | Mismatch in Procedure 'findCTP' structure. Expected: [Name: findCTP, Definition hash: 1176d97d]Found: [Name: findCTP, Definition hash: febddac5] |
| ERROR | Mismatch in Procedure 'formatDeploymentStatus' structure. Expected: [Name: formatDeploymentStatus, Definition hash: c24cc089]Found: [Name: formatDeploymentStatus, Definition hash: 4402c1d1] |
| ERROR | Mismatch in Procedure 'formatMsg' structure. Expected: [Name: formatMsg, Definition hash: 7d5909a2]Found: [Name: formatMsg, Definition hash: e31f0aea] |
| ERROR | Mismatch in Procedure 'formatSeverity' structure. Expected: [Name: formatSeverity, Definition hash: 33d986ef]Found: [Name: formatSeverity, Definition hash: ec498837] |
| ERROR | Mismatch in Procedure 'formattime' structure. Expected: [Name: formattime, Definition hash: 4e8a42b2]Found: [Name: formattime, Definition hash: b34844d1] |
| ERROR | Mismatch in Procedure 'getACObjectSyncState' structure. Expected: [Name: getACObjectSyncState, Definition hash: c38caa8a]Found: [Name: getACObjectSyncState, Definition hash: 71bfabd2] |
| ERROR | Mismatch in Procedure 'getExcluded' structure. Expected: [Name: getExcluded, Definition hash: d82f265b]Found: [Name: getExcluded, Definition hash: d90c27a3] |
| ERROR | Mismatch in Procedure 'getFinalACObjectSyncState' structure. Expected: [Name: getFinalACObjectSyncState, Definition hash: 99ce5197]Found: [Name: getFinalACObjectSyncState, Definition hash: ae3e52df] |
| ERROR | Mismatch in Procedure 'LC_Post_PRU' structure. Expected: [Name: LC_Post_PRU, Definition hash: 972b4206]Found: [Name: LC_Post_PRU, Definition hash: d7d434e] |
| ERROR | Mismatch in Procedure 'LC_Pre_PRU' structure. Expected: [Name: LC_Pre_PRU, Definition hash: 543a5f69]Found: [Name: LC_Pre_PRU, Definition hash: 8c6b60b1] |
| ERROR | Mismatch in Procedure 'RefreshSWCollInstallations' structure. Expected: [Name: RefreshSWCollInstallations, Definition hash: 2b6645af]Found: [Name: RefreshSWCollInstallations, Definition hash: 828246f7] |
| ERROR | Mismatch in Procedure 'RefreshWS_SWCollInstallations' structure. Expected: [Name: RefreshWS_SWCollInstallations, Definition hash: 6d607fb7]Found: [Name: RefreshWS_SWCollInstallations, Definition hash: 92d380ff] |
| ERROR | Mismatch in Procedure 'RenewAllContracts' structure. Expected: [Name: RenewAllContracts, Definition hash: e55e9226]Found: [Name: RenewAllContracts, Definition hash: b4ce936e] |
| ERROR | Mismatch in Procedure 'RenewContract' structure. Expected: [Name: RenewContract, Definition hash: 518af81e]Found: [Name: RenewContract, Definition hash: 8f79f966] |
| ERROR | Mismatch in Procedure 'z_bo_ceiling' structure. Expected: [Name: z_bo_ceiling, Definition hash: d4a927db]Found: [Name: z_bo_ceiling, Definition hash: 55c12923] |
| ERROR | Mismatch in Procedure 'z_bo_changedatetime' structure. Expected: [Name: z_bo_changedatetime, Definition hash: a0d55f0f]Found: [Name: z_bo_changedatetime, Definition hash: e73d6057] |
| ERROR | Mismatch in Procedure 'z_bo_char_length' structure. Expected: [Name: z_bo_char_length, Definition hash: 74da2b54]Found: [Name: z_bo_char_length, Definition hash: 40a2c9c] |
| ERROR | Mismatch in Procedure 'z_bo_charindex' structure. Expected: [Name: z_bo_charindex, Definition hash: 1ddf3fd7]Found: [Name: z_bo_charindex, Definition hash: f608411f] |
| ERROR | Mismatch in Procedure 'z_bo_charindex_xml' structure. Expected: [Name: z_bo_charindex_xml, Definition hash: ccd53a5d]Found: [Name: z_bo_charindex_xml, Definition hash: 8a253ba5] |
| ERROR | Mismatch in Procedure 'z_bo_concat' structure. Expected: [Name: z_bo_concat, Definition hash: e7c4631a]Found: [Name: z_bo_concat, Definition hash: 58836462] |
| ERROR | Mismatch in Procedure 'z_bo_get_value' structure. Expected: [Name: z_bo_get_value, Definition hash: 2d5830c7]Found: [Name: z_bo_get_value, Definition hash: 416d320f] |
| ERROR | Mismatch in Procedure 'z_bo_getDate' structure. Expected: [Name: z_bo_getDate, Definition hash: d7081ec0]Found: [Name: z_bo_getDate, Definition hash: 3d382008] |
| ERROR | Mismatch in Procedure 'z_bo_getenddate' structure. Expected: [Name: z_bo_getenddate, Definition hash: b86b845e]Found: [Name: z_bo_getenddate, Definition hash: ae0385a6] |
| ERROR | Mismatch in Procedure 'z_bo_getstartdate' structure. Expected: [Name: z_bo_getstartdate, Definition hash: abe5ffc9]Found: [Name: z_bo_getstartdate, Definition hash: 835b0120] |
| ERROR | Mismatch in Procedure 'z_bo_isnull' structure. Expected: [Name: z_bo_isnull, Definition hash: af83425f]Found: [Name: z_bo_isnull, Definition hash: 8f6b43a7] |
| ERROR | Mismatch in Procedure 'z_bo_patindex' structure. Expected: [Name: z_bo_patindex, Definition hash: 2fef3da9]Found: [Name: z_bo_patindex, Definition hash: fc903ef1] |
| ERROR | Mismatch in Procedure 'z_bo_removetime' structure. Expected: [Name: z_bo_removetime, Definition hash: ee7aedca]Found: [Name: z_bo_removetime, Definition hash: 36d7ef12] |
| ERROR | Mismatch in Procedure 'z_bo_replace' structure. Expected: [Name: z_bo_replace, Definition hash: 24573ca6]Found: [Name: z_bo_replace, Definition hash: f2403dee] |
| ERROR | Mismatch in Procedure 'z_bo_substring' structure. Expected: [Name: z_bo_substring, Definition hash: f05a3e72]Found: [Name: z_bo_substring, Definition hash: c0e23fba] |
| ERROR | Mismatch in Procedure 'z_bo_substring_xml' structure. Expected: [Name: z_bo_substring_xml, Definition hash: 9e83d4b]Found: [Name: z_bo_substring_xml, Definition hash: d3f93e93] |
| ERROR | Mismatch in Procedure 'zQueuePop' structure. Expected: [Name: zQueuePop, Definition hash: 2e19aea5]Found: [Name: zQueuePop, Definition hash: 6bb9afed] |
Resolution
The errors shown above can safely be ignored when the report is from a ZCM 10.3.x appliance, or if the zone is using an external Sybase database
Additional Information
For information on similar ZDC issues, see TID 7007203 - ZDC mismatches that can safely be ignored