IBM Support

PM79500: REPORT ON METRIC PACKAGE (MS SQL SERVER) RETURNS WRONG RESULT WHEN THE USER IS MEMBER IN MORE THAN 47 ACTIVE DIRECTORY GROUPS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • A report on a metric package returns the wrong result when a MS
    SQL Server holds the metric store and the user is member in more
    than 47 MS Active Directory groups.?The report query sent to MS
    SQL Server does not return any data, which results in the wrong
    report output. There is no error message in the browser.?If the
    user is member of less than 48 MS Active Directory groups, the
    report returns the expected result.??The behaviour is not
    reproducible with IBM DB2 as metric store data base.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Those using Metric Studio where the Metric Store is on       *
    * Microsoft SQL Server.                                        *
    * If user is member of a number of groups, such that the       *
    * concatenated ids of groups that make up user's identity is > *
    * 8000 bytes.                                                  *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See error description.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to IBM Cognos Business Intelligence 10.2 Refresh     *
    * Pack 1                                                       *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PM79500

  • Reported component name

    COG METRIC STUD

  • Reported component ID

    5724W12MS

  • Reported release

    A20

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-12-19

  • Closed date

    2013-06-11

  • Last modified date

    2013-06-11

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

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

Fix information

Applicable component levels

  • RA21 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCRGHL","label":"Metrics Studio"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.2","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
11 June 2013