IJ38390: GRAPHICAL RESOURCE VIEW - MISSING PROPERTIES CAUSE IT TO FAIL WITH ERROR BMXAA4214E

APAR status

• Closed as program error.

Error description

• In the Graphical Resource View application missing properties
  from SKDProperty cause it to fail with error BMXAA4214E - An
  unknown error has occurred.   It should not fail to start just
  because a few properties are missing.
  
  
  STEPS TO REPRODUCE
  1. To set it up to fail you must go to the database and remove
  the rows from SKDProperty and SKDPropertymap where
  skdobjectname='SKDRESOURCE' for these propertynames:
  - crewassignment
  -  defaultvendor   (probably not needed but included here for
  completeness)
  - repairfacility
  - repfacsiteid
  2. Commit your changes.
  3. Now start Maximo and create a Graphical Resource View
  Resource List.
  4. Save
  5. Click on Graphical View tab
  
  RESULTS:
  The errors above and the exception in the log.  The Graphical
  View tab fails to load.
  
  EXPECTED RESULTS:
  For the Graphical View tab to display the selected resources.
  
  WORKAROUND:
  The workaround is to add the properties back in with the
  Configure Gantt View Properties dialog in Graphical Assignment
  as there is no Configure Gantt View Properties dialog in
  Graphical Resource View. But all properties defined on it go
  to a set of tables, SKDProperty and SKDPropertymap, common to
  all scheduler applications.
  
  Run this select against the failing database and against a
  working out of the box environment:
  
  select * from skdproperty where skdobjectname='SKDRESOURCE';
  
  Compare the 2 to see how many rows are missing. Out of the box
  there are 13 rows. In one case, 4 had to be added to get
  Graphical Resource View to work.
  
  Then use the Resource tab on the Configure Gantt View
  Properties dialog in Graphical Assignment to add them back in to
  the database that fails. Open the dialog for each property and
  its Object and Attribute Mapping rows and use them as models to
  enter the missing rows into the database that fails. Enter
  both the properties (SKDProperty) and its mappings
  (SKDPropertymap).
  
  Then restart the Maximo Application Server and now Graphical
  Resource View will work.
  
  If DEFAULTVENDOR cannot be added it can be ignored.
  
  
  REPORTED IN VERSION:
  7.6.1.2-IFIX20210920
  

Local fix

• The workaround is to add the properties back in with the
  Configure Gantt View Properties dialog in Graphical Assignment
  as there is no  Configure Gantt View Properties dialog in
  Graphical Resource View.   But all properties defined on it go
  to a set of tables, SKDProperty and SKDPropertymap,  common to
  all scheduler applications.
  
  Run this select against the failing database and against a
  working out of the box environment:
  
  select * from skdproperty where skdobjectname='SKDRESOURCE';
  
  Compare the 2 to see how many rows are missing.   Out of the box
  there are 13 rows.   In one case, 4 had to be added to get
  Graphical Resource View to work.
  
  Then use the Resource tab on the  Configure Gantt View
  Properties dialog in Graphical Assignment to add them back in to
  the database that fails.   Open the dialog for each property and
  its Object and Attribute Mapping rows and use them as models to
  enter the missing rows into the database that fails.   Enter
  both the properties (SKDProperty) and its mappings
  (SKDPropertymap).
  
  Then restart the Maximo Application Server and now Graphical
  Resource View will work.
  
  If DEFAULTVENDOR cannot be added it can be ignored.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Scheduler users                                              *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is contained in the following
  maintenancepackage:
  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:

Fix information

• Fixed component name

  MAXIMO SCHEDULE

• Fixed component ID

  5724R46SE

Applicable component levels