PI77238: DMH5012E ON ERROR > Perform group-by query > SORT ON COUNT

RAAz-6.1.0.13-Install-IMRepository
RAAz-6.1.0.13-Install
Rational Asset Analyzer for System z Fix Pack 13 (6.1.0.13) for 6.1
Rational Asset Analyzer for System z Fix Pack 14 (6.1.0.14) for 6.1
Rational Asset Analyzer for System z Fix Pack 15 (6.1.0.15) for 6.1
Rational Asset Analyzer for System z Fix Pack 16 (6.1.0.16) for 6.1
Rational Asset Analyzer for System z Fix Pack 17 (6.1.0.17) for 6.1
Rational Asset Analyzer for System z Fix Pack 18 (6.1.0.18) for 6.1
Rational Asset Analyzer for System z Fix Pack 19 (6.1.0.19) for 6.1
Rational Asset Analyzer for System z Fix Pack 20 (6.1.0.20) for 6.1
Rational Asset Analyzer for System z Fix Pack 21 (6.1.0.21) for 6.1
Rational Asset Analyzer for System z Fix Pack 22 (6.1.0.22) for 6.1
Rational Asset Analyzer for System z Fix Pack 23 (6.1.0.23) for 6.1

APAR status

• Closed as program error.

Error description

• This problem only occurs with RAAz (regardless of whether the
  UI is on z/OS or Windows).  Steps to reproduce it are:
  Database -> errors
  Activity log errors
  Perform group-by query
  Analysis type  return code
  Sort by count
  Result is an error message that starts like:
  com. ibm. dmh. msg. WsaaException: DMH5012E:
  Attempt to retrieve unknown 'Prop' model object with name
  'ActivityLogEntry. Count'.
       at com. ibm. dmh. ui. Prop. lookup(Prop.
  java:177)
       at com. ibm. dmh. ui. SqlUtil.
  getOrderByClause(SqlUtil. java:988)
       at com. ibm. dmh. ui. QueryService.
  getRegularGroupQuery(QueryService. java:1383)
  

Local fix

• none known
  

Problem summary

• With Rational Asset Analyzer for System z, if you use the
  Advanced search to modify the view and select the group-by
  option, and you order the results by the Count column, the
  following error message is displayed -- DMH5012E: Attempt to
  retrieve unknown 'Prop' model object with name '<name>.
  Count'.
  

Problem conclusion

• Rational Asset Analyze for System z was Updated to correctly
  handle the derived Count column so that it can be sorted.
  

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

• gui
  

Fix information

• Fixed component name

  RAA FOR SSTEM Z

• Fixed component ID

  5655W5700

Applicable component levels

• R610 PSY

     UP