APAR status
Closed as program error.
Error description
STEPS TO REPRODUCE: - open Maximo and go to an application like Service Requests - Go to Advanced Search and Where clause - Enter this: status='NEW' order by reportdate ASC - Click OK: a record selection shows in the List tab - do Actions / Run Reports - Click on "Create Report" button - Ensure that "Apply application query" is checked - Click on Preview Report - the QBR report runs fine but its Where clause (showing at end of report list) is only: status='NEW' The 'order by reportdate ASC' portion of the Where clause has been removed. This is expected functionality because Maximo already offers the option to do an Order By when creating the QBR report by using the Sorting option in the QBR's Format tab. - Go to Advanced Search and Where clause - Only enter this: order by reportdate ASC - Click OK: a record selection shows in the List tab - do Actions/ Run Reports - Click on 'Create Report' button - Ensure that "Apply application query" is checked - Click on Preview Report - the QBR report doesn't run and you get this error: "There was an exception on the server. Check your report parameter values, or contact your system administrator, who can find additional details in the server log."
Local fix
Remove the 'Order By' in the Maximo Where clause, then do an 'Order By' when creating the QBR report by using the Sorting option in the QBR's Format tab.
Problem summary
**************************************************************** * USERS AFFECTED: * * All Maximo Users * **************************************************************** * PROBLEM DESCRIPTION: * * Error when running qbr report if maximo where clause only * * consists of an 'order by'. * **************************************************************** * RECOMMENDATION: * * Upgrade to latest release * **************************************************************** STEPS TO REPRODUCE: - open Maximo and go to an application like Service Requests - Go to Advanced Search and Where clause - Enter this: status='NEW' order by reportdate ASC - Click OK: a record selection shows in the List tab - do Actions / Run Reports - Click on "Create Report" button - Ensure that "Apply application query" is checked - Click on Preview Report - the QBR report runs fine but its Where clause (showing at end of report list) is only: status='NEW' The 'order by reportdate ASC' portion of the Where clause has been removed. This is expected functionality because Maximo already offers the option to do an Order By when creating the QBR report by using the Sorting option in the QBR's Format tab. - Go to Advanced Search and Where clause - Only enter this: order by reportdate ASC - Click OK: a record selection shows in the List tab - do Actions/ Run Reports - Click on 'Create Report' button - Ensure that "Apply application query" is checked - Click on Preview Report - the QBR report doesn't run and you get this error: "There was an exception on the server. Check your report parameter values, or contact your system administrator, who can find additional details in the server log."
Problem conclusion
Able to run qbr report with where clause that only consists of an 'order by'. The fix for this APAR is contained in the following maintenance package: | release\fix pack | Fix Pack Release 7.6.0.8 TPAE
Temporary fix
Comments
APAR Information
APAR number
IV90466
Reported component name
AD HOC REPORTIN
Reported component ID
5724R46AH
Reported release
760
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-11-03
Closed date
2017-01-26
Last modified date
2017-01-26
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
MAXIMO
Fix information
Fixed component name
AD HOC REPORTIN
Fixed component ID
5724R46AH
Applicable component levels
R760 PSY
UP
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCHPNC","label":"Report Admin"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.6","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
26 January 2017