Troubleshooting
Problem
In Database Configuration when creating a view the Automatically Select check box can be unchecked and DConfig will process without error. However, unchecking the Automatically Select box may require additional configuration work such as backend table manipulation to work.
Symptom
BMXAA6712E - The MBO record could not be fetched from the database in the mboset. The mboset has been closed. Check the log files in the home directory to determine the source and cause of the error.
13 Feb 2012 XX:XX:XX:XXX [ERROR] [MXServer] [] 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 ROWSTAMP is not valid.
Resolving The Problem
If DBconfig has been run to create a view with Automatically Select unchecked, you will need to run back end SQL. When you select an object to extend, all attributes are being copied into Maxattrbutescfg and Maxviewcolumncfg. Since the extended object has a Rowstamp in our case, the rowstamp entry is carried over to Maxviewcolumncfg.
If you specify a non auto select view, these attributes are not parsed against the view select and if not all attributes are specified in the view select, there is a mismatch compared to the attributes and entries in the MaxViewColumn(cfg) table.
To fix this you will need to run the following in a SQL tool and restart Maximo
delete from maxviewcolumn where viewname = 'name of the view' and viewcolumnname = 'ROWSTAMP';
delete from maxviewcolumncfg where viewname = 'name of the view' and viewcolumnname = 'ROWSTAMP';
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21591153