Skip to main content
I
isodius12-Amethyst
12-Amethyst
October 2, 2013
Question

java.SQL.Exception - not full-text indexed

  • October 2, 2013
  • 1 reply
  • 3371 views

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.

1 reply

J
jgorsline1-Visitor
1-Visitor
October 2, 2013

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.

    I
    isodius12-AmethystAuthor
    12-Amethyst
    October 2, 2013

    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.

    Terms & ConditionsAccessibility statement