ZDC Reports Missing Views and Functions on ZENworks 11.2.4

  • 7014762
  • 19-Mar-2014
  • 18-Jun-2014

Environment

Novell ZENworks Configuration Management 11.2.4 Database
Microsoft SQL Server Database (MS SQL)

Situation

Running ZENworks Diagnostic Center (ZDC) after upgrading to ZENworks 11.2.4
Running ZDC while upgrading from ZENworks 11.2.4

The following is seen in the ZDC report:

Following Procedures/Views are missing.

Severity Description
ERROR Missing View 'zContent_VW'
Detail: Name: zContent_VW, Definition hash: eaf57395
ERROR Missing View 'zLinkedObject_VW'
Detail: Name: zLinkedObject_VW, Definition hash: 457b1aa1
ERROR Missing Procedure 'z_bo_getdevicefolder'
Detail: Name: z_bo_getdevicefolder, Definition hash: 4c0c4d10
ERROR Missing Procedure 'z_bo_getpath'
Detail: Name: z_bo_getpath, Definition hash: 2efe32c9

Following mismatches were found in database Procedures/Views.

Severity Description
ERROR Mismatch in View 'ZRS_ASSIGNABLECONS' structure.
Expected: [Name: ZRS_ASSIGNABLECONS, Definition hash: c9a7054c ]
Found: [Name: zrs_assignablecons, Definition hash: cd62feaf]
ERROR Mismatch in View 'zrs_assignment' structure.
Expected: [Name: zrs_assignment, Definition hash: 6c3ecaf8 ]
Found: [Name: zrs_assignment, Definition hash: 8c28ddf8]

Resolution

Contact Novell support for a database script that will resolve this issue.