HOW TO: Remove or Uninstall additional language in Maximo
Fernando Corcuera 270007B092 Visits (10769)
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.
If you are not sure what your base language is, run the following query:
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.
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:
*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.