IV93096: BMXAA6713E-THE MBO FETCH OPERATION FAILED IN THE MBOSET WITH THE SQL ERROR CODE-206

APAR status

• Closed as program error.

Error description

• BMXAA6713E-The MBO fetch operation failed in the mboset with the
  SQL error code-206  The record could not be retrieved from the
  database, While using Location on a Workorder
  
  
  Steps to replicated issue: MultiTenant Maximo
  1. Log into MTM with GA account and create extension table for
  Workorder
  2. Log into MTM with consultant user or Tenant Admin and add the
  new  field via Database Information
  3. Log into MTM with consultant user or Tenant Admin and add the
  new  field to the workorder list tab
  
  
  Another scenario where the error is occuring
  1. Create a public saved query logged in as Tenant Admin
  2. The user of that tenant received the error when trying to use
  the query on a start center or within the Application
  
  Exact error  received :
  BMXAA6713E - The MBO fetch operation failed in the mboset with
  the SQL  error code -206. The record could not be retrieved from
  the  database.
  
  Note:
  assetext_2011 is the extension view for the tenant with tenantid
   2011. This view is created when user apply changes after adding
  attribute to  Maximo table based on extension table.
  
  Issue found in the code. In the database layer after
  alias is assigned to a table for example
  from asetext_2011 asset  you cannot use table name in the where
  clause so  assetext_2011.siteid is invalid.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Maximo Users                                             *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * BMXAA6713E-THE MBO FETCH OPERATION FAILED IN THE MBOSET      *
  * WITHTHE SQL ERROR CODE-206                                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to latest release                                    *
  ****************************************************************
  

Problem conclusion

• BMXAA6713E-THE MBO FETCH OPERATION FAILED IN THE MBOSET WITHTHE
  SQL ERROR CODE-206 NO LONGER OCCURS
  
  The fix for this APAR is contained in the following maintenance
  package:
  	 | release\fix pack | Fix Pack Release 7.6.0.8
  

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:

Modules/Macros

• MAXIMO
  

Fix information

• Fixed component name

  WORK ORDERS

• Fixed component ID

  5724R46WO

Applicable component levels

• R760 PSY

     UP