markvh Super Contributor.
Super Contributor.
734 views

ZCM 11.3 to ZCM 11 SP4 Update ZDC results

Hi there

Running ZDC to verify the MS SQL database prior to our upgrade I see the following two errors.

Is this serious enough to stop the upgrade with issues or can I still proceed.
ZCM 11.3 to 11.4 first to be done and then (Post 11.4 then to 11.4.1)

ZENworks Database Verifier

All required tables are found in the database.

Following objects missing are in tables' structures.
Missing object in table 'zQuickTaskAssignment'
Object type: [Constraint] , Object name: [fk_zQuickTaskAssignment_auxid]
Detail: [Name: fk_zQuickTaskAssignment_auxid, Type: FOREIGN KEY, Table: zQuickTaskAssignment]


Following mismatches were found in tables' structures.
Mismatch in table 'zSystemUpdateLocation' structure.
Object type: [Column] , Object name: [alternateLocation]
Expected: [Name: alternateLocation, Size: 1073741823, Type: CLOB, Nullable: false]
Found: [Name: alternateLocation, Size: 1073741823, Type: CLOB, Nullable: true]

All required database Procedures/Views are present in the database.
Labels (2)
0 Likes
2 Replies
Knowledge Partner
Knowledge Partner

Re: ZCM 11.3 to ZCM 11 SP4 Update ZDC results

Markvh,
> Following mismatches were found in tables' structures.
> Mismatch in table 'zSystemUpdateLocation' structure.
> Object type: [Column] , Object name: [alternateLocation]
> Expected: [Name: alternateLocation, Size: 1073741823, Type: CLOB,
> Nullable: false]
> Found: [Name: alternateLocation, Size: 1073741823, Type: CLOB, Nullable:
> true]


Those are generally benign. Let me ask about that other one.

--
Anders Gustafsson (NKP)
The Aaland Islands (N60 E20)

Have an idea for a product enhancement? Please visit:
https://www.novell.com/products/enhancement-request.html

0 Likes
Knowledge Partner
Knowledge Partner

Re: ZCM 11.3 to ZCM 11 SP4 Update ZDC results

Here is what I got back:

"
I doubt the QuickTask table would impact the Upgrade itself.
Customer could run a scan after the upgrade and worry (or not) then."

--
Anders Gustafsson (NKP)
The Aaland Islands (N60 E20)

Have an idea for a product enhancement? Please visit:
https://www.novell.com/products/enhancement-request.html

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.