Cannot activate full-text search: unable to execute configDB

Technote (troubleshooting)


Problem(Abstract)

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.

Cross reference information
Segment Product Component Platform Version Edition
Systems and Asset Management IBM Maximo Asset Management Database Install Utility AIX, HP-UX, Linux, Solaris, Windows 6.2.1, 6.2.2, 6.2.3, 6.2.4, 6.2.5, 6.2.6, 6.2.7, 6.2.8

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

IBM Maximo Asset Management
Database Config

Software 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

Operating system(s):

Windows

Reference #:

1416909

Modified date:

2010-06-29

Translate my page

Machine Translation

Content navigation