IBM Support

IT27935: SQL SLA POLICY SHOWS "UNABLE TO FIND DATABASES FOR THE GIVEN SLAPOLICY USING PATH" ERROR AFTER DELETING DATABASE FROM SQL

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Deleting an SQL database from SQL Server management studio,
    that was once part of an SQL SLA Policy results in the following
    error in the job log.
    WARN,Unable to find databases for the given sla policy using
    path=/DBINST:952308117/DB:4c70a7d28900d8950edbe6336fca9d32
    WARN,Unable to find databases for the given sla policy using
    path=/DBINST:952308117/DB:851bdbf838cfd560380ee851fae53757
    Note: These are internal keys, not a true db name.
    After the Default Application Server Inventory job runs
     the databases should be removed from the internal association
      to the SLA.
    Version affected: 10.1.X
    Keywords: TS001805360 SPP ISPP
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * IBM Spectrum Protect Plus level 10.1.0, 10.1.1, 10.1.2 and   *
    * 10.1.3                                                       *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See ERROR DESCRIPTION                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply fixing level when available. This problem is currently *
    * projected to be fixed in 10.1.2.350, 10.1.3 patch 1 and      *
    * 10.1.4. Note that this is subject to change at the           *
    * discretion of IBM                                            *
    ****************************************************************
    

Problem conclusion

  • Deleted resources will be removed from SLA the next time a job
    is run after the deletion. A warning message will be displayed
    to the user about this removal.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT27935

  • Reported component name

    SP PLUS

  • Reported component ID

    5737SPLUS

  • Reported release

    A12

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-01-30

  • Closed date

    2019-04-12

  • Last modified date

    2019-05-29

  • 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

    SP PLUS

  • Fixed component ID

    5737SPLUS

Applicable component levels

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSNQFQ","label":"IBM Spectrum Protect Plus"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A12","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
30 January 2024