IV29259: GANT VIEW ADVANCED SEARCH FILTER NOT WORKING ON TPAE 7.5.0.1

APAR status

• Closed as program error.

Error description

• problem reproduced on TPAE 7.5.0.1 with Scheduler 7.5.0.0
  
  1. Go to "Planning and schedule" -> "Scheduler" application
  
  
  2. Click on "New record", choose a name for the scheduler, a
  description, a calendar, a shift and a start date
  
  Calendar: DAY
  SHIFT:    DAY
  
  Start date: 9/27/12 07:08:58 AM
  
  
  3. Under the Work Query tab, choose a Data Source = WORKORDER,
  and
  specify a Where Clause that should query on workorders bearing
  different LOCATION fields
  
  
  wonum is not null and orgid = 'EAGLENA' and siteid = 'BEDFORD'
  
  
  4. Under the Resource Availability tab, choose a Data Source =
  LABOR and
  specify a Where Clause that should query on all available labors
  (i.e.
  "laborid is not null" or "1=1")
  
  I used Copy Query button to accept default value
  
  
  
  5. Click on Gantt View tab
  
  6. Once the Java app is launched, you should see on the top left
  window multiple workorders with different locations.
  
  
  7. Click on the Binoculars button in the Scheduler toolbar
  (Advanced Search)
  
  
  8. Select a valid location in the location field (the goal is to
  filter the results on one specific location only)
  
  
  I used BOILER
  
  
  
  
  9. Click on the Find button
  
  10. This is where the bug happens : the results are still
  unfiltered, as  if nothing happened.
  
  None of the filters in the Advanced Search window are
  working.
  
  
  
  
  Did not reproduce issue, results were filtered to show only
  BOILER location results
  
  This issue is not reproducible on TPAE 7.5.0.0 with Scheduler
  7.5.0.0 or TPAE 7.5.0.3 with Scheduler 7.5.0.3
  

Local fix

• Dev to provide fix
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: GANT VIEW ADVANCED SEARCH FILTER NOT WORKING *
  *                 ON TPAE 7.5.0.1                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: problem reproduced on TPAE 7.5.0.1 with *
  *                      Scheduler 7.5.0.0                       *
  *                                                              *
  *                      1. Go to "Planning and schedule" ->     *
  *                      "Scheduler" application                 *
  *                                                              *
  *                      2. Click on "New record", choose a name *
  *                      for the scheduler, a                    *
  *                                                              *
  *                      description, a calendar, a shift and a  *
  *                      start date                              *
  *                                                              *
  *                      Calendar: DAY                           *
  *                                                              *
  *                      SHIFT:    DAY                           *
  *                                                              *
  *                      Start date: 9/27/12 07:08:58 AM         *
  *                                                              *
  *                      3. Under the Work Query tab, choose a   *
  *                      Data Source = WORKORDER,                *
  *                                                              *
  *                      and                                     *
  *                                                              *
  *                      specify a Where Clause that should      *
  *                      query on workorders bearing             *
  *                                                              *
  *                      different LOCATION fields               *
  *                                                              *
  *                      wonum is not null and orgid = 'EAGLENA' *
  *                      and siteid = 'BEDFORD'                  *
  *                                                              *
  *                      4. Under the Resource Availability tab, *
  *                      choose a Data Source =                  *
  *                                                              *
  *                      LABOR and                               *
  *                                                              *
  *                      specify a Where Clause that should      *
  *                      query on all available labors           *
  *                                                              *
  *                      (i.e.                                   *
  *                                                              *
  *                      "laborid is not null" or "1=1")         *
  *                                                              *
  *                      I used Copy Query button to accept      *
  *                      default value                           *
  *                                                              *
  *                      5. Click on Gantt View tab              *
  *                                                              *
  *                      6. Once the Java app is launched, you   *
  *                      should see on the top left              *
  *                                                              *
  *                      window multiple workorders with         *
  *                      different locations.                    *
  *                                                              *
  *                      7. Click on the Binoculars button in    *
  *                      the Scheduler toolbar                   *
  *                                                              *
  *                      (Advanced Search)                       *
  *                                                              *
  *                      8. Select a valid location in the       *
  *                      location field (the goal is to          *
  *                                                              *
  *                      filter the results on one specific      *
  *                      location only)                          *
  *                                                              *
  *                      I used BOILER                           *
  *                                                              *
  *                      9. Click on the Find button             *
  *                                                              *
  *                      10. This is where the bug happens : the *
  *                      results are still                       *
  *                                                              *
  *                      unfiltered, as  if nothing happened.    *
  *                                                              *
  *                      None of the filters in the Advanced     *
  *                      Search window are                       *
  *                                                              *
  *                      working.                                *
  *                                                              *
  *                      Did not reproduce issue, results were   *
  *                      filtered to show only                   *
  *                                                              *
  *                      BOILER location results                 *
  *                                                              *
  *                      This issue is not reproducible on TPAE  *
  *                      7.5.0.0 with Scheduler                  *
  *                                                              *
  *                      7.5.0.0 or TPAE 7.5.0.3 with Scheduler  *
  *                      7.5.0.3                                 *
  *                                                              *
  *                      LOCAL FIX:                              *
  *                                                              *
  *                      Dev to provide fix                      *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  ****************************************************************
  problem reproduced on TPAE 7.5.0.1 with Scheduler 7.5.0.0
  
  1. Go to "Planning and schedule" -> "Scheduler" application
  
  2. Click on "New record", choose a name for the scheduler, a
  
  description, a calendar, a shift and a start date
  
  Calendar: DAY
  
  SHIFT:    DAY
  
  Start date: 9/27/12 07:08:58 AM
  
  3. Under the Work Query tab, choose a Data Source = WORKORDER,
  
  and
  
  specify a Where Clause that should query on workorders bearing
  
  different LOCATION fields
  
  wonum is not null and orgid = 'EAGLENA' and siteid = 'BEDFORD'
  
  4. Under the Resource Availability tab, choose a Data Source =
  
  LABOR and
  
  specify a Where Clause that should query on all available
  labors
  
  (i.e.
  
  "laborid is not null" or "1=1")
  
  I used Copy Query button to accept default value
  
  5. Click on Gantt View tab
  
  6. Once the Java app is launched, you should see on the top
  left
  
  window multiple workorders with different locations.
  
  7. Click on the Binoculars button in the Scheduler toolbar
  
  (Advanced Search)
  
  8. Select a valid location in the location field (the goal is
  to
  
  filter the results on one specific location only)
  
  I used BOILER
  
  9. Click on the Find button
  
  10. This is where the bug happens : the results are still
  
  unfiltered, as  if nothing happened.
  
  None of the filters in the Advanced Search window are
  
  working.
  
  Did not reproduce issue, results were filtered to show only
  
  BOILER location results
  
  This issue is not reproducible on TPAE 7.5.0.0 with Scheduler
  
  7.5.0.0 or TPAE 7.5.0.3 with Scheduler 7.5.0.3
  
  LOCAL FIX:
  
  Dev to provide fix
  

Problem conclusion

• not reproduced in 7504 and 7520
  
  The fix for this APAR is contained in the following maintenance
  package:
  
    | release\fix pack | Release 7.5.2.0 of Scheduler
  

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 SCHEDULE

• Fixed component ID

  5724R46SE

Applicable component levels

• R751 PSY

     UP