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..



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]