Home

Results 1 to 2 of 2

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

  1. #1
    Join Date
    Sep 2015
    Posts
    2

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



    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]

  2. #2
    Shaun Pond NNTP User

    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



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •