Technote (troubleshooting)
Problem(Abstract)
Getting the following two integrity errors at Integrity Checker run time after installing release_pmp_7.1.1.5.zip fixpack file (IBM 7.1.1.5-TIV-ITRPM-FP0005 ): BMXAA6234E, BMXAA0496E
Symptom
BMXAA0443E - ERROR -- BMXAA6234E - Column PMRELDSLCIRLN.NEWCIFLG is not large enough for the values defined in domain CISTATUS.
BMXAA0443E - ERROR -- BMXAA0496E - This column is defined to be the 'same-as' a column that does not exist in Maximo
Resolving the problem
The attributes of maxattribute and maxattributecfg were named incorrectly.
SQL> select attributename , sameasobject,SAMEASATTRIBUTE from
maxattribute where objectname = 'PMRELDSLCIRLN' and attributename
='DESCRIPTION';
returned:
ATTRIBUTENAME
--------------------------------------------------
SAMEASOBJECT
------------------------------
SAMEASATTRIBUTE
--------------------------------------------------
DESCRIPTION
DESCRIPTION
CI
and :
SQL> select attributename , sameasobject,SAMEASATTRIBUTE from
maxattributecfg where objectname = 'PMRELDSLCIRLN' and attributename
='DESCRIPTION';
returned:
ATTRIBUTENAME
--------------------------------------------------
SAMEASOBJECT
------------------------------
SAMEASATTRIBUTE
--------------------------------------------------
DESCRIPTION
DESCRIPTION
CI
By updating the sameasobject you can fix the issue:
.
SQL> update maxattribute set SAMEASATTRIBUTE= 'DESCRIPTION' where
objectname = 'PMRELDSLCIRLN' and attributename ='DESCRIPTION';
1 row updated.
SQL> update maxattributecfg set SAMEASATTRIBUTE = 'DESCRIPTION' where
objectname = 'PMRELDSLCIRLN' and attributename ='DESCRIPTION';
1 row updated.
SQL> commit
2 ;
Commit complete.
.
So, the result should look like this one:
SQL> select attributename , sameasobject,SAMEASATTRIBUTE from maxattribute where
objectname = 'PMRELDSLCIRLN' and attributename ='DESCRIPTION';
.
ATTRIBUTENAME
--------------------------------------------------
SAMEASOBJECT
------------------------------
SAMEASATTRIBUTE
--------------------------------------------------
DESCRIPTION
CI
DESCRIPTION
.
SQL> select attributename , sameasobject,SAMEASATTRIBUTE from maxattributecfg where objectname = 'PMRELDSLCIRLN' and attributename ='DESCRIPTION';
.
ATTRIBUTENAME
--------------------------------------------------
SAMEASOBJECT
------------------------------
SAMEASATTRIBUTE
--------------------------------------------------
DESCRIPTION
CI
DESCRIPTION
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.