IBM Support

Error in Stocked Tools application

Troubleshooting


Problem

You might get errors BMXAA6713E or BMXAA6712E in the Stocked Tools application. Records cannot be retrieved from the database.

Symptom

Case 1:

The error in the Stocked Tools application is "BMXAA6713E - The MBO fetch operation failed in the mboset".

Oracle Environment:
Click the Stocked Tool tab, get error: BMXAA6713E - The MBO fetch operation failed in the mboset with the SQL error code 17006. The record could not be retrieved from the database. See the log file for more details about the error.

SQL Server Environment:
Click the Stocked Tool tab, get error: BMXAA6713E - The MBO fetch operation failed in the mboset with the SQL error code 0. The record could not be retrieved from the database.

DB2 Environment:
BMXAA6713E - The MBO fetch operation failed in the mboset with the SQL error code -204. The record could not be retrieved from the database.

Stack trace from Systemout.log file:
The record could not be retrieved from the database. See the log file for more details about the error. java.sql.SQLException: Invalid column name


Case 2:

The error in the stocked Tools application is: BMXAA6712E - The database connection failed and the record was not retrieved".

Error in the log:
select * from toolinv where (status != 'OBSOLETE' and siteid = 'BEDFORD')

BMXAA6712E - The database connection failed and the record was not retrieved. Try the operation again. If you experience repeated failures, check the log files in the home directory or contact your system administrator.

BMXAA6713E - The MBO fetch operation failed in the mboset with the SQL error code 0. The record could not be retrieved from the database. See the log file for more details about the error. com.microsoft.sqlserver.jdbc.SQLServerException: The column name null is not valid

[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Stocked Tools","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"Version Independent","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}},{"Product":{"code":"SSRHPA","label":"IBM Maximo Application Suite"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}},{"Product":{"code":"SSWT9A","label":"IBM Control Desk"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
18 September 2025

UID

swg21967173

Page Feedback