IBM Support

PI99543: QUERY STUDIO CASTS NOT ONLY ON A TIMESTAMP FIELD BUT ALSO ON A DATE FIELD WHEN USING LAST NUMBER OF DAYS FILTER

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • Query Studio casts not only on a TIMESTAMP field but also on a
    DATE field when using  Last Number of Days filter when when
    there are large volume of data in combination with the CAST the
    queries would go  from minutes to hours thus  indexes are not
    being utilized causing severe performance issue like reports
    stuck in executing state for ever
    

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

  • Configuration Instructions:
    
    To be added to configuration/qrsvpproperties.xml :
    
    	<structure>
    		<!-- When UseAlternateLastNumberOfDaysSyntax is set to 1 the
    Last Number of Days will generate different syntax
    		 which will resemble:   					[QI] between
    _add_days(current_date, -1 * X ) AND current_timestamp
    		rather than the default:					CAST( [QI] as date ) between
    _add_days(current_date, -1 * X ) AND current_date
    -->
    		<property>UseAlternateLastNumberOfDaysSyntax</property>
    		<value type="long">1</value>
    	</structure>
    

APAR Information

  • APAR number

    PI99543

  • Reported component name

    COG QUERY STUDI

  • Reported component ID

    5724W12QS

  • Reported release

    B0A

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-06-25

  • Closed date

    2019-06-05

  • Last modified date

    2019-06-05

  • 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

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCHNWV","label":"Query Studio v11x"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B0A","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
05 June 2019