Error in Find in Files

[KenVee]

Application log shows:
Application: w3wp.exe Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: VaultLib.VaultDbException Stack: at
VaultIndexService.VaultIndexServiceSQL.GetRepositoryIndexSettings(Int32, VaultLib.RepositoryIndexInfo ByRef) at
VaultIndexService.VaultIndexManager.MoveItemToProcessRequestList(VaultIndexService.RepositoryIndexStateChange) at
VaultIndexService.VaultIndexManager.RepositoryIndexStateChgProc() at
System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean) at
System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean) at
System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object) at
System.Threading.ThreadHelper.ThreadStart()

sgVault log shows:
----03/02/2014 09:43:58 ken.vee--xxx.xxx.xxx.xxx(xxx.xxx.xxx.xxx)--SSL Enabled FindInFilesByFolder returned: FailInvalidIndexStatus

Vault index service log shows:
03/02/2014 10:01:14 <generic>: GetEntryAssembly() returned null; not logging assembly name
03/02/2014 10:01:14 <generic>: SourceGear Index Service started.
03/02/2014 10:14:47 <generic>: GetEntryAssembly() returned null; not logging assembly name
03/02/2014 10:14:47 <generic>: SourceGear Index Service started.
03/02/2014 10:15:08 <generic>: GetEntryAssembly() returned null; not logging assembly name
03/02/2014 10:15:09 <generic>: SourceGear Index Service started.
03/02/2014 10:15:14 <generic>: GetEntryAssembly() returned null; not logging assembly name
03/02/2014 10:15:14 <generic>: SourceGear Index Service started.

[Beth]

Is this a new install?

Was Find in Files working before?

Go to the Vault admin web page and click on Vault Plugins. Find the plugin paths that related to the Vault index service. Try each of those plugins in a browser. Do they bring up a page or fail?

[KenVee]

Recently upgraded to 7.1

I honestly cannot say if find in files used to work or last worked.
We have been using Vault standard for quite a while - at least since Sept 2011- I have only been here a year.

[KenVee]

I have 5 lines
Notify and Index are duplicated
Each has an entry on IP 127.0.0.1 (local loop back) and an entry for the externally accessible URL for the site.
The 127.0.0.1 show False in the Active column where as all 3 plugins with an externally accessible URL show active.
Active services VaultNotifyService, VaultIndexService and VaulShadowFolderService bring up a standard Web service description page.

This is true whether I browse from my laptop or on the web server itself.

[KenVee]

Just in case you ask -
I have checked the connection strings in the config and all 3 match up and the user used has db owner for all 3 databases.
When I try to do a search I see a connection created to the sgvaultindex db

[Beth]

Can you go to the page where Find in Files is turned on for a repository? Check there to see if it displays "ready."

If you have multiple repositories, check each one and see if it is turned on and displays "ready." If some are off, just make a note of those. You only need to turn the feature on if you want to search in those repositories.

[KenVee]

Each of them was off
I selected "On" this message appeared

The request to change settings have been sent to the Index Server. It may take a moment before the change is seen. If you encounter a problem saving this setting, please check the Index Server log file for additional information.

I looked to see if there was any activity in the databases and saw none

Went back to the page and the status had returned to "Off" for each repository

I looked in the database and constructed an XML request with repid & GUID and got this reply from the web service
<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<soap:Body>
<GetRepositoryIndexStatusResponse xmlns="http://www.sourcegear.com/schemas/vaultplugin/">
<GetRepositoryIndexStatusResult>1027</GetRepositoryIndexStatusResult>
<ris>INDETERMINATE</ris>
<nPercentComplete>0</nPercentComplete>
<nUTCTicks>0</nUTCTicks>
<strLastStatusMsg />
</GetRepositoryIndexStatusResponse>
</soap:Body>
</soap:Envelope>

[KenVee]

Ah the log says Invalid security token so my hack failed!

[Beth]

Check the web.config for the vaultindexservice and compare it to the web.config for vaultnotifyservice. See if the entry for <add key="SecurityToken" value=" ...."> match. If they don't copy out what is entered for the vaultindexservice and save it in a new notepad file in case it's needed again. Then copy in the same value that the vaultnotifyservice has.