Accelerator report creation fails and logs Event ID 400

Problem

Attempting to create any Enterprise Vault (EV) Compliance Accelerator (CA) or Discovery Accelerator (DA) report using the report templates uploaded to a SQL Server Reporting Service server fails with the error listed below.

Error Message

Enterprise Vault Event Log entry:

Log Name:      Veritas Enterprise Vault
Source:        Accelerator Service Processor
Date:          11/24/2020 9:15:29 AM
Event ID:      400
Task Category: None
Level:         Error
Keywords:      Classic
Description:
APP AS - Customer ID: # - An error occurred during the initialisation of report engine. System.Web.Services.Protocols.SoapException: The path of the item '/Discovery Accelerator Reports/Discovery T+E Customer/EV vaultadmin' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InvalidItemPathException: The path of the item '/Discovery Accelerator Reports/Discovery T+E Customer/EV vaultadmin' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash.
   at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
   at KVS.Accelerator.Application.ReportService2010.ReportingService2010.GetPolicies(String ItemPath, Boolean& InheritParent)
   at KVS.Accelerator.Application.SSRS_Reports.AssignRoleToUser(String path, String user, Role role)
   at KVS.Accelerator.Application.SSRS_Reports.Init_Reporting()

V-437-400
 

Cause

This issue is caused by the use of the '+' character in the CA or DA customer name.  The first time any report is created using any of the templates that have been uploaded to the SQL Server Reporting Services (SSRS), a folder is created in the SSRS server's ReportServer virtual directory using the Accelerator customer's name.  This folder is used to contain every report that is created.

The '+' character is typically reserved for certain functionality within the SSRS and .NET processes used by the Accelerators.  When the '+' is part of a folder name, the Accelerator Report processing cannot access that folder.  This limitation is not a Veritas restriction.  Microsoft has guidance to not use the '+' character in any path.  Specifically, Microsoft has general naming conventions that state to not use hyphens, underscores or any other non-alphanumeric characters for .NET names which the Accelerators use for SSRS reporting.  See the following Microsoft .NET Documentation for more information about .NET naming convensions:
General Naming Conventions

Solution

Rename the Accelerator customer and its Virtual Directory to remove the '+' character.  Note that this may require deleting the customer with the '+' in the name and creating a new customer.  Veritas recommends having the CA / DA customer name the same as its Virtual Directory and database names to avoid confusion.