IBM Support

Unable to Create or Query for SRs After Installing Interim Fix 7.5.0.4-IFIX20140731-1755

Troubleshooting


Problem

Error BMXAA6713E: The MBO fetch operation failed.

Symptom

Excerpt from the log:

BMXAA6714E - The data for the next record in the mboset could not be
retrieved for the SQL query select * from sr where ((status like
'%NEW%')) and (pmcomtype is null) order by ticketid OPTION (FAST 1000)
. See the log file for more details about the error.

com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'fr1code'.

Cause

It is caused by a bad build for 7.5.0.4 fixpack (TPAE_7504_IFIX.20140731-1755.psi.zip)

Tivoli's process automation engine 7.5.0.4-IFIX20140731-1755 Build
20130129-2023 DB Build V7504-38 HFDB Build HF7504-25

Resolving The Problem

We have already removed the bad build from Fix Central:

http://www-933.ibm.com/support/fixcentral/swg/selectFixes?parent=ibm~Tivoli&product=ibm/Tivoli/IBM+Maximo+Asset+Management&release=7.5.0.4&platform=All&function=all

Please do NOT install you have already downloaded one of the following bad builds:TPAE_7504_IFIX.20140723-0846.psi.zip
TPAE_7504_IFIX.20140731-1755.psi.zip
TPAE_7504_IFIX.20140806-0814.psi.zip
TPAE_7504_IFIX.20140812-1639.psi.zip
TPAE_7504_IFIX.20140819-1717.psi.zip
TPAE_7504_IFIX.20140826-1757.psi.zip
TPAE_7504_IFIX.20140902-1730.psi.zip

[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Self Service","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.5","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
17 June 2018

UID

swg21688027