Validation fails on REPORTCUSTOM table with SQL Server

Technote (troubleshooting)


Problem(Abstract)

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=&quot;setrptpwd&quot; label=&quot;Set Custom Report Server Password&quot; mboname=&quot;REPORTCUSTOM&quot; savemode=&quot;ONUNLOAD&quot; hidehelp=&quot;true&quot;&gt;&lt;section

Once done re-run the validation and that should resolve your issue.

Rate this page:

(0 users)Average rating

Document information


More support for:

IBM Maximo Asset Management
Upgrade Validation Utility

Software version:

7.1.1

Operating system(s):

Platform Independent

Reference #:

1575615

Modified date:

2013-12-02

Translate my page

Machine Translation

Content navigation