I've used this forum as a reference: https://www-secure.symantec.com/connect/forums/cannot-enable-analytics
Under the solution the first SQL query shows me that Full text seach is not enabled under the instance name. The second query for the Customer DB and Vault Store DB's show that Full text seach is enable by showing a "1" under the SQL column.
Analytics is showing errors in Discovery Accelerator when trying to enable it, and the Seach Terms "Drop down" arrows are greyed out. I'm wondering if this is related to "Full Text Search" not being enalbed in SQL. We are running SQL 2008 SP2.
Is this a correct assumption? Do we still need to enable full text search in SQL if the customer database is showing that it is enabled? I can't seem to find the FDhost service in "SQL configuration manager".
Solved! Go to Solution.
How did you get along implementing the steps in TECH75608? Tony is correct in referencing this TechNote as your SQL Server must be configured to allow Full Text Indexing for Analytics to work. The steps in the TechNote will get Full Text Indexing enabled on the SQL instance.
The 'SQL Full-Text Fiter Daemon Launcher' and 'SQL Server Analysis Services' must be set to Automatic startup and running, plus the full-text database feature must be enabed by running the stored procedure noted in the TechNote.
Also be sure you have plenty of free space on the drive hosting the analytics files. This drive can be confirmed by looking in the properties of the DA Customer through the EVBAAdmin site (must be logged onto the DA server as the Vault Service Account to access this site).
We have not been able to apply the TECHNOTE yet due to other ongoing issues. However I will "Mark" the above as a solution once the change is implemented. I've checked another instance in our LAB and I was able to enable "Analytics" as that SQL instance was running those services.
However after checking this instance in our LAB and noticing that those services were running; I still have an issue in Discovery Accelerator that I assumed it would be resolved once Analytics was enabled. :(
The "Drop Down" arrow where you can see the "Any of" option is not functional within a "Search Term" field. Discovery Accelerator is being tested with Evault FSA. Is this normal functionality? Or, settings missed at my end?
Thanks for your help!
The "Any of" option requires that you enter criteria on multiple lines to become active. For example, if your "To or from" field has
on one line, then the "Any of'" option will not be allowed to change, and the search criteria would look like
Ken AND Adams
when passed to the search engine.
If the "To or from" field has
the "Any of" option will then become enabled to change and allow you to change to "All of" if you want.