APAR status
Closed as program error.
Error description
In 7612, If you create an AdHoc report with the ROS 'Work Order Details with Actuals and PLans' and include data from the Communication Log table, you will get an error. BMXAA8093E - The report could not be created and the cause of the error cannot be determined. Try to create the report again, or contact your system administrator. BMXAA4176E - Attribute &SYNONYMLIST&_WOCLASS[WORKORDER, does not exist. Gather the logs from the <HOME> directory and determine the process or app referencing the invalid attribute. To duplicate, select a small sample of workorders and create an AdHooc report. Run Reports, Create Report. Click the content Tab and change the Parent Category to 'Work Orders Details with Actuals and Plans. From the WorOrder table, add wonum & description. Select the Communication Log table and select a field to add to the report. Click Preview to run the report. In the Report Object Structure application, Openthe ROS, REP_WOPLANACT If you go to the COMMLOG entry, you will see that the relationship is as follows. exists (select 1 from workorder where workorderid = commlog.ownerid and workorder.wogroup = :wogroup and workorder.siteid = :siteid ) and CommLog.OwnerTable in (:&synonymlist&_woclass[WORKORDER, ACTIVITY, CHANGE, RELEASE], 'WORKORDER', 'WOACTIVITY', 'WOCHANGE', 'WORELEASE') If you compare this relationship to the one from 7611, you will see they are different. exists (select 1 from workorder where workorderid = commlog.ownerid and woclass = commlog.ownertable and workorder.wogroup = :wogroup and workorder.siteid = :siteid ) Tivoli's process automation engine 7.6.1.2
Local fix
Use the 7611 relationship to create a new relationship in 7612 between WorkOrder & COMMLOG. Use this relationship in the Report Object Structure.
Problem summary
**************************************************************** * USERS AFFECTED: * * MAXIMO * **************************************************************** * PROBLEM DESCRIPTION: * * In Work Order Tracking application, creating AdHoc report * * with Report Object Structure "WO Details with Actual and * * Plans" fails on COMMLOG. * **************************************************************** * RECOMMENDATION: * * In Work Order Tracking application, creating AdHoc report * * with Report Object Structure "WO Details with Actual and * * Plans" fails on COMMLOG. * ****************************************************************
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
IJ41207
Reported component name
MAXIMO REPORTIN
Reported component ID
TIVOREPTS
Reported release
761
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2022-07-15
Closed date
2022-08-27
Last modified date
2022-09-09
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 REPORTIN
Fixed component ID
TIVOREPTS
Applicable component levels
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"Maximo Asset Management"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"761","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Document Information
Modified date:
09 September 2022