IBM Support

PI15788: SINGLE SIGN ON CAUSES REUSE OF CACHE FOR DIFFERENT USERS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When using Dynamic Query Mode, a situation can occur which
    enables a user to see the data for another user.  This problem
    happens when all the following conditions are met: 1) Use DQM
    packages; and 2) using single sign-on authentication to access
    their relational database; and 3) the data in the database is
    secured based on the same user id used with sign-on; 4) there is
    no explicit database sign on defined in Cognos product.  Note:
    single sign-on is supported for SQL Server, Teradata and SAP
    Hana
    

Local fix

  • Adding the following to xqe.config.xml (in <install>/configurati
    on directory) will turn OFF query reuse hence preventing users t
    o see cached data.  <XQEConfiguration version="1.0" xmlns:xsi="h
    ttp://www.w3.org/2001/XMLSchema-instance">  <!-- Copyright (C) 2
    008 Cognos ULC, an IBM Company. All rights reserved. Cognos (R)
    is a trademark of Cognos ULC, (formerly Cognos Incorporated). --
    >  <general>   <queryReuse enabled="false"/>
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See error description.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to IBM Cognos Business Intelligence 10.2.1 Fix Pack  *
    * 3                                                            *
    ****************************************************************
    

Problem conclusion

  • Code Fix
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI15788

  • Reported component name

    COG ANALYSIS ST

  • Reported component ID

    5724W12AS

  • Reported release

    A11

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2014-04-10

  • Closed date

    2014-06-20

  • Last modified date

    2014-06-20

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

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

    PI34424

Fix information

  • Fixed component name

    COG REPORT STUD

  • Fixed component ID

    5724W12RS

Applicable component levels

  • RA21 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCHNWW","label":"Report Authoring v11x"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A11","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
20 June 2014