ZDC Reports Missing Views and Functions on ZENworks 11.2.4

Document ID:7014762
Creation Date:19-Mar-2014
Modified Date:18-Jun-2014
- Micro Focus Products:
  ZENworks Configuration Management

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.