IJ34642: "VIEW SCHEDULED REPORTS" DIALOG IS EMPTY IF MXE.DB.FETCHSTOPLIMITENABLED=0 AND MXE.DB.FETCHSIZEUSE=0

APAR status

• Closed as program error.

Error description

• STEPS TO REPRODUCE:
  - Go to System Properties.
  -  Filter on mxe.db.fetch.
  -  The DEFAULT settings are :
  mxe.db.fetchStopLimitEnabled = 1
  mxe.db.fetchsizeuse = 1
  mxe.db.fetchResultLogLimit = 1000
  - Go to Report Administration and select 'View Scheduled
  Reports' option.
  -  A list of report schedules show in the dialog.
  -  Click on 'Filter', put cursor on empty filter for any column
  and hit 'Enter' (therefore no actual filter criteria)
  -  The same list of report schedules shows in the dialog.
  -  Go to System Properties application.
  -  Make these changes :
  mxe.db.fetchStopLimitEnabled = 0
  mxe.db.fetchsizeuse = 0
  -  Stop the Maximo application server in WAS (needed because
  Live Refresh option is not available for 2nd system property),
  clear the WAS cache, clear the browser cache and restart the
  Maximo application server.
  -  Log on to Maximo.
  -  Go to Report Administration and select 'View Scheduled
  Reports' option.
  -  A list of report schedules show in the dialog.
  -  Click on 'Filter', put cursor on empty filter for any column
  and hit 'Enter' (therefore no actual filter criteria)
  RESULTS:
  The list of report schedules is now empty.
  
  EXPECTED RESULTS:
  The value of System Properties mxe.db.fetchStopLimitEnabled and
  mxe.db.fetchsizeuse should not impact on the list of report
  schedules.
  
  REPORTED IN VERSION:
  Maximo TPAE 7.6.1.1
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * MAXIMO                                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When property mxe.db.fetchStopLimitEnabled is set to 0 and   *
  * and there is sorting on a non-persistent attribute of a      *
  * table in a dialog, filter on the table doesn't return any    *
  * record.                                                      *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is contained in the following maintenance
  package: release\fix pack for Release 8.x Product
  

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