IJ31533: 7.6.1.1 - MTONLY CONDITION DOESN'T SEEM TO WORK - "CONFIGURBEAN.EXTTABLE - LIST PAGE THROW EXCEPTION "

APAR status

• Closed as program error.

Error description

• Note: "configurbean.exttable - List page throw exception "
  
  The
  Database Configuration application has a SigOption named
  EXTTABLE with a Description of "Create Extension Table".
  If
  you log into a Non-Multi-Tenant MaxDemo environment as a user
  in the MAXADMIN, SYSADMIN, or ITADMIN Security Groups and you
  go the Database Configuration application, you will see "Create
  Extension Table" as an option on the "Select Action" menu from
  the List tab. If you filter for an object (e.g. - ACTCI),
  select it, and then select that option, you will get an error
  saying:
  
  BMXAA8682I - The extension table was not created for
  the object ACTCI.
  BMXAA8691E - An extension table cannot be
  created for the table ACTCI. To diagnose the problem, check the
  system log file.
  
  If you look at the system log file, you will
  see a message saying "Can only create extension tables in
  Multi-Tenant Systems.".
  
  But if you look at the ApplicationAuth
  records for that option, you should see that the ConditionNum
  is set to "MTONLY". That condition calls a class named
  "psdi.app.configure.MTOnlyCondition" which is presumably
  checking the System Property "mxe.mt.enabled" which I found in
  documentation but does not exist in my MaxDemo environment. I
  tried adding it and setting it to "0" but the "Create Extension
  Table" option still appears in the "Select Action".
  
  Also There
  are ApplicationAuth records with the same ConditionNum for
  OptionName = "STORAGETYPE" (Show Storage Type for MT only) with
  App = "CONFIGUR" and and also for OptionName = "CONSULTANT"
  (Consultant User) with App = "PERSON" and App = "USER". These
  options are referenced in the Presentation XML for these
  applications. In the Configur.xml, it is associated with an
  attribute named "StorageTypeDesc" and in the Person.xml and
  User.xml, it is associated with an attribute named
  "IsConsultant".
  
  These attributes do not appear in MaxDemo
  environment even if change the mxe.mt.enabled System Property
  to "1".
  
  
  System Information:
  App Server	Weblogic Application
  Server 12.2.1.3.0
  Version
  Tivoli's process automation engine
  7.6.1.1-IFIX20200522-1523 Build 20190514-1348 DB Build
  V7611-365 HFDB Build HF7611-13
  IBM Maximo Asset Management Work
  Centers 7.6.0.4 Build $build$ DB Build V7604-119
  IBM Maximo
  Asset Management Scheduler 7.6.7.3 Build 20190514-1348 DB Build
  V7673-78 HFDB Build HF7673-12
  IBM Tpae Integration Framework
  7.6.1.1-MIF_7611_IFIX.20200504-1653 Build 20190422-1259 DB
  Build V7611-01
  IBM Maximo for Utilities 7.6.0.2-20200522-1028
  Build 20171128-1353 DB Build V7602-68 HFDB Build HF7602-13
  IBM
  Maximo Spatial Asset Management 7.6.0.5-20201027-1144 Build
  20190522-1410 DB Build V7605-09 HFDB Build HF7605-09
  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
  
  Server OS	Linux
  3.8.13-118.19.4.el7uek.x86_64
  
  Server DB	Oracle 19.0 (Oracle
  Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
  Version 19.9.0.0.0)
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Maximo users (non-multitenancy only)                         *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * CREATE EXTENSION TABLE AVAILABLE ON LIST TAB OF DATABASE     *
  * CONFIGURATION FOR NON-MT ENVIRONMENTS. ERRORS ?BMXAA8682I,   *
  * BMXAA8691E - An extension table cannot be created for the    *
  * table ALTITEM.? encountered when executed.                   *
  ****************************************************************
  The Database Configuration application has a SigOption named
  EXTTABLE with a Description of "Create Extension Table".
  If you log into a Non-Multi-Tenant MaxDemo environment as a user
  in the MAXADMIN, SYSADMIN, or ITADMIN Security Groups and you
  go the Database Configuration application, you will see "Create
  Extension Table" as an option on the "Select Action" menu from
  the List tab. If you filter for an object (e.g. - ACTCI), select
  it, and then select that option, you will get an error saying:
  BMXAA8682I - The extension table was not created for
  the object ACTCI.
  BMXAA8691E - An extension table cannot be
  created for the table ACTCI. To diagnose the problem, check the
  system log file.
  If you look at the system log file, you will see a message
  saying "Can only create extension tables in Multi-Tenant
  Systems.". But if you look at the ApplicationAuth
  records for that option, you should see that the ConditionNum
  is set to "MTONLY". That condition calls a class named
  "psdi.app.configure.MTOnlyCondition" which is presumably
  checking the System Property "mxe.mt.enabled" which I found in
  documentation but does not exist in my MaxDemo environment. I
  tried adding it and setting it to "0" but the "Create Extension
  Table" option still appears in the "Select Action".
  The 'Create Extension Table' action should not be present in the
  action menu of the Database Configuration application for
  non-multitenancy environments.
  

Problem conclusion

• The fix for this APAR will be contained in a future release.
  

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

  MAXIMO ASST MGM

• Fixed component ID

  5724R46AM

Applicable component levels