APAR status
Closed as program error.
Error description
Problem: Not able to view anything in the dispatch view when multiple queries exist. When multiple queries are created it is causing a restriction in the dispatch view when trying to merge the results of these queries together. Bug in dispatch code to build the query when multiple queries exist. Application should be using 'or' not 'and' when 2 queries exist. problem sql in the log : 0803144016) app (null) object (ASSIGNMENT) : select * from assignment where orgid= 'GN' and status in ( 'WAITASGN' ) and craft= 'IN_PZ' and (exists (select * from workorder where assignment.wonum=workorder.wonum and assignment.siteid=workorder.siteid and (wonum in ('PP100003624291')) and (wonum in ('PP100003624263'))) or exists (select * from workorder where assignment.wonum=workorder.wonum and assignment.siteid=workorder.siteid and parent in (select wonum from workorder where 1=1 and (wonum in ('PP100003624291')) and (wonum in ('PP100003624263'))))) for read only Dev suggestion should have "or" not "and" when 2 queries Results: No routes are being displayed when multiple queries are set in the application for the dispatch view. Expected Results: All routes should be displayed in the application. Reported In Version: Tivoli's process automation engine 7.6.1.2 IBM Maximo Asset Management Scheduler 7.6.8.0
Local fix
Problem summary
Problem conclusion
A fix for this APAR will be included in a future release.
Temporary fix
Comments
APAR Information
APAR number
IJ47852
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
2023-08-10
Closed date
2023-09-29
Last modified date
2023-09-29
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
[{"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","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Document Information
Modified date:
29 September 2023