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 number
IJ31533
Reported component name
MAXIMO ASST MGM
Reported component ID
5724R46AM
Reported release
761
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-03-15
Closed date
2023-04-24
Last modified date
2023-04-24
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
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"Maximo Asset Management"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"761","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Document Information
Modified date:
24 April 2023