IBM Support

PH06761: ERROR: RMEMBEDDEDFILTER INCOMPATIBLE WHEN HAVING SECURITY TABLE FILTER FOR 2 RELATED REPORTS IN ONE DASHBOARD

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error description

  • Env:
    1. Cognos 11.0.9 , Windows server 2008 R2
    
    2. content store is Oracle 11.2.0.4
    datasource Oracle 11.2.0.4
    
    Problem
    Referring to the case TS001610046
    
    It is about 1 pie report in the Dashboard , in the pie report,
    there is 2 filter field applied .
    
    there is Security table applied in FM model , if the login user
    is filter in this security table, there will be the error, if
    the login user is not filter in this security table, there will
    be no issue.
    
    Related tables and fields for reproduce steps' screenshots see
    the attachment in next comment.
    
    Main content and details for Reproduce steps:
    1. Import below FM package to FM and table and data to Oracle
    database:
    https://ecurep.mainz.de.ibm.com/ae5/#id=TS001515370&path=TS00151
    5370%2F2018-11-07%2F&filepath=TS001515370%2F2018-11-07%2FFM_Tabl
    e.7z
    https://ecurep.mainz.de.ibm.com/ae5/#id=TS001515370&path=TS00151
    5370%2F2018-11-08%2F&filepath=TS001515370%2F2018-11-08%2FFM_Tabl
    e_20181108.7z
    
    We build table relationship between tables in FM, like YYYYMM
    field is the join relationship between those table
    
    Here there is Security table: WPG06_DIM_SECURITY_CEO, add
    'Specify Data Security' : Security.WPG06_DIM_SECURITY_CEO.EMP_NO
    = 'A0191' , Group is for Login user.
    
    On another table DASHBOARD.Dashboard AR, there is security
    filter as below:
    DASHBOARD.Dashboard AR.Organization.OU ID in (
    Security.WPG06_DIM_SECURITY_CEO.OU_ID )
    
    
    2. Publish the package CSO_RDB_06_R6_f in FM
    
    3. On Cognos welcome page, create new Dashboard.
    
    4. Add package CSO-RDB_06_R6_f
    
    5. Create one Stack colume bar chart, with colume 'YYYYMM'
    (DIM_TIME) , length 'Overdue Amt' (Dashboard AR), color 'Aging'
    
    6. Create another Pie chart in same dashboard, with Segments
    'Cust Group' (DIM_CUSTOMER), Size 'NSB Amt (USD)'
    
    7. After we create those 2 reports, we can reproduce the same
    issues as customer.
    
    First, if we click on stacked bar chart, YYYYMM for 201809, it
    works, for another pie chart will show data for 201809.
    While if we click on the color bar like Aging , it will pass
    201809 and Aging information like Bucket1 to pie chart, it will
    report the error 'Query Service internal error has occurred,
    please see the logs for details' , in the logs, we can see:
    
    <event component="XQE" group="Exception" level="ERROR"
    thread="274" timestamp="2018-11-13 23:32:12.768"><![CDATA[Caught
    error in the Query Service: java.lang.ClassCastException:
    com.cognos.xqe.ast.rqp.RMEmbeddedFilter incompatible with
    com.cognos.xqe.ast.v5.query.V5DetailFilter
    at
    com.cognos.xqe.transformation.v5tocogsql.V5QueryToRQPQuery.Initi
    alizeFactManager.logWarningForDroppingFilter(InitializeFactManag
    er.java:1735)
    ........
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Users                                                    *
    *                                                              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    *                                                              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to IBM Cognos Analytics 11.1.2                       *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PH06761

  • Reported component name

    COG REPORT STUD

  • Reported component ID

    5724W12RS

  • Reported release

    B09

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-12-21

  • Closed date

    2019-06-04

  • Last modified date

    2019-06-04

  • 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



Document information

More support for: Cognos Analytics
Report Authoring v11x

Software version: B09

Reference #: PH06761

Modified date: 04 June 2019