IBM Support

Validation fails on REPORTCUSTOM table with SQL Server

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=&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.

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

Document Information

Modified date:
17 June 2018

UID

swg21575615