IJ22331: BMXAA0494E -- THE DEFINITION OF THIS COLUMN DOES NOT MATCH THE ACTUAL COLUMN.

APAR status

• Closed as program error.

Error description

• Database: MS SQL 2016 (Case insensitive)
  
  * All installations
  performed using installers and not binary files.
  
  In a folder
  (SMP):
  
   Install Maximo 7.6.0
   Install Maximo 7.6.0.10
   Install
  Maximo 7.6.0.10 latest hot fix
   Maxinst applying demo data
  (Using ConfigTool)
   Install ACM 7.6.6
   Install ACM 7.6.6 hot
  fix
   Install NUC 7.6.1
   Install NUC 7.6.1 hot fix
   Install ANY
  7.6.3
   Install ANY 7.6.3 hot fix
   Run updatedb using
  ConfigTool
   Run integrity checker as below:
   Report mode
  
  Repair mode
   Run configdb.bat
   Report mode again
  
  In another
  folder (SMP_1):
  
   Install Maximo 7.6.1
   Install Maximo 7.6.1.1
  
  Install Maximo 7.6.1.1 latest hot fix
   Install ACM 7.6.7
  
  Install ACM 7.6.7.2
   Install NUC 7.6.2
   Install ANY 7.6.4
  
  
  
  
  Using ConfigTool (under SMP_1/ConfigTool), configure the SMP_1
  environment to point to the SMP folder database
   Run updatedb
  using ConfigTool
   Run integrity checker (from SMP_1) as below:
  
   Report mode
   Repair mode
   Run configdb.bat
   Report mode
  again
  
  At this point, no errors should be reported. But 2
  errors remained (from defect 349814).
  
  BMXAA0443E -- Error -
  BMXAA0494E -- The definition of this column does not match the
  actual column. The native column definition does not match the
  servers metadata. Run the Integrity Checker in repair mode. Thu
  Nov 07 13:16:32 EST 2019
  
   BMXAA6841I -- TICKET.PLUSAPROBLEM,
  Maximo definition is ALN(15), Database column is
  ALN(15)
  
  BMXAA0443E -- Error - BMXAA0494E -- The definition of
  this column does not match the actual column. The native column
  definition does not match the servers metadata. Run the
  Integrity Checker in repair mode. Thu Nov 07 13:16:32 EST
  2019
  
   BMXAA6841I -- WORKORDER.PLUSAPARTFAILURE, Maximo
  definition is UPPER(15), Database column is UPPER(15)
  
  
  
  
  System information (from defect 349814):
  
  -- Tivoli's process
  automation engine 7.6.1.1 Build 20190514-1348 DB Build
  V7611-365,
  
  IBM Maximo Asset Management Work Centers 7.6.0.4
  Build 20190514-1348 DB Build V7604-119,
  
  IBM Maximo Anywhere
  7.6.4.0 Build 20191106_214919-0500 DB Build V7640-03,
  
  IBM
  Maximo for Nuclear Power 7.6.2.0 Build 20191106-0617 DB Build
  V7620-46,
  
  IBM Tpae Integration Framework 7.6.1.1 Build
  20190419-2330 DB Build V7611-01,
  
  IBM Maximo Asset
  Configuration Manager 7.6.7.2 Build 20191106-2324 DB Build
  V7672-08,
  
  IBM Maximo Asset Management 7.6.1.1 Build
  20190514-1348 DB Build V7611-01,
  
  IoT Connection Utility
  7.6.0.2 Build 20190426-2206 DB Build V7602-07,
  
  TPAE OSLC
  Object Structure 7.6.4.0 Build 20191106_214826-0500 DB Build
  V7640-02
  
  -- Database Server Name: Microsoft SQL
  Server
  
  Database Server Version: 13.00.1601
  
  Database Server
  Major Version: 13 , Minor Version: 0
  
  Database Server Driver
  Name: Microsoft JDBC Driver 6.0 for SQL Server
  
  Database Server
  Driver Version: 6.0.8112.200
  
  Database Server Driver Major
  Version: 6 , Driver Minor Version: 0
  
  Java Version: 1.8.0_151
  

Local fix

• n/a
  

Problem summary

Problem conclusion

• The fix for this APAR is contained in the following maintenance
  package: | Release 7.6.1.3 of Base Services
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  UPGRADE PROGRAM

• Fixed component ID

  5724R46UP

Applicable component levels