This documentation applies to the 8.1 version of Remedy Action Request System, which is in "End of Version Support."

To view the latest version, select the version from the Product version menu.

Troubleshooting full text search

To troubleshoot full text search (FTS) related issues, perform the following:

  • Examine data in the following log files located in the <ARServerInstallDir>/ARServer/Db folder:
    • arfts.log
    • arfts-secondary.log
    • arftsindx.log
    • arerror.log
    • arftsplugin.log
    • arftsplugin-secondary.log
    • armonitor.log
    • arsql.log

Note

By default, logs are available in the above files except the arftsindx.log and arsql.log files. To get the FTS index and SQL logs, you must enable them.

To enable FTS index logging

  1. In a browser, open the AR System Administration Console, and click System > General > Server Information.
    The AR System Administration: Server Information form appears.
  2. Click the Log Files tab.
  3. To enable full text index logging:
    1. Select the Full Text Index check box.
    2. Select the option for the type of logging you want:
      • File
      • Form
  4. In the Name field, specify a log file name or form.
    The default log file name is arftindx.log. The default form name is AR System Log: Full Text Index.

FTS index logging records all full text indexing operations to the full text indexer log but not full text searching operations. All logging for full text indexing is logged in the ARServerInstallDir/db/arftindx.log file. Entries in this log file represent the operations performed by the full text dispatcher and indexing threads, including the information sent to the search engine for modifying the indexes.

To enable SQL logging

  1. Select the SQL check box.
  2. In the Name field, specify a log file name or form.
    The default log file name is arsql.log. The default form name is AR System Log: SQL.
  3. Click OK.

SQL logging records all full text searching operations to the SQL log file, but not full text indexing operations. All logging for full text searching is logged in the ARServerInstallDir/db/arsql.log file, sharing the file with database logging. Entries in this log file that represent search engine activity are prefixed with FTS:.

For more information, see Setting log files options.

This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

Comments

  1. Tiffany Alexander

    The troubleshooting page seems to have been cut off at turning on logs.  There are no troubleshooting steps included.

    May 10, 2013 03:05
    1. Aparna Saxena

      Hi Tiffany,

      Thank you for your comment! The writer responsible for this content is currently working on this.

      Thanks,

      Aparna

       

      May 11, 2013 01:18
    1. Ashwini Mathad

      Hi Tiffany,

      This content is modified based on your feedback.

      Thank you!

      May 22, 2013 08:03