Troubleshooting
Problem
This documentation provides instructions to solve the error, as below : BMXAA5617E- When text search is enabled, a language column name must be specified.
Symptom
If you are trying to change the length and scale for the attributes of type Decimal, or during any other database configuration task, you may experience an error, as below :
BMXAA5617E- When text search is enabled, a language column name must be specified.
This can occur on Multi language environments where Text Search is enabled and LANGCOLUMNNAME is null.
Resolving The Problem
In order to find any instance of null value in a langcolumnname attribute, please run the following SQL statement against your database :
select tablename,langcolumnname,textsearchenabled from maxtablecfg
where textsearchenabled=1 and langcolumnname is null order by tablename ;
select tablename,langcolumnname,textsearchenabled from maxtable
where textsearchenabled=1 and langcolumnname is null order by tablename ;
You will need to update the records for the tables that meet the results where the langcolumname was null.
NOTE : Make sure Maximo is stopped, and that you have a database backup, before you try that procedure.
The update statement below is just an example.
UPDATE maxtablecfg SET langcolumnname='LANGCODE'
where tablename='YOUR_TABLENAME' ;
UPDATE maxtable SET langcolumnname='LANGCODE'
where tablename='YOUR_TABLENAME';
Start Maximo again and re-test the issue scenario.
Should you need any assistance, please contact IBM Maximo Support
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21695456