IJ37247: ASSET MEASUREMENT HISTORY REPORT SHOWS DATA FROM MULTIPLE SITES WHEN A SPECIFIC SITE IS ENTERED AS A PARAMETER

APAR status

• Closed as program error.

Error description

• Problem Description:
  The report is not filtering out for the selected site when
  creating the sub dataset.
  
  The query is extracting from the MEASUREMENT object contains
  data for measurement points which can be utilized in multiple
  sites (same measurement point in 2, or more sites) but the query
  is not including siteid in the where clause (as it is included
  in the main dataset.
  
  DataSet [subDataSet]: select measurement.measuredate,
  measurement.measurementvalue, measurement.inspector,  (case
  when measurement.measurementvalue between 3500 and 5000 then
  null    when measurement.measurementvalue between 3200 and 3500
  then 'WARNING'    when measurement.measurementvalue < 3200 then
  'ACTION'    when measurement.measurementvalue between 5000 and
  5500 then 'WARNING'    when measurement.measurementvalue > 5500
  then 'ACTION'  end) as results,  row_number() over(order by
  measurement.measuredate) as rownumbering  from measurement
  where measurement.pointnum = '1001'  and measurementvalue is not
  null  order by measurement.measuredate
  
  
  Note: the above sql taken from the report running in the demo
  database is not including the siteid from the initial where
  clause. If pointnum 1001 exists for 2 or more sites then that
  query will pull all values, not just the site entered as a
  parameter.
  
  STEPS TO REPRODUCE:
  You will need to create a measurement point in 2 sites.
  you will need to make measurements for this point in both sites
  run the report for one of the 2 sites
  
  
  RESULTS:
  the detail of the report will include both records
  
  EXPECTED RESULTS:
  
  The selected site should be the only site that is reported.
  
  PRODUCT VERSION:
  7612
  

Local fix

• re-write the sql
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * MAXIMO                                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * In MEASUREMENT table when multiple records are present with  *
  * same POINTNUM but different sites, measurement information   *
  * from different site appears in report.                       *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR will be included in a future Release.
  

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

  MAXIMO REPORTIN

• Fixed component ID

  TIVOREPTS

Applicable component levels