IV45258: AFTER APPLYING ITNM V3.9 FIX PACK 3: TAGMANAEDENTITIES.STCH DOES NOT HONOR ENTITYTYPE=2 FILTER RESULTING IN UNMANAGED ENTITIES

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • This APAR is created as AE/MDV APAR with "MDVRGRS" class.
    | MDVPARTL 3.9.0-TIV-ITNMIP-FP0003 |
    
    v3.9.0.97 - platform independent
    
    TagManagedEntities.stch does not honor EntityType=2 filter when
    the condition is based on EntityOID. This was working correctly
    in earlier builds and is broken on FP3.
    
    Below is excerpt from a custom stitcher:
    
     <snip>
    
    oqlUpdate = oqlUpdate + interfaceFilter + rediscoveryFilter +
                        " AND
                             (
      ExtraInfo->m_IfDescr like 'Dialer'
    .............deleted few lines.........
    (EntityOID='1.3.6.1.4.1.9.1.642' and
    (ExtraInfo->ReverseRelatedTo is NULL and RelatedTo is NULL) and
    (ExtraInfo->m_IfAlias is NULL or ExtraInfo->m_IfAlias =''))
                            OR
    (EntityOID='1.3.6.1.4.1.9.1.858' and
    (ExtraInfo->ReverseRelatedTo is NULL and RelatedTo is NULL) and
    (ExtraInfo->m_IfAlias is NULL  or ExtraInfo->m_IfAlias =''))
    
    </snip>
    
    With above condition - all chassis (EntityType=1) are also
    unmanaged that are of above two OIDSs along with
    Interfaces(EntityType=2), resulting in no monitoring(polling).
    

Local fix

  • Add an additional filter (EntityType = 2) like below:
    
    (EntityOID='1.3.6.1.4.1.9.1.642' and
    (ExtraInfo->ReverseRelatedTo is NULL and RelatedTo is NULL) and
    (ExtraInfo->m_IfAlias is NULL or ExtraInfo->m_IfAlias ='') and
    EntityType =2 )
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * After the enhancement of OQL optimization made in FP3, an    *
    * OQL query involving a mix of indexed and unindexed queries   *
    * on the same table AND'd together could in some cases result  *
    * in the wrong data being returned.                            *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * The following fixpacks will contain the fix:                 *
    * | fix pack | 3.9.0-ITNMIP-FP0004                             *
    *                                                              *
    * Request a testfix from IBM for IV45258, if needed before the *
    * FP4 release.                                                 *
    ****************************************************************
    

Problem conclusion

  • The issue was an OQL query involving a mix of indexed and
    unindexed queries on the same table AND'd together could in some
    cases result in the wrong data being returned. The bug was due
    to a issue with the algorithm being used in CRivTable.cc to
    determine when we could avoid ANDing the results and just take
    the right hand side for performance.
    
    The issue was resolved by altering the algorithm to work
    correctly.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IV45258

  • Reported component name

    NC/PREC DISCOVY

  • Reported component ID

    5724O52DS

  • Reported release

    390

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-07-08

  • Closed date

    2013-08-14

  • Last modified date

    2013-08-14

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    NC/PREC DISCOVY

  • Fixed component ID

    5724O52DS

Applicable component levels

  • R390 PSY

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Netcool for Asset Management

Software version:

390

Reference #:

IV45258

Modified date:

2013-08-14

Translate my page

Machine Translation

Content navigation