Troubleshooting
Problem
When running Maximo Integrity Checker, you may encounter error BMXAA8148E about an inconsistency with a long description column.
Symptom
Full error message is:
BMXAA0443E -- ERROR -- BMXAA8148E - Attribute is a long description owner, but there is no long description attribute
MXGLTXN.REMARK
Cause
The column specified in the error message is defined to support long descriptions. But the definition is incomplete.
Diagnosing The Problem
For any column that is enabled to own long descriptions, there must be an associated nonpersistent long description attribute. The long description owner listed in the error message is defined inconsistently; it does not have an associated long description attribute.
Resolving The Problem
This error can be resolved in one of two ways:
1. Clear the flag that indicates the Maximo column can own long descriptions by running these 2 SQL statements:
- Update maxattribute Set isldowner=0 Where objectname='MXGLTXN' And attributename='REMARK' ;
- Update maxattributecfg Set isldowner=0 Where objectname='MXGLTXN' And attributename='REMARK' ;
2. Enable the column to own long descriptions by adding the missing long description attribute for this column to the Maximo tables. This solution varies slightly by database platform. Attached are the solutions for DB2 (AddLDAttribute.db2), Oracle (AddLDAttribute.ora), and SQL Server (AddLDAttribute.sqs).
Notes:
- The SQL statements above use column MXGLTXN.REMARK as an example. In all statements, replace with the table and column name from the BMXAA8148E error.
- Integrity Checker in repair mode essentially employs the first option to resolve the problem.
- The name of the long description attribute must be the name of the column appended with '_LONGDESCRIPTION'.
After the database changes are applied and committed, again run Integrity Checker in report-only mode, in order to confirm that the error is no longer reported.
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21958986