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 number
IJ33870
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
2021-07-21
Closed date
2021-10-25
Last modified date
2021-10-25
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:
26 October 2021