Troubleshooting
Problem
The retrieval of records in the Maximo Work Order Tracking Application is returning all records when it should be using the Select Statement where clause to reduce the amount of records returned.
This was working correctly in Maximo 7.5.0.5 or earlier, and after upgrading to Maximo 7.5.0.11 it is no longer working.
Symptom
In the Work Order Tracking Application, when pressing return to list the records, all records are returned, when the expectation is that a smaller subset is displayed as Specified in the View/Manage Queries.
Cause
This is a code defect, and has been corrected from Maximo 7.5.0.11.
However, environments that upgrade from earlier versions, might not benefit from the code improvement.
Environment
This will affect upgraded Maximo 7.5.0.11 environments that have been upgraded from Maximo 7.5.0.5 or earlier. It will not impact new installations of Maximo 7.5.0.11.
Diagnosing The Problem
Go to -> Work Order Tracking -> Select Save Query -> View/Manage Queries
Notice that for the queries available, the Clause Field is populated and displayed.
This is the expected behaviour.
Resolving The Problem
This is a known issue, and was fixed in Maximo 7.5.0.11.
However, when upgrading a Maximo 7.5.0.5 or earlier, the issue does not get resolved because the library.xml used to resolve the issue, is from the original install of 7.5.0.5.
Lets look at the library.xml files from both scenarios:
The original 7.5.0.11 wotrack library.xml contains:
<tabledetails id="searchvmqr_tabledtails" sigoption="BMXVIEWMANAGEWHER" sigoptiondatasrc="MAINRECORD">
However it should only contain:
<tabledetails id="searchvmqr_tabledtails" sigoption="BMXVIEWMANAGEWHER">
Was this topic helpful?
Document Information
Modified date:
16 August 2018
UID
ibm10728075