IJ33870: BMXAT0128E ERROR WHEN MOVING WORK ORDER IN GRAPHICAL SCHEDULING IF ITS DESCRIPTION INCLUDES AN APOSTROPHE

APAR status

• Closed as program error.

Error description

• STEPS TO REPRODUCE:
  1. Navigate to Work Order Tracking application.
  2. Create a sample Work Order with a Description containing a
  single quote: For example: Repair Driver's seat.
  3. Enter some planned Labor hours along with a Target Start and
  Target Finish date.
  4. Change the status to Waiting for Scheduling (WSCH) and save
  the WO. Note the Work Order number. Create a query for this WO.
  5. Navigate to 'Graphical Scheduling - Large Projects'
  application
  6. Create a Work List with the saved query referring to the
  previously-created Work Order.
  7. In the Graphical View (Gantt View) tab and top-right
  quadrant, try to move the Work Order from one date to another
  (for example, to next day).
  8. The following error message appears:
  "BMXAT0128E - The activity changes did not save for project
  {0}. For more information, check the Maximo log file (in your
  application server directory) or contact your system
  administrator. The string constant beginning with "'name, 0
  milestone, '' supervisor, 1 modified from sysibm.sysdummy1) "
  does not have an ending string delimiter.. SQLCODE=-10,
  SQLSTATE=42603, DRIVER=4.26.14"
  9. Click OK. The assignment has actually been moved despite
  error message.
  10. Go back to the WO record in Work Order Tracking, remove the
  apostrophe from the Description field: <Repair Driver seat>,
  and save the WO.
  11. Go back to 'Graphical Scheduling - Large Projects'
  application and move the assignment in Graphical View: the
  error occurs again.
  12. You need to right-click on WO in top-left quadrant, select
  'Modify Work Order'
  13. The change made to the WO Description in Work Order
  Tracking is now showing in Graphical Scheduling - Large
  Projects.
  14. Try to move the Work Order from one date to another (for
  example, to next day).
  15. This time, the assignment is moved correctly and without
  any error message. So the apostrophe / single quote in the WO
  Description is definitely giving the error.
  RESULTS:
  The following error message appears:
  "BMXAT0128E - The activity changes did not save for project
  {0}. For more information, check the Maximo log file (in your
  application server directory) or contact your system
  administrator. The string constant beginning with "' name, 0
  milestone, '' supervisor, 1 modified from sysibm.sysdummy1) "
  does not have an ending string delimiter.. SQLCODE=-10,
  SQLSTATE=42603, DRIVER=4.26.14"
  EXPECTED RESULTS:
  The assignment should be moved correctly and without any error
  message.
  REPORTED IN VERSION:
  IBM Maximo Asset Management Scheduler 7.6.8.0
  

Local fix

• Remove apostrophe from the Work Order's Description field
  

Problem summary

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

Problem conclusion

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