Highlighted
Absent Member.
Absent Member.
1364 views

ZCM 10.3.4 to 11 SP2 fails to upgrade database

I am trying to upgrade my single SLES 11 SP1 server from ZCM 10.3.4 to 11.2. I have an embedded Sybase created through the original installation.

If I run the downloadable ZDC I get told I have no DB problems but if I run zdc_verifyDB from the ZCM 11 ISO I get lots of errors (sample below). The errors all seem to be along the lines of many of the fields in many but not all tables in my DB have a length of 0 and a type of NULL. Views and Procedures are fine though.

This thing is a VM and I cloned it before trying the install anyway, which spat out errors relating to the DB (can't remember the exact errors and I have recovered from my clone)

I'd be grateful for any help.

Cheers
Jon


[DEBUG] [TableHelper] Verifying table 'BASELINEGROUP'
[TRACE] [DBObjectComparer] Comparing Columns
[TRACE] [DBObjectComparer] Column 'BASELINE_ID' is okay.
[TRACE] [DBObjectComparer] Column 'groupUID' is okay.
[TRACE] [DBObjectComparer] Comparing Indexes
[TRACE] [DBObjectComparer] Index 'BASELINEGROUP UNIQUE (groupUID)' is okay.
[TRACE] [DBObjectComparer] Comparing Constraints
[TRACE] [DBObjectComparer] Comparing Triggers
[DEBUG] [TableHelper] Verifying table 'BaseLineGroupPatchSignature'
[TRACE] [DBObjectComparer] Comparing Columns
[TRACE] [DBObjectComparer] Column 'groupUID' is okay.
[TRACE] [DBObjectComparer] Column 'SIGNATURE_ID' is okay.
[TRACE] [DBObjectComparer] Comparing Indexes
[TRACE] [DBObjectComparer] Comparing Constraints
[TRACE] [DBObjectComparer] Constraint 'FK38670AEAAC3C3C09' is okay.
[TRACE] [DBObjectComparer] Constraint 'FK38670AEAB227C794' is okay.
[TRACE] [DBObjectComparer] Comparing Triggers
[DEBUG] [TableHelper] Verifying table 'DeviceInfo'
[TRACE] [DBObjectComparer] Comparing Columns
[TRACE] [DBObjectComparer] Column 'ID' is okay.
[TRACE] [DBObjectComparer] Column 'deviceId' is okay.
[ERROR] [DBObjectComparer] Mismatch in Column 'deviceName' structure!!!
Expected: [Name: deviceName, Size: 255, Type: NVARCHAR, Nullable: false]
Found : [Name: deviceName, Size: 0, Type: NULL, Nullable: false]
[DEBUG] [DBObjectComparer] Additional Information:

[ERROR] [DBObjectComparer] Mismatch in Column 'osName' structure!!!
Expected: [Name: osName, Size: 255, Type: NVARCHAR, Nullable: true]
Found : [Name: osName, Size: 0, Type: NULL, Nullable: true]
[DEBUG] [DBObjectComparer] Additional Information:

[ERROR] [DBObjectComparer] Mismatch in Column 'ipAddress' structure!!!
Expected: [Name: ipAddress, Size: 255, Type: NVARCHAR, Nullable: true]
Found : [Name: ipAddress, Size: 0, Type: NULL, Nullable: true]
[DEBUG] [DBObjectComparer] Additional Information:

[ERROR] [DBObjectComparer] Mismatch in Column 'servicePack' structure!!!
Expected: [Name: servicePack, Size: 255, Type: NVARCHAR, Nullable: true]
Found : [Name: servicePack, Size: 0, Type: NULL, Nullable: true]
[DEBUG] [DBObjectComparer] Additional Information:

[TRACE] [DBObjectComparer] Column 'createdDate' is okay
Labels (2)
0 Likes
5 Replies
Highlighted
Absent Member.
Absent Member.

Re: ZCM 10.3.4 to 11 SP2 fails to upgrade database

Gerdesj,

> If I run the downloadable ZDC


the one for 10.3.4?

--

Shaun Pond


0 Likes
Highlighted
Absent Member.
Absent Member.

Re: ZCM 10.3.4 to 11 SP2 fails to upgrade database

spond;2188286 wrote:
Gerdesj,

> If I run the downloadable ZDC


the one for 10.3.4?

--

Shaun Pond


(Also to convince myself!):
./zdc 
_________ ____
|__ / _ \ / ___| Novell ZENworks(R)
/ /| | | | |
/ /_| |_| | |___ v 0.6 (10.3.4)
/____|____/ \____|
0 Likes
Highlighted
Absent Member.
Absent Member.

Re: ZCM 10.3.4 to 11 SP2 fails to upgrade database

Gerdesj,

you've convinced me, as long as when you said "run zdc_verifyDB from
the ZCM 11 ISO", you meant 11 SP2 ISO - I recommend a SR at this point,
since there's something obviously amiss...

--

Shaun Pond


0 Likes
Highlighted
Absent Member.
Absent Member.

Re: ZCM 10.3.4 to 11 SP2 fails to upgrade database

> as long as when you said "run zdc_verifyDB from the ZCM 11 ISO", you meant 11 SP2 ISO

Yes, I did run it from the SP2 ISO - mounted on the VM direct from a datastore.

Oh well, seeing as clones are cheap I will have a goodly play before resorting to an SR (I will post back if I fix it)

Another option I can think of is to migrate my DB to something else say MSSQL. It seems only the schema is borked, ie constraints on the data rather than the data itself - the system is fully functional and passes the "standard" ZDC test so I might get away with it ...

Thanks for your help

Cheers
Jon
0 Likes
Highlighted
Absent Member.
Absent Member.

Re: ZCM 10.3.4 to 11 SP2 fails to upgrade database

I ran into the very same thing verifying our sybase 10.3.1 database. The 10.3.1 version of zdc reports no unusual errors but the zdc_verifydb located on both the 11.1a and 11.2 .iso's would report literally hundreds of errors. For almost every table in database the error the same as yours, mismatch where "expected size was 255" and the "found size was 0". I had an open SR for a different issue migrating from 10.3.1 to 11.1 (in test) so I inquired about these errors too. Tech said these errors can be ignored as the zenworks 11 database rebuild would correct them during the upgrade. I ran through the upgrade and did a zdc report once 11.1a was installed, all database errors were gone.
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.