IBM Support

Maximo upgrade can fail in WriteReportProperties

Troubleshooting


Problem

The Maximo upgrade process can fail with the error: writereportprop process ends : error Please check the log file.

Symptom

Error text, as found in log file writereportproperties<timestamp>.log:

com.inet.tds.at: Msg 209, Level 16, State 1, Line 1, Sqlstate 01000
[SHADY75]Ambiguous column name 'langcode'.

Cause

Some legacy objects still exist in the database and must be removed in order to complete the upgrade, including column LANGUAGE.LANGCODE. This is a column that is left over from versions of Maximo prior to Maximo 7.1, and should have been removed during the upgrade to 7.1. The presence of this column in Maximo 7 causes tool WriteReportProperties to fail.

Environment

Maximo 7.1; unlikely to occur after 7.1.

Diagnosing The Problem

Review the results of this SQL query:

Select objectname, attributename, maxtype, length, persistent From maxattribute Where attributename='LANGCODE' And length=3 Order By 1 ;

Any rows that are returned from the query are obsolete and must be removed from Maximo and the native database.

Resolving The Problem

Any rows that are returned from the query above are obsolete and must be removed from Maximo and the native database. For example, if these results are returned from the query:

LANGUAGE LANGCODE LOWER 3 1
TRANSLATION LANGCODE LOWER 3 1

For each instance of objectname and attributename returned from the query, to remove the row from Maximo run these 2 SQL statements:

Delete From maxattribute Where objectname='LANGUAGE' And attributename='LANGCODE' ;
Delete From maxattributecfg Where objectname='LANGUAGE' And attributename='LANGCODE' ;

To remove the row from the native database run this command:

Alter Table language Drop Column langcode

After all obsolete LANGCODE columns are remove, re-run WriteReportProperties:

SMP\maximo\tools\maximo\writereportprop.bat

Note that the rest of the upgrade process completed. Only WriteReportProperties did not complete and needs to be run.

[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Upgrade Programs","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.1","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SSKTXT","label":"Tivoli Change and Configuration Management Database"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"7.1","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SS6HJK","label":"Tivoli Service Request Manager"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"7.1","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
17 June 2018

UID

swg22003488