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 number
IV93096
Reported component name
WORK ORDERS
Reported component ID
5724R46WO
Reported release
760
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-02-07
Closed date
2017-02-22
Last modified date
2017-02-22
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
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCHPPU","label":"Work Order Tracking"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"760","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
22 February 2017