IBM Support

IV52576: ERRORS FOUND IN SCRIPT AND SQL FILES

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Need to update the ncp_polling_exceptions.pl:
    A.  ncp_polling_exceptions.pl - add explanation text to header
    
    sub getUnmanaged2
    {
        my $dbh = shift;
        if ($format eq "report")
        {
            print "List of IP addresses unmanaged from Discovery
    (Status 2:Interface unmanaged, Status 3:IP address not in
    discovery scope)\n";
            print "Check ifDescr in TagManagedEntities.stch for the
    following interfaces:\n";
        }
        my $query = "select "
            . "u.ip \"IP\", "
            . "u.mainNode \"HOSTNAME\", "
            . "i.ifDescr \"IFDESCR\", "
            . "p.entityStatus \"ENTITY\" "
            . "from $monitorSchema.unmanagedIps u "
            . "inner join $monitorSchema.pollLog p on u.ip = p.ip
    and u.mainNodeEntityId = p.mainNodeEntityId "
            . "inner join $ncimSchema.interfaces i on p.entityId =
    i.entityId "
            . "where u.domainName = \'$domain\' and p.entityStatus
    >= 2";
    
    B. Pretty output in ncp_polling_exceptions.pl
    
    sub getNoSNMPAddress
    {
        my $dbh = shift;
        my $query = "select c.ip \"IP\", c.mainNode \"HOSTNAME\",
    CASE WHEN c.mainNodeMgdStatus IS NULL THEN 'Yes' WHEN
    c.mainNodeMgdStatus = 1 THEN 'Yes' ELSE 'No' END
    \"NODEMANAGED\" from chassisOnlyIps c, expectedIps e where c.ip
    = e.ip and c.domainName = \'$domain\'";
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Modify ncp_polling_exceptions.pl to enhance the outputs of   *
    * getUnmanaged2 and getNoSNMPAddress.                          *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * The following fixpacks will contain the fix:                 *
    * | fix pack | 3.9.0-ITNMIP-FP0005                             *
    * | fix pack | 4.1.0-ITNMIP-FP0001                             *
    * | fix pack | 4.1.1-ITNMIP-FP0002                             *
    ****************************************************************
    

Problem conclusion

  • Modify ncp_polling_exceptions.pl -
    A. add status 3 in getUnmanaged2 and have more explanation text
    to header.
    sub getUnmanaged2
    {
        my $dbh = shift;
        if ($format eq "report")
        {
            print "List of IP addresses unmanaged from Discovery
    (Status 2:Interface unmanaged, Status 3:IP address not in
    discovery scope)\n";
            print "Check ifDescr in TagManagedEntities.stch for the
    following interfaces:\n";
        }
        my $query = "select "
            . "u.ip \"IP\", "
            . "u.mainNode \"HOSTNAME\", "
            . "i.ifDescr \"IFDESCR\", "
            . "p.entityStatus \"ENTITY\" "
            . "from $monitorSchema.unmanagedIps u "
            . "inner join $monitorSchema.pollLog p on u.ip = p.ip
    and u.mainNodeEntityId = p.mainNodeEntityId "
            . "inner join $ncimSchema.interfaces i on p.entityId =
    i.entityId "
            . "where u.domainName = \'$domain\' and p.entityStatus
    >= 2";
    
    B. pretty getNoSNMPAddress output.
    sub getNoSNMPAddress
    {
        my $dbh = shift;
        my $query = "select c.ip \"IP\", c.mainNode \"HOSTNAME\",
    CASE WHEN c.mainNodeMgdStatus IS NULL THEN 'Yes' WHEN
    c.mainNodeMgdStatus = 1 THEN 'Yes' ELSE 'No' END
    \"NODEMANAGED\" from chassisOnlyIps c, expectedIps e where c.ip
    = e.ip and c.domainName = \'$domain\'";
    

Temporary fix

Comments

APAR Information

  • APAR number

    IV52576

  • Reported component name

    NC/PRECISIONIP

  • Reported component ID

    5724O52RC

  • Reported release

    390

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2013-11-26

  • Closed date

    2015-03-05

  • Last modified date

    2015-03-05

  • 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/PRECISIONIP

  • Fixed component ID

    5724O52RC

Applicable component levels

  • R390 PSN

       UP

  • R390 PSY

       UP

  • R410 PSN

       UP

  • R410 PSY

       UP

  • R411 PSN

       UP

  • R411 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCP984","label":"Discovery and RCA"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"390","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
05 March 2015