IJ30711: GETTING TIMEOUT ERRORS WHILE TRYING TO FIX A METER READING, DUE TO SITE ID.

APAR status

• Closed as program error.

Error description

• STEPS TO REPRODUCE:
  
  Steps to replicate
  1.Go To Asset
  Application
  2. Create Asset "1001" and add ?FUEL-G? meter from
  the Meters tab
  3. From more actions, Enter
  Meter Reading> add 3
  readings
  4. Go to user Default Information change Default
  insert site to Denver.
  5. Recreate steps from 1 to 3, use the
  same assetnum?1001?
  6.From more actions Mange Meter Reading
  History. modify reading.
  RESULTS
  The query below is causing
  proformas issue, as when the run it against the backends db it
  returns no result
  Select * from meterreading where metername=
  'CYCLES' and inheritedfromasset= '425755' and
  readingdate>TO_TIMESTAMP ('2020-10-04 00:00:00.000' ,
  'YYYY-MM-DD HH24:MI:SS.FF') and readingdate<=TO_TIMESTAMP
  ('2020-11-02 00:00:00.000' , 'YYYY-MM-DD HH24:MI:SS.FF') and
  assetnum!= '425755' order by assetnum,readingdate
  asc
  
  
  
  REPORTED IN VERSION:
  
  Maximo Asset Management 7.6.1.1
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Maximo users                                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * METERREADING SQL query causing performance issue. Needs to   *
  * include SITEID.                                              *
  ****************************************************************
  STEPS TO REPRODUCE:
  1.Go To Asset
   Application
   2. Create Asset "1001" and add ?FUEL-G? meter from
   the Meters tab
   3. From more actions, Enter
   Meter Reading> add 3
   readings
   4. Go to user Default Information change Default
   insert site to Denver.
   5. Recreate steps from 1 to 3, use the
   same assetnum?1001?
   6.From more actions Mange Meter Reading
   History. modify reading.
   RESULTS
   The query below is causing
   proformas issue, as when the run it against the backends db it
   returns no result
   Select * from meterreading where metername=
   'CYCLES' and inheritedfromasset= '425755' and
   readingdate>TO_TIMESTAMP ('2020-10-04 00:00:00.000' ,
   'YYYY-MM-DD HH24:MI:SS.FF') and readingdate<=TO_TIMESTAMP
   ('2020-11-02 00:00:00.000' , 'YYYY-MM-DD HH24:MI:SS.FF') and
   assetnum!= '425755' order by assetnum,readingdate
   asc
  

Problem conclusion

• The fix for this APAR is contained in the following maintenance
  package: Release 7.6.1.3 of Base Services
  

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

  MAXIMO ASST MGM

• Fixed component ID

  5724R46AM

Applicable component levels