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.
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg22003488