After upgrading to Enterprise Vault 12.4.x or 12.5 search results will report partial results as the archive is being updated.

After upgrading to Enterprise Vault 12.4.x or 12.5 search results will report partial results as the archive is being updated.

Article: 100046947
Last Published: 2020-03-27
Ratings: 0 0
Product(s): Enterprise Vault

Problem

After upgrading to Enterprise Vault 12.4, 12.4.1, 12.4.2, or 12.5 search results report contains partial results as the archive is being updated. End users utilizing Enterprise Vault Search will see this issue when performing a search against their archives.

Error Message

The Enterprise Vault search window will report the following:

"Search is returning partial results because the vault that you are searching is being updated"

The event logs may show the following for affected volumes.

Log Name:      Veritas Enterprise Vault
Source:        Enterprise Vault 
Date:          12/13/2019 5:58:14 AM
Event ID:      41309
Task Category: Index Admin Service 
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      EV01.EV.LOCAL
Description:
The following error message occurred in the core indexing engine: The SQL statement [ALTER TABLE authority ADD frozen TEXT] on database [J:\Indexes\Index_MNT02\Indexes\2017\Q1\index3\1290E758B53E25647B4520A7962C04233_18503\live\log.sqlt] resulted in a SQL error: [SQL error code [1]: duplicate column name: frozen].   

For more information, see Help and Support Center at http://telemetry.community.veritas.com/entt?product=ev&language=english&version=12.3.0.0&build=12.3.0.1365&error=V-437-41309
v-437-41309

Cause

This issue is due to a change in the velocity indexing. Where prior to EV 12.4 EV used Velocity v8.1-6 and after EV 12.4.x the indexing engine was changed to Watson 10.0.0.4v. As a result the Watson 10.0.0.4v engine is unable to find an expected column named 'Frozen' in the 'Authority' table of each log.sqlt file that exists in each index volume.

As it can not find this column the index volume may be marked as failed or we may see event ID 41039. To fix this issue Veritas has created a script that can be run before upgrading to 12.4.2 that goes through each log.sqlt in the environment and adds this 'Frozen' Column to the 'Authority' table.

It appears the Watson engine attempts to add the column, but it is already there and it throws the 41309 stating that it cannot add a duplicate column. As any live volumes in this state cannot be added to items awaiting indexing for that volume will build up. End user and DA users may get the warning "Search is returning partial results because the vault that you are searching is being updated" after performing searches. 

 

Solution

Work Around:

A patch is available that can resolve the issue . Please create a Support case to obtain the workaround. 

Case creation can be performed online by visiting our Support site and choosing My Cases or we can be contacted by phone.


Veritas Corporation has acknowledged that the above-mentioned issue is present in the version(s) of the product(s) referenced in this article.

This issue is currently under investigation by Veritas Corporation. Pending the outcome of the investigation, this issue may be resolved by way of a cumulative hotfix or service pack in the current or future versions of the software. However, this particular issue is not currently scheduled for any release.  If you feel this issue has a direct business impact for you and your continued use of the product, please contact your Veritas Sales representative or the Veritas Sales group to discuss these concerns.  For information on how to contact Veritas Sales, please see http://www.veritas.com .

Please be sure to refer back to this document periodically as any changes to the status of the issue will be reflected here.

References

JIRA : CFT-2045

Was this content helpful?