PM38887: QUERY STUDIO RETURNS ERROR WHEN "LAST NUMBER OF DAYS" AND "LEAVE OUT MISSING VALUES" IS SELECTED

APAR status

• Closed as program error.

Error description

• Query Studio returns RSV-SRV-0040 error when "Last Number of
  Days" and "Leave Out Missing Value" is selected on date and a
  product line.?                               ?Issue is
  reproducible using the Go Sales (query) samples in Cognos 8.4,
  8.4.1 fp3 as well as 10.1.?
                     ?Cognos Query Studio returns an error every
  time they try to filter a date column by "Last Number of Days"
  (60) and also "Leave Out Missing Values". The error seems to
  only be triggered if there is also a filter?applied from another
  (related) query subject (e.g. Product Line).
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.1 Refresh     *
  * Pack 1 or Upgrade to IBM Cognos 8 Business Intelligence      *
  * 8.4.1 Fix Pack 4                                             *
  ****************************************************************
  

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

  COG8 BI QUERY S

• Fixed component ID

  5724W12QS

Applicable component levels

• RA11 PSN

     UP