Troubleshooting
Problem
BMXAA0443E - ERROR -- BMXAA0483E - Table cannot be deleted because it does not exist in the database: Wed Dec 14 19:02:24 EST 2011 REPORTCUSTOM Wed Dec 14 19:02:24 EST 2011
Symptom
Cannot pass validation step of the upgrade.
Cause
This happens when upgrading from 6.2.8 to 7.1.1.9 with SQL Server environments. The reason is due to 7.1.1.9 having an entry for REPORTCUSTOM in the metadoc.xml when this field does not exist in SQL Server 6.2.8 environments without the December 13th 2011 hotfix.
The table is added with core 6.2.8 on Oracle which is why the issue does not appear there. This is to add functionality for V7RI Birt Reporting for Maximo 6
Resolving The Problem
There are 2 ways to resolve this issue:
1) You can install the latest 6.2.8 hotfix which adds the table to 6.2.8 SQL Server environments
2) Or as this table is not used at all in Maximo 7 (the reason it is in the metadoc to be dropped) You can remove in from the metadoc.xml
To do this:
Open the metadoc.xml in \ibm\SMP\maximo\tools\maximo\classes\psdi\upgrade\V600\en
Search for the word REPORTCUSTOM remove the first line returned that looks like the following.
<TABLE tbname="REPORTCUSTOM" status="OLDONLY">REPORTCUSTOM</TABLE>
Then search down again and remove the following section (next result)
id="setrptpwd" label="Set Custom Report Server Password" mboname="REPORTCUSTOM" savemode="ONUNLOAD" hidehelp="true"><section
Once done re-run the validation and that should resolve your issue.
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21575615