IJ14547: ERROR WHEN CREATING INTERFACE TABLES ON DB2

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 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