IV94203: AD HOC ISSUE WHEN THE WHERE CLAUSE CONTAINS "ORDER BY" AND THERE IS AN APPRESTRICTIONS IN THE APPLICATION.

APAR status

• Closed as program error.

Error description

• ERROR DESCRIPTION:
  If you have a combination of "Order By" on your where clause
  and an apprestriction on the application, you are not able to
  run an Ad Hoc report.
  You face the following 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.
  ENVIRONMENT:
  IBM WebSphere Application Server 8.5.5.3
  Tivoli's process automation engine 7.6.0.5
  OS: Windows 6.3
  DB: Oracle 11.2
  STEPS TO REPRODUCE:
  Maximo 7605
  Go To application Desgin application and pick the WOTRACK
  application. Add any apprestriction to this application and
  save it.
  Go to WOTRACK application and click on "Advanced Search" ->
  "Where
  Clause". On the end of this, add ORDER BY WONUM.
  Try to run an ad hoc report with "Apply Application Query"
  marked.
  You will face an error.
  CURRENT ERRONEOUS RESULT:
  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.
  EXPECTED RESULT:
  The report should run with no errors
  ADDITIONAL INFO:
  (enter text here)
  ENVIRONMENT:
  IBM WebSphere Application Server 8.5.5.3
  Tivoli's process automation engine 7.6.0.5
  OS: Windows 6.3
  DB: Oracle 11.2
  LOCAL FIX:
  No
  

Local fix

• No
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Maximo Users                                             *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * AD HOC ISSUE WHEN THE WHERE CLAUSE CONTAINS "ORDER BY" AND   *
  * THERE IS AN APPRESTRICTIONS IN THE APPLICATION.              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to latest release                                    *
  ****************************************************************
  

Problem conclusion

• NO AD HOC ISSUE WHEN THE WHERE CLAUSE CONTAINS "ORDER BY" AND
  THERE IS AN APPRESTRICTIONS IN THE APPLICATION
  
  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 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