APAR status
Closed as program error.
Error description
ERROR DESCRIPTION: Problem Description Error "BMXAA1332E - Cannot populate the interface tables. null" when using a different schema in the Maximo database. STEPS TO REPRODUCE: SETUP 1. Create a new system user for DB2. For example: a. username = testuser b. password = Maximo01 Go to Control Panel and select User Account Go to "Add or Remove User Accounts" and Create a New Account Enter lcuser for the name of the new account The account type should be administrator Click the newly created account and click "Create a Password" to give a password to the new account Go to Computer Management Local Users and Groups and select "Users" Right-click on lcuser, and then select "Properties" In the popup window, select Member Of tab and click "Add" Enter DB2USERS in the "Enter the Object Name to Select" field Click "Check Names" and then click OK Click OK again to save your changes 2. Log in to the maximo database (DB2) as maximo 3. Run the script below to create a new schema: CREATE SCHEMA testuser AUTHORIZATION Maximo01; GRANT ALTERIN ON SCHEMA testuser TO USER Maximo01; GRANT CREATEIN ON SCHEMA testuser TO USER Maximo01; GRANT DROPIN ON SCHEMA testuser TO USER Maximo01; STEPS: 1) Create new Object Structure in the Object Structure application e.g. Object Structure "MAYPO" Select "Support Flat Structure" checkbox Save the record 2) Create new Publish Channel in the Publish Channel application Define the object structure created in step 1 Define an Interface Table name e.g. MAYPO Save the record 3) Bring up the out of the box MXIFACETABLE End Point in the End Point application Go to Duplicate action and make a duplicate of the MXIFACETABLE End Point e.g. call the new end point "EDER" Enter the properties for End Point like below: DRIVER: com.ibm.db2.jcc.DB2Driver ISREMOTE: 1 Password: Maximo01 URL: jobs:db2://localhost:50005/maxdb76 USERNAME: testuser Save the record 4) Go to the External Systems application and create a new External System e.g. External System "MAYPO" Define the ENDPOINT e.g. End Point "EDER" Add the Publish Channel created in step 2 above e.g. Publish Channel "MAYPO" Save the record 5) Go to "Create InterfaceTables" action RESULTS: Receive Error "BMXAA1332E - The interface tables list could not be populated. Verify that the database where the interface tables are being created is accessible to the server. See the server logs and error logs for more information about the underlying exception. null" EXPECTED RESULTS: No error message when creating Interface table REPORTED IN VERSION IBM Maximo Asset Management 7.6.0.9 IBM TPAE Integration Framework 7.6.0.9
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All users * **************************************************************** * PROBLEM DESCRIPTION: * * When creating an iface table with a publish channel endpoint * * that points to a different schema in the same database used * * by Maximo, an error prevents the interface table from being * * created. * **************************************************************** * RECOMMENDATION: * ****************************************************************
Problem conclusion
The fix for this APAR is included in the following package: | Release 7.6.1.2 of Base Services.
Temporary fix
Comments
APAR Information
APAR number
IJ14547
Reported component name
INTEGRATION
Reported component ID
5724R46I1
Reported release
760
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-03-10
Closed date
2019-05-08
Last modified date
2019-05-08
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
INTEGRATION
Fixed component ID
5724R46I1
Applicable component levels
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"760","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Document Information
Modified date:
08 May 2019