Troubleshooting
Problem
Integrity Checker can report this error: BMXAA0443E -- ERROR -- configure#NoEntityOrCol WMASSIGNMENT.DISPLAYWONUM
Symptom
The error code is not being translated as it should. Error message should read:
BMXAA0443E -- ERROR -- BMXAA0688E - Both Entity Name and Column Name must be specified when the attribute is persistent.
WMASSIGNMENT.DISPLAYWONUM
If a Maximo column is defined as persistent, then attributes EntityName and ColumnName must be populated.
Cause
Problem typically occurs on a legacy database that has been upgraded from 6.2 and earlier. Likely the inconsistency in the definition of the column has existed since 6.2 or earlier, but a consistency check for the condition was not added to Integrity Checker until 7.5.
Environment
Maximo 7.5 or newer Integrity Checker
Diagnosing The Problem
If a Maximo column is persistent, meaning that the column exists on the native database, then Maximo attributes EntityName and ColumnName must be populated. You can verify that either or both attributes are not populated from the results of this SQL query:
Select persistent, entityname, columnname From maxattribute Where objectname='WMASSIGNMENT' And attributename='DISPLAYWONUM'
Resolving The Problem
Column WMAssignment.DispayWONum should be defined in the Maximo tables as nonpersistent. This will resolve the issue of EntityName and/or ColumnName not populated. To change the definition of the column to nonpersistent, apply the following two SQL update statements, then again run Integrity Checker in report mode in order to verify that the error is no longer reported.
- Update maxattribute Set persistent=0, searchtype='NONE' Where objectname='WMASSIGNMENT' And attributename='DISPLAYWONUM'
- Update maxattributecfg Set persistent=0, searchtype='NONE' Where objectname='WMASSIGNMENT' And attributename='DISPLAYWONUM'
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21685097