Summary

This KB article addresses the following error which may appear in the recognition.log file when running the ARL update:

2023-11-20 01:14:39,879 [ft.Recognition.Program] [FATAL] An unhandled exception occurred.
System.Exception: Error running command: sqlcmd.exe -S server-name -d FNMSCompliance -b  -i "C:\ProgramData\Flexera Software\FlexNet Manager Platform\DataImport\Content\ARL\.temp-extract\ARLCreateTables120.sql"  -E ---> System.ComponentModel.Win32Exception: The system cannot find the file specified

Symptoms

2023-11-20 01:14:39,744 [ecognition.Recognition] [INFO ] Executing SQL file C:\ProgramData\Flexera Software\FlexNet Manager Platform\DataImport\Content\ARL\.temp-extract\ARLCreateTables120.sql
2023-11-20 01:14:39,854 [ecognition.Recognition] [INFO ] Executing command: -S server-name -d FNMSCompliance -b  -i "C:\ProgramData\Flexera Software\FlexNet Manager Platform\DataImport\Content\ARL\.temp-extract\ARLCreateTables120.sql"  -E
2023-11-20 01:14:39,879 [ft.Recognition.Program] [FATAL] An unhandled exception occurred.
System.Exception: Error running command: sqlcmd.exe -S server-name -d FNMSCompliance -b  -i "C:\ProgramData\Flexera Software\FlexNet Manager Platform\DataImport\Content\ARL\.temp-extract\ARLCreateTables120.sql"  -E ---> System.ComponentModel.Win32Exception: The system cannot find the file specified
   at System.Diagnostics.Process.StartWithCreateProcess(ProcessStartInfo startInfo)
   at ManageSoft.Recognition.Recognition.ExecuteCommand(String command, String commandParams, String[] argumentsForSanitization)

Cause

Resolution

Additional information

1. Ensure sqlcmd.exe is installed, and locate it on the filesystem
2. If UAC is enabled and prohibits setting system environment variables, turn UAC off and then reboot
3. Start a cmd window with local administrator rights
4. Add the path of sqlcmd.exe to the system PATH environment variable:

   setx PATH "<directory containing sqlcmd.exe>" /M​

5. UAC can now be turned back on if required

A common location where sqlcmd.exe can be found is: C:\Program Files\Microsoft SQL Server\<version-number>\Tools\Binn

If multiple versions of sqlcmd.exe are installed, the system PATH environment variable should be configured so that the directory containing the most recent ODBC-based version of sqlcmd.exe appears before any directories containing other versions.