PI04969: SQL Server function current_date no longer being sent to database

APAR status

• Closed as program error.

Error description

• When upgrading from 10.1.1 FP2 to 10.2.0, Query Studio reports
  that leverage LAST_N_DAYS filter functionality are seeing
  dramatic increases of local processing as the Query Studio
  function of choice (current_date) is not pushed to SQL Server
  2005 via Dynamic Query Mode.??As Query Studio does not allow
  users to chose the functions they use, it is impossible to avoid
  local processing via the use of the SQL Server getdate()
  function.
  

Local fix

• If possible, use Report Studio reports and leverage the SQL Serv
  er getDate() function instead of the current_date.
  

Problem summary

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

Problem conclusion

• Code Fix
  

Temporary fix

Comments

APAR Information

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

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

Fix information

• Fixed component name

  COG REPORT STUD

• Fixed component ID

  5724W12RS

Applicable component levels

• RA20 PSN

     UP