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 number
IJ38390
Reported component name
MAXIMO SCHEDULE
Reported component ID
5724R46SE
Reported release
768
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2022-03-10
Closed date
2022-03-22
Last modified date
2022-03-22
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
[{"Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS9NUN","label":"Maximo Asset Management Scheduler"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"768"}]
Document Information
Modified date:
23 March 2022