Error Message

- Error listed in the Info pane of the Customer's Current Status section in the EVBAAdmin administration website:

Argument data type nvarchar(max) is invalid for argument 1 of textptr function. The text, ntext or image pointer value conflicts with the column name specified.

- Errors seen in the EV Event Logs on the Accelerator Server:

Log Name:      Veritas Enterprise Vault
Source:        Accelerator Manager
Event ID:      49
Task Category: None
Level:         Error
Description:
APP ATM - Error Executing : C:\Program Files (x86)\Enterprise Vault Business Accelerator\AcceleratorDatabasePrograms.sql
Line: 22628
Failed to Execute the following command:
CREATE PROCEDURE usp_Search_Application_CreateRun @CaseID int, @SchedulerStepID int, @Type int, @Name as nvarchar(100), @OnlyNew as bit, @AutoAccept as bit, @Description as nvarchar(250), @ApplicationSearchType int, @SearchID int, @XMLSourcePtr varbinary(16), @IncludePF bit = 0, @IncludeSPS bit = 0, @AcceptGlobalMarks int = 0, @ModifiedByID int = -1, @SearchLearningBehaviour tinyint = 0 AS if(@ModifiedByID IS NULL) SET @ModifiedByID = -1

V-437-49

Log Name:      Veritas Enterprise Vault
Source:        Accelerator Manager
Event ID:      59
Task Category: None
Level:         Error
Description:
APP ATM - Failed to update database. System.Data.SqlClient.SqlException (0x80131904): Argument data type nvarchar(max) is invalid for argument 1 of textptr function.
The text, ntext, or image pointer value conflicts with the column name specified.
   at Symantec.EnterpriseVault.DatabaseAccess.EVSqlBase.Do[T](Func`1 action)
   at Symantec.EnterpriseVault.DatabaseAccess.EVSqlCommand.ExecuteNonQuery()
   at KVS.Accelerator.Application.Install.RunScript(String ScriptName, EVSqlCommand CMD, Int32 CustomerID)
   at KVS.Accelerator.Application.Install.UpdateDatabase(CustomerRow theCustomerRow, String configDSN)
ClientConnectionId:798c3ff7-f7ef-4e8e-834c-ab6c12459b43
Error Number:8116,State:1,Class:16

V-437-59

Log Name:      Veritas Enterprise Vault
Source:        Accelerator Manager
Event ID:      64
Task Category: None
Level:         Error
Description:
APP ATM - Error upgrading a Customer.
Install Thread - worker thread (0)
Customer ID: 2
Number of tries: 1
Cause: Argument data type nvarchar(max) is invalid for argument 1 of textptr function.
The text, ntext, or image pointer value conflicts with the column name specified.

V-437-64

This issue is caused by the data type for column XMLText in table tblIntSearches in the Accelerator Customer database being changed from the default type of ntext to a non-default type of nvarchar(max). This database schema change is not initiated by any step of the upgrade process. Such a change could only have been manually performed, outside the normal Accelerator processes, for reasons known only to those making the change.

The upgrade process refreshes certain stored procedures, one of which is usp_Search_Application_CreateRun which makes use of the TEXTPTR function referencing the XMLText column in table tblIntSearches. Per Microsoft Books OnLine (https://docs.microsoft.com/en-us/sql/t-sql/functions/text-and-image-functions-textptr-transact-sql?view=sql-server-ver15), the TEXTPTR function is only compatible with the text, ntext and image data types. It is not compatible with the nvarchar data type, regardless of width. The error is logged because the edited data type is incompatible with the TEXTPTR function.

Please contact technical support for assistance in addressing this issue.