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

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 is sysrouted FROM one or more of the following:

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

Fix information

Applicable component levels