erwinboudrie Absent Member.
Absent Member.
720 views

Zcm upgrade 11.2 > 11.3 zdc errors (using oracle 11.2.04)

We are testing the upgrade from zenworks 11.2>11.3 in our test environment (copy production, Oracle 11.2.0.4).

Before the upgrade to Zenworks 11.3.0a we run ZDC to check the Oracle database (no errors found)
Setup 11.3, After cleanup (25 hours) (we run ZDC again (no errors)
The installation of 11.3.0a ends with (successful).

After reboot we run ZDC for 11.3a, with the basefile zcm_11.3.0a.zdc. (errors found). (3 retries to upgrade 11.2>11.3 same result..:mad:



Severity Description
ERROR Missing object in table 'ZQUICKTASKASSIGNMENT'
Object type: [Constraint] , Object name: [FK_ZQUICKTASKASSIGNMENT_AUXID]
Detail: [Name: FK_ZQUICKTASKASSIGNMENT_AUXID, Type: R, Table: ZQUICKTASKASSIGNMENT]

ERROR Missing object in table 'ZCONTENT'
Object type: [Index] , Object name: [IDX_ZCONTENT_K1_K4]
Detail: [Name: IDX_ZCONTENT_K1_K4, Table: ZCONTENT]

ERROR Missing object in table 'ZCONTENT'
Object type: [Index] , Object name: [IDX_ZCONTENT_K1_K4]
Detail: [Name: IDX_ZCONTENT_K1_K4, Table: ZCONTENT]

ERROR Missing object in table 'ZCONTENTSYNCSTATE'
Object type: [Index] , Object name: [UNIQ_ZCONTENTSYNCSTATE]
Detail: [Name: UNIQ_ZCONTENTSYNCSTATE, Table: ZCONTENTSYNCSTATE]

ERROR Missing object in table 'ZCONTENTSYNCSTATE'
Object type: [Index] , Object name: [UNIQ_ZCONTENTSYNCSTATE]
Detail: [Name: UNIQ_ZCONTENTSYNCSTATE, Table: ZCONTENTSYNCSTATE]

ERROR Missing object in table 'ZCONTENTSYNCSTATE'
Object type: [Index] , Object name: [UNIQ_ZCONTENTSYNCSTATE]
Detail: [Name: UNIQ_ZCONTENTSYNCSTATE, Table: ZCONTENTSYNCSTATE]

ERROR Missing object in table 'ZCONTENTSYNCSTATE'
Object type: [Constraint] , Object name: [UNIQ_ZCONTENTSYNCSTATE]
Detail: [Name: UNIQ_ZCONTENTSYNCSTATE, Type: U, Table: ZCONTENTSYNCSTATE]

ERROR Missing object in table 'ZZENOBJECT'
Object type: [Index] , Object name: [IDX_ZZENOBJECT_K1_K6]
Detail: [Name: IDX_ZZENOBJECT_K1_K6, Table: ZZENOBJECT]

ERROR Missing object in table 'ZZENOBJECT'
Object type: [Index] , Object name: [IDX_ZZENOBJECT_K1_K6]
Detail: [Name: IDX_ZZENOBJECT_K1_K6, Table: ZZENOBJECT]

ERROR Missing object in table 'ZZENOBJECT'
Object type: [Index] , Object name: [UNIQ_ZZENOBJECT_PATH]
Detail: [Name: UNIQ_ZZENOBJECT_PATH, Table: ZZENOBJECT]

ERROR Missing object in table 'ZZENOBJECT'
Object type: [Constraint] , Object name: [UNIQ_ZZENOBJECT_PATH]
Detail: [Name: UNIQ_ZZENOBJECT_PATH, Type: U, Table: ZZENOBJECT]
Following mismatches were found in tables' structures.

Severity Description
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: 0]
Found: [Name: TG_NCPRODUCT_INS_LOCALPRODUCT, Table: NC_PRODUCT, Definition hash: 386e8240]

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: 0]
Found: [Name: TG_NCPRODUCT_UPD_LOCALPRODUCT, Table: NC_PRODUCT, Definition hash: 864f3b39]

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: 0]
Found: [Name: tg_NCProduct_Ins_Upd, Table: NC_PRODUCT, Definition hash: f1130057]

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: 0]
Found: [Name: tg_NCProduct_del, Table: NC_PRODUCT, Definition hash: 91193a6c]

ERROR Mismatch in table 'ZSYSTEMUPDATELOCATION' structure.
Object type: [Column] , Object name: [ALTERNATELOCATION]
Expected: [Name: ALTERNATELOCATION, Size: 4000, Type: CLOB, Nullable: false]
Found: [Name: ALTERNATELOCATION, Size: 4000, Type: CLOB, Nullable: true]
All required database Procedures/Views are present in the database.

Following mismatches were found in database Procedures/Views.

Severity Description
ERROR Mismatch in View 'ZCONTENT_VW' structure.
Expected: [Name: ZCONTENT_VW, Definition hash: 202877b0 ]
Found: [Name: ZCONTENT_VW, Definition hash: 94d77b0]
Labels (2)
0 Likes
1 Reply
Anonymous_User Absent Member.
Absent Member.

Re: Zcm upgrade 11.2 > 11.3 zdc errors (using oracle 11.2.04)

Erwinboudrie,

best to open a SR with Novell: some of those "errors" may be cosmetic,
but best to be sure

--

Shaun Pond
in my "day job" I work for ENGL; our aim is to make Windows deployment
easy


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.