IBM Support

Resolving Integrity Checker Error BMXAA9027E

Troubleshooting


Problem

Integrity Checker may report error BMXAA9027E.

Symptom

Full text of error from Integrity Checker report:
  
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:
  
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"}]

Document Information

Modified date:
23 May 2024

UID

swg22005846

Page Feedback