When running a Velocity report, the system will attempt to attach archive files to SQL. Once attached, they will pull the data out of the archive to process the report requested.
If the archive files can’t be found, or if the system doesn’t think the files exist, it will generate the below message indicating the archive files can’t be found.
To resolve this issue, follow the steps below:
Log into Velocity SQL, select Databases, Velocity, Tables, locate dbo.ArchiveFiles, open Top 200 Rows, compare the data in ArchiveFiles to the error recieved
Right click on the Velocity Database, select Properties, select Files
Open System Databases, right click Master, select Properties, then Files
Right click on the Velocity Database, select Properties, select Options
C:\Windows\SysWOW64\SQLServerManager15.msc to find SQL Server Configuration Manager
Open Surface Area Configuration for Features, and check Enable CLR integration
Open the Velocity Database, select Programmability, Assemblies, then choose kekUDP
If the problem persists, make sure the archives can be attached manually to SQL to validate the process can work outside of Velocity. If the problem continues, please call Tech Support.