Skip to main content
isodius12-Amethyst
12-Amethyst
Oct 2, 2013 1:15 PM UTC
Question

java.SQL.Exception - not full-text indexed

Hi,

I've successfully installed Integrity Server 10.3 with SQL Server 2008 R2. The server runs but in the server.log file, there is the following exception:

ERROR [mksis.IntegrityServer] * * * * ERROR * * * * (0): java.sql.SQLException -- java.sql.SQLException: Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'Text3' because it is not full-text indexed.

I searched a by the Integrity documentation avec DB requirements and settings, but found nothing related to full-text indexing. This is not also a feature or setting of SQL Server.

Could someone tell me a bit more about this exception? How to fix it?

Thanks.

6 replies

jgorsline1-Visitor
1-Visitor
Oct 2, 2013 3:48 PM UTC

You are seeing this error because you don't have the correct database priviledges granted to the Integrity database user. The database user needs the db_owner role. This is outlined in the Installation guide.

To remedy this, give the Integrity database user the correct permissions, make sure you have case-sensitive collation installed on the database and enable Full Text Search.

Translate
    isodius12-AmethystAuthor
    12-Amethyst
    Oct 2, 2013 3:57 PM UTC

    Thanks Jeremy,

    I won't be able to test your advice until this next monday. But I'll do asap.

    Thanks again for the help.

    Translate
    Terms & ConditionsAccessibility statement