IBM Support

Cannot activate full-text search: unable to execute configDB

Troubleshooting


Problem

In migrated Maximo SQL Server environments, full-text search hasn't been enabled for tables and columns. This state causes an error when running configDB.

Symptom

When running configDB, the following displays:


    C:\Maximo\tools\maximo>configdb.bat
    <date time stamp> --- Starting ----
    Reading properties file : maximo.properties
    RestoreFromBackup started for schema dbo <date time stamp>
    RestoreFromBackup connected to database jdbc:inetdae7a:hostname:1433?database=MAXIMO&language=us_english&nowarnings=true <date time stamp>
    ConfigDB started for schema dbo <date time stamp>
    ConfigDB connected to database jdbc:inetdae7a:hostname:1433?database=MAXIMO&language=us_english&nowarnings=true <date time stamp>
    Getting metadata <date time stamp>
    Configuring tables <date time stamp>
    Altering table ACTION Wed <date time stamp>
    com.inet.tds.at: Msg 15609, Level 16, State 1, Procedure sp_fulltext_table, Line 160, Sqlstate 01000
    [HOSTNAME]Cannot activate full-text search for table 'action' because no columns have been enabled for full-text search.
    at com.inet.tds.aq.a(Unknown Source)
    at com.inet.tds.k.b(Unknown Source)
    at com.inet.tds.k.a(Unknown Source)
    at com.inet.tds.k.a(Unknown Source)
    at com.inet.tds.af.b(Unknown Source)
    at com.inet.tds.af.execute(Unknown Source)
    at psdi.configure.CommonShell.doSql(CommonShell.java:339)
    at psdi.configure.CommonShell.doSql(CommonShell.java:312)
    at psdi.configure.TextSearch.doSql(TextSearch.java:517)
    at psdi.configure.TextSearch.adjustTextSearchOneTable(TextSearch.java:463)
    at psdi.configure.ConfigDB.configureTables(ConfigDB.java:555)
    at psdi.configure.ConfigDB.process(ConfigDB.java:255)
    at psdi.configure.ConfigDB.main(ConfigDB.java:2582)
    [HOSTNAME]Cannot activate full-text search for table 'action' because no columns have been enabled for full-text search. <date time stamp>
    ConfigDB completed with errors <date time stamp>
    RestoreFromBackup completed <date time stamp>
    C:\Maximo\tools\maximo

Diagnosing The Problem

Launch the SQL Server Enterprise Manager (SQL Server 2000) or SQL Server Management Studio. (SQL Server 2005). Go to the Maximo database, right click on it and select Full-Text Catalogs. Click on a table that generated the error. Check whether those tables have full-text indexing enabled. If not, this is why the error occurred.

Resolving The Problem

Running the attached script, which contains all of the maximo 6.2.x SQL Server full-text index definitions, will resolve the problem. Listed below is a sample from that script:


    sp_fulltext_table 'address', 'create', 'textcatalog', 'address_ndx'
    go
    sp_fulltext_column 'address', 'description', 'add', 0
    go
    sp_fulltext_table 'address', 'activate'
    go
    sp_fulltext_table 'address', 'start_change_tracking'
    go
    sp_fulltext_table 'address', 'start_background_updateindex'
    go

The attached file has been abstracted from maximo.sqs, which file is installed under \maximo\tools\maximo\en. It includes all Maximo 6.2.x base tables. Start Query Analyzer (SQL Server 2000) or a New Query (SQL Server 2005) and connect to your database as sa or maximo.

setfulltextcat.txt setfulltextcat.txt

[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Database Config","Platform":[{"code":"PF033","label":"Windows"}],"Version":"6.2.1;6.2.2;6.2.3;6.2.4;6.2.5;6.2.6;6.2.7;6.2.8","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Database Install Utility","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"6.2.1;6.2.2;6.2.3;6.2.4;6.2.5;6.2.6;6.2.7;6.2.8","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
17 June 2018

UID

swg21416909

Page Feedback