IBM Support

PH39405: XQE-DAT-0001 DATA SOURCE ADAPTER ERROR IN REPORTS THAT USE A DATA MODULE AND DATA SETS THAT INCLUDE A LEFT JOIN.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • XQE-DAT-0001 Data source adapter error in reports that use a
    data module and data sets that include a left join.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to IBM Cognos Analytics 11.2.1                       *
    ****************************************************************
    Configuration Instructions:
    
    A new capability is added called joins.BracketInner which
    impacts Native SQL generation. If the property is set to true,
    grouped inner joins will be bracketed. The property is by
    default false, and is set to true for Flint in Flint.properties
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PH39405

  • Reported component name

    COGNOS ANALYTIC

  • Reported component ID

    5724W12XX

  • Reported release

    B0A

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-07-29

  • Closed date

    2021-09-30

  • Last modified date

    2021-09-30

  • 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

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"Cognos Analytics"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B0A"}]

Document Information

Modified date:
02 October 2021