Troubleshooting
Problem
Integrity Checker may report error BMXAA9027E.
Symptom
Full text of error from Integrity Checker report:
The Error message is followed by the name of one or more tables.
BMXAA0443E -- Error - BMXAA9027E -- The MaxAttribute values are not sequential in the following business objects. Run the Integrity Checker in repair mode.
The Error message is followed by the name of one or more tables.
Cause
Column maxattribute.attributeno represents the relative position of an attribute within the maxattribute table. For each Maximo object, values of attributeno must be sequential, starting with 1.
Environment
Maximo 7.6.0.6 and newer, and Manage 8.0 and newer.
Diagnosing The Problem
For each object listed in the error message, gaps in AttributeNo can be detected by scanning the results of this SQL query:
Where <tablename> is one of the objects listed in the error.
Select objectname, attributename, attributeno
From maxattribute
Where objectname='<tablename>'
Order By 3 ;
Where <tablename> is one of the objects listed in the error.
Resolving The Problem
Do not run Integrity Checker in repair mode, as suggested in the error message. Eliminate gaps in attributeno with the following SQL:
Update maxattribute
Set attributeno=nn
Where objectname='<tablename>'
And attributeno=nn ;
Update maxattributecfg
Set attributeno=nn
Where objectname='<tablename>'
And attributeno=nn ;
where <tablename> is one of the objects listed in the error, and nn are values of attributeno from the query results.For example. this error is reported by Integrity Checker:
BMXAA0443E -- Error - BMXAA9027E -- The MaxAttribute values are not sequential in the following business objects. Run the Integrity Checker in repair mode.
ROSTER_NYY
To determine the cause of the error, run this SQL query:
Select objectname, attributename, attributeno
From maxattribute
Where objectname='ROSTER_NYY'
Order By 3 ;
Sample results returned from the query:
OBJECTNAME ATTRIBUTENAME ATTRIBUTENO
ROSTER_NYY MARTIN 1
ROSTER_NYY JETER 2
ROSTER_NYY RUTH 4
ROSTER_NYY GEHRIG 5
ROSTER_NYY DIMAGGIO 6
Note the gap in values of AttributeNo - values jump from 2 to 4, with no 3. To resolve the attribute numbers from this example, run:
Update maxattribute
Set attributeno=3
Where objectname='ROSTER_NYY'
And attributeno=4 ;
Update maxattribute
Set attributeno=4
Where objectname='ROSTER_NYY'
And attributeno=5 ;
Update maxattribute
Set attributeno=5
Where objectname='ROSTER_NYY'
And attributeno=6 ;
Update maxattributecfg
Set attributeno=3
Where objectname='ROSTER_NYY'
And attributeno=4 ;
Update maxattributecfg
Set attributeno=4
Where objectname='ROSTER_NYY'
And attributeno=5 ;
Update maxattributecfg
Set attributeno=5
Where objectname='ROSTER_NYY'
And attributeno=6 ;
After applying the SQL statements, run Integrity Checker again in Report Mode to verify that the error is no longer reported.
[{"Type":"MASTER","Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"ARM Category":[{"code":"a8m50000000CbDAAA0","label":"Upgrade-\u003EIntegrity Checker"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.6.1"},{"Type":"MASTER","Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSWT9A","label":"IBM Control Desk"},"ARM Category":[{"code":"a8m500000008b3TAAQ","label":"Miscellaneous Category (Portal, UI, Maximo, Install)"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.6.1"},{"Type":"MASTER","Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSRHPA","label":"IBM Maximo Application Suite"},"ARM Category":[{"code":"a8m50000000CbDAAA0","label":"Upgrade-\u003EIntegrity Checker"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
23 May 2024
UID
swg22005846