HOW TO: Remove or Uninstall additional language in Maximo

February 7, 2017 Fernando Corcuera

Ever wonder how to remove a secondary or an additional language in Maximo? Today's your lucky day as I will walk you through on how you can do it in this blog entry.

 

First of all, there is no functionality of TDToolkit that will remove a secondary language. Therefore we will be doing this activity in the back-end, direct to your database.

 

We can start by viewing your available languages in your database. To view all your installed additional languages, run the following query against your database:

select languagename, maxlangcode from language where enabled = 1;

*This will list ALL languages including the base language.

e.g.:

image

 

 

 

 

 

If you are not sure what your base language is, run the following query:
select varvalue from maxvars where varname = 'BASELANGUAGE';

e.g.:

image

 

 

 

 

Once you know the language code for the language you want to remove, run the following SQL command against your database.

update language set enabled = 0 where maxlangcode = 'DE';

*Replace the DE with the code of the language you want to remove.

*This will disable the language but it will not remove the actual translation.

 

If you want to remove the actual translation in the database, continue on following the instructions below:

 

1) Run the following command and replace the DE with your language code.
select 'delete from ' || langtablename || ' where langcode = ''DE'';' from maxtable where langtablename is not null;

 

2) Run the output from the SQL in step 1 separately, SQLServer might need some tweaking to work if the table names are case sensitive.

3) Finally remove the language from the table used to keep track of versions:
delete from tdtversion where language = 'DE';

*This will remove the actual translation from the database.

 

IMPORTANT NOTE: Keep in mind that the MXServer needs to be restarted after either the disabling or the removal of an additional language. Make sure you do not disable the Base Language.

Previous Article
Maximo Asset Management Interim Fixes released

   First and foremost, you will want to review the latest blog post by Richard Lesses that covers Installin...

Next Article
Maximo Asset Management 7.5.0.10 Interim Fix 008 released

The Interim Fix (IFIX) is available at Fix Central.   As with all IFIXes, Maximo Asset Management 7.5.0.10 ...

×

Want our latest news? Subscribe to our blog!

Last Name
First Name
Thank you!
Error - something went wrong!