IJ39328: UNABLE TO SAVE CHANGES ON GRAPHICAL ASSIGNMENT-REPAIR FACILITIES WHEN A GLOBAL DATA RESTRICTION IS USED ON THE LOCATION OBJECT

APAR status

• Closed as program error.

Error description

• Unable to save changes on Graphical Assignment-Repair Facilities
  list when a Global Data Restriction is used on the Location
  object. This is only happening for restrictions containing a
  bind variable like &PERSONID&.
  The error displayed will be similar to:
  BMXAT0051E - The resource information was not populated. For
  more information, check the Maximo log file (in your application
  server directory) or contact your system administrator.
  Incorrect syntax near ':'.
  
  STEPS TO REPRODUCE:
  1. Go to Security Groups,
  
  2. bring up MAXADMIN group
  3. Create a Global Data Restriction:
  Object: LOCATIONS
  Type: QUALIFIED
  Value: (:TYPE = 'STOREROOM' AND (:disabled = 1 AND :&PERSONID&
  IN (select userid from groupuser where groupname in
  ('MAXADMIN')) OR :disabled = 0)  OR :TYPE <> 'STOREROOM')
  
  4. Go to Graphical Assignment-Repair Facilities
  5. Create a new list
  6. Save
  
  RESULT:
  
  Error displayed:
  BMXAT0051E - The resource information was not populated. For
  more information, check the Maximo log file (in your application
  server directory) or contact your system administrator.
  Incorrect syntax near ':'.
  
  EXPECTED RESULT:
  List should be saved
  
  REPORTED IN VERSION:
  Tivoli's process automation engine 7.6.1.1
  IBM Maximo Asset Management Scheduler 7.6.7.3
  IBM Maximo Asset Management Scheduler Plus 7.6.7.3
  

Local fix

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