Validation fails on REPORTCUSTOM table with SQL Server
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
Cannot pass validation step of the upgrade.
This happens when upgrading from 6.2.8 to 220.127.116.11 with SQL Server environments. The reason is due to 18.104.22.168 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.
More support for:
Maximo Asset Management
Upgrade Validation Utility
Software version: 7.1.1
Operating system(s): Platform Independent
Reference #: 1575615
Modified date: 16 November 2015